CData Software - Knowledge Base
Recent Articles
-
Analyze Live Basecamp Data in SAS Viya
Use CData Connect AI to connect to Basecamp from SAS Viya and deploy self-service analytics using live Basecamp.
-
Use JayDeBeApi to access Microsoft Exchange Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Exchange.
-
Integrating Codex CLI with Amplitude 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 PolyBase to Adobe Experience Manager
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Adobe Experience Manager.
-
Operational Reporting on PostgreSQL Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote PostgreSQL.
-
Visualize Live Salesloft Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Salesloft.
-
Automated Continuous Paylocity Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Paylocity replication to OneLake in Microsoft Fabric.
-
How to Query Live Amazon S3 Data in Perplexity MacOS Desktop
Connect to and query live Amazon S3 Data in Perplexity Desktop using CData MCP Server.
-
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 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 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 from Node.js.
-
Extend Google Sheets with Cassandra Data
Make calls to Cassandra from Google Apps Script via the API Server.
-
Validate Dynamics CRM Data with QuerySurge
Access and validate Microsoft Dynamics CRM 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 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.
-
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.
-
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 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 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 from Google Apps Script.
-
Replicate HubDB Data from PowerShell
Write a quick PowerShell script to query HubDB. Use connectivity to the live data to replicate HubDB to SQL Server.
-
Cassandra Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Apache Cassandra 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.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Aircall
Provide connectivity to Aircall 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 Business Cloud Accounting 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 Microsoft SharePoint.
-
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 Accounting to Snowflake using the CData SSIS Tasks for Xero and Snowflake.
-
How to Connect DBeaver to ZeroBounce via a JDBC Driver
Manage ZeroBounce 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 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 through MCP integration.
-
Connect to Zoho Books Data in ACL Analytics
Connect to Zoho Books via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Zoho Books.
-
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 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 from your Excel spreadsheets.
-
Query Azure DevOps Data in ColdFusion
Write standard ColdFusion data access code to connect to Azure DevOps.
-
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.
-
How to create Supabase federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Supabase in MySQL .
-
Object-Relational Mapping (ORM) with LionDesk Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to LionDesk into a Java-based ORM framework, Hibernate.
-
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
-
Use the CData API Server to Access Microsoft Dataverse Data in Microsoft PowerPivot
Use the CData API Server to connect to live Microsoft Dataverse (CDS) in the Power Pivot business intelligence tool.
-
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 in Dundas BI.
-
Build Dashboards with Kintone Data in Dundas BI
Create dynamic dashboards and perform analytics based on Kintone in Dundas BI.
-
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 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.
-
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 from within the editor.
-
Use the CData Software ODBC Driver for PivotalTracker in SAS for Real-Time Reporting and Analytics
Connect to real-time PivotalTracker in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for PivotalTracker.
-
Analyze Active Directory Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Active Directory in Microsoft R Open.
-
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.
-
Access Microsoft Teams Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Teams from your Oracle system.
-
Connect to Harvest Data from PowerBuilder via JDBC
This article demonstrates how to access Harvest 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.
-
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 Apache HBase 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 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.
-
Access Rebilly Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Rebilly from your Oracle system.
-
Migrating data from Microsoft Ads to Snowflake using CData SSIS Components.
Easily push Microsoft Ads to Snowflake using the CData SSIS Tasks for Microsoft Ads and Snowflake.
-
Integrate LionDesk with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate LionDesk with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to LionDesk.
-
Automate Elasticsearch Data Replication to SAP HANA
Use CData Sync to customize and automate Elasticsearch 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.
-
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.
-
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/TSV Files 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 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 from Web applications running on WebLogic.
-
Integrating Codex CLI with Quaderno 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 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 using pandas and the CData Connect AI Python SDK.
-
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 Google AlloyDB.
-
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 for you.
-
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 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.
-
Connect to Azure Analysis Services Data in RazorSQL
Connect to Azure Analysis Services from wizards and query Azure Analysis Services 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 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.
-
Import and Visualize REST Data in Power View
Create data visualizations based on REST 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 in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Adobe Commerce.
-
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 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. 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 in Excel.
-
Use the CData Software JDBC Driver for Tanda in MicroStrategy Desktop
Connect to Tanda 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. You can visually build the import query or use any SQL supported by the driver.