CData Software - Knowledge Base
Recent Articles
-
Deploy the ADO.NET Provider for Printful on an SSRS Report Server
Connect to Printful 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 Tanda Data in Talend Cloud Data Management Platform
Connect Tanda Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrate Cline with Live Tavily Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Tavily data from within your IDE.
-
How to work with Shopify Data in Apache Spark using SQL
Access and process Shopify Data in Apache Spark using the CData Software JDBC Driver.
-
Use CData Connect AI to Access SAP Netweaver Gateway Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP Netweaver Gateway data in the Power Pivot business intelligence tool.
-
Automate Omnisend Data Replication to Couchbase
Use CData Sync to Customize and automate Omnisend data replication to Couchbase.
-
Integrate Trae with Live Google Forms Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Google Forms data from within the AI-powered IDE.
-
Getting Started with the CData ADO.NET Provider for MongoDB
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for MongoDB.
-
Connect to Epicor Kinetic Data in Ruby
Connect to Epicor Kinetic data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Cvent Replication to Vertica
Use CData Sync for automated, continuous, customizable Cvent replication to Vertica.
-
Automated Continuous FormSite Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable FormSite data replication to OneLake in Microsoft Fabric.
-
Replicate Multiple SendPulse Accounts via the CData Sync CLI
Replicate multiple SendPulse accounts to one or many databases.
-
Integrate LibreChat with Live Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Zuora data from within the chat interface.
-
Visualize CapsuleCRM Data in TIBCO Spotfire through ADO.NET
Integrate CapsuleCRM data into dashboards in TIBCO Spotfire.
-
Use JayDeBeApi to access Spotify Data in Python
Use standard Python scripting and the development environment of your choice to access live Spotify data.
-
Automated Continuous BigCommerce Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable BigCommerce replication to Google BigQuery.
-
Integrate with Recurly Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Recurly data to a JSON file on disk.
-
Create Informatica Mappings From/To a JDBC Data Source for Sybase IQ
Create Sybase IQ data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
A PostgreSQL Interface for Salesforce Marketing Data using the CData ODBC Driver
Use the SQL Gateway and Salesforce Marketing ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Oracle Eloqua Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Oracle Eloqua data in the Denodo Virtual DataPort Administrator.
-
How to Connect ShipEngine 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 ShipEngine data in real time using natural language.
-
How to Easily Query MessageBird Data in OpenOffice Base
Connect to MessageBird data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to import Vault CRM Data into Apache Solr
Use the CData Software JDBC Driver for Vault CRM in Data Import Handler and create an automated import of Vault CRM data to Apache Solr Enterprise Search platform.
-
Use JayDeBeApi to access SAP Ariba Source Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP Ariba Source data.
-
Access Email Data from MySQL in PHP
Connect to Email through the standard MySQL libraries in PHP.
-
How to connect Amazon QuickSight to Dropbox Data
Create a connection to Dropbox data in CData Connect AI and insert Dropbox data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to connect and process Act CRM data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Act CRM data.
-
Create Reports with SAP Fieldglass Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Fieldglass data.
-
Access Live Zoho Projects Data in Excel 365 Online (Excel for the web)
Connect to Zoho Projects data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use CData Connect AI to Access MailChimp Data in Microsoft Power Pivot
Use CData Connect AI to connect to live MailChimp data in the Power Pivot business intelligence tool.
-
Access Live Anaplan Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Anaplan data into the statistical analysis tools available in SAS JMP. This article shows how to use Anaplan data in the Graph Builder and Query Builder.
-
Automated Continuous Zoho CRM Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Zoho CRM replication to PostgreSQL.
-
Connecting Pipedream with Oracle Service Cloud 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 Oracle Service Cloud data in real time.
-
Connect and Query Live Attio Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Attio data into Databricks and enable direct, live querying and analysis without replication.
-
Integrate Vercel with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Vercel with External Services.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for RabbitMQ
Provide connectivity to RabbitMQ data through an SAP BusinessObjects universe.
-
Connect to Live Google Ad Manager Data in MicroStrategy through CData Connect AI
Create a live connection to Google Ad Manager Data in CData Connect AI and connect to your Google Ad Manager data from MicroStrategy.
-
Model SAP Hybris C4C Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP Hybris C4C, enabling the direct import of real-time SAP Hybris C4C data.
-
How to integrate Templated with Apache Airflow
Access and process Templated data in Apache Airflow using the CData JDBC Driver.
-
How to create Visio diagrams from eBay Data
Automatically update eBay data with the changes you make to Visio master shapes.
-
How to Connect to SAP Business One Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP Business One data. Leverage the pyodbc module for ODBC in Python.
-
Integrating Kiro with SAP Hybris C4C 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.
-
Integrate Miro Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Miro data from Informatica Cloud.
-
Analyze Coda Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Coda data in Microsoft R Open.
-
Automated Continuous Basecamp Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Basecamp data replication to OneLake in Microsoft Fabric.
-
Create Zoho Books-Connected Dashboards in Grafana
Connect to Zoho Books Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zoho Books data.
-
Connect to and Visualize Live MessageBird Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MessageBird data.
-
LINQ to Adobe Target 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 Adobe Target Data Provider.
-
Access Live CouchDB Data in Coginiti Pro
Connect to and query live CouchDB data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Google Directory Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Directory data from HeidiSQL.
-
Deploy the ADO.NET Provider for Kintone on an SSRS Report Server
Connect to Kintone 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.
-
How to integrate SurveyMonkey with Apache Airflow
Access and process SurveyMonkey data in Apache Airflow using the CData JDBC Driver.
-
How to Connect to Live Confluence 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 Confluence data for you.
-
Automate xBase Integration Tasks from PowerShell
Are you in search of a quick and easy way to access xBase data from PowerShell? This article demonstrates how to utilize the xBase Cmdlets for tasks like connecting to xBase data, automating operations, downloading data, and more.
-
Replicate Multiple Klipfolio Accounts
Replicate multiple Klipfolio accounts to one or many databases.
-
Connect Attio to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Attio with IBM WebSphere for seamless data integration and connectivity.
-
Automated Flowlu Data Replication to Teradata
Use CData Sync to Customize and automate Flowlu data replication to Teradata.
-
How to create an RPA flow for Azure Data Catalog Data in UiPath Studio
Use the Azure Data Catalog ODBC Driver to create workflows that access real-time Azure Data Catalog data without any coding.
-
Connect to Copper Data from a Connection Pool in Jetty
The Copper JDBC Driver supports connection pooling: This article shows how to connect faster to Copper data from Web apps in Jetty.
-
Integrate Goose with Live Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Exact Online data from within the local AI agent.
-
Working with Odoo Data in LINQPad
Execute LINQ queries to Odoo data in LINQPad.
-
Integrating LangChain with Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Microsoft Entra ID data within automated workflows.
-
Integrating Claude Code CLI with Sybase 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.
-
Prepare, Blend, and Analyze OData Services in Alteryx Designer (Connect AI)
Build workflows to access live OData services for self-service data analytics.
-
Viewing Odoo Data in RAD Studio Data Explorer
How to view Odoo data in RAD Studio Data Explorer using the CData ODBC Driver for Odoo.
-
Connecting Mastra with LinkedIn 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 LinkedIn data, no replication required.
-
Work with Salesforce Data in FoxPro
Load Salesforce data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automate Beeminder Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Beeminder data from PowerShell? This article demonstrates how to utilize the Beeminder Cmdlets for tasks like connecting to Beeminder data, automating operations, downloading data, and more.
-
Query Live Google Cloud Storage Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Google Cloud Storage data directly from the development environment.
-
Analyze Harvest Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Harvest data with the CData JDBC Driver for Harvest.
-
Access Apollo Data from MySQL in PHP
Connect to Apollo through the standard MySQL libraries in PHP.
-
Publish Crystal Reports on Square Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Square data.
-
Stream SAP SuccessFactors Data into Apache Kafka Topics
Access and stream SAP SuccessFactors data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to integrate RSS with Apache Airflow
Access and process RSS feeds in Apache Airflow using the CData JDBC Driver.
-
Integrate Devin with Live Cosmos DB Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Cosmos DB data.
-
Integrating Kiro with HDFS 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 Query Chargebee Data in MySQL Workbench
Execute MySQL queries against live Chargebee data from MySQL Workbench.
-
How to Connect to Live Facebook 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 Facebook data for you.
-
Connect to SpaceX Data from PowerBuilder via ADO.NET
This article demonstrates how to access SpaceX data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build Apps with Live Cloudant Data Using the Low-Code Development Platform of Mendix
Connect Cloudant data with Mendix to build apps using the CData JDBC Driver for Cloudant.
-
How to connect SharePoint with SAP Data through external lists
Provide SAP data to SharePoint users as an external list.
-
Moving Data from Phoenix to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Phoenix data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Query PagerDuty Data as a MySQL Database in Node.js
Execute MySQL queries against PagerDuty data from Node.js.
-
Build Visualizations of ConstantContact Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ConstantContact data in Birst.
-
How to Connect to Live Adobe Analytics Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Adobe Analytics data securely in real time.
-
Connect to Shippo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Shippo to connect to Shippo data from Web applications running on WebLogic.
-
Connect PayPal Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your PayPal data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Square-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Square Data and create custom apps in Mendix.
-
Replicate SparkPost Data in Heroku for Use in Salesforce Connect
Replicate SparkPost data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Trae with Live Lakebase Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Lakebase data from within the AI-powered IDE.
-
Automated Continuous Cohere Replication to MySQL
Use CData Sync for automated, continuous, customizable Cohere replication to MySQL.
-
Migrating data from Google Cloud Storage to Google BigQuery using CData SSIS Components.
Easily push Google Cloud Storage data to Google BigQuery using the CData SSIS Tasks for Google Cloud Storage and Google BigQuery.
-
Connect iContact Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your iContact data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate with Rebilly Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Rebilly data to a JSON file on disk.
-
Use the CData SSIS Components to Insert New or Update Existing SAS Data Sets Records from SQL Server
Easily push SQL Server data to SAS Data Sets using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SAS Data Sets or update existing records with data from a SQL Server database.
-
Extract, Transform, and Load Tavily Data in Informatica PowerCenter
Create a simple Workflow for Tavily data in Informatica PowerCenter.
-
Build a PostgreSQL Interface for Google Translate Data using the CData JDBC Driver
Use the Remoting features of the Google Translate JDBC Driver to create a PostgreSQL entry-point for data access.
-
Bridge Salesforce Marketing Connectivity with Apache NiFi
Access and process Salesforce Marketing data in Apache NiFi using the CData JDBC Driver.
-
Analyze AlloyDB Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of AlloyDB data and visualize AlloyDB data in SAP Analytics Cloud.
-
Use JayDeBeApi to access SpaceX Data in Python
Use standard Python scripting and the development environment of your choice to access live SpaceX data.