CData Software - Knowledge Base
Recent Articles
-
Automated Continuous SQL Server Replication to SingleStore
Use CData Sync for automated, continuous, customizable SQL Server replication to SingleStore.
-
Use the CData Software ODBC Driver for QuickBooks Online in SAS for Real-Time Reporting and Analytics
Connect to real-time QuickBooks Online in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for QuickBooks Online.
-
Access Live eBay Analytics Data in AWS Lambda (with IntelliJ IDEA)
Connect to live eBay Analytics in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Sage 300 Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Sage 300 replication to PostgreSQL.
-
How to Build an ETL App for Microsoft Entra ID Data in Python with CData Connect AI
Build ETL pipelines that read and write live Microsoft Entra ID in Python with petl and the CData Connect AI Python SDK.
-
Consume Salesforce Pardot OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Salesforce Pardot feeds that reflect any changes in SAP Lumira.
-
Connect to ConvertAPI Data in DBeaver
Use the CData ODBC Driver to connect to ConvertAPI in DBeaver.
-
Model Cloudant Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Cloudant, enabling the direct import of real-time IBM Cloudant.
-
How to publish and share Zoho Recruit Data dashboards with Tableau Server
The CData ODBC driver for Zoho Recruit enables you integrate Zoho Recruit into Tableau dashboards.
-
Build Charts with ZohoDesk Data in Clear Analytics
Create dynamic charts and perform analytics based on ZohoDesk in Clear Analytics.
-
Connect to MariaDB Data in Claris FileMaker Pro
Use the CData ODBC Driver for MariaDB in FileMaker Pro to connect to MariaDB and work with MariaDB in your FileMaker applications.
-
DataBind Controls to Bullhorn CRM Data in C++Builder
DataBind to Bullhorn CRM in C++Builder with standard components and controls.
-
Replicate Vault CRM Data to Multiple Databases via the CData Sync CLI
Replicate Veeva Vault & Vault CRM to disparate databases with a single configuration.
-
Integrating Claude Code with SAS xpt Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAS XPORT within assisted coding and automated development workflows.
-
Integrating OpenCode Terminal with Gong 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.
-
Use the CData Software ODBC Driver for Freshsales in MicroStrategy
Connect to Freshsales in MicroStrategy Developer using the CData Software ODBC Driver for Freshsales.
-
Access Live Dynamics 365 Data in TIBCO Data Virtualization
Use the Dynamics 365 Tibco DV Adapter to create a Microsoft Dynamics 365 data source in TIBCO Data Virtualization Studio and gain access to live Microsoft Dynamics 365 from your TDV Server.
-
Connect to Excel Data in DBArtisan
Use wizards in DBArtisan to configure Microsoft Excel as a data source.
-
Build Automated FTP-Connected Workflows in Zapier
Use CData Connect AI to connect to live FTP Servers and build automated workflows in Zapier.
-
How to update Cloudant from Excel
This article explains how to transfer data from Excel to Cloudant using the Excel Add-In for Cloudant.
-
Build Sage 200-Connected Apps in Choreo
Use CData Connect AI to connect to Sage 200 Data from Choreo and build custom apps using live Sage 200.
-
Use the CData Software ODBC Driver for Greenhouse in MicroStrategy Desktop
Connect to Greenhouse in MicroStrategy Desktop using the CData Software ODBC Driver for Greenhouse.
-
Visualize Live Outreach.io Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Outreach.io into custom reports in Power BI.
-
Establish a Live Connection with PolarTeamPro Data using Tableau Bridge
The CData ODBC Driver for PolarTeamPro enables you to integrate live PolarTeamPro into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Pipeline CRM Data in TIBCO Spotfire through ADO.NET
Integrate Pipeline CRM into dashboards in TIBCO Spotfire.
-
Integrate iContact Data in Pentaho Data Integration
Build ETL pipelines based on iContact in the Pentaho Data Integration tool.
-
Connect to GraphQL Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for GraphQL Data and connect to GraphQL in Akorbi Digital RunMyProcess.
-
Integrate with Live Zoho Creator Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Zoho Creator from the MuleSoft Anypoint Platform to integrate live Zoho Creator into custom reports and dashboards.
-
Integrate FormSite Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live FormSite from Informatica Cloud.
-
Automated Continuous SurveyMonkey Replication to Vertica
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Vertica.
-
Automated Continuous Odoo Replication to SQL Server
Use CData Sync for automated, continuous, customizable Odoo replication to SQL Server.
-
Create FreshBooks-Connected Business Apps in AppSheet
Connect to FreshBooks Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to FreshBooks.
-
Automated Continuous Clio Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Clio replication to Apache Cassandra.
-
How to Access Pipeliner CRM Data Using Entity Framework
This article shows how to access Pipeliner CRM using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Creating Cassandra-Connected Applications in Unqork
You can use CData Connect AI to feed Apache Cassandra to Unqork and build custom business apps.
-
Integrate LibreChat with Live AlloyDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google AlloyDB from within the chat interface.
-
Integrate Live ShipEngine Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ShipEngine to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to and Query Todoist Data in QlikView over ODBC
Create data visualizations with Todoist in QlikView.
-
Automated Continuous MySQL Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable MySQL replication to Apache Cassandra.
-
Analyze Live SendGrid Data in SAS Viya
Use CData Connect AI to connect to SendGrid from SAS Viya and deploy self-service analytics using live SendGrid.
-
Create Reports from Vault CRM Data in Looker Studio
Use CData Connect AI to gain access to live Veeva Vault & Vault CRM and create custom reports in Looker Studio.
-
Create Data Visualizations in Cognos BI with Google Forms Data
Access Google Forms as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Visualize Superchat Data in TIBCO Spotfire through ADO.NET
Integrate Superchat into dashboards in TIBCO Spotfire.
-
Connect to Clio Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Clio as an External Source in Dremio.
-
Import Real-Time Gumroad Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Gumroad in ColdFusion.
-
How to Connect to Live SendGrid Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SendGrid without replication.
-
How to Create Power BI Visual Reports with Real-Time Freshsales Data
Use CData Power BI Connectors to visualize Freshsales in Power BI.
-
Query Microsoft Dataverse Data in DataGrip
Create a Data Source for Microsoft Dataverse in DataGrip and use SQL to query live Microsoft Dataverse (CDS).
-
Integrating LlamaIndex with Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Microsoft Entra ID in real time.
-
Create Unbounce Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Unbounce from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Couchbase Data in DBArtisan
Use wizards in DBArtisan to configure Couchbase as a data source.
-
Visualize Guru Data in Sisense
Create an ElastiCube in Sisense app with access to Guru.
-
Access Live Simplesat Data in AWS Lambda
Connect to live Simplesat in AWS Lambda using the CData JDBC Driver.
-
Build a PostgreSQL Interface for Zoho Projects Data using the CData JDBC Driver
Use the Remoting features of the Zoho Projects JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Mistral AI Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Mistral AI in Microsoft R Open.
-
Sendwithus Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Sendwithus facts in real time.
-
How to Seamlessly Import SAS xpt Data into IBM SPSS Modeler
Integrate SAS xpt data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Visualizations of Clari Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Clari in Birst.
-
Automated Continuous Optimizely Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Optimizely replication to IBM DB2.
-
Automated Continuous AdRoll Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable AdRoll replication to Azure SQL Database.
-
Connect to ServiceNow Data from Crystal Reports
Use CData Connect AI to connect to and report on live ServiceNow from Crystal Reports.
-
Integrating GitHub Copilot CLI with Kintone 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 Twilio Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Twilio from an ASP.NET MVC application.
-
How to Connect to Live Zoho Inventory Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Zoho Inventory securely in real time.
-
Prepare, Blend, and Analyze Amazon DynamoDB Data in Alteryx Designer (ODBC)
Build workflows to access live Amazon DynamoDB for self-service data analytics.
-
Feed Missive Data into FineReport
How to set Missive as a JDBC data source in FineReport.
-
Build ZohoMarketingHub-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ZohoMarketingHub.
-
Visualize Live DocuSign Data in the Power BI Service
Use CData Connect AI to connect to live DocuSign and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Migrating data from Wistia to Databricks using CData SSIS Components.
Easily push Wistia to Databricks using the CData SSIS Tasks for Wistia and Databricks.
-
Analyze SAP Ariba Procurement Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of SAP Ariba Procurement and visualize live SAP Ariba Procurement in Infragistics Reveal.
-
Automated Continuous Shortcut Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Shortcut replication to Amazon Redshift.
-
Replicate Google Campaign Manager 360 Data to Multiple Databases via the CData Sync CLI
Replicate Google Campaign Manager 360 to disparate databases with a single configuration.
-
Connect to Supabase Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Supabase and work with Supabase in your FileMaker applications.
-
Migrating data from QuickBooks to Snowflake using CData SSIS Components.
Easily push QuickBooks Desktop to Snowflake using the CData SSIS Tasks for QuickBooks and Snowflake.
-
Access Live Helpscout Data in AWS Lambda
Connect to live Helpscout in AWS Lambda using the CData JDBC Driver.
-
Connect Aweber Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Aweber using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect to Live Avro Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Apache Avro through natural language.
-
Build Pipelines with Live MailChimp Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to MailChimp from Google Cloud Data Fusion, enabling the integration of live MailChimp into the building and management of effective data pipelines.
-
Connect to SAP Business One Data in HULFT Integrate
Connect to SAP Business One as a JDBC data source in HULFT Integrate
-
Analyze SAP SuccessFactors Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP SuccessFactors in Microsoft R Open.
-
Connect to SAP Fieldglass Data in RazorSQL
Connect to SAP Fieldglass from wizards and query SAP Fieldglass from the GUI in the RazorSQL database management tool.
-
Create WordPress-Connected Applications in Appsmith
Connect to WordPress Data via CData Connect AI in Appsmith and create custom business applications with real-time access to WordPress.
-
Build Automated Microsoft Dataverse-Connected Workflows in Zapier
Use CData Connect AI to connect to live Microsoft Dataverse (CDS) and build automated workflows in Zapier.
-
Connect ZeroBounce to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ZeroBounce with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Odoo Data in Pentaho Data Integration
Build ETL pipelines based on Odoo ERP in the Pentaho Data Integration tool.
-
Bridge FreshBooks Connectivity with Apache NiFi
Access and process FreshBooks in Apache NiFi using the CData JDBC Driver.
-
Connect to Sybase IQ Data in DBeaver
Use the CData ODBC Driver to connect to Sybase IQ in DBeaver.
-
Use CData Connect AI to Access Apollo Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Apollo in the Power Pivot business intelligence tool.
-
Access Live Blackbaud FE NXT Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Blackbaud FE NXT into the statistical analysis tools available in SAS JMP. This article shows how to use Blackbaud FE NXT in the Graph Builder and Query Builder.
-
Use the CData Software ODBC Driver for Elorus in MicroStrategy
Connect to Elorus in MicroStrategy Developer using the CData Software ODBC Driver for Elorus.
-
Getting Started with the CData JDBC Driver for Azure Synapse
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Azure Synapse.
-
Connect to Auth0 Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Auth0.
-
Replicate Multiple DB2 Accounts
Replicate multiple DB2 accounts to one or many databases.
-
How to Work with Greenplum Data in ETL Validator JDBC
Connect to Greenplum from ETL Validator jobs using the CData Software JDBC Driver.
-
Automate Twitter Ads Data Replication to SAP HANA
Use CData Sync to customize and automate Twitter Ads replication to SAP HANA.
-
Object-Relational Mapping (ORM) with Superchat 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 Superchat into a Java-based ORM framework, Hibernate.
-
Access Live SAP SuccessFactors LMS Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP SuccessFactors LMS from your Google Sheets.
-
Integrating Gumloop with Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Freshservice within automated workflows.
-
Automated Continuous Invoiced Replication to MySQL
Use CData Sync for automated, continuous, customizable Invoiced replication to MySQL.
-
Natively Connect to ZohoPeople Data in PHP
The CData ODBC driver for ZohoPeople enables you to create PHP applications with connectivity to ZohoPeople. Leverage the native support for ODBC in PHP.