CData Software - Knowledge Base

Recent Articles

---

• «
• 633
• 634
• 635
• 636
• 637
• 638
• 639
• 640
• 641
• 642
• »

• Natively Connect to Redis Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Redis. Leverage the native support for ODBC in PHP.

• Analyze Foursquare Data in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Foursquare with the CData JDBC Driver for Foursquare.

• Analyze Live Square Data in SAS Viya

  Use CData Connect AI to connect to Square from SAS Viya and deploy self-service analytics using live Square.

• How to connect to Everhour Data in DBVisualizer

  Integrate Everhour with visual data analysis tools and data connection wizards in DBVisualizer

• Enable the Harvest JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Harvest.

• Access Live Mouseflow Data in AWS Lambda (with IntelliJ IDEA)

  Connect to live Mouseflow in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Perform Batch Operations with Google Sheets Data in Apache NiFi

  Connect to Google Sheets and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Build Databricks-Powered Applications in Claude Code with CData MCP Server

  Use the CData MCP Server for Databricks to explore live Databricks Data in Claude Code to assist with building Databricks-powered applications.

• Build Dashboards with LDAP Objects in DBxtra

  Create dynamic dashboards and perform analytics based on LDAP in DBxtra.

• Create Zuora-Connected Nintex Workflows

  Use CData Connect AI to connect to Zuora Data from Nintex Workflow Cloud and build custom workflows using live Zuora.

• How to Access Live SAP Business Warehouse Data in Visual Studio Code via Cline

  Run CData MCP Server for SAP Business Warehouse on Windows Subsytem for Linux (WSL) and connect to live SAP Business Warehouse from the Cline extension in Visual Studio Code.

• How to Query Live Twilio Data in Claude Desktop

  Connect to and query live Twilio Data in Claude Desktop using CData MCP Server.

• Getting Started with the CData Excel Add-In for ADP

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ADP.

• Automate Impala Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Apache Impala and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• How to Query Live Sybase Data in Perplexity MacOS Desktop

  Connect to and query live Sybase Data in Perplexity Desktop using CData MCP Server.

• Getting Started with the CData ODBC Driver for Couchbase

  Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Couchbase.

• Connect to MYOB AccountRight Data as a SQL Server Linked Server

  Use CData Connect AI to create a linked server for live MYOB AccountRight.

• How to create Google Calendar federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Calendar in MySQL .

• Use the CData Software ODBC Driver for Azure Data Catalog in SAS for Real-Time Reporting and Analytics

  Connect to real-time Azure Data Catalog in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Azure Data Catalog.

• Connect to Mailjet Data from a Connection Pool in Jetty

  The Mailjet JDBC Driver supports connection pooling: This article shows how to connect faster to Mailjet from Web apps in Jetty.

• Access Live HelloSign Data in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate HelloSign into the statistical analysis tools available in SAS JMP. This article shows how to use HelloSign in the Graph Builder and Query Builder.

• Build Dashboards with Oracle Data in DBxtra

  Create dynamic dashboards and perform analytics based on Oracle Database in DBxtra.

• Getting Started with the CData Excel Add-In for Customer.io

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Customer.io.

• Use the CData Software ODBC Driver for Microsoft Dataverse in MicroStrategy Desktop

  Connect to Microsoft Dataverse (CDS) in MicroStrategy Desktop using the CData Software ODBC Driver for Microsoft Dataverse.

• Create Datasets from Monday.com in Domo Workbench and Build Visualizations of Monday.com Data in Domo

  Use the CData Software ODBC Driver for Monday.com to create datasets from Monday.com in Domo Workbench and then build visualizations in the Domo service.

• Connect to Highrise Data from Filemaker Pro (Mac)

  Use CData Connect AI to connect to and query live Highrise CRM from Filemaker Pro on Mac.

• How to Build an ETL App for Freshsales Data in Python with CData

  Create ETL applications and real-time data pipelines for Freshsales in Python with petl.

• How to create Visio diagrams from Cvent Data

  Automatically update Cvent with the changes you make to Visio master shapes.

• Connect to Azure Data Lake Storage Data Using the Script Function in Claris FileMaker Pro

  Use the CData ODBC Driver for Azure Data Lake Storage and the Script function in FileMaker Pro to connect to Azure Data Lake Storage and work with Azure Data Lake Storage in your FileMaker application.

• Create Dashboards and Visualize Live Oracle HCM Cloud Data in Geckoboard

  Use CData Connect AI to connect to live Oracle HCM Cloud and create dashboards for real-time monitoring and visualization in Geckoboard.

