CData Software - Knowledge Base
Recent Articles
-
Connect to Bitbucket Data in DBeaver
Use the CData ODBC Driver to connect to Bitbucket data in DBeaver.
-
Automated Continuous Browserless Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Browserless replication to AlloyDB.
-
Build FTP-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live FTP data.
-
Build Google Search-Connected Apps in Choreo
Use CData Connect AI to connect to Google Search Results from Choreo and build custom apps using live Google Search results.
-
Integrate Google's Antigravity Agent with Live CapsuleCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live CapsuleCRM data using the Model Context Protocol.
-
Create BigCommerce-Connected Dashboards in Grafana
Connect to BigCommerce Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to BigCommerce data.
-
Analyze Kafka Data in Looker
Use CData Connect AI to connect to Kafka Data from Looker and build custom apps using live Kafka data.
-
Import QuickBooks Time Data Using Azure Data Factory
Use CData Connect AI to connect to QuickBooks Time Data from Azure Data Factory and import live QuickBooks Time data.
-
Create Dynamic Epicor Kinetic Grids Using the Infragistics XamDataGrid
Learn how you can connect Epicor Kinetic to Infragistics XamDataGrid to build dynamic grids.
-
Import Real-Time Cloudflare Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Cloudflare data in ColdFusion.
-
Connect to Microsoft Dataverse Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Dataverse data.
-
Process & Analyze Confluence Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Confluence Data.
-
Build Charts with ShipEngine Data in Clear Analytics
Create dynamic charts and perform analytics based on ShipEngine data in Clear Analytics.
-
Migrating data from Invoiced to Databricks using CData SSIS Components.
Easily push Invoiced data to Databricks using the CData SSIS Tasks for Invoiced and Databricks.
-
Query Sage 200 Data in DataGrip
Create a Data Source for Sage 200 in DataGrip and use SQL to query live Sage 200 data.
-
Integrate Google's Antigravity Agent with Live eBay Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live eBay Analytics data using the Model Context Protocol.
-
Connect to Copper in SpagoBI
Create reports featuring live Copper data in SpagoBI Studio. Host Copper reports on SpagoBI Server.
-
Access Live PhantomBuster Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate PhantomBuster data into the statistical analysis tools available in SAS JMP. This article shows how to use PhantomBuster data in the Graph Builder and Query Builder.
-
Consume SuiteCRM OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SuiteCRM feeds that reflect any changes in SAP Lumira.
-
Automated Continuous Sendwithus Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Sendwithus replication to AlloyDB.
-
Connect to iContact Data in DBArtisan
Use wizards in DBArtisan to configure iContact data as a data source.
-
Stream Rebilly Data into Apache Kafka Topics
Access and stream Rebilly data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Work with Contentful Data in FoxPro
Load Contentful data into a FoxPro database. This article includes full code and a walk-through of the process.
-
DataBind Controls to Authorize.Net Data in Delphi
DataBind to Authorize.Net data in Delphi with standard data access components and controls.
-
Access Live GitHub Data in Coginiti Pro
Connect to and query live GitHub data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Vault CRM in SpagoBI
Create reports featuring live Vault CRM data in SpagoBI Studio. Host Vault CRM reports on SpagoBI Server.
-
Build Agents in Relevance AI with Access to Live Quickbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Quickbase data within intelligent agent workflows.
-
Automated Continuous Freshservice Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Freshservice data replication to OneLake in Microsoft Fabric.
-
Build ZohoPeople-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to ZohoPeople Data from Zoho Analytics and import live ZohoPeople data.
-
Query Float Data in ColdFusion
Write standard ColdFusion data access code to connect to Float data.
-
Build a Simple VCL Application for MySQL Data
How to build a simple VCL Application to view MySQL data in RAD Studio using the CData ODBC Driver for MySQL.
-
Integrating Microsoft Exchange Data in Talend Cloud Data Management Platform
Connect Microsoft Exchange Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Microsoft Exchange.
-
Automated Continuous LeadDesk Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable LeadDesk replication to Apache Kafka.
-
How to integrate ZeroBounce with Apache Airflow
Access and process ZeroBounce data in Apache Airflow using the CData JDBC Driver.
-
How to update Oracle from Excel
This article explains how to transfer data from Excel to Oracle using the Excel Add-In for Oracle.
-
Build an OLAP Cube in SSAS from Microsoft Entra ID Data
Establish a connection to Microsoft Entra ID data data from SQL Server Analysis Services, and use the Microsoft Entra ID Data Provider to build OLAP cubes for use in analytics and reporting.
-
Publish ScrapingBee-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ScrapingBee data.
-
Automate QuickBooks Online Integration Tasks from PowerShell
Are you in search of a quick and easy way to access QuickBooks Online data from PowerShell? This article demonstrates how to utilize the QuickBooks Online Cmdlets for tasks like connecting to QuickBooks Online data, automating operations, downloading data, and more.
-
Create Data Visualizations in Cognos BI with SAP HANA Data
Access SAP HANA data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Real-Time Chargebee Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Chargebee data in Power Apps.
-
Using the CData Software ODBC Driver for Hugging Face in PyCharm
Connect to Hugging Face as an ODBC data source in PyCharm using the CData Software ODBC Driver for Hugging Face.
-
How to Visualize Certinia Data in Python with pandas
Use pandas and other modules to analyze and visualize live Certinia data in Python.
-
Configure the CData JDBC Driver for Oracle Sales in a Connection Pool in Tomcat
Connect to Oracle Sales data from a connection pool in Tomcat.
-
Visualize Box Data in Tableau
The CData ODBC driver for Box enables you integrate Box data into Tableau dashboards.
-
Connect to Google Drive Data in Ruby
Connect to Google Drive data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to RSS Feeds from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for RSS to connect to RSS feeds and execute queries in PowerBuilder.
-
How to Connect to Live Dynamics CRM Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Dynamics CRM data securely in real time.
-
Build MVC Applications with Connectivity to Nuclia Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Nuclia from an ASP.NET MVC application.
-
Back Up CampaignMonitor data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with CampaignMonitor data data.
-
Integrate Live FTP Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to FTP data and integrate live FTP data into apps built in Microsoft Power Apps.
-
Use Manus AI to Talk to Your Dynamics NAV 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 Dynamics NAV data.
-
Integrate Recurly with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Recurly with External Services.
-
Integrate with live Pipedrive Data in Jitterbit
Use CData Connect AI to connect to and integrate live Pipedrive data in Jitterbit.
-
Access Live Contentful Data in AWS Lambda
Connect to live Contentful data in AWS Lambda using the CData JDBC Driver.
-
Natively Connect to REST Data in PHP
The CData ODBC driver for REST enables you to create PHP applications with connectivity to REST data. Leverage the native support for ODBC in PHP.
-
How to Access Dynamics CRM Data Using Entity Framework
This article shows how to access Dynamics CRM data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Working with PostgreSQL Data in LINQPad
Execute LINQ queries to PostgreSQL data in LINQPad.
-
Visualize Salesforce 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 Salesforce data into TIBCO Spotfire.
-
Query Retently Data in ColdFusion
Write standard ColdFusion data access code to connect to Retently data.
-
Use Microsoft Copilot Studio to talk to your SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your SAP BusinessObjects BI data for you.
-
Integrate Xero Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Xero data and integrate live Xero data into your Power Automate tasks.
-
How to Connect Flowise AI Agents to Live Certinia 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 Certinia data without replication.
-
Build SAS xpt-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAS xpt data.
-
Publish Reports with Hugging Face Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Hugging Face data.
-
Replicate Airtable Data to Multiple Databases via the CData Sync CLI
Replicate Airtable data to disparate databases with a single configuration.
-
Build Agents in Relevance AI with Access to Live iContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on iContact data within intelligent agent workflows.
-
Automated Continuous QuickBooks Time Replication to SQL Server
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to SQL Server.
-
Connect to Vimeo Data from PowerBuilder via JDBC
This article demonstrates how to access Vimeo data from PowerBuilder using the Vimeo JDBC Driver.
-
Getting Started with the CData ADO.NET Provider for FHIR
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for FHIR.
-
Replicate Stack Exchange Data to Multiple Databases via the CData Sync CLI
Replicate Stack Exchange data to disparate databases with a single configuration.
-
Use the CData Software JDBC Driver for Adobe Analytics in MicroStrategy
Connect to Adobe Analytics data in MicroStrategy Developer using the CData Software JDBC Driver for Adobe Analytics.
-
Connect to Unbounce Data from a Connection Pool in Jetty
The Unbounce JDBC Driver supports connection pooling: This article shows how to connect faster to Unbounce data from Web apps in Jetty.
-
Getting Started with the CData ADO.NET Provider for Oracle Eloqua
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Oracle Eloqua.
-
Connecting Mastra with Power BI XMLA Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Power BI XMLA data, no replication required.
-
Trigger Adobe Commerce IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Adobe Commerce with standard wizards in Logic Apps.
-
Integrate Vault CRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Vault CRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Vault CRM data.
-
Query Twilio Data as a MySQL Database in Node.js
Execute MySQL queries against Twilio data from Node.js.
-
Connecting Pipedream with Procore Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Procore data in real time.
-
Build Semantic Layer Views for Airtable Data in APOS Live Data Gateway
Use the CData Connector for Airtable in APOS Live Data Gateway to build Semantic Layer Views for Airtable data.
-
Connect to Mixpanel Data in RazorSQL
Connect to Mixpanel from wizards and query Mixpanel data from the GUI in the RazorSQL database management tool.
-
Connect to Deel Data in CloverDX (formerly CloverETL)
Transfer Deel data using the visual workflow in the CloverDX data integration tool.
-
DataBind Controls to Google Contacts Data in C++Builder
DataBind to Google Contacts data in C++Builder with standard components and controls.
-
Automated Continuous Dynamics 365 Replication to Databricks
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Databricks.
-
Integrate Samanage Data in Pentaho Data Integration
Build ETL pipelines based on Samanage data in the Pentaho Data Integration tool.
-
Automated Continuous Parallel Replication to SQL Server
Use CData Sync for automated, continuous, customizable Parallel replication to SQL Server.
-
How to Create Power BI Visual Reports with Real-Time Rebilly Data
Use CData Power BI Connectors to visualize Rebilly data in Power BI.
-
Bridge Jira Assets Connectivity with Apache NiFi
Access and process Jira Assets data in Apache NiFi using the CData JDBC Driver.
-
Integrating Claude Code CLI with xBase 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.
-
Access Live Excel Data in AWS Lambda
Connect to live Excel data in AWS Lambda using the CData JDBC Driver.
-
Integrate with Adobe Commerce Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Adobe Commerce data to a JSON file on disk.
-
Visualize Gong 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 Gong data into TIBCO Spotfire.
-
Process & Analyze SendPulse Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SendPulse Data.
-
Create Clockify Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Clockify data access from reports, embedded analytics, and more.
-
Establish a Live Connection with Google Analytics Data using Tableau Bridge
The CData ODBC Driver for Google Analytics enables you to integrate live Google Analytics data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Live Shippo Data in MicroStrategy through CData Connect AI
Create a live connection to Shippo Data in CData Connect AI and connect to your Shippo data from MicroStrategy.
-
Create Informatica Mappings From/To a JDBC Data Source for Bitbucket
Create Bitbucket data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Explore Geographical Relationships in ADP Data with Power Map
Create data visualizations with ADP data in Power Map.
-
Prepare, Blend, and Analyze LDAP Objects in Alteryx Designer (Connect AI)
Build workflows to access live LDAP objects for self-service data analytics.
-
ETL Teamgate in Oracle Data Integrator
This article shows how to transfer Teamgate data into a data warehouse using Oracle Data Integrator.
-
Build Dashboards with Postmark Data in Dundas BI
Create dynamic dashboards and perform analytics based on Postmark data in Dundas BI.