CData Software - Knowledge Base
Recent Articles
-
Write a Simple Go Application to work with Harvest Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Harvest data.
-
Connect Google Search Results to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google Search results using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect PolyBase to LaunchDarkly
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live LaunchDarkly data.
-
How to Connect DBeaver to Copper via a JDBC Driver
Manage Copper data with visual tools in DBeaver like the query browser.
-
How to Connect to Live ActiveCampaign Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your ActiveCampaign data for you.
-
Connect to Quaderno Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Quaderno and work with Quaderno data in your FileMaker applications.
-
Connect to Oracle HCM Cloud Data from a Connection Pool in Jetty
The Oracle HCM Cloud JDBC Driver supports connection pooling: This article shows how to connect faster to Oracle HCM Cloud data from Web apps in Jetty.
-
Build Dashboards with SAP Ariba Source Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP Ariba Source data in Dundas BI.
-
Write a Simple Go Application to work with Oracle Financials Cloud Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Oracle Financials Cloud data.
-
Connecting Mastra with Guru Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Guru data, no replication required.
-
Connect to Superchat Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Superchat as an External Source in Dremio.
-
How to Connect to Live Sage 300 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 Sage 300 data for you.
-
Query Live BigCommerce Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live BigCommerce data through a conversational interface.
-
Connect to BigQuery Data in Ruby
Connect to BigQuery data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Analyze QuickBooks Online Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of QuickBooks Online data and visualize live QuickBooks Online data in Infragistics Reveal.
-
Connect to Ontraport Data in HULFT Integrate
Connect to Ontraport as a JDBC data source in HULFT Integrate
-
Use Biml to Build SSIS Tasks to Replicate Paddle Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Paddle data to SQL Server.
-
Use the CData Software JDBC Driver for Front in MicroStrategy Web
Connect to Front data in MicroStrategy Web using the CData Software JDBC Driver for Front.
-
Integrate with Shortcut Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Shortcut data in SnapLogic.
-
How to Connect Flowise AI Agents to Live Toggl Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Toggl data without replication.
-
Use Agno to Talk to Your Xero 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 Xero data for you.
-
How to work with Freshdesk Data in Apache Spark using SQL
Access and process Freshdesk Data in Apache Spark using the CData Software JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Lakebase
Provide connectivity to Lakebase data through an SAP BusinessObjects universe.
-
Getting Started with the CData JDBC Driver for Rootly
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Rootly.
-
How to Visualize Optimizely Data in Python with pandas
Use pandas and other modules to analyze and visualize live Optimizely data in Python.
-
Automate Parquet Data Replication to Azure Synapse
Use CData Sync to customize and automate Parquet data replication to Azure Synapse.
-
Connecting Pipedream with SAP Concur Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on SAP Concur data in real time.
-
How to Connect Flowise AI Agents to Live Google Calendar Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Google Calendar data without replication.
-
Publish Dynamics NAV-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Dynamics NAV data.
-
Create Reports with Office 365 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Office 365 data.
-
Integrate Goose with Live Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Amazon DynamoDB data from within the local AI agent.
-
Connect to Drip Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Drip and the SQL Gateway to access Drip data from Google Apps Script.
-
Access Live Okta Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Okta data from your Excel spreadsheets.
-
Connect to Factorial from Asprova with CData Software ODBC Driver for Factorial
This article shows how to connect faster to Factorial data from Asprova.
-
Automated Azure DevOps Data Replication to Teradata
Use CData Sync to Customize and automate Azure DevOps data replication to Teradata.
-
Access SFTP 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 SFTP data.
-
Connect to IBM Informix Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for IBM Informix data in the Denodo Virtual DataPort Administrator.
-
Stream Office 365 Data into Apache Kafka Topics
Access and stream Office 365 data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Build an ETL App for Dotmailer Data in Python with CData
Create ETL applications and real-time data pipelines for Dotmailer data in Python with petl.
-
Process & Analyze Pushbullet Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Pushbullet Data.
-
Automated Continuous Box Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Box replication to delimited files (CSV/TSV).
-
Process & Analyze Autopilot Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Autopilot Data.
-
Connecting GenSpark with Certinia Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Certinia data without any replication or custom integration required.
-
Create Dashboards and Visualize Live Azure Table Data in Geckoboard
Use CData Connect AI to connect to live Azure Table data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrating Pipeliner CRM Data in Talend Cloud Data Management Platform
Connect Pipeliner CRM Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Replicate Salesloft Data in Heroku for Use in Salesforce Connect
Replicate Salesloft data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Consume Google Search OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Search feeds that reflect any changes in SAP Lumira.
-
How to connect to Harvest Data from Spring Boot
Connect to Harvest in a Spring Boot Application using the CData API Driver for JDBC
-
DataBind Charts to Paylocity Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Paylocity 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.
-
Integrate Cursor with Live Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Freshdesk data from within the editor.
-
How to Connect DBeaver to Demio via a JDBC Driver
Manage Demio data with visual tools in DBeaver like the query browser.
-
Create Datadog Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Datadog from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect to Live SAP Hybris C4C 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 SAP Hybris C4C data through natural language.
-
Getting Started with the CData ODBC Driver for Paymo
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Paymo.
-
Moving Data from Google Analytics to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Analytics data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Timely Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Timely and the SQL Gateway to access Timely data from Google Apps Script.
-
Extract, Transform, and Load Aha! Data in Informatica PowerCenter
Create a simple Workflow for Aha! data in Informatica PowerCenter.
-
Analyze Printify Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Printify data and visualize live Printify data in Infragistics Reveal.
-
Integrate Sugar CRM with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Sugar CRM with External Services.
-
Create Datasets from Clari in Domo Workbench and Build Visualizations of Clari Data in Domo
Use the CData Software ODBC Driver for Clari to create datasets from Clari data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous CapsuleCRM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Apache Cassandra.
-
Analyze Mouseflow Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Mouseflow data in Microsoft R Open.
-
Query MySQL Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume MySQL entities in PHP by modeling them as objects.
-
Automated Continuous Epicor Kinetic Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Apache Cassandra.
-
Back Up Datadog 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 Datadog data data.
-
Replicate Adobe Commerce Data in Heroku for Use in Salesforce Connect
Replicate Adobe Commerce data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Dashboards and Visualize Live HBase Data in Geckoboard
Use CData Connect AI to connect to live HBase data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate with SAP SuccessFactors LMS Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP SuccessFactors LMS data in SnapLogic.
-
Connect to Jira Assets Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Jira Assets data.
-
Access Live Google Ad Manager Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Google Ad Manager data through MCP integration.
-
Integrating Claude Code with Phoenix Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Phoenix data within assisted coding and automated development workflows.
-
How to Connect the Power BI Service to Dynamics NAV: Complete Guide
Connect to the CData Software Power BI Connector for Dynamics NAV from PowerBI.com to provide real-time Dynamics NAV data across the organization.
-
Connect to Greenplum Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Greenplum and the SQL Gateway to access Greenplum data from Google Apps Script.
-
Integrating Claude Code CLI with Guru 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.
-
How to Connect to & Open Salesforce Marketing Data in Microsoft Excel
This article uses the CData ODBC driver for Salesforce Marketing to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Live Zoho Inventory Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Zoho Inventory in CData Connect AI and connect to your Zoho Inventory data from PostgreSQL.
-
Natively Connect to PDFMonkey Data in PHP
The CData ODBC driver for PDFMonkey enables you to create PHP applications with connectivity to PDFMonkey data. Leverage the native support for ODBC in PHP.
-
How to import Salesloft Data into Apache Solr
Use the CData Software JDBC Driver for Salesloft in Data Import Handler and create an automated import of Salesloft data to Apache Solr Enterprise Search platform.
-
Access Live SFTP Data in AWS Lambda
Connect to live SFTP data in AWS Lambda using the CData JDBC Driver.
-
Connect to Smartsheet Data in CloverDX (formerly CloverETL)
Transfer Smartsheet data using the visual workflow in the CloverDX data integration tool.
-
Process & Analyze Webex Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Webex Data.
-
Create Dynamic Amazon Marketplace Grids Using the Infragistics XamDataGrid
Learn how you can connect Amazon Marketplace to Infragistics XamDataGrid to build dynamic grids.
-
Link ConvertAPI with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ConvertAPI data in Filemaker Pro for Mac or Windows.
-
Build JSON-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live JSON services and build JSON-connected web apps with Axios.
-
Connect to and Query Deel Data in QlikView over ODBC
Create data visualizations with Deel data in QlikView.
-
Bidirectional Access to Google Ad Manager Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Google Ad Manager data in Filemaker Pro for Mac or Windows.
-
Build a PostgreSQL Interface for Zoho Inventory Data using the CData JDBC Driver
Use the Remoting features of the Zoho Inventory JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Reports from Trello Data in Looker Studio
Use CData Connect AI to gain access to live Trello data and create custom reports in Looker Studio.
-
How to Access Live Raisers Edge NXT Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Raisers Edge NXT enables you to integrate Raisers Edge NXT data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Timely Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Timely and work with Timely data in your FileMaker applications.
-
Connect to Perigon Data in DBeaver
Use the CData ODBC Driver to connect to Perigon data in DBeaver.
-
Back Up Oracle Eloqua data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Oracle Eloqua. In this article, we will employ an SSIS workflow to populate a database with Oracle Eloqua data data.
-
Access Live LinkedIn Ads Data in AWS Lambda (with IntelliJ IDEA)
Connect to live LinkedIn Ads data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create a Data Access Object for Mailgun Data using JDBI
A brief overview of creating a SQL Object API for Mailgun data in JDBI.
-
Visualize Live Oracle Financials Cloud Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Oracle Financials Cloud data.
-
Connect to HBase Data in HULFT Integrate
Connect to HBase as a JDBC data source in HULFT Integrate
-
Query Amazon Athena Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Amazon Athena entities in PHP by modeling them as objects.
-
Build MVC Applications with Connectivity to ServiceDesk Plus Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ServiceDesk Plus from an ASP.NET MVC application.
-
Build a PostgreSQL Interface for Guru Data using the CData JDBC Driver
Use the Remoting features of the Guru JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect Stack Exchange to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Stack Exchange data using the CData Python MCP Server.