• How to Create Power BI Visual Reports with Real-Time FormSite Data

  Use CData Power BI Connectors to visualize FormSite in Power BI.

• Excel Spreadsheet Automation on Shippo Data with the QUERY Formula

  Pull data from Shippo, automate spreadsheets, and more with the QUERY formula.

• Access Salesforce Data in SharePoint External Lists

  Provide Salesforce data to SharePoint users as an external list.

• Connect to and Query ADP Data in QlikView over ODBC

  Create data visualizations with ADP in QlikView.

• Working with CapsuleCRM Data in LINQPad

  Execute LINQ queries to CapsuleCRM in LINQPad.

• Access eBay Analytics Data from MySQL in Amazon QuickSight

  Connect to eBay Analytics and build visualizations of eBay Analytics using a MySQL Connection in Amazon QuickSight.

• Feed Lakebase Data into FineReport

  How to set Lakebase as a JDBC data source in FineReport.

• Analyze YouTube Analytics Data in Looker

  Use CData Connect AI to connect to YouTube Analytics Data from Looker and build custom apps using live YouTube Analytics.

• Build Voice Agents in ElevenLabs with access to Live Salesforce Data

  Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Salesforce & Force.com.

• Access Live Zuora Data in Emergent via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Zuora through MCP integration.

• Natively Connect to Paddle Data in PHP

  The CData ODBC driver for Paddle enables you to create PHP applications with connectivity to Paddle. Leverage the native support for ODBC in PHP.

• Getting Started with the CData Power BI Connector for CSV

  Complete guide to installing, licensing, and connecting with the CData Power BI Connector for CSV.

• Automated Continuous CampaignMonitor Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable CampaignMonitor replication to IBM DB2.

• Getting Started with the CData ODBC Driver for Rootly

  Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Rootly.

• Connect to OneNote Data from Filemaker Pro (Mac)

  Use CData Connect AI to connect to and query live Microsoft OneNote from Filemaker Pro on Mac.

• How to use SQLAlchemy ORM to access Dynamics 365 Business Central Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Dynamics 365 Business Central.

• How to publish and share Mailjet Data dashboards with Tableau Server

  The CData ODBC driver for Mailjet enables you integrate Mailjet into Tableau dashboards.

• How to Query Excel Data in MySQL Workbench

  Execute MySQL queries against live Microsoft Excel from MySQL Workbench.

• How to work with ClickUp Data in Apache Spark using SQL

  Access and process ClickUp Data in Apache Spark using the CData Software JDBC Driver.

• Build Spark-Connected Dashboards Using Zoho Analytics

  Use CData Connect AI to connect to Spark Data from Zoho Analytics and import live Apache Spark SQL.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Moosend

  Provide connectivity to Moosend through an SAP BusinessObjects universe.

• Create SSAS Tabular Models from Humanity Data

  How to build a SQL Server Analysis Service Tabular Model from Humanity using CData drivers.

• Build an OLAP Cube in SSAS from Email Data

  Establish a connection to Email data from SQL Server Analysis Services, and use the Email Data Provider to build OLAP cubes for use in analytics and reporting.

• Automate Tasks in Power Automate Using the CData API Server

  Automate Dynamics CRM actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.

• Integrating Codex CLI with Raisers Edge NXT via CData CLI

  CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.

• Automated Continuous AfterShip Replication to Oracle

  Use CData Sync for automated, continuous, customizable AfterShip replication to Oracle.

• Use the CData Software ODBC Driver for WooCommerce in MicroStrategy Desktop

  Connect to WooCommerce in MicroStrategy Desktop using the CData Software ODBC Driver for WooCommerce.

• How to Connect to CouchDB Data in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Apache CouchDB. Leverage the pyodbc module for ODBC in Python.

• Access Live EnterpriseDB Data in Coginiti Pro

  Connect to and query live EnterpriseDB from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Configure the CData JDBC Driver for Shopify in a Connection Pool in Tomcat

  Connect to Shopify from a connection pool in Tomcat.

• Integrate Live Shopify Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live Shopify to Blue Prism using the CData ODBC Driver for Shopify to create automated workflows for repetitive business tasks.

• Replicate BigCommerce Data in Heroku for Use in Salesforce Connect

  Replicate BigCommerce to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• How to Import Data from Microsoft Dataverse into Google Sheets

  Import Microsoft Dataverse (CDS) into a Google spreadsheet that is automatically refreshed.

• Query Klipfolio Data in ColdFusion

  Write standard ColdFusion data access code to connect to Klipfolio.

• Connect to Zoho Creator from Asprova with CData Software ODBC Driver for Zoho Creator

  This article shows how to connect faster to Zoho Creator data from Asprova.

• Import and Visualize Excel Online Data in Power View

  Create data visualizations based on Microsoft Excel Online in Excel.

• Configure the CData JDBC Driver for Paddle in a Connection Pool in Tomcat

  Connect to Paddle from a connection pool in Tomcat.

• Use Biml to Build SSIS Tasks to Replicate Lakebase Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Lakebase to SQL Server.

• Visualize Live Google Forms Data of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Google Forms using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Use the CData Software JDBC Driver for Power BI XMLA in MicroStrategy Web

  Connect to Power BI XMLA in MicroStrategy Web using the CData Software JDBC Driver for Power BI XMLA.

• DataBind Charts to ConvertAPI Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to ConvertAPI from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• How to use SQLAlchemy ORM to access ZohoExpense Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ZohoExpense.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for eBay

  Provide connectivity to eBay through an SAP BusinessObjects universe.

• Analyze ActiveCampaign Data in Infragistics Reveal

  Use the CData API Server to create an OData API on top of ActiveCampaign and visualize live ActiveCampaign in Infragistics Reveal.

• Build Act-On-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Act-On and build web apps with connectivity to live Act-On.

• Bidirectional Access to SAP SuccessFactors LMS Data from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate SAP SuccessFactors LMS in Filemaker Pro for Mac or Windows.

• DataBind Controls to Billsby Data in C++Builder

  DataBind to Billsby in C++Builder with standard components and controls.

• How to work with Rebilly Data in Apache Spark using SQL

  Access and process Rebilly Data in Apache Spark using the CData Software JDBC Driver.

• Access Live Mouseflow Data in Coginiti Pro

  Connect to and query live Mouseflow from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Add Insightly Data to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Insightly with the Informatica Enterprise Data Catalog to classify and organize data.

• Automated Continuous Certinia Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Certinia replication to Amazon S3.

• Edit and Search Google Ads External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of Google Ads to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Google Ads objects that you can access from apps and the dashboard.

• Connect to Epicor Kinetic from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Epicor Kinetic, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Build OData-Connected Dashboards Using Zoho Analytics

  Use CData Connect AI to connect to OData Services from Zoho Analytics and import live OData.

• Access Live Salesforce Data in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Salesforce & Force.com from your Google Sheets.

• Bidirectional Access to Paddle Data from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Paddle in Filemaker Pro for Mac or Windows.

• Easily Integrate Impala Data in Lazarus Pascal IDE

  Learn how to easily integrate live Apache Impala in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Build Amazon DynamoDB Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live Amazon DynamoDB and build visualizations in Tableau.

• Visualize Elasticsearch Data in TIBCO Spotfire through ADO.NET

  Integrate Elasticsearch into dashboards in TIBCO Spotfire.

• Build FTP-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to FTP Servers and build web apps with connectivity to live FTP Servers.

• Use CData Connect AI to Access Azure Synapse Data in Microsoft Power Pivot

  Use CData Connect AI to connect to live Azure Synapse in the Power Pivot business intelligence tool.

• Load Google Sheets Data to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Sheets to a database.

• Create Data Visualizations Based On Cosmos DB Data in Mode

  Use CData Connect AI to connect to Cosmos DB Data from Mode and build visualizations using live

• Build Snowflake-Powered Applications in GitHub Copilot with CData MCP Server

  Use the CData MCP Server for Snowflake to explore live Snowflake Data in GitHub Copilot to assist with building Snowflake-powered applications.

• Replicate JotForm Data from PowerShell

  Write a quick PowerShell script to query JotForm. Use connectivity to the live data to replicate JotForm to SQL Server.

• Trigger Kintone IFTTT Flows in Azure App Service

  Automate IFTTT (if-this-then-that) workflows for Kintone with standard wizards in Logic Apps.

• How to connect PolyBase to Instagram

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Instagram.

• Integrate Act CRM with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Act CRM with External Services.

• ETL Neo4J in Oracle Data Integrator

  This article shows how to transfer Neo4J into a data warehouse using Oracle Data Integrator.

• Import and Visualize Pingdom Data in Power View

  Create data visualizations based on Pingdom in Excel.

• «
• 633
• 634
• 635
• 636
• 637
• 638
• 639
• 640
• 641
• 642
• »