CData Software - Knowledge Base
Recent Articles
-
Access Azure Table Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Azure Table data.
-
Analyze MailerLite Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for MailerLite from Power Pivot. You will use the Table Import Wizard to load MailerLite data. You can visually build the import query or use any SQL supported by the driver.
-
Build a Simple VCL Application for Chargebee Data
How to build a simple VCL Application to view Chargebee data in RAD Studio using the CData ODBC Driver for Chargebee.
-
Automated Continuous xBase Replication to SQL Server
Use CData Sync for automated, continuous, customizable xBase replication to SQL Server.
-
Create Outreach.io-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Outreach.io Data from Klipfolio and build custom visualizations using live Outreach.io data.
-
Automated Continuous Dynamics CRM Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Azure SQL Database.
-
How to Build an ETL App for Confluence Data in Python with CData Connect AI
Extract and transform live Confluence data in Python with petl and the CData Connect AI Python SDK.
-
Connect to Gorgias Data from PowerBuilder via ADO.NET
This article demonstrates how to access Gorgias data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Amazon DynamoDB Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Amazon DynamoDB data.
-
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 data.
-
Import Real-Time DB2 Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use DB2 data in ColdFusion.
-
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).
-
LINQ to Recurly 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 Recurly Data Provider.
-
Getting Started with the CData ODBC Driver for Gong
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Gong.
-
How to connect SharePoint with CouchDB Data through external lists
Provide CouchDB data to SharePoint users as an external list.
-
Query Intercom Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Intercom data from Node.js.
-
Integrate Dynamics 365 Business Central with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Dynamics 365 Business Central with External Services.
-
Getting Started with the CData SSIS Components for BigQuery
Complete guide to installing, licensing, and connecting with the CData SSIS Components for BigQuery.
-
Getting Started with the CData Power BI Connector for PabblySubscriptions
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
A Performance Comparison of Drivers for NoSQL
An article comparing the read performance of CData Software Drivers for MongoDB.
-
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.
-
DataBind Controls to Pipeline CRM Data in Delphi
DataBind to Pipeline CRM data in Delphi with standard data access components and controls.
-
Model, Search, and Visualize Live Zoho Projects Data in ThoughtSpot
Use CData Connect AI to connect to live Zoho Projects data for modeling, searching, and visualizing.
-
Feed BenchmarkEmail Data into FineReport
How to set BenchmarkEmail data as a JDBC data source in FineReport.
-
Create Dashboards and Visualize Live Oracle Service Cloud Data in Geckoboard
Use CData Connect AI to connect to live Oracle Service Cloud data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate with NetSuite Data in JReport Designer
Create charts and reports based on NetSuite data in JReport Designer.
-
Object-Relational Mapping (ORM) with LinkedIn 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 LinkedIn data into a Java-based ORM framework, Hibernate.
-
Build Dashboards with Neo4J Data in DBxtra
Create dynamic dashboards and perform analytics based on Neo4J data in DBxtra.
-
Connect ZohoDesk Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ZohoDesk data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Codat Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Codat data.
-
How to Connect to & Open ActiveCampaign Data in Microsoft Excel
This article uses the CData ODBC driver for ActiveCampaign to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use Grok to Talk to Your Redis 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 Redis data for you.
-
Create Epicor Kinetic Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Epicor Kinetic data access from reports, embedded analytics, and more.
-
Connect to Sybase IQ Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Sybase IQ to connect to Sybase IQ data and execute queries in PowerBuilder.
-
Integrating Antigravity CLI with Amazon DynamoDB data via CData CLI
Connect Amazon DynamoDB data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Salesforce Data 360-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Salesforce Data 360 Data and create custom apps in Mendix.
-
How to load SurveyMonkey data into Elasticsearch via Logstash
Introducing a simple method to load SurveyMonkey data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
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.
-
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.
-
Build HBase-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for HBase Data and create custom apps in Mendix.
-
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.
-
Build AgileCRM-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live AgileCRM data.
-
Automated Continuous Datadog Replication to MySQL
Use CData Sync for automated, continuous, customizable Datadog replication to MySQL.
-
Connect and Query Live Monday.com Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Monday.com data into Databricks and enable direct, live querying and analysis without replication.
-
Enable the Azure Table JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Azure Table data.
-
Use JayDeBeApi to access REST Data in Python
Use standard Python scripting and the development environment of your choice to access live REST data.
-
Replicate REST Data to Multiple Databases
Replicate REST data to disparate databases with a point-and-click configuration.
-
Viewing Google Search Results in RAD Studio Data Explorer
How to view Google Search results in RAD Studio Data Explorer using the CData ODBC Driver for Google Search.
-
Connect to Oracle HCM Cloud Data from PowerBuilder via ADO.NET
This article demonstrates how to access Oracle HCM Cloud data from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle HCM Cloud.
-
Integrate Trae with Live NetSuite SuiteAnalytics Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live NetSuite SuiteAnalytics data from within the AI-powered IDE.
-
Integrate Dify with Live Samanage 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 Samanage data.
-
Integrating Claude Code with Microsoft Entra ID Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft Entra ID data within assisted coding and automated development workflows.
-
Load Clio Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Clio data to a database.
-
How to connect PolyBase to Notion
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Notion data.
-
Work with Act-On Data in FoxPro
Load Act-On data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Manage MYOB AccountRight Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for MYOB AccountRight.
-
Prepare, Blend, and Analyze Google Contacts Data in Alteryx Designer (ODBC)
Build workflows to access live Google Contacts data for self-service data analytics.
-
Integrate Cline with Live Gmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Gmail data from within your IDE.
-
Query FHIR Data through ODBC in Node.js
Use node-odbc to execute SQL queries against FHIR data from Node.js.
-
Consume Greenhouse OData Feeds in PowerBuilder
This article demonstrates how to consume Greenhouse data as OData feeds from PowerBuilder using the API Server.
-
Connect to Wave Financial Data from AWS Glue
Use CData Connect AI to gain access to live Wave Financial data from your AWS Glue jobs.
-
Integrate with live ZohoDesk Data in Jitterbit
Use CData Connect AI to connect to and integrate live ZohoDesk data in Jitterbit.
-
Connect to SAP HANA Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP HANA data.
-
Build WooCommerce-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for WooCommerce Data and create custom apps in Bubble.
-
Create Dynamic Google Translate Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Translate to Infragistics XamDataGrid to build dynamic grids.
-
Build Automated Guru-Connected Workflows in Zapier
Use CData Connect AI to connect to live Guru data and build automated workflows in Zapier.
-
Process & Analyze Nethunt Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Nethunt Data.
-
Using the CData Software ODBC Driver for ZohoSubscriptions in PyCharm
Connect to ZohoSubscriptions as an ODBC data source in PyCharm using the CData Software ODBC Driver for ZohoSubscriptions.
-
Migrating data from Short.io to Databricks using CData SSIS Components.
Easily push Short.io data to Databricks using the CData SSIS Tasks for Short.io and Databricks.
-
Access Clio Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Clio data from your Oracle system.
-
Work with Live QuickBooks Data in Power Query
Use CData Connect AI to connect to QuickBooks data and work with live QuickBooks data in Microsoft Power Query.
-
Bridge AfterShip Connectivity with Apache NiFi
Access and process AfterShip data in Apache NiFi using the CData JDBC Driver.
-
Replicate Pinecone Data in Heroku for Use in Salesforce Connect
Replicate Pinecone data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Query Live Smartsheet Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Smartsheet data data in natural language using Python.
-
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.
-
Excel Spreadsheet Automation on RabbitMQ Data with the QUERY Formula
Pull data from RabbitMQ, automate spreadsheets, and more with the QUERY formula.
-
Visualize Live ActiveCampaign Data in the Power BI Service
Use CData Connect AI to connect to live ActiveCampaign data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Claude to Talk to Your Dropbox 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 Dropbox data for you.
-
Migrating data from Bugsnag to Google BigQuery using CData SSIS Components.
Easily push Bugsnag data to Google BigQuery using the CData SSIS Tasks for Bugsnag and Google BigQuery.
-
Connect to Google Campaign Manager 360 Data in NetBeans
Connect to Google Campaign Manager 360 data in NetBeans with the data source configuration wizard.
-
Create Reports with SingleStore Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SingleStore data.
-
Excel Spreadsheet Automation on Gmail Data with the QUERY Formula
Pull data from Gmail, automate spreadsheets, and more with the QUERY formula.
-
Build Semantic Layer Views for Zuora Data in APOS Live Data Gateway
Use the CData Connector for Zuora in APOS Live Data Gateway to build Semantic Layer Views for Zuora data.
-
Query Presto Data as a MySQL Database in Node.js
Execute MySQL queries against Presto data from Node.js.
-
Stream Greenplum Data into Apache Kafka Topics
Access and stream Greenplum data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Analyze Apify Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Apify data and visualize Apify data in SAP Analytics Cloud.
-
Publish Reports with Zoho Books Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoho Books data.
-
How to Work with Moosend Data in ETL Validator JDBC
Connect to Moosend from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect SingleStore Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SingleStore data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Write a Simple Go Application to work with WordPress Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to WordPress data.
-
Migrating data from Spotify to Databricks using CData SSIS Components.
Easily push Spotify data to Databricks using the CData SSIS Tasks for Spotify and Databricks.
-
Using the CData Software ODBC Driver for Aha! in PyCharm
Connect to Aha! as an ODBC data source in PyCharm using the CData Software ODBC Driver for Aha!.
-
How to connect SharePoint with SAP Hybris C4C Data through external lists
Provide SAP Hybris C4C data to SharePoint users as an external list.
-
Build Automated Workflows with Live Zoho CRM Data in Workato
Use CData Connect AI to connect to live Zoho CRM data and build automated workflows in Workato.
-
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.