CData Software - Knowledge Base
Recent Articles
-
How to connect and process TigerGraph data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live TigerGraph data.
-
Integrating Codex with Neo4J 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.
-
How to Connect to & Open Reply.io Data in Microsoft Excel
This article uses the CData ODBC driver for Reply.io to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Query xBase Data in ColdFusion
Write standard ColdFusion data access code to connect to xBase data.
-
Use the CData Software JDBC Driver for Google Ad Manager in MicroStrategy Web
Connect to Google Ad Manager data in MicroStrategy Web using the CData Software JDBC Driver for Google Ad Manager.
-
Connect to Aweber Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Aweber data in Airbyte.
-
Connect to Moosend Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Moosend and the SQL Gateway to access Moosend data from Google Apps Script.
-
Connect to Postmark Data in CloverDX (formerly CloverETL)
Transfer Postmark data using the visual workflow in the CloverDX data integration tool.
-
Manage LinkedIn Ads Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for LinkedIn Ads.
-
Connect to Toggl Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Toggl as an External Source in Dremio.
-
Use the CData ODBC Driver for Airtable in Microsoft Power Query
You can use the CData Airtable ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Airtable data into Microsoft Power Query.
-
Use the CData Software ODBC Driver for Wistia in SAS for Real-Time Reporting and Analytics
Connect to real-time Wistia data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Wistia.
-
Access Unbounce Data from MySQL in PHP
Connect to Unbounce through the standard MySQL libraries in PHP.
-
Connect to TaxJar Data in JRuby
Create a simple JRuby app with access to live TaxJar data.
-
Create Bannerbear-Connected Business Apps in AppSheet
Connect to Bannerbear Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Bannerbear data.
-
Replicate MessageBird Data to Multiple Databases
Replicate MessageBird data to disparate databases with a point-and-click configuration.
-
Replicate Multiple MongoDB Accounts
Replicate multiple MongoDB accounts to one or many databases.
-
Moving Data from Campaigner to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Campaigner data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to PayPal Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for PayPal Data and connect to PayPal data in Akorbi Digital RunMyProcess.
-
Build Voice Agents in ElevenLabs with access to Live Jira Assets Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Jira Assets data.
-
Integrating Kiro with Vimeo 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.
-
A PostgreSQL Interface for Perplexity Data using the CData ODBC Driver
Use the SQL Gateway and Perplexity ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Cloudant Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Cloudant replication to delimited files (CSV/TSV).
-
Connect to SAP Netweaver Gateway from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP Netweaver Gateway to connect to SAP Netweaver Gateway data from Web applications running on WebLogic.
-
Getting Started with the CData Power BI Connector for Perigon
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Analyze Drip Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Drip from Power Pivot. You will use the Table Import Wizard to load Drip data. You can visually build the import query or use any SQL supported by the driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Sage 300
Provide connectivity to Sage 300 data through an SAP BusinessObjects universe.
-
Analyze Live Greenplum Data in SAS Viya
Use CData Connect AI to connect to Greenplum data from SAS Viya and deploy self-service analytics using live Greenplum data.
-
Visualize Live Amazon Marketplace Data in the Power BI Service
Use CData Connect AI to connect to live Amazon Marketplace data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Add Exact Online Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Exact Online with the Informatica Enterprise Data Catalog to classify and organize data.
-
Analyze MailChimp Data in Looker
Use CData Connect AI to connect to MailChimp Data from Looker and build custom apps using live MailChimp data.
-
Replicate Sugar CRM Data from PowerShell
Write a quick PowerShell script to query Sugar CRM data. Use connectivity to the live data to replicate Sugar CRM data to SQL Server.
-
Build Apps with Live Missive Data Using the Low-Code Development Platform of Mendix
Connect Missive data with Mendix to build apps using the CData API Driver for JDBC.
-
Prepare, Blend, and Analyze Salesforce Data 360 Data in Alteryx Designer (Connect AI)
Build workflows to access live Salesforce Data 360 data for self-service data analytics.
-
Migrating data from Odoo to Databricks using CData SSIS Components.
Easily push Odoo data to Databricks using the CData SSIS Tasks for Odoo and Databricks.
-
Access Live TaxJar Data in TIBCO Data Virtualization
Use the TaxJar Tibco DV Adapter to create a TaxJar data data source in TIBCO Data Virtualization Studio and gain access to live TaxJar data from your TDV Server.
-
Integrate Azure Table with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Azure Table with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Azure Table data.
-
Connect to MySQL Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for MySQL and the SQL Gateway to access MySQL data from Google Apps Script.
-
Create Dashboards and Visualize Live Egnyte Data in Geckoboard
Use CData Connect AI to connect to live Egnyte data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrating Kiro with Figshare 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.
-
Integrate Trae with Live Bannerbear Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Bannerbear data from within the AI-powered IDE.
-
Edit and Search External Microsoft Entra ID Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft Entra ID data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Microsoft Entra ID Data objects that you can access from apps and the dashboard.
-
Publish Crystal Reports on Dynamics CRM Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Dynamics CRM data.
-
Create Reports from Bright Data Data in Looker Studio
Use CData Connect AI to gain access to live Bright Data data and create custom reports in Looker Studio.
-
Connect to Exact Online from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Exact Online data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous Cloudant Replication to MongoDB
Use CData Sync for automated, continuous, customizable Cloudant replication to MongoDB.
-
Publish Reports with Instantly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Instantly data.
-
Automated Continuous Calendly Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Calendly replication to Apache Kafka.
-
Automated Continuous PayPal Replication to MongoDB
Use CData Sync for automated, continuous, customizable PayPal replication to MongoDB.
-
Migrating data from Shopify to Google BigQuery using CData SSIS Components.
Easily push Shopify data to Google BigQuery using the CData SSIS Tasks for Shopify and Google BigQuery.
-
Migrating data from CockroachDB to Google BigQuery using CData SSIS Components.
Easily push CockroachDB data to Google BigQuery using the CData SSIS Tasks for CockroachDB and Google BigQuery.
-
Integrate PolarTeamPro Data in the Pentaho Report Designer
Publish reports based on PolarTeamPro data in the Pentaho BI tool.
-
Build Paylocity-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Paylocity data and build Paylocity-connected web apps with Axios.
-
Integrating Codex with Chargebee 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.
-
Automate ZohoInvoice Data Replication to Azure Data Lake
Use CData Sync to customize and automate ZohoInvoice data replication to Azure Data Lake.
-
Integrating LlamaIndex with ZohoDesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on ZohoDesk data in real time.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Coinbase
Provide connectivity to Coinbase data through an SAP BusinessObjects universe.
-
Authorize.Net Reporting in OBIEE with the Authorize.Net JDBC Driver
Deploy the Authorize.Net JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Zendesk Data in Claris FileMaker Pro
Use the CData ODBC Driver for Zendesk in FileMaker Pro to connect to Zendesk and work with Zendesk data in your FileMaker applications.
-
Use Biml to Build SSIS Tasks to Replicate Auth0 Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Auth0 data to SQL Server.
-
Configure the CData JDBC Driver for AgileCRM in a Connection Pool in Tomcat
Connect to AgileCRM data from a connection pool in Tomcat.
-
Build Optimizely-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Optimizely data without replication.
-
Replicate JotForm Data to Multiple Databases via the CData Sync CLI
Replicate JotForm data to disparate databases with a single configuration.
-
Integrating Dataiku with Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Zoom data.
-
Integrate Live Slack Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Slack data to Blue Prism using the CData ODBC Driver for Slack to create automated workflows for repetitive business tasks.
-
Natively Connect to Adobe Commerce Data in PHP
The CData ODBC driver for Adobe Commerce enables you to create PHP applications with connectivity to Adobe Commerce data. Leverage the native support for ODBC in PHP.
-
Create Reports from Klipfolio Data in Looker Studio
Use CData Connect AI to gain access to live Klipfolio data and create custom reports in Looker Studio.
-
Connect to Live Oracle Eloqua Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Oracle Eloqua in CData Connect AI and connect to your Oracle Eloqua data from PostgreSQL.
-
Access Anaplan Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Anaplan data from HeidiSQL.
-
Create Sage 300-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Sage 300 Data from OutSystems and build custom enterprise apps using live Sage 300 data.
-
Integrate with GitLab Data in SnapLogic
Use CData Connect AI to connect to and integrate with live GitLab data in SnapLogic.
-
Connect to Onfleet Data in CloverDX (formerly CloverETL)
Transfer Onfleet data using the visual workflow in the CloverDX data integration tool.
-
Build Oracle HCM Cloud-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Oracle HCM Cloud Data and create custom apps in Mendix.
-
FreeAgent Reporting in OBIEE with the FreeAgent JDBC Driver
Deploy the FreeAgent JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Hacker News Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Hacker News and work with Hacker News data in your FileMaker application.
-
Connect to and Visualize Live SingleStore Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SingleStore data.
-
Getting Started with the CData ADO.NET Provider for Okta
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Okta.
-
How to integrate Freshdesk with Apache Airflow
Access and process Freshdesk data in Apache Airflow using the CData JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Paymo
Provide connectivity to Paymo data through an SAP BusinessObjects universe.
-
Connect to and Visualize Live Notion Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Notion data.
-
Integrate Theia IDE with Live AfterShip Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live AfterShip data from within the development environment.
-
Integrating Claude Code with Redshift Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Redshift data within assisted coding and automated development workflows.
-
Automated Continuous Retently Replication to MySQL
Use CData Sync for automated, continuous, customizable Retently replication to MySQL.
-
Connect and Visualize Live Exact Online Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Exact Online data into the Databricks platform and create visualization dashboards with real-time Exact Online data.
-
Bridge Google Ads Connectivity with Apache NiFi
Access and process Google Ads data in Apache NiFi using the CData JDBC Driver.
-
Using the CData Software ODBC Driver for Customer.io in PyCharm
Connect to Customer.io as an ODBC data source in PyCharm using the CData Software ODBC Driver for Customer.io.
-
Integrate Live Asana Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Asana data to Blue Prism using the CData ODBC Driver for Asana to create automated workflows for repetitive business tasks.
-
How to connect to GetResponse Data from IntelliJ
Integrate connectivity to GetResponse data with wizards in IntelliJ.
-
Integrating Antigravity CLI with Apollo data via CData CLI
Connect Apollo data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Data Flows from SQL Server to HubSpot through SSIS
Easily push SQL Server data to HubSpot using the CData SSIS Tasks for HubSpot.
-
Connect to SAP Business Warehouse Data in RapidMiner
Integrate SAP Business Warehouse data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to PhantomBuster Data in JRuby
Create a simple JRuby app with access to live PhantomBuster data.
-
Integrating Kiro with Jira Assets 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 SQL Server Data in Tableau
The CData ODBC driver for SQL Server enables you integrate SQL Server data into Tableau dashboards.
-
How to import Spotify Data into Apache Solr
Use the CData Software JDBC Driver for Spotify in Data Import Handler and create an automated import of Spotify data to Apache Solr Enterprise Search platform.
-
A PostgreSQL Interface for Notion Data (MySQL Remoting via JDBC)
Use the Remoting features of the Notion JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Dynamic Tanda Grids Using the Infragistics XamDataGrid
Learn how you can connect Tanda to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Landbot Data in Pentaho Data Integration
Build ETL pipelines based on Landbot data in the Pentaho Data Integration tool.
-
How to Connect the Power BI Service to Copper: Complete Guide
Connect to the CData Software Power BI Connector for Copper from PowerBI.com to provide real-time Copper data across the organization.
-
Integrate Live SendGrid Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SendGrid from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SendGrid data.