CData Software - Knowledge Base
Recent Articles
-
Stream SAP Data into Apache Kafka Topics
Access and stream SAP data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Avalara AvaTax Data in RapidMiner
Integrate Avalara AvaTax data with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Informatica Mappings From/To a JDBC Data Source for Omnisend
Create Omnisend data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live Mouseflow Data in AWS Lambda
Connect to live Mouseflow data in AWS Lambda using the CData JDBC Driver.
-
Bridge Todoist Connectivity with Apache NiFi
Access and process Todoist data in Apache NiFi using the CData JDBC Driver.
-
Publish Reports with Beeminder Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Beeminder data.
-
DataBind Controls to QuickBooks Data in Delphi
DataBind to QuickBooks data in Delphi with standard data access components and controls.
-
How to Create Power BI Visual Reports with Real-Time SAS xpt Data
Use CData Power BI Connectors to visualize SAS xpt data in Power BI.
-
Create Informatica Mappings From/To an ODBC Data Source for Oracle Financials Cloud
Create an ODBC connection to Oracle Financials Cloud in Informatica and browse and transfer Oracle Financials Cloud data.
-
Feed MailChimp Data into FineReport
How to set MailChimp data as a JDBC data source in FineReport.
-
Query MongoDB Data as a SQL Server Database in Node.js
Execute SQL Server queries against MongoDB data from Node.js.
-
Import Perplexity Data Using Azure Data Factory
Use CData Connect AI to connect to Perplexity Data from Azure Data Factory and import live Perplexity data.
-
How to Easily Query Pushbullet Data in OpenOffice Base
Connect to Pushbullet data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Publish BambooHR-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live BambooHR data.
-
Design BIRT Reports on Missive Data
Provide current Missive data to your embedded analytics.
-
Integrate Cvent Data in the Pentaho Report Designer
Publish reports based on Cvent data in the Pentaho BI tool.
-
Seamlessly Bring Microsoft Ads Data into Retool Using CData Connect AI
Integrate Microsoft Ads data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Semantic Layer Views for BambooHR Data in APOS Live Data Gateway
Use the CData Connector for BambooHR in APOS Live Data Gateway to build Semantic Layer Views for BambooHR data.
-
Import and Visualize Cohere Data in Power View
Create data visualizations based on Cohere data in Excel.
-
Connect to HubDB Data in Google Apps Script via Connect AI
Use CData Connect AI to access HubDB data in Google Apps Script.
-
Integrating Cursor 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 data 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 data in Airbyte.
-
Build Data Flows from Google Ads to SQL Server using SSIS
Easily back up Google Ads data to SQL Server using the SSIS components for Google Ads.
-
Connect to QuickBooks Data in Jaspersoft Studio
Execute SQL to remote QuickBooks data in Jaspersoft Studio.
-
Publish MarkLogic-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live MarkLogic data.
-
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 data 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 data 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 data using the CData Python MCP Server.
-
Query Gmail Data in ColdFusion
Write standard ColdFusion data access code to connect to Gmail data.
-
Publish Gorgias-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Gorgias data.
-
How to connect to Harvest Data from IntelliJ
Integrate connectivity to Harvest data 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 data. Leverage the pyodbc module for ODBC in Python.
-
Use the CData Software JDBC Driver for Paymo in MicroStrategy Desktop
Connect to Paymo data 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 Jira data 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 data.
-
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 data into Microsoft Power Query.
-
Visualize Keap Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Keap data.
-
Connect to and Query Float Data in QlikView over ODBC
Create data visualizations with Float data 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 data 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 data 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 data 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 data.
-
Analyze Cosmos DB Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Cosmos DB data 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 data 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 data.
-
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 data 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 data 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 data 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 data 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 data.
-
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 data 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
-
Query Live ZohoMarketingHub Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live ZohoMarketingHub data through a conversational interface.
-
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 Cloud Accounting data through natural language.
-
Build a Simple VCL Application for OneNote Data
How to build a simple VCL Application to view OneNote data 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 data 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 data replication to OneLake in Microsoft Fabric.
-
Query Hugging Face Data in ColdFusion
Write standard ColdFusion data access code to connect to Hugging Face data.
-
Build Dashboards with FTP Data in Dundas BI
Create dynamic dashboards and perform analytics based on FTP data 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 data 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 data.
-
Feed HubSpot Data into FineReport
How to set HubSpot data as a JDBC data source in FineReport.
-
Analyze Live Dynamics 365 Data in SAS Viya
Use CData Connect AI to connect to Dynamics 365 data from SAS Viya and deploy self-service analytics using live Dynamics 365 data.
-
Getting Started with the CData Connect AI Python SDK for Quickbase
Install the CData Connect AI Python SDK to read and write live Quickbase data 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 data.
-
Use the CData Software JDBC Driver for ZohoMarketingHub in MicroStrategy Web
Connect to ZohoMarketingHub data 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 data in Power BI Desktop and then publish them to Power BI Report Server.
-
Automate ConvertAPI Data Replication to Azure Synapse
Use CData Sync to customize and automate ConvertAPI data replication to Azure Synapse.
-
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 data 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 data with the CData JDBC Driver for Hubstaff.
-
Build Charts with Cosmos DB Data in Clear Analytics
Create dynamic charts and perform analytics based on Cosmos DB data in Clear Analytics.
-
Create Informatica Mappings From/To an ODBC Data Source for Campaigner
Create an ODBC connection to Campaigner in Informatica and browse and transfer Campaigner data.
-
Visualize Coda Data in Sisense
Create an ElastiCube in Sisense app with access to Coda data.
-
Integrate Dify with Live GitLab Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live GitLab data.
-
How to connect and process QuickBooks data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live QuickBooks data.
-
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 data without any replication or custom integration required.
-
Build Data Flows from Dropbox to SQL Server using SSIS
Easily back up Dropbox data to SQL Server using the SSIS components for Dropbox.
-
Connect to Coinbase Data from a Connection Pool in JBoss
Integrate Coinbase data into Java servlets: Use the Management Console in JBoss to install the Coinbase JDBC Driver.
-
Integrating Codex with Clockify 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 Controls to Qualaroo Data in C++Builder
DataBind to Qualaroo data 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 data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
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 data.
-
Build Apps with Live Zoho CRM data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Zoho CRM data into the Adalo platform and build custom mobile and web applications with real-time Zoho CRM data.
-
Use the CData Software ODBC Driver for FormSite in MicroStrategy
Connect to FormSite data in MicroStrategy Developer using the CData Software ODBC Driver for FormSite.
-
Analyze Suadeo Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Suadeo data and visualize live Suadeo data in Infragistics Reveal.
-
Integrate Trae with Live Freshdesk Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Freshdesk data from within the AI-powered IDE.
-
Automated Continuous LightSpeedRetail Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable LightSpeedRetail data 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 data.
-
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 data 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 data.