CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Paylocity Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Paylocity data replication to OneLake in Microsoft Fabric.
-
Automated Continuous Sage 300 Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Sage 300 replication to delimited files (CSV/TSV).
-
Migrating data from Brex to Snowflake using CData SSIS Components.
Easily push Brex data to Snowflake using the CData SSIS Tasks for Brex and Snowflake.
-
How to Work with Cohere Data in ETL Validator JDBC
Connect to Cohere from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Landbot Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Landbot replication to Amazon S3.
-
Automated Continuous Klaviyo Replication to Snowflake
Use CData Sync for automated, continuous, customizable Klaviyo replication to Snowflake.
-
Query Intercom Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Intercom data from Node.js.
-
Validate Dynamics CRM Data with QuerySurge
Access and validate Dynamics CRM data in QuerySurge using the CData JDBC Driver.
-
How to Work with Marketo Data in ETL Validator JDBC
Connect to Marketo from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating Claude Code CLI with Helpscout 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.
-
Build MVC Applications with Connectivity to PhantomBuster Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access PhantomBuster from an ASP.NET MVC application.
-
Easily Integrate Drip Data in Lazarus Pascal IDE
Learn how to easily integrate live Drip data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to SingleStore Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live SingleStore data.
-
Automated Continuous Amplitude Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Amplitude replication to Apache Kafka.
-
Enable the Apify JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Apify data.
-
DataBind SpaceX Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide SpaceX data to a chart.
-
Integrate with Elorus Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Elorus data to a JSON file on disk.
-
Connect to Google Ad Manager Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Ad Manager and the SQL Gateway to access Google Ad Manager data from Google Apps Script.
-
Replicate HubDB Data from PowerShell
Write a quick PowerShell script to query HubDB data. Use connectivity to the live data to replicate HubDB data to SQL Server.
-
Cassandra Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Cassandra data through CData Connect AI using different applications and tools.
-
Automated Continuous Airtable Replication to MySQL
Use CData Sync for automated, continuous, customizable Airtable replication to MySQL.
-
Seamlessly Bring Sage 300 Data into Retool Using CData Connect AI
Integrate Sage 300 data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Aircall
Provide connectivity to Aircall data through an SAP BusinessObjects universe.
-
How to Visualize Sage Cloud Accounting Data in Python with pandas
Use pandas and other modules to analyze and visualize live Sage Cloud Accounting data in Python.
-
Create SharePoint-Connected Nintex Workflows
Use CData Connect AI to connect to SharePoint Data from Nintex Workflow Cloud and build custom workflows using live SharePoint data.
-
Automated Continuous OneNote Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable OneNote replication to Amazon Redshift.
-
Migrating data from Xero to Snowflake using CData SSIS Components.
Easily push Xero data to Snowflake using the CData SSIS Tasks for Xero and Snowflake.
-
How to Connect DBeaver to ZeroBounce via a JDBC Driver
Manage ZeroBounce data with visual tools in DBeaver like the query browser.
-
Visualize Zoom 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 Zoom data into TIBCO Spotfire.
-
How to work with HBase Data in Apache Spark using SQL
Access and process HBase Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live Zoho Inventory 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 Zoho Inventory data through MCP integration.
-
Connect to Zoho Books Data in ACL Analytics
Connect to Zoho Books data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Zoho Books data.
-
How to Build an ETL App for Sage Intacct Data in Python with CData Connect AI
Build ETL pipelines that read and write live Sage Intacct data in Python with petl and the CData Connect AI Python SDK.
-
Access Live Salesforce CRM Analytics Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Salesforce CRM Analytics data from your Excel spreadsheets.
-
Query Azure DevOps Data in ColdFusion
Write standard ColdFusion data access code to connect to Azure DevOps data.
-
How to Work with Figshare Data in ETL Validator JDBC
Connect to Figshare from ETL Validator jobs using the CData Software JDBC Driver.
-
Visualize Live Spotify Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Spotify data.
-
How to create Supabase federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Supabase data in MySQL .
-
Create Data Visualizations Based On GraphQL Data in Mode
Use CData Connect AI to connect to GraphQL Data from Mode and build visualizations using live GraphQL data.
-
Automated Continuous Certinia Replication to SQL Server
Use CData Sync for automated, continuous, customizable Certinia replication to SQL Server.
-
Connect to Superchat Data in HULFT Integrate
Connect to Superchat as a JDBC data source in HULFT Integrate
-
Build Dashboards with Perigon Data in Dundas BI
Create dynamic dashboards and perform analytics based on Perigon data in Dundas BI.
-
Build Dashboards with Kintone Data in Dundas BI
Create dynamic dashboards and perform analytics based on Kintone data in Dundas BI.
-
Build Gong-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 Gong data without replication.
-
How to Connect to Live MailChimp Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your MailChimp data for you.
-
Publish Reports with Shopify Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Shopify data.
-
Integrate Cursor with Live Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Amazon DynamoDB data from within the editor.
-
Analyze Active Directory Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Active Directory data in Microsoft R Open.
-
Automated Continuous Close Replication to Snowflake
Use CData Sync for automated, continuous, customizable Close replication to Snowflake.
-
Create SAP HANA-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP HANA Data from OutSystems and build custom enterprise apps using live SAP HANA data.
-
Access Microsoft Teams Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Teams data from your Oracle system.
-
Connect to Harvest Data from PowerBuilder via JDBC
This article demonstrates how to access Harvest data from PowerBuilder using the Harvest JDBC Driver.
-
How to connect PolyBase to Anaplan
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Anaplan data.
-
Automated Continuous Demio Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Demio data replication to OneLake in Microsoft Fabric.
-
Replicate Multiple Facebook Accounts via the CData Sync CLI
Replicate multiple Facebook accounts to one or many databases.
-
Connect to HBase Data in NetBeans
Connect to HBase data in NetBeans with the data source configuration wizard.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for QuickBooks Online
Provide connectivity to QuickBooks Online data through an SAP BusinessObjects universe.
-
Automated Continuous Sage 200 Replication to Vertica
Use CData Sync for automated, continuous, customizable Sage 200 replication to Vertica.
-
Create Sugar CRM-Connected Dashboards in Grafana
Connect to Sugar CRM Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Sugar CRM data.
-
Access Rebilly Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Rebilly data from your Oracle system.
-
Migrating data from Microsoft Ads to Snowflake using CData SSIS Components.
Easily push Microsoft Ads data to Snowflake using the CData SSIS Tasks for Microsoft Ads and Snowflake.
-
Use Dash to Build Web Apps on Bitbucket Data via CData Connect AI
Build interactive Dash web apps on live Bitbucket data using pandas and the CData Connect AI Python SDK.
-
Automate Elasticsearch Data Replication to SAP HANA
Use CData Sync to customize and automate Elasticsearch data replication to SAP HANA.
-
Create Azure Data Lake Storage-Connected Business Apps in AppSheet
Connect to Azure Data Lake Storage Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Azure Data Lake Storage data.
-
How to Easily Query Dotmailer Data in OpenOffice Base
Connect to Dotmailer data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous Pushbullet Replication to Oracle
Use CData Sync for automated, continuous, customizable Pushbullet replication to Oracle.
-
Use Grok to Talk to Your CSV 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 CSV data for you.
-
How to Work with Moosend Data in ETL Validator JDBC
Connect to Moosend from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect SharePoint with SAP Hybris C4C Data through external lists
Provide SAP Hybris C4C data to SharePoint users as an external list.
-
Connect to Adobe Experience Manager from a Connection Pool in WebLogic
Use the CData JDBC Driver for Adobe Experience Manager to connect to Adobe Experience Manager data from Web applications running on WebLogic.
-
Integrating Codex with Quaderno 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 with live SAP Fieldglass Data in Jitterbit
Use CData Connect AI to connect to and integrate live SAP Fieldglass data in Jitterbit.
-
Use Dash to Build Web Apps on SAP Ariba Source Data via CData Connect AI
Build interactive Dash web apps on live SAP Ariba Source data using pandas and the CData Connect AI Python SDK.
-
Automate Outlook Data Replication to Azure Data Lake
Use CData Sync to customize and automate Outlook data replication to Azure Data Lake.
-
Create AlloyDB-Connected Business Apps in AppSheet
Connect to AlloyDB Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to AlloyDB data.
-
Use Grok to Talk to Your BambooHR 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 BambooHR data for you.
-
Integrate OpenCode with Live CockroachDB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live CockroachDB data from within your AI coding agent.
-
LINQ to Simplesat Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Simplesat Data Provider.
-
Integrating LangGraph with SAP Ariba Source Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SAP Ariba Source data within automated workflows.
-
Create Informatica Mappings From/To an ODBC Data Source for Zoho Books
Create an ODBC connection to Zoho Books in Informatica and browse and transfer Zoho Books data.
-
Connect to Azure Analysis Services Data in RazorSQL
Connect to Azure Analysis Services from wizards and query Azure Analysis Services data from the GUI in the RazorSQL database management tool.
-
How to Visualize Google Cloud Storage Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Cloud Storage data in Python.
-
Build Data Flows from SQL Server to SharePoint Excel Services through SSIS
Easily push SQL Server data to SharePoint Excel Services using the CData SSIS Tasks for SharePoint Excel Services.
-
Connect to Gmail from Asprova with CData Software ODBC Driver for Gmail
This article shows how to connect faster to Gmail data from Asprova.
-
Integrate Zoom with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Zoom with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Zoom data.
-
Query, Visualize, and Share live ShipEngine Data in Redash
Use CData Connect AI to connect to live ShipEngine data in Redash for querying, visualizing, and sharing.
-
Model Suadeo Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Suadeo, enabling the direct import of real-time Suadeo data.
-
Import and Visualize REST Data in Power View
Create data visualizations based on REST data in Excel.
-
Use the CData Software ODBC Driver for Adobe Commerce in SAS for Real-Time Reporting and Analytics
Connect to real-time Adobe Commerce data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Adobe Commerce.
-
Automated Continuous Vimeo Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Vimeo data replication to OneLake in Microsoft Fabric.
-
DataBind Mistral AI Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Mistral AI data to a chart.
-
Integrating Claude Code CLI with Parquet 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.
-
Build Twitter Ads-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Twitter Ads Data and create custom apps in Bubble.
-
Natively Connect to Customer.io Data in PHP
The CData ODBC driver for Customer.io enables you to create PHP applications with connectivity to Customer.io data. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData ADO.NET Provider for Reckon Accounts Hosted
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Reckon Accounts Hosted.
-
Manage AdRoll Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for AdRoll.
-
Import and Visualize Okta Data in Power View
Create data visualizations based on Okta data in Excel.
-
Use the CData Software JDBC Driver for Tanda in MicroStrategy Desktop
Connect to Tanda data in MicroStrategy Desktop using the CData Software JDBC Driver for Tanda.
-
Using CData JDBC Drivers in ColdFusion
This article will demonstrate how to use the CData JDBC Drivers with ColdFusion. Included are steps for adding the CData JDBC Driver as a data source, as well as basic ColdFusion code to query the data source and display results.
-
Analyze Zoom Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zoom from Power Pivot. You will use the Table Import Wizard to load Zoom data. You can visually build the import query or use any SQL supported by the driver.