CData Software - Knowledge Base
Recent Articles
-
Integrating Cursor CLI with iContact 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.
-
Visualize Live Google Analytics Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Google Analytics into custom reports in Power BI.
-
Connect to Sage Intacct Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Sage Intacct in Airbyte.
-
Build Data Flows from Google Ads to SQL Server using SSIS
Easily back up Google Ads to SQL Server using the SSIS components for Google Ads.
-
Connect to QuickBooks Data in Jaspersoft Studio
Execute SQL to remote QuickBooks Desktop in Jaspersoft Studio.
-
Publish MarkLogic-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live MarkLogic.
-
Integrate with Microsoft Planner Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft Planner to a JSON file on disk.
-
How to Connect to & Open Webflow Data in Microsoft Excel
This article uses the CData ODBC driver for Webflow to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Connect to Live Lakebase Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Lakebase through natural language.
-
Connect Facebook Ads to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Facebook Ads using the CData Python MCP Server.
-
Query Gmail Data in ColdFusion
Write standard ColdFusion data access code to connect to Gmail.
-
Publish Gorgias-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Gorgias.
-
How to connect to Harvest Data from IntelliJ
Integrate connectivity to Harvest with wizards in IntelliJ.
-
How to Connect to Intercom Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Intercom. Leverage the pyodbc module for ODBC in Python.
-
Use the CData Software JDBC Driver for Paymo in MicroStrategy Desktop
Connect to Paymo in MicroStrategy Desktop using the CData Software JDBC Driver for Paymo.
-
Faster Reporting using the CData Provider for Salesforce
The CData ADO.NET Provider for Salesforce features advanced caching capabilities. The Auto Cache feature of the Data Provider can be used to execute expensive queries against a local, automatically updated cache.
-
Build PostgreSQL-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for PostgreSQL Data and create custom apps in Bubble.
-
How to Connect to Live Jira 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 Atlassian Jira for you.
-
Model eBay Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and eBay, enabling the direct import of real-time eBay.
-
Use the CData ODBC Driver for Instagram in Microsoft Power Query
You can use the CData Instagram ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Instagram into Microsoft Power Query.
-
Visualize Keap Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Keap.
-
Connect to and Query Float Data in QlikView over ODBC
Create data visualizations with Float in QlikView.
-
How to Connect to Live ServiceNow Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live ServiceNow securely in real time.
-
Import Real-Time DocuSign Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use DocuSign in ColdFusion.
-
Use Dash to Build to Web Apps on Greenhouse Data
Create Python applications that use pandas and Dash to build Greenhouse-connected web apps.
-
Create a Data Access Object for Shippo Data using JDBI
A brief overview of creating a SQL Object API for Shippo in JDBI.
-
Build Semantic Layer Views for Microsoft Entra ID Data in APOS Live Data Gateway
Use the CData Connector for Microsoft Entra ID in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Entra ID.
-
Analyze Cosmos DB Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Azure Cosmos DB and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Automated Amazon S3-Connected Workflows in Zapier
Use CData Connect AI to connect to live Amazon S3 and build automated workflows in Zapier.
-
Create Informatica Mappings From/To an ODBC Data Source for SendPulse
Create an ODBC connection to SendPulse in Informatica and browse and transfer SendPulse.
-
Use the CData ODBC Driver for Rootly in Microsoft Power Query
You can use the CData Rootly ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Rootly into Microsoft Power Query.
-
Getting Started with the CData Connect AI Python SDK for Box
Install the CData Connect AI Python SDK to read and write live Box with standard DB-API 2.0 Python code.
-
Use Claude to Talk to Your BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your BambooHR for you.
-
Seamlessly Bring Oracle Financials Cloud Data into Retool Using CData Connect AI
Integrate Oracle Financials Cloud data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Migrating data from Oracle SCM to Databricks using CData SSIS Components.
Easily push Oracle SCM to Databricks using the CData SSIS Tasks for Oracle SCM and Databricks.
-
Analyze Azure Table Data in Looker
Use CData Connect AI to connect to Azure Table Data from Looker and build custom apps using live Azure Table Storage.
-
Analyze OneNote Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Microsoft OneNote and visualize live Microsoft OneNote in Infragistics Reveal.
-
Analyze Google Analytics Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google Analytics and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Jira Data in HULFT Integrate
Connect to Jira as a JDBC data source in HULFT Integrate
-
How to Connect to Live Sage Cloud Accounting Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Sage Business Cloud Accounting through natural language.
-
Build a Simple VCL Application for OneNote Data
How to build a simple VCL Application to view Microsoft OneNote in RAD Studio using the CData ODBC Driver for OneNote.
-
Integrating Claude Code with Airtable Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Airtable within assisted coding and automated development workflows.
-
Automated Continuous Gorgias Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Gorgias replication to OneLake in Microsoft Fabric.
-
How to Import Data from Impala into Google Sheets
Import Apache Impala into a Google spreadsheet that is automatically refreshed.
-
Query Hugging Face Data in ColdFusion
Write standard ColdFusion data access code to connect to Hugging Face.
-
Build Dashboards with FTP Data in Dundas BI
Create dynamic dashboards and perform analytics based on FTP Servers in Dundas BI.
-
Build AI/ML Models with Live Snapchat Ads Data using Dataiku
Connect Snapchat Ads Data with Dataiku using the CData JDBC Driver for Snapchat Ads.
-
Import Oracle Eloqua Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Oracle Eloqua Data and provide access to live Oracle Eloqua for custom reports in the Power BI Service.
-
Build Semantic Layer Views for Highrise Data in APOS Live Data Gateway
Use the CData Connector for Highrise in APOS Live Data Gateway to build Semantic Layer Views for Highrise CRM.
-
Feed HubSpot Data into FineReport
How to set HubSpot as a JDBC data source in FineReport.
-
Analyze Live Dynamics 365 Data in SAS Viya
Use CData Connect AI to connect to Microsoft Dynamics 365 from SAS Viya and deploy self-service analytics using live Microsoft Dynamics 365.
-
Getting Started with the CData Connect AI Python SDK for Quickbase
Install the CData Connect AI Python SDK to read and write live Quickbase with standard DB-API 2.0 Python code.
-
How to use SQLAlchemy ORM to access EmailOctopus Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of EmailOctopus.
-
Use the CData Software JDBC Driver for ZohoMarketingHub in MicroStrategy Web
Connect to ZohoMarketingHub in MicroStrategy Web using the CData Software JDBC Driver for ZohoMarketingHub.
-
View Reports on Real-Time Jodoo Data in Power BI Report Server
Use the CData ODBC Driver for Jodoo to visualize Jodoo in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Query Live CouchDB Data in Claude Desktop
Connect to and query live CouchDB Data in Claude Desktop using CData MCP Server.
-
Connect to ConstantContact Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ConstantContact and work with ConstantContact in your FileMaker applications.
-
How to Connect to & Open Avro Data in Microsoft Excel
This article uses the CData ODBC driver for Avro to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous FreeAgent Replication to Snowflake
Use CData Sync for automated, continuous, customizable FreeAgent replication to Snowflake.
-
Analyze Hubstaff Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Hubstaff with the CData JDBC Driver for Hubstaff.
-
Build Charts with Cosmos DB Data in Clear Analytics
Create dynamic charts and perform analytics based on Azure Cosmos DB in Clear Analytics.
-
Build Asana-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Asana to explore live Asana Data in GitHub Copilot to assist with building Asana-powered applications.
-
Create Informatica Mappings From/To an ODBC Data Source for Campaigner
Create an ODBC connection to Campaigner in Informatica and browse and transfer Campaigner.
-
Visualize Coda Data in Sisense
Create an ElastiCube in Sisense app with access to Coda.
-
How to connect and process QuickBooks Desktop from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live QuickBooks Desktop.
-
Connecting GenSpark with Amazon S3 Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Amazon S3 without any replication or custom integration required.
-
Build Data Flows from Dropbox to SQL Server using SSIS
Easily back up Dropbox to SQL Server using the SSIS components for Dropbox.
-
Connect to Coinbase Data from a Connection Pool in JBoss
Integrate Coinbase into Java servlets: Use the Management Console in JBoss to install the Coinbase JDBC Driver.
-
Integrating Codex CLI with Clockify 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 Controls to Qualaroo Data in C++Builder
DataBind to Qualaroo in C++Builder with standard components and controls.
-
Automated Continuous DB2 Replication to Amazon S3
Use CData Sync for automated, continuous, customizable DB2 replication to Amazon S3.
-
Choosing the Best Method to Connect Accelo to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Accelo from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access PivotalTracker Data from MySQL in Amazon QuickSight
Connect to PivotalTracker and build visualizations of PivotalTracker using a MySQL Connection in Amazon QuickSight.
-
How to connect PolyBase to Oracle Service Cloud
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Oracle Service Cloud.
-
Build Apps with Live Zoho CRM in Adalo using CData Connect AI
Use CData Connect AI to integrate live Zoho CRM into the Adalo platform and build custom mobile and web applications with real-time Zoho CRM.
-
Use the CData Software ODBC Driver for FormSite in MicroStrategy
Connect to FormSite in MicroStrategy Developer using the CData Software ODBC Driver for FormSite.
-
Automated Continuous LightSpeedRetail Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to OneLake in Microsoft Fabric.
-
Enable the Microsoft Ads JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft Ads.
-
How to Build an ETL App for Azure Table Data in Python with CData
Create ETL applications and real-time data pipelines for Azure Table Storage in Python with petl.
-
Create Sugar CRM-Connected Applications in Appsmith
Connect to Sugar CRM Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Sugar CRM.
-
Getting Started with the CData ODBC Driver for Odoo
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Odoo.
-
Integrating Boomi Agentstudio with Dynamics 365 Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft Dynamics 365, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Sybase IQ Data Replication to Teradata
Use CData Sync to Customize and automate Sybase IQ replication to Teradata.
-
Connect to IBM Cloud Object Storage Data in Jaspersoft Studio
Execute SQL to remote IBM Cloud Object Storage in Jaspersoft Studio.
-
Use the CData Software ODBC Driver for Notion in MicroStrategy Desktop
Connect to Notion in MicroStrategy Desktop using the CData Software ODBC Driver for Notion.
-
Access Live Vertica Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Vertica through MCP integration.
-
Automated Continuous Shippo Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Shippo replication to Amazon S3.
-
Connect to Snapchat Ads Data from HeidiSQL
Use CData Connect AI to connect to and query live Snapchat Ads from HeidiSQL.
-
How to connect and process Microsoft OneDrive from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft OneDrive.
-
Use the CData Software JDBC Driver for Facebook Ads in MicroStrategy Desktop
Connect to Facebook Ads in MicroStrategy Desktop using the CData Software JDBC Driver for Facebook Ads.
-
Connect to Apify Data from a Connection Pool in Jetty
The Apify JDBC Driver supports connection pooling: This article shows how to connect faster to Apify from Web apps in Jetty.
-
Publish Telegram-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Telegram.
-
Integrating Boomi Agentstudio with Neo4J Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Neo4J, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automate Marketo Data Replication to SAP HANA
Use CData Sync to customize and automate Marketo replication to SAP HANA.
-
Replicate Xero Data to Multiple Databases via the CData Sync CLI
Replicate Xero Accounting to disparate databases with a single configuration.
-
Use the CData Software JDBC Driver for ClickTime in MicroStrategy Desktop
Connect to ClickTime in MicroStrategy Desktop using the CData Software JDBC Driver for ClickTime.
-
How to connect to Drip Data with Squirrel SQL client
Connect to Drip and execute queries in the Squirrel SQL Client.
-
How to Connect to Live Adobe Commerce Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Adobe Commerce through natural language.
-
Connect to ConvertAPI in SpagoBI
Create reports featuring live ConvertAPI in SpagoBI Studio. Host ConvertAPI reports on SpagoBI Server.
-
Automated Continuous SAP Hybris C4C Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Snowflake.