CData Software - Knowledge Base
Recent Articles
-
Integrate OpenCode with Live Reckon Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Reckon data from within your AI coding agent.
-
Connect to and Visualize Live CockroachDB Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live CockroachDB data.
-
A PostgreSQL Interface for Templated Data (MySQL Remoting via JDBC)
Use the Remoting features of the Templated JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to integrate Shippo with Apache Airflow
Access and process Shippo data in Apache Airflow using the CData JDBC Driver.
-
Access Live Pinterest Data in AWS Lambda
Connect to live Pinterest data in AWS Lambda using the CData JDBC Driver.
-
Write a Simple Go Application to work with SAP SuccessFactors LMS Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP SuccessFactors LMS data.
-
Build Apps with Live Epicor Kinetic Data Using the Low-Code Development Platform of Mendix
Connect Epicor Kinetic data with Mendix to build apps using the CData JDBC Driver for Epicor Kinetic.
-
Build Zoom-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Zoom data.
-
Build Visualizations of Tickspot Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Tickspot data in Birst.
-
Migrating data from Trello to Google BigQuery using CData SSIS Components.
Easily push Trello data to Google BigQuery using the CData SSIS Tasks for Trello and Google BigQuery.
-
Publish Bright Data-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Bright Data data.
-
Create OData-Connected Dashboards in Grafana
Connect to OData Services via CData Connect AI in Grafana and create custom business dashboards with real-time access to OData services.
-
Establish a Live Connection with Excel Online Data using Tableau Bridge
The CData ODBC Driver for Excel Online enables you to integrate live Excel Online data into Tableau Cloud dashboards using the Tableau Bridge.
-
Natively Connect to Samanage Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Samanage data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Retently Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Retently replication to delimited files (CSV/TSV).
-
Excel Spreadsheet Automation on Microsoft Exchange Data with the QUERY Formula
Pull data from Microsoft Exchange, automate spreadsheets, and more with the QUERY formula.
-
Use ChatGPT to Talk to Your Printify 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 Printify data for you.
-
Automated Continuous Unbounce Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Unbounce data replication to OneLake in Microsoft Fabric.
-
Stream MessageBird Data into Apache Kafka Topics
Access and stream MessageBird data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Analyze Invoiced Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Invoiced data with the CData JDBC Driver for Invoiced.
-
Create Data Visualizations in Cognos BI with Epicor Kinetic Data
Access Epicor Kinetic data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect CapsuleCRM Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your CapsuleCRM data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Automated XML-Connected Workflows in Zapier
Use CData Connect AI to connect to live XML data and build automated workflows in Zapier.
-
Connect to Live Facebook Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Facebook in CData Connect AI and connect to your Facebook data from PostgreSQL.
-
Connect to Live SuiteCRM Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SuiteCRM in CData Connect AI and connect to your SuiteCRM data from PostgreSQL.
-
Process & Analyze SendInBlue Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SendInBlue Data.
-
Getting Started with the CData JDBC Driver for Acumatica
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Acumatica.
-
Publish Crystal Reports on Toggl Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Toggl data.
-
Connect to Autopilot Data in NetBeans
Connect to Autopilot data in NetBeans with the data source configuration wizard.
-
Integrating OpenCode with Onfleet 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.
-
Integrating LlamaIndex with Klaviyo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Klaviyo data in real time.
-
Integrate ServiceDesk Plus with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ServiceDesk Plus with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ServiceDesk Plus data.
-
Create Data Visualizations in Cognos BI with Reply.io Data
Access Reply.io data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Connect the Power BI Service to Zoho Books: Complete Guide
Connect to the CData Software Power BI Connector for Zoho Books from PowerBI.com to provide real-time Zoho Books data across the organization.
-
Import Real-Time FreeAgent Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use FreeAgent data in ColdFusion.
-
Automate Gong Data Replication to Azure Data Lake
Use CData Sync to customize and automate Gong data replication to Azure Data Lake.
-
Use CData Connect AI to Access Zoho CRM Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Zoho CRM data in the Power Pivot business intelligence tool.
-
Connect to and Query Dotmailer Data in QlikView over ODBC
Create data visualizations with Dotmailer data in QlikView.
-
Trigger WordPress IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for WordPress with standard wizards in Logic Apps.
-
Build Dashboards with Microsoft Planner Data in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft Planner data in DBxtra.
-
Build Apps with Live SQL Analysis Services Data Using the Low-Code Development Platform of Mendix
Connect SQL Analysis Services data with Mendix to build apps using the CData JDBC Driver for SQL Analysis Services.
-
Integrate Open WebUI with Live xBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live xBase data from within the chat interface.
-
Build a Simple VCL Application for Okta Data
How to build a simple VCL Application to view Okta data in RAD Studio using the CData ODBC Driver for Okta.
-
Use Claude to Talk to Your Sage 300 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 Sage 300 data for you.
-
Replicate ZohoPeople Data to Multiple Databases
Replicate ZohoPeople data to disparate databases with a point-and-click configuration.
-
Interact with Live Salesforce Data 360 Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Salesforce Data 360 data.
-
Moving Data from Toggl to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Toggl data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automate Bullhorn CRM Data Replication to Azure Data Lake
Use CData Sync to customize and automate Bullhorn CRM data replication to Azure Data Lake.
-
DataBind Controls to Google Search Results in C++Builder
DataBind to Google Search results in C++Builder with standard components and controls.
-
Access Live TaxJar Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live TaxJar data from your Excel spreadsheets.
-
Provide OData Services of Exa Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Exa data by developing a WCF Service Application.
-
Build Bannerbear-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Bannerbear data and build web apps with connectivity to live Bannerbear data.
-
Integrate OpenCode with Live Redshift Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Redshift data from within your AI coding agent.
-
Automate Shippo Data Replication to Azure Synapse
Use CData Sync to customize and automate Shippo data replication to Azure Synapse.
-
Automate SAP Concur Data Replication to SAP HANA
Use CData Sync to customize and automate SAP Concur data replication to SAP HANA.
-
How to connect and process Avalara AvaTax data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Avalara AvaTax data.
-
Replicate Webflow Data in Heroku for Use in Salesforce Connect
Replicate Webflow data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Agents in Relevance AI with Access to Live ZohoExpense Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on ZohoExpense data within intelligent agent workflows.
-
Access Live Oracle Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle data from your Google Sheets.
-
A PostgreSQL Interface for Pipedrive Data using the CData ODBC Driver
Use the SQL Gateway and Pipedrive ODBC Driver to create a PostgreSQL entry-point for data access.
-
Enable the CData JDBC Driver for QuickBooks in KNIME
Access QuickBooks data and other data sources in KNIME using the JDBC Driver. You can follow the procedure detailed below to enable any CData JDBC driver in KNIME.
-
Connect to ServiceDesk Plus Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live ServiceDesk Plus data from Filemaker Pro on Mac.
-
How to Query Live Calendly Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Calendly data data in natural language using Python.
-
Access Smartsheet Data from MySQL in PHP
Connect to Smartsheet through the standard MySQL libraries in PHP.
-
Import and Visualize ChargeOver Data in Power View
Create data visualizations based on ChargeOver data in Excel.
-
Connect to Epicor Kinetic Data in NetBeans
Connect to Epicor Kinetic data in NetBeans with the data source configuration wizard.
-
Integrate IBM Cloud Object Storage Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live IBM Cloud Object Storage data from Informatica Cloud.
-
Visualize Live Gmail Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Gmail data into custom reports in Power BI.
-
How to Query Live Exa Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Exa data data in natural language using Python.
-
Build Voice Agents in ElevenLabs with access to Live PostgreSQL Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live PostgreSQL data.
-
Interact with Live Microsoft Planner Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Microsoft Planner data.
-
How to connect to Tally Data with Squirrel SQL client
Connect to Tally data and execute queries in the Squirrel SQL Client.
-
Create Reports from SAP Concur Data in Looker Studio
Use CData Connect AI to gain access to live SAP Concur data and create custom reports in Looker Studio.
-
Analyze ZohoPeople Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of ZohoPeople data and visualize live ZohoPeople data in Infragistics Reveal.
-
Integrating Antigravity CLI with Everhour data via CData CLI
Connect Everhour data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Publish Mistral AI-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Mistral AI data.
-
Validate SAP Hybris C4C Data with QuerySurge
Access and validate SAP Hybris C4C data in QuerySurge using the CData JDBC Driver.
-
Build Perplexity-Connected Apps in Choreo
Use CData Connect AI to connect to Perplexity Data from Choreo and build custom apps using live Perplexity data.
-
How to Connect to Live Shortcut 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 Shortcut data through natural language.
-
Visualize Live Zuora Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Zuora data.
-
Build Exa-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Exa data.
-
Use the CData Software ODBC Driver for CockroachDB in MicroStrategy Web
Connect to CockroachDB data in MicroStrategy Web using the CData Software ODBC Driver for CockroachDB.
-
Use the CData ODBC Driver for GitLab in Microsoft Power Query
You can use the CData GitLab ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import GitLab data into Microsoft Power Query.
-
Access Live Aha! Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Aha! data into the statistical analysis tools available in SAS JMP. This article shows how to use Aha! data in the Graph Builder and Query Builder.
-
Back Up SFTP data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SFTP. In this article, we will employ an SSIS workflow to populate a database with SFTP data data.
-
Analyze Elasticsearch Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Elasticsearch data in Microsoft R Open.
-
Deploy the ADO.NET Provider for Timely on an SSRS Report Server
Connect to Timely data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrating Cursor with Pinterest 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.
-
Connect to Adobe Analytics Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Adobe Analytics Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use Agno to Talk to Your Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Amazon S3 data for you.
-
How to work with Samanage Data in Apache Spark using SQL
Access and process Samanage Data in Apache Spark using the CData Software JDBC Driver.
-
Natively Connect to Parallel Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Parallel data. Leverage the native support for ODBC in PHP.
-
Integrate with Azure Data Catalog Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Azure Data Catalog data to a JSON file on disk.
-
Access Live Sugar CRM 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 Sugar CRM data through MCP integration.
-
Build Voice Agents in ElevenLabs with access to Live Zoho Books Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Zoho Books data.
-
Stream ChargeOver Data into Apache Kafka Topics
Access and stream ChargeOver data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Replicate Dynamics CRM Data from PowerShell
Write a quick PowerShell script to query Dynamics CRM data. Use connectivity to the live data to replicate Dynamics CRM data to SQL Server.
-
Connect to SAP Concur Data in ACL Analytics
Connect to SAP Concur data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP Concur data.
-
Use Azure AI Foundry to Talk to Your Google Spanner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Google Spanner data for you.
-
How to Connect to SAP Netweaver Gateway Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP Netweaver Gateway data. Leverage the pyodbc module for ODBC in Python.