CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Python Connector for JSON
Learn to install and license the CData Python Connector and configure a connection to live JSON services.
-
Query Front Data in ColdFusion
Write standard ColdFusion data access code to connect to Front data.
-
Feed Excel Data into FineReport
How to set Excel data as a JDBC data source in FineReport.
-
Connect to Smartsheet Data in ACL Analytics
Connect to Smartsheet data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Smartsheet data.
-
Getting Started with the CData SSIS Components for Retently
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Retently.
-
Import Real-Time Asana Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Asana data in ColdFusion.
-
How to integrate TigerGraph with Apache Airflow
Access and process TigerGraph data in Apache Airflow using the CData JDBC Driver.
-
Query CouchDB Data as a MySQL Database in Node.js
Execute MySQL queries against CouchDB data from Node.js.
-
Publish ShipEngine-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ShipEngine data.
-
Model, Search, and Visualize Live Act CRM Data in ThoughtSpot
Use CData Connect AI to connect to live Act CRM data for modeling, searching, and visualizing.
-
How to connect and process Oracle Sales data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Oracle Sales data.
-
Build Sugar CRM-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Sugar CRM Data from Zoho Analytics and import live Sugar CRM data.
-
Build Oracle HCM Cloud-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Oracle HCM Cloud data.
-
Seamlessly Bring Microsoft Entra ID Data into Retool Using CData Connect AI
Integrate Microsoft Entra ID data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
DataBind Charts to Couchbase Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Couchbase data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Create GitLab-Connected Nintex Workflows
Use CData Connect AI to connect to GitLab Data from Nintex Workflow Cloud and build custom workflows using live GitLab data.
-
Access Live Dynamics CRM Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Dynamics CRM data from your Excel spreadsheets.
-
Replicate Invoiced Data to Multiple Databases via the CData Sync CLI
Replicate Invoiced data to disparate databases with a single configuration.
-
Seamlessly Bring SAP Netweaver Gateway Data into Retool Using CData Connect AI
Integrate SAP Netweaver Gateway data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Connect ClickUp Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live ClickUp data in real time using natural language.
-
Visualize Live Phoenix Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Phoenix data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Migrating data from Avro to Google BigQuery using CData SSIS Components.
Easily push Avro data to Google BigQuery using the CData SSIS Tasks for Avro and Google BigQuery.
-
How to Connect DBeaver to Gumroad via a JDBC Driver
Manage Gumroad data with visual tools in DBeaver like the query browser.
-
Replicate LinkedIn Data in Heroku for Use in Salesforce Connect
Replicate LinkedIn data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Oracle Financials Cloud Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Oracle Financials Cloud data.
-
How to connect SharePoint with CSV Data through external lists
Provide CSV data to SharePoint users as an external list.
-
Automated Continuous Guru Replication to SingleStore
Use CData Sync for automated, continuous, customizable Guru replication to SingleStore.
-
How to Build an ETL App for Pipeliner CRM Data in Python with CData
Create ETL applications and real-time data pipelines for Pipeliner CRM data in Python with petl.
-
Create Datasets from RabbitMQ in Domo Workbench and Build Visualizations of RabbitMQ Data in Domo
Use the CData Software ODBC Driver for RabbitMQ to create datasets from RabbitMQ data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Bright Data Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Bright Data replication to Apache Cassandra.
-
Natively Connect to Google Sheets Data in PHP
The CData ODBC driver for Google Sheets enables you to create PHP applications with connectivity to Google Sheets data. Leverage the native support for ODBC in PHP.
-
Integrate Live Printify Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Printify data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Use the CData ODBC Driver for SAP Ariba Procurement from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP Ariba Procurement to connect to SAP Ariba Procurement data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP Ariba Procurement data in Excel.
-
Integrate Cline with Live Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Outreach.io data from within your IDE.
-
Automated ZohoExpense Data Replication to Teradata
Use CData Sync to Customize and automate ZohoExpense data replication to Teradata.
-
LINQ to LinkedIn 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 LinkedIn Data Provider.
-
Work with Live Splunk Data in Power Query
Use CData Connect AI to connect to Splunk data and work with live Splunk data in Microsoft Power Query.
-
Create Sendwithus-Connected Dashboards in Grafana
Connect to Sendwithus Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Sendwithus data.
-
Extract, Transform, and Load Short.io Data in Informatica PowerCenter
Create a simple Workflow for Short.io data in Informatica PowerCenter.
-
Create HBase-Connected Applications in Appsmith
Connect to HBase Data via CData Connect AI in Appsmith and create custom business applications with real-time access to HBase data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for FormSite
Provide connectivity to FormSite data through an SAP BusinessObjects universe.
-
Integrating LangChain with HubDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on HubDB data within automated workflows.
-
Create Mailjet-Connected Applications in Appsmith
Connect to Mailjet Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Mailjet data.
-
Publish HubSpot-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live HubSpot data.
-
How to connect to Exact Online Data with Squirrel SQL client
Connect to Exact Online data and execute queries in the Squirrel SQL Client.
-
Integrate with Cosmos DB Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Cosmos DB data to a JSON file on disk.
-
Automated Continuous Sage 300 Replication to SQL Server
Use CData Sync for automated, continuous, customizable Sage 300 replication to SQL Server.
-
Automated Continuous Elorus Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Elorus replication to Google Cloud SQL.
-
Publish SAP Concur-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP Concur data.
-
Automated Continuous ScrapingBee Replication to SingleStore
Use CData Sync for automated, continuous, customizable ScrapingBee replication to SingleStore.
-
Create Reports with LaunchDarkly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date LaunchDarkly data.
-
Automate Planio Data Replication to Couchbase
Use CData Sync to Customize and automate Planio data replication to Couchbase.
-
How to Connect to Live GitLab 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 GitLab data through natural language.
-
Connect to Oracle Service Cloud Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Oracle Service Cloud Data and connect to Oracle Service Cloud data in Akorbi Digital RunMyProcess.
-
How to Seamlessly Import Klipfolio Data into IBM SPSS Modeler
Integrate Klipfolio data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connecting Moonlit Workflow with Avro Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Avro data in real time.
-
Integrating OpenCode with Cosmos DB 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.
-
Replicate Multiple Zoom Accounts via the CData Sync CLI
Replicate multiple Zoom accounts to one or many databases.
-
Connect to Jumpseller Data from AWS Glue
Use CData Connect AI to gain access to live Jumpseller data from your AWS Glue jobs.
-
How to connect to Google Campaign Manager 360 Data with Squirrel SQL client
Connect to Google Campaign Manager 360 data and execute queries in the Squirrel SQL Client.
-
How to Connect to Live Attio 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 Attio data for you.
-
Access Google Spanner Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Spanner data from your Oracle system.
-
Import and Visualize SAP HANA XS Advanced Data in Power View
Create data visualizations based on SAP HANA XS Advanced data in Excel.
-
Import and Visualize Asana Data in Power View
Create data visualizations based on Asana data in Excel.
-
Use Biml to Build SSIS Tasks to Replicate HBase Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate HBase data to SQL Server.
-
Automate Typeform Data Replication to SAP HANA
Use CData Sync to customize and automate Typeform data replication to SAP HANA.
-
How to Access Insightly Data Using Entity Framework
This article shows how to access Insightly data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to work with Printify Data in Apache Spark using SQL
Access and process Printify Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to Live Okta Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Okta data for you.
-
Bind Live Act CRM Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Act CRM data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Integrate HelloSign with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate HelloSign with External Services.
-
Use the CData Software JDBC Driver for IBM Informix in MicroStrategy Desktop
Connect to IBM Informix data in MicroStrategy Desktop using the CData Software JDBC Driver for IBM Informix.
-
Query Scrapfly Data in DataGrip
Create a Data Source for Scrapfly in DataGrip and use SQL to query live Scrapfly data.
-
Feed Toggl Data into FineReport
How to set Toggl data as a JDBC data source in FineReport.
-
Visualize Live Act-On Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Act-On data into custom reports in Power BI.
-
Automate Harvest Data Replication to Couchbase
Use CData Sync to Customize and automate Harvest data replication to Couchbase.
-
Automated Continuous Paymo Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Paymo replication to Google Cloud SQL.
-
How to Access Live Bullhorn CRM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Bullhorn CRM enables you to integrate Bullhorn CRM data into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData ODBC Driver for Webflow
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Webflow.
-
Connect to Square Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Square Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to SQL Server Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SQL Server as an External Source in Dremio.
-
Connect to SAP Ariba Procurement Data from a Connection Pool in JBoss
Integrate SAP Ariba Procurement data into Java servlets: Use the Management Console in JBoss to install the SAP Ariba Procurement JDBC Driver.
-
Getting Started with the CData Python Connector for Slack
Learn to install and license the CData Python Connector and configure a connection to live Slack data.
-
Build Voice Agents in ElevenLabs with access to Live Stripe Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Stripe data.
-
Automated Continuous SuiteCRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SuiteCRM replication to delimited files (CSV/TSV).
-
Automated Continuous Stack Exchange Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Amazon S3.
-
Use the CData Software ODBC Driver for MailerSend in SAS for Real-Time Reporting and Analytics
Connect to real-time MailerSend data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MailerSend.
-
Build Visualizations of MongoDB Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of MongoDB data in Birst.
-
Connect to Real-Time Bitly Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Bitly data in Power Apps.
-
Query Paddle Data as a MySQL Database in Node.js
Execute MySQL queries against Paddle data from Node.js.
-
Connect to Oracle Service Cloud Data in ACL Analytics
Connect to Oracle Service Cloud data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Oracle Service Cloud data.
-
Create SSAS Tabular Models from ChargeOver Data
How to build a SQL Server Analysis Service Tabular Model from ChargeOver data using CData drivers.
-
Integrate with live Splunk Data in Jitterbit
Use CData Connect AI to connect to and integrate live Splunk data in Jitterbit.
-
Create Informatica Mappings From/To an ODBC Data Source for JobNimbus
Create an ODBC connection to JobNimbus in Informatica and browse and transfer JobNimbus data.
-
Connect Apollo to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Apollo with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software ODBC Driver for Zoho Recruit in MicroStrategy Desktop
Connect to Zoho Recruit data in MicroStrategy Desktop using the CData Software ODBC Driver for Zoho Recruit.
-
Access Live Microsoft Entra ID Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft Entra ID data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Natively Connect to Clari Data in PHP
The CData ODBC driver for Clari enables you to create PHP applications with connectivity to Clari data. Leverage the native support for ODBC in PHP.
-
Connect to ClickUp Data from HeidiSQL
Use CData Connect AI to connect to and query live ClickUp data from HeidiSQL.
-
Automated Workday Data Replication to Teradata
Use CData Sync to Customize and automate Workday data replication to Teradata.