CData Software - Knowledge Base
Recent Articles
-
Automated Continuous SAP HANA XS Advanced Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to MySQL.
-
Getting Started with the CData Python Connector for OData
Learn to install and license the CData Python Connector
-
Build Gong-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Gong Data in Gemini Code Assist to assist with building Gong-powered applications.
-
Create Data Visualizations in Cognos BI with Cassandra Data
Access Apache Cassandra as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Visualize Teamwork Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Teamwork.
-
How to Query Egnyte Data in MySQL Workbench
Execute MySQL queries against live Egnyte from MySQL Workbench.
-
Access Live ADP Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ADP from your Google Sheets.
-
Create Dynamic Odoo Grids Using the Infragistics XamDataGrid
Learn how you can connect Odoo to Infragistics XamDataGrid to build dynamic grids.
-
Prepare, Blend, and Analyze MySQL Data in Alteryx Designer (Connect AI)
Build workflows to access live MySQL for self-service data analytics.
-
Build Semantic Layer Views for Google Directory Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Directory.
-
Integrate LibreChat with Live Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft Ads from within the chat interface.
-
Sage Cloud Accounting Reporting in OBIEE with the Sage Cloud Accounting JDBC Driver
Deploy the Sage Cloud Accounting JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Airtable-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Airtable and build web apps with connectivity to live Airtable.
-
Migrating data from Aweber to Google BigQuery using CData SSIS Components.
Easily push Aweber to Google BigQuery using the CData SSIS Tasks for Aweber and Google BigQuery.
-
Load Gong Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Gong to a database.
-
Analyze SharePoint Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft SharePoint with the CData JDBC Driver for SharePoint.
-
Access Mode Data from MySQL in PHP
Connect to Mode through the standard MySQL libraries in PHP.
-
Automate Instagram Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Instagram and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Query OData Services using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume OData entities in PHP by modeling them as objects.
-
Access Live HDFS Data in TIBCO Data Virtualization
Use the HDFS Tibco DV Adapter to create a Apache HDFS data source in TIBCO Data Virtualization Studio and gain access to live Apache HDFS from your TDV Server.
-
Publish Reports with Google Drive Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Drive.
-
How to Build an ETL App for Outreach.io Data in Python with CData
Create ETL applications and real-time data pipelines for Outreach.io in Python with petl.
-
Automate Oracle Financials Cloud Data Replication to Couchbase
Use CData Sync to Customize and automate Oracle Financials Cloud replication to Couchbase.
-
Integrate with Postmark Data in JReport Designer
Create charts and reports based on Postmark in JReport Designer.
-
Connect to Real-Time Discourse Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Discourse in Power Apps.
-
Use the CData Software JDBC Driver for Templated in MicroStrategy Web
Connect to Templated in MicroStrategy Web using the CData Software JDBC Driver for Templated.
-
Integrate with Live Cassandra Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Cassandra from the MuleSoft Anypoint Platform to integrate live Apache Cassandra into custom reports and dashboards.
-
Create SharePoint-Connected Dashboards in Grafana
Connect to SharePoint Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Microsoft SharePoint.
-
Create SSAS Tabular Models from SendPulse Data
How to build a SQL Server Analysis Service Tabular Model from SendPulse using CData drivers.
-
Use JayDeBeApi to access ZohoMarketingHub Data in Python
Use standard Python scripting and the development environment of your choice to access live ZohoMarketingHub.
-
Connect to Quaderno from Asprova with CData Software ODBC Driver for Quaderno
This article shows how to connect faster to Quaderno data from Asprova.
-
Operational Reporting on ZohoDesk Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ZohoDesk.
-
Deploy the ADO.NET Provider for Zuora on an SSRS Report Server
Connect to Zuora from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrating Claude Code CLI with LeadDesk Data 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 Autopilot Replication to MySQL
Use CData Sync for automated, continuous, customizable Autopilot replication to MySQL.
-
Feed Freshdesk Data into FineReport
How to set Freshdesk as a JDBC data source in FineReport.
-
Automate Odoo Data Replication to SAP HANA
Use CData Sync to customize and automate Odoo ERP replication to SAP HANA.
-
Build Google Campaign Manager 360-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Campaign Manager 360 and build web apps with connectivity to live Google Campaign Manager 360.
-
Use the CData API Server to Access SAP Netweaver Gateway Data in Microsoft PowerPivot
Use the CData API Server to connect to live SAP Netweaver Gateway in the Power Pivot business intelligence tool.
-
Connect to Act CRM Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Act CRM using standard SQL.
-
Getting Started with the CData Power BI Connector for Eventbrite
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create Data Visualizations in Cognos BI with Placid Data
Access Placid as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Google Tasks Data from MySQL in Amazon QuickSight
Connect to Google Tasks and build visualizations of Google Tasks using a MySQL Connection in Amazon QuickSight.
-
Integrating LangGraph with Google Cloud Storage Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google Cloud Storage within automated workflows.
-
How to Connect to Live Power BI XMLA Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Power BI XMLA for you.
-
Getting Started with the CData ADO.NET Provider for Productboard
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
A PostgreSQL Interface for NASA Data using the CData ODBC Driver
Use the SQL Gateway and NASA ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Visualizations of Dynamics 365 Business Central Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Dynamics 365 Business Central in Birst.
-
Getting Started with the CData ADO.NET Provider for Toggl
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Query LinkedIn Ads Data as a SQL Server Database in Node.js
Execute SQL Server queries against LinkedIn Ads from Node.js.
-
Back Up Azure Table Storage to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Azure. In this article, we will employ an SSIS workflow to populate a database with Azure Table Storage data.
-
Build MVC Applications with Connectivity to Bannerbear Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Bannerbear from an ASP.NET MVC application.
-
Connect to Eventbrite Data from PowerBuilder via JDBC
This article demonstrates how to access Eventbrite from PowerBuilder using the Eventbrite JDBC Driver.
-
Visualize SAP BusinessObjects BI Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load SAP BusinessObjects BI into TIBCO Spotfire.
-
Back Up Exact Online to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Exact Online. In this article, we will employ an SSIS workflow to populate a database with Exact Online data.
-
Connect to Live Amazon S3 Data in MicroStrategy through CData Connect AI
Create a live connection to Amazon S3 Data in CData Connect AI and connect to your Amazon S3 from MicroStrategy.
-
A PostgreSQL Interface for Microsoft Ads Data (MySQL Remoting via JDBC)
Use the Remoting features of the Microsoft Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Mixpanel-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Mixpanel Data in Cursor to assist with building Mixpanel-powered applications.
-
Connect to Airtable Data from AWS Glue
Use CData Connect AI to gain access to live Airtable from your AWS Glue jobs.
-
Connect to Access Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft Access in DBeaver.
-
Getting Started with the CData Python Connector for Zuora
Learn to install and license the CData Python Connector
-
Use the CData Software JDBC Driver for Spotify in MicroStrategy Desktop
Connect to Spotify in MicroStrategy Desktop using the CData Software JDBC Driver for Spotify.
-
Configure the CData JDBC Driver for Google Contacts in a Connection Pool in Tomcat
Connect to Google Contacts from a connection pool in Tomcat.
-
Prepare, Blend, and Analyze Vercel Data in Alteryx Designer (ODBC)
Build workflows to access live Vercel for self-service data analytics.
-
Automated Continuous Cloudant Replication to SingleStore
Use CData Sync for automated, continuous, customizable Cloudant replication to SingleStore.
-
Connect to Bitbucket Data in RapidMiner
Integrate Bitbucket with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData API Server to Access Twitter Ads Data in Microsoft PowerPivot
Use the CData API Server to connect to live Twitter Ads in the Power Pivot business intelligence tool.
-
Query Gmail Data as a SQL Server Database in Node.js
Execute SQL Server queries against Gmail from Node.js.
-
Publish Crystal Reports on CapsuleCRM Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date CapsuleCRM.
-
Create Informatica Mappings From/To a JDBC Data Source for Rebilly
Create Rebilly data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Sage Cloud Accounting Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Sage Business Cloud Accounting.
-
Automated Continuous FreeAgent Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable FreeAgent replication to Google BigQuery.
-
How to Connect to FormSite Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to FormSite. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Stack Exchange Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Google BigQuery.
-
Getting Started with the CData ADO.NET Provider for Sage 300
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Sage 300.
-
Connect to Zoom Data in RazorSQL
Connect to Zoom from wizards and query Zoom from the GUI in the RazorSQL database management tool.
-
Replicate Autopilot Data in Heroku for Use in Salesforce Connect
Replicate Autopilot to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Analyze xBase Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for xBase from Power Pivot. You will use the Table Import Wizard to load xBase. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Codex CLI with SendPulse 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.
-
Connect to ZeroBounce Data from a Connection Pool in JBoss
Integrate ZeroBounce into Java servlets: Use the Management Console in JBoss to install the ZeroBounce JDBC Driver.
-
Explore Geographical Relationships in PingOne Data with Power Map
Create data visualizations with PingOne in Power Map.
-
Access Azure Data Lake Storage Data from MySQL in Amazon QuickSight
Connect to Azure Data Lake Storage and build visualizations of Azure Data Lake Storage using a MySQL Connection in Amazon QuickSight.
-
Create Gumroad Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Gumroad from PowerBI.com to create Power BI Dataflows with real-time data.
-
Import and Visualize Everhour Data in Power View
Create data visualizations based on Everhour in Excel.
-
DataBind Controls to HelloSign Data in Delphi
DataBind to HelloSign in Delphi with standard data access components and controls.
-
QuickBooks Online Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on QuickBooks Online facts in real time.
-
Load ZohoMarketingHub Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ZohoMarketingHub to a database.
-
How to work with Cvent Data in Apache Spark using SQL
Access and process Cvent Data in Apache Spark using the CData Software JDBC Driver.
-
Automate ZohoInvoice Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live ZohoInvoice and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect Zuora Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zuora using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for MYOB AccountRight
Provide connectivity to MYOB AccountRight through an SAP BusinessObjects universe.
-
Build Keap-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Keap.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ZohoDesk
Provide connectivity to ZohoDesk through an SAP BusinessObjects universe.
-
Visualize Reckon Accounts Hosted Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Reckon Accounts Hosted.
-
Build REST-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for REST to explore live REST Data in Cursor to assist with building REST-powered applications.
-
Automate Planio Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Planio and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect Paymo Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Paymo using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect to Live SAP Ariba Procurement Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your SAP Ariba Procurement for you.
-
Create SSAS Tabular Models from JSON Services
How to build a SQL Server Analysis Service Tabular Model from JSON using CData drivers.
-
How to create an RPA flow for Salesforce Data 360 Data in UiPath Studio
Use the Salesforce Data 360 ODBC Driver to create workflows that access real-time Salesforce Data 360 without any coding.