CData Software - Knowledge Base
Recent Articles
-
Connect to and Visualize Live Google Cloud Storage Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Cloud Storage data.
-
Process & Analyze Google Forms Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Forms Data.
-
Automated Continuous Apify Replication to MySQL
Use CData Sync for automated, continuous, customizable Apify replication to MySQL.
-
Use Dash to Build Web Apps on SAS xpt Data via CData Connect AI
Build interactive Dash web apps on live SAS xpt data using pandas and the CData Connect AI Python SDK.
-
Build a PostgreSQL Interface for Bullhorn CRM Data using the CData JDBC Driver
Use the Remoting features of the Bullhorn CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create iContact-Connected Applications in Appsmith
Connect to iContact Data via CData Connect AI in Appsmith and create custom business applications with real-time access to iContact data.
-
Consume SingleStore OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SingleStore feeds that reflect any changes in SAP Lumira.
-
Create Power BI Reports on Real-Time Hubstaff Data
Use the CData ODBC Driver for Hubstaff to visualize Hubstaff data in Power BI Desktop.
-
Automate Supabase Data Replication to Azure Synapse
Use CData Sync to customize and automate Supabase data replication to Azure Synapse.
-
ADO.NET Provider Getting Started Guide
A basic guide to connecting applications to data from anywhere using the CData ADO.NET Provider
-
Automated Continuous Zoom Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Zoom replication to Google Cloud SQL.
-
Integrate Google's Vertex AI Agent with Live ZohoExpense Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live ZohoExpense data within intelligent workflows.
-
Work with Live XML Data in Power Query
Use CData Connect AI to connect to XML data and work with live XML data in Microsoft Power Query.
-
Automated Continuous Brex Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Brex data replication to OneLake in Microsoft Fabric.
-
DataBind Charts to Webex Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Webex 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.
-
Access Live ConstantContact Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to ConstantContact data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrating Antigravity CLI with HubSpot data via CData CLI
Connect HubSpot data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Google's Vertex AI Agent with Live Shippo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Shippo data within intelligent workflows.
-
Back Up Deel data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Deel data data.
-
Connect to SAP ByDesign Data in CloverDX (formerly CloverETL)
Transfer SAP ByDesign data using the visual workflow in the CloverDX data integration tool.
-
Connect to Sage 200 Data in Jaspersoft Studio
Execute SQL to remote Sage 200 data in Jaspersoft Studio.
-
Use the CData Software ODBC Driver for Cassandra in MicroStrategy Desktop
Connect to Cassandra data in MicroStrategy Desktop using the CData Software ODBC Driver for Cassandra.
-
Import Real-Time Zoho Recruit Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Zoho Recruit data in ColdFusion.
-
Build Automated SingleStore-Connected Workflows in Zapier
Use CData Connect AI to connect to live SingleStore data and build automated workflows in Zapier.
-
Build an OLAP Cube in SSAS from Avro Data
Establish a connection to Avro data data from SQL Server Analysis Services, and use the Avro Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to create an RPA flow for Sage 300 Data in UiPath Studio
Use the Sage 300 ODBC Driver to create workflows that access real-time Sage 300 data without any coding.
-
Creating VWO-Connected Applications in Unqork
You can use CData Connect AI to feed VWO data to Unqork and build custom business apps.
-
Build Apps with Live Google Cloud Storage Data Using the Low-Code Development Platform of Mendix
Connect Google Cloud Storage data with Mendix to build apps using the CData JDBC Driver for Google Cloud Storage.
-
Build Automated Workflows with Live Reckon Data in Workato
Use CData Connect AI to connect to live Reckon data and build automated workflows in Workato.
-
Create Acumatica Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Acumatica data access from reports, embedded analytics, and more.
-
Integrate Dify with Live SFTP 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 SFTP data.
-
How to Access Everhour Data Using Entity Framework
This article shows how to access Everhour data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to DB2 Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for DB2 data.
-
Connecting Agentforce with MYOB AccountRight Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your MYOB AccountRight data for you.
-
How to Connect to & Open Cloudant Data in Microsoft Excel
This article uses the CData ODBC driver for Cloudant to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Build an ETL App for Act-On Data in Python with CData Connect AI
Build ETL pipelines that read and write live Act-On data in Python with petl and the CData Connect AI Python SDK.
-
How to Easily Query Copper Data in OpenOffice Base
Connect to Copper data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build iContact-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for iContact Data and create custom apps in Mendix.
-
Build Sybase IQ-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Sybase IQ Data from Zoho Analytics and import live Sybase IQ data.
-
Connect to Live Dynamics CRM Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Dynamics CRM in CData Connect AI and connect to your Dynamics CRM data from PostgreSQL.
-
Connect to ConstantContact Data from PowerBuilder via JDBC
This article demonstrates how to access ConstantContact data from PowerBuilder using the ConstantContact JDBC Driver.
-
How to Seamlessly Import Dynamics 365 Data into IBM SPSS Modeler
Integrate Dynamics 365 data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Getting Started with the CData Python Connector for Google Calendar
Learn to install and license the CData Python Connector and configure a connection to live Google Calendar data.
-
Integrate DocuSign with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate DocuSign with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to DocuSign data.
-
Automated Continuous Sentry Replication to Vertica
Use CData Sync for automated, continuous, customizable Sentry replication to Vertica.
-
Use JayDeBeApi to access Google Analytics Data in Python
Use standard Python scripting and the development environment of your choice to access live Google Analytics data.
-
Create Reports with VWO Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date VWO data.
-
Access Clari Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Clari data from HeidiSQL.
-
Use the CData ODBC Driver for JotForm in Microsoft Power Query
You can use the CData JotForm ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import JotForm data into Microsoft Power Query.
-
Automated Continuous OpenWeatherMap Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable OpenWeatherMap replication to delimited files (CSV/TSV).
-
Connect to OnePageCrm Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to OnePageCrm and work with OnePageCrm data in your FileMaker application.
-
Automate Cosmos DB Data Replication to Azure Data Lake
Use CData Sync to customize and automate Cosmos DB data replication to Azure Data Lake.
-
Create IBM Informix-Connected Dashboards in Grafana
Connect to IBM Informix Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to IBM Informix data.
-
How to Connect to Live Toggl 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 Toggl data for you.
-
Integrate Cursor with Live Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Avalara AvaTax data from within the editor.
-
Seamlessly Bring Reckon Data into Retool Using CData Connect AI
Integrate Reckon data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Publish Moosend-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Moosend data.
-
Build a PostgreSQL Interface for Auth0 Data using the CData JDBC Driver
Use the Remoting features of the Auth0 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build NASA-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to NASA data and build web apps with connectivity to live NASA data.
-
How to Connect to Live SAP Concur 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 SAP Concur data for you.
-
Build MVC Applications with Connectivity to ConvertAPI Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ConvertAPI from an ASP.NET MVC application.
-
Automate ADP Data Replication to Azure Data Lake
Use CData Sync to customize and automate ADP data replication to Azure Data Lake.
-
Integrating Antigravity CLI with Presto data via CData CLI
Connect Presto data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connecting Agentforce with Adobe Commerce Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Adobe Commerce data for you.
-
Use ChatGPT to Talk to Your Supabase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Supabase data for you.
-
Replicate ChartMogul Data from PowerShell
Write a quick PowerShell script to query ChartMogul data. Use connectivity to the live data to replicate ChartMogul data to SQL Server.
-
Connect to LightSpeedRetail Data from PowerBuilder via ADO.NET
This article demonstrates how to access LightSpeedRetail data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to LDAP Objects in DBeaver
Use the CData ODBC Driver to connect to LDAP objects in DBeaver.
-
Access Live Gorgias Data in Coginiti Pro
Connect to and query live Gorgias data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Replicate Customer.io Data in Heroku for Use in Salesforce Connect
Replicate Customer.io data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Query Live Google Drive Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Drive data data in natural language using Python.
-
Integrating OpenCode with Supabase 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.
-
Visualize NASA Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to NASA data.
-
Integrate with Freshteam Data in JReport Designer
Create charts and reports based on Freshteam data in JReport Designer.
-
Adobe Experience Manager Reporting in OBIEE with the Adobe Experience Manager JDBC Driver
Deploy the Adobe Experience Manager JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Claude Code CLI with Okta 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.
-
Visualize ShipStation Data in Tableau
The CData ODBC driver for ShipStation enables you integrate ShipStation data into Tableau dashboards.
-
Create Reports with Snowflake Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Snowflake data.
-
Connect to BenchmarkEmail Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live BenchmarkEmail data from Filemaker Pro on Mac.
-
Integrating Codex with Cohere 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.
-
Migrating data from Everhour to Snowflake using CData SSIS Components.
Easily push Everhour data to Snowflake using the CData SSIS Tasks for Everhour and Snowflake.
-
Integrate Salesforce CRM Analytics with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Salesforce CRM Analytics with External Services.
-
Connecting Agentforce with SAP Hybris C4C Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your SAP Hybris C4C data for you.
-
Getting Started with the CData ODBC Driver for GetResponse
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for GetResponse.
-
Import Real-Time ShipStation Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ShipStation data in ColdFusion.
-
How to connect to ZohoSubscriptions Data from IntelliJ
Integrate connectivity to ZohoSubscriptions data with wizards in IntelliJ.
-
How to connect to ElevenLabs Data with Squirrel SQL client
Connect to ElevenLabs data and execute queries in the Squirrel SQL Client.
-
View Reports on Real-Time Google Cloud Storage Data in Power BI Report Server
Use the CData ODBC Driver for Google Cloud Storage to visualize Google Cloud Storage data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect PolyBase to SAP HANA XS Advanced
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP HANA XS Advanced data.
-
Validate Oracle SCM Data with QuerySurge
Access and validate Oracle SCM data in QuerySurge using the CData JDBC Driver.
-
Build MVC Applications with Connectivity to Qualaroo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Qualaroo from an ASP.NET MVC application.
-
Publish Opsgenie-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Opsgenie data.
-
Create SSAS Tabular Models from Coda Data
How to build a SQL Server Analysis Service Tabular Model from Coda data using CData drivers.
-
Viewing Azure Table Data in RAD Studio Data Explorer
How to view Azure Table data in RAD Studio Data Explorer using the CData ODBC Driver for Azure Table.
-
Build Freshdesk-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Freshdesk data.
-
Provide OData Services of ShipEngine Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ShipEngine data by developing a WCF Service Application.
-
Use the CData Software JDBC Driver for Epicor Kinetic in MicroStrategy Desktop
Connect to Epicor Kinetic data in MicroStrategy Desktop using the CData Software JDBC Driver for Epicor Kinetic.
-
Integrating Codex with Monday.com 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.
-
Stream CampaignMonitor Data into Apache Kafka Topics
Access and stream CampaignMonitor data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
DataBind Controls to HBase Data in Delphi
DataBind to HBase data in Delphi with standard data access components and controls.