CData Software - Knowledge Base
Recent Articles
-
How to create Aha! federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Aha! in MySQL .
-
Automated Continuous Sybase Replication to MySQL
Use CData Sync for automated, continuous, customizable Sybase replication to MySQL.
-
How to Connect Flowise AI Agents to Live Airtable Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Airtable without replication.
-
Getting Started with the CData Python Connector for SAP BusinessObjects BI
Learn to install and license the CData Python Connector
-
Use JayDeBeApi to access CSV Data in Python
Use standard Python scripting and the development environment of your choice to access live CSV/TSV Files.
-
Query Kintone Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Kintone entities in PHP by modeling them as objects.
-
Access Live Dynamics 365 Business Central 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 Dynamics 365 Business Central through MCP integration.
-
Build Data Flows from Webflow to SQL Server using SSIS
Easily back up Webflow to SQL Server using the SSIS components for Webflow.
-
Connect to FreeAgent in SpagoBI
Create reports featuring live FreeAgent in SpagoBI Studio. Host FreeAgent reports on SpagoBI Server.
-
Trigger Shopify IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Shopify with standard wizards in Logic Apps.
-
Publish Reports with Facebook Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Facebook.
-
Automated Continuous Accelo Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Accelo replication to Apache Cassandra.
-
How to connect Amazon QuickSight to Outreach.io Data
Create a connection to Outreach.io in CData Connect AI and insert Outreach.io into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Instagram-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Instagram Data and create custom apps in Mendix.
-
Getting Started with the CData ADO.NET Provider for JotForm
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to SAP BusinessObjects BI Data in Jaspersoft Studio
Execute SQL to remote SAP BusinessObjects BI in Jaspersoft Studio.
-
Provide OData Services of ZohoInvoice Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ZohoInvoice by developing a WCF Service Application.
-
A PostgreSQL Interface for Scrapfly Data (MySQL Remoting via JDBC)
Use the Remoting features of the Scrapfly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Google Tasks Data Replication to Azure Synapse
Use CData Sync to customize and automate Google Tasks replication to Azure Synapse.
-
Create Informatica Mappings From/To an ODBC Data Source for Dynamics CRM
Create an ODBC connection to Dynamics CRM in Informatica and browse and transfer Microsoft Dynamics CRM.
-
Build AI/ML Models with Live SAP Fieldglass Data using Dataiku
Connect SAP Fieldglass Data with Dataiku using the CData JDBC Driver for SAP Fieldglass.
-
Connect to Salesforce Marketing Data in Claris FileMaker Pro
Use the CData ODBC Driver for Salesforce Marketing Cloud in FileMaker Pro to connect to Salesforce Marketing and work with Salesforce Marketing Cloud in your FileMaker applications.
-
Visualize Zoho Books Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Zoho Books.
-
Use Manus AI to Talk to Your Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Oracle Database.
-
Create Dashboards and Visualize Live Trello Data in Geckoboard
Use CData Connect AI to connect to live Trello and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrating GitHub Copilot CLI with Instagram 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.
-
ETL Harvest in Oracle Data Integrator
This article shows how to transfer Harvest into a data warehouse using Oracle Data Integrator.
-
Visualize Live CSV Data in the Power BI Service
Use CData Connect AI to connect to live CSV/TSV Files and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to import Facebook Data into Apache Solr
Use the CData Software JDBC Driver for Facebook in Data Import Handler and create an automated import of Facebook to Apache Solr Enterprise Search platform.
-
How to Connect to Twilio Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Twilio. Leverage the pyodbc module for ODBC in Python.
-
Build AI Agents with LinkedIn Ads Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live LinkedIn Ads through CData Connect AI.
-
Integrating Claude Code CLI with Close 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.
-
DataBind Charts to Klaviyo Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Klaviyo 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.
-
Connect to Asana Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Asana and the SQL Gateway to access Asana from Google Apps Script.
-
Connect to MySQL Data in Jaspersoft Studio
Execute SQL to remote MySQL in Jaspersoft Studio.
-
How to connect to Stripe Data in DBVisualizer
Integrate Stripe with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Elasticsearch from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Elasticsearch, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Browserless Data in Aqua Data Studio
Access Browserless from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect DBeaver to Bitbucket via a JDBC Driver
Manage Bitbucket with visual tools in DBeaver like the query browser.
-
Replicate REST Data to Multiple Databases via the CData Sync CLI
Replicate REST to disparate databases with a single configuration.
-
How to create ClickUp federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ClickUp in MySQL .
-
Create Parallel Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Parallel from PowerBI.com to create Power BI Dataflows with real-time data.
-
Moving Data from ShipStation to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ShipStation data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Egnyte Data in DBeaver
Use the CData ODBC Driver to connect to Egnyte in DBeaver.
-
Create Datasets from Invoiced in Domo Workbench and Build Visualizations of Invoiced Data in Domo
Use the CData Software ODBC Driver for Invoiced to create datasets from Invoiced in Domo Workbench and then build visualizations in the Domo service.
-
Replicate FHIR Data to Multiple Databases
Replicate FHIR to disparate databases with a point-and-click configuration.
-
Automate Testmonitor Data Replication to Azure Data Lake
Use CData Sync to customize and automate Testmonitor replication to Azure Data Lake.
-
How to connect and process MessageBird from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live MessageBird.
-
Stream SendGrid Data into Apache Kafka Topics
Access and stream SendGrid in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Easily Query Guru Data in OpenOffice Base
Connect to Guru data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create Power BI Reports on Real-Time Sage 200 Data
Use the CData ODBC Driver for Sage 200 to visualize Sage 200 in Power BI Desktop.
-
How to Connect to Live Google Contacts Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Google Contacts for you.
-
Design BIRT Reports on ActiveCampaign Data
Provide current ActiveCampaign to your embedded analytics.
-
How to connect SharePoint with SageHR Data through external lists
Provide SageHR to SharePoint users as an external list.
-
Getting Started with the CData ADO.NET Provider for Email
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Email.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Mouseflow
Provide connectivity to Mouseflow through an SAP BusinessObjects universe.
-
Connect to Email Data in NetBeans
Connect to Email in NetBeans with the data source configuration wizard.
-
Automated Continuous DB2 for i Replication to SingleStore
Use CData Sync for automated, continuous, customizable DB2 for i replication to SingleStore.
-
Getting Started with the CData JDBC Driver for Klipfolio
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Klipfolio.
-
Natively Connect to Zuora Data in PHP
The CData ODBC driver for Zuora enables you to create PHP applications with connectivity to Zuora. Leverage the native support for ODBC in PHP.
-
Viewing Recurly Data in RAD Studio Data Explorer
How to view Recurly in RAD Studio Data Explorer using the CData ODBC Driver for Recurly.
-
Visualize Live Vault CRM Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Veeva Vault & Vault CRM into custom reports in Power BI.
-
Create MYOB AccountRight Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time MYOB AccountRight data access from reports, embedded analytics, and more.
-
Integrate LionDesk with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate LionDesk with External Services.
-
Use Agno to Talk to Your Google Contacts Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Google Contacts for you.
-
How to connect to Klaviyo Data from Spring Boot
Connect to Klaviyo in a Spring Boot Application using the CData JDBC Driver for Klaviyo
-
Integrate Clio Data in the Pentaho Report Designer
Publish reports based on Clio in the Pentaho BI tool.
-
Integrate SAP Concur Data in Pentaho Data Integration
Build ETL pipelines based on SAP Concur in the Pentaho Data Integration tool.
-
eBay Analytics Reporting in OBIEE with the eBay Analytics JDBC Driver
Deploy the eBay Analytics JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Query Bright Data Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Bright Data entities in PHP by modeling them as objects.
-
Manage SendPulse Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SendPulse.
-
Migrating data from ConvertAPI to Databricks using CData SSIS Components.
Easily push ConvertAPI to Databricks using the CData SSIS Tasks for ConvertAPI and Databricks.
-
Provide OData Services of Zoom Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Zoom by developing a WCF Service Application.
-
How to create Visio diagrams from Shopify Data
Automatically update Shopify with the changes you make to Visio master shapes.
-
Build Voice Agents in ElevenLabs with access to Live Databricks Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Databricks.
-
Connect to PagerDuty in SpagoBI
Create reports featuring live PagerDuty in SpagoBI Studio. Host PagerDuty reports on SpagoBI Server.
-
How to Connect Sybase IQ Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Sybase IQ data in real time using natural language.
-
How to Visualize Telegram Data in Python with pandas
Use pandas and other modules to analyze and visualize live Telegram in Python.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle Service Cloud
Provide connectivity to Oracle Service Cloud through an SAP BusinessObjects universe.
-
Create Informatica Mappings From/To an ODBC Data Source for Mixpanel
Create an ODBC connection to Mixpanel in Informatica and browse and transfer Mixpanel.
-
Working with Trello Data in LINQPad
Execute LINQ queries to Trello in LINQPad.
-
Create a Data Access Object for Productboard Data using JDBI
A brief overview of creating a SQL Object API for Productboard in JDBI.
-
Connect to Amazon S3 Data in NetBeans
Connect to Amazon S3 in NetBeans with the data source configuration wizard.
-
Use ChatGPT to Talk to Your CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your CSV/TSV Files for you.
-
Create a Data Access Object for Calendly Data using JDBI
A brief overview of creating a SQL Object API for Calendly in JDBI.
-
Connecting Agentforce with Google Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Google Ads for you.
-
Use the CData SSIS Components to Insert New or Update Existing SharePoint Excel Services Records from SQL Server
Easily push SQL Server data to SharePoint Excel Services using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SharePoint Excel Services or update existing records with data from a SQL Server database.
-
Visualize Live Zuora Data in the Power BI Service
Use CData Connect AI to connect to live Zuora and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to ChargeOver Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ChargeOver and work with ChargeOver in your FileMaker applications.
-
Use Manus AI to Talk to Your Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Xero Accounting.
-
Query Office 365 Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Office 365 entities in PHP by modeling them as objects.
-
Connect to Live Snapchat Ads Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Snapchat Ads in CData Connect AI and connect to your Snapchat Ads from PostgreSQL.
-
Migrating data from CampaignMonitor to Snowflake using CData SSIS Components.
Easily push CampaignMonitor to Snowflake using the CData SSIS Tasks for CampaignMonitor and Snowflake.
-
Use Grok to Talk to Your Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Elasticsearch for you.
-
Automated Continuous Samanage Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Samanage replication to IBM DB2.
-
Integrating Codex CLI with SAP Concur 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.
-
Getting Started with the CData ADO.NET Provider for Google Sheets
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Google Spreadsheets.
-
Getting Started with the CData SSIS Components for Chargebee
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Chargebee.
-
Integrating GitHub Copilot CLI with Atlassian Confluence 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.
-
Replicate CockroachDB Data to Multiple Databases via the CData Sync CLI
Replicate CockroachDB to disparate databases with a single configuration.