CData Software - Knowledge Base
Recent Articles
-
Connect to Pinterest Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Pinterest data in the Denodo Virtual DataPort Administrator.
-
How to connect to Optimizely Data from Spring Boot
Connect to Optimizely in a Spring Boot Application using the CData API Driver for JDBC
-
How to Connect to ZohoSubscriptions Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ZohoSubscriptions data. Leverage the pyodbc module for ODBC in Python.
-
Import SharePoint Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SharePoint Data and provide access to live SharePoint data for custom reports in the Power BI Service.
-
ETL Mixpanel in Oracle Data Integrator
This article shows how to transfer Mixpanel data into a data warehouse using Oracle Data Integrator.
-
Build Apps with Live Apollo Data Using the Low-Code Development Platform of Mendix
Connect Apollo data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Postmark 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 Postmark and work with Postmark data in your FileMaker application.
-
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.
-
How to integrate Metabase with Oracle SCM Data
Use CData Connect AI to connect to live Oracle SCM data and create an interactive dashboard in Metabase from Oracle SCM data.
-
Integrate Cursor with Live Adobe Commerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Adobe Commerce data from within the editor.
-
Work with Strava Data in FoxPro
Load Strava data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Object-Relational Mapping (ORM) with Insightly Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Insightly data into a Java-based ORM framework, Hibernate.
-
Connect to Sage Cloud Accounting Data in HULFT Integrate
Connect to Sage Cloud Accounting as a JDBC data source in HULFT Integrate
-
LINQ to Oracle SCM 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 Oracle SCM Data Provider.
-
Visualize Qualaroo Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Qualaroo data.
-
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.
-
How to Connect to Live Sage Intacct Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Sage Intacct data for you.
-
Integrating GitHub Copilot with ServiceNow 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 Klipfolio Accounts
Replicate multiple Klipfolio accounts to one or many databases.
-
Connect to Sage Cloud Accounting Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Sage Cloud Accounting as an External Source in Dremio.
-
Access Live ElevenLabs Data in AWS Lambda
Connect to live ElevenLabs data in AWS Lambda using the CData JDBC Driver.
-
Use Databricks Agent Bricks to Talk to Your Couchbase Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Couchbase data for you.
-
Use ChatGPT to Talk to Your AgileCRM 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 AgileCRM data for you.
-
Connecting Agentforce with ActiveCampaign 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 ActiveCampaign data for you.
-
How to import Workable Data into Apache Solr
Use the CData Software JDBC Driver for Workable in Data Import Handler and create an automated import of Workable data to Apache Solr Enterprise Search platform.
-
How to Connect to & Open Azure Data Catalog Data in Microsoft Excel
This article uses the CData ODBC driver for Azure Data Catalog to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Open WebUI with Live BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live BigCommerce data from within the chat interface.
-
Bridge FHIR Connectivity with Apache NiFi
Access and process FHIR data in Apache NiFi using the CData JDBC Driver.
-
How to Connect Sage Cloud Accounting 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 Sage Cloud Accounting data in real time using natural language.
-
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.
-
Access Presto Data from MySQL in PHP
Connect to Presto through the standard MySQL libraries in PHP.
-
Connecting Mastra with Google Campaign Manager 360 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 Google Campaign Manager 360 data, no replication required.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Opsgenie
Provide connectivity to Opsgenie data through an SAP BusinessObjects universe.
-
Working with Odoo Data in LINQPad
Execute LINQ queries to Odoo data in LINQPad.
-
How to Build an ETL App for ZendeskSell Data in Python with CData
Create ETL applications and real-time data pipelines for ZendeskSell data in Python with petl.
-
Use the CData Software ODBC Driver for Certinia in MicroStrategy Desktop
Connect to Certinia data in MicroStrategy Desktop using the CData Software ODBC Driver for Certinia.
-
Query Live RSS Feeds 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 RSS feeds directly from the development environment.
-
Connect to Google Campaign Manager 360 Data in ACL Analytics
Connect to Google Campaign Manager 360 data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Campaign Manager 360 data.
-
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.
-
Integrate LDAP with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate LDAP with External Services.
-
Interact with Live Salesforce CRM Analytics 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 CRM Analytics data.
-
Build Pipelines with Live Xero Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Xero from Google Cloud Data Fusion, enabling the integration of live Xero data into the building and management of effective data pipelines.
-
How to work with Coda Data in Apache Spark using SQL
Access and process Coda Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous ZarMoney Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ZarMoney replication to Google BigQuery.
-
Query Live Kafka 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 Kafka data directly from the development environment.
-
Automated Continuous OData Replication to AlloyDB
Use CData Sync for automated, continuous, customizable OData replication to AlloyDB.
-
Connect to Zoho Books Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Zoho Books Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Connect to Live DocuSign 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 DocuSign data for you.
-
Access Live ZohoPeople Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to ZohoPeople data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate Cursor with Live BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live BigCommerce data from within the editor.
-
Access Azure Synapse Data from MySQL in PHP
Connect to Azure Synapse through the standard MySQL libraries in PHP.
-
Build Automated Mode-Connected Workflows in Zapier
Use CData Connect AI to connect to live Mode data and build automated workflows in Zapier.
-
Integrating Claude Code CLI with Aweber 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.
-
DataBind Controls to Google Analytics Data in C++Builder
DataBind to Google Analytics data in C++Builder with standard components and controls.
-
Create Discord-Connected Dashboards in Grafana
Connect to Discord Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Discord data.
-
Integrating LlamaIndex with LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on LinkedIn data in real time.
-
Use the CData Software ODBC Driver for Active Directory in SAS for Real-Time Reporting and Analytics
Connect to real-time Active Directory data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Active Directory.
-
Integrate Live Postmark Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Postmark 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 CockroachDB in Microsoft Power Query
You can use the CData CockroachDB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import CockroachDB data into Microsoft Power Query.
-
Automated Continuous Unbounce Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Unbounce replication to Apache Cassandra.
-
Integrating GitHub Copilot with Presto 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.
-
Automated Continuous ZohoDesk Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ZohoDesk replication to Apache Kafka.
-
Replicate Google Translate Data to Multiple Databases via the CData Sync CLI
Replicate Google Translate data to disparate databases with a single configuration.
-
Establish a Live Connection with Act CRM Data using Tableau Bridge
The CData ODBC Driver for Act CRM enables you to integrate live Act CRM data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Google's Antigravity Agent with Live Adobe Commerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Adobe Commerce data using the Model Context Protocol.
-
Connect to Google Campaign Manager 360 Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Campaign Manager 360 data using standard SQL.
-
Create Informatica Mappings From/To a JDBC Data Source for Figshare
Create Figshare data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Avalara AvaTax Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Avalara AvaTax data from Informatica Cloud.
-
How to Connect to Live Campaigner Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Campaigner data for you.
-
Integrating LangChain with SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SAS xpt data within automated workflows.
-
Query Cohere Data in DataGrip
Create a Data Source for Cohere in DataGrip and use SQL to query live Cohere data.
-
Migrating data from Harvest to Google BigQuery using CData SSIS Components.
Easily push Harvest data to Google BigQuery using the CData SSIS Tasks for Harvest and Google BigQuery.
-
Import and Visualize SAP SuccessFactors LMS Data in Power View
Create data visualizations based on SAP SuccessFactors LMS data in Excel.
-
Connect to Onfleet Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Onfleet data using standard SQL.
-
Automate Perplexity Data Replication to SAP HANA
Use CData Sync to customize and automate Perplexity data replication to SAP HANA.
-
Replicate Yelp Data to Multiple Databases
Replicate Yelp data to disparate databases with a point-and-click configuration.
-
Build Teradata-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Teradata data.
-
How to Build an ETL App for Tickspot Data in Python with CData
Create ETL applications and real-time data pipelines for Tickspot data in Python with petl.
-
Connect to Harvest Data in RapidMiner
Integrate Harvest data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Apify Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Apify replication to IBM DB2.
-
Connecting GenSpark with Adobe Commerce Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Adobe Commerce data without any replication or custom integration required.
-
Automated Continuous SAP Netweaver Gateway Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to Apache Cassandra.
-
Analyze SurveyMonkey Data in Cognos Analytics
Use CData Connect AI to connect to SurveyMonkey Data from Cognos Analytics and analyze live SurveyMonkey data.
-
Integrate Bitbucket Data in Pentaho Data Integration
Build ETL pipelines based on Bitbucket data in the Pentaho Data Integration tool.
-
How to Connect to Live SendGrid 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 SendGrid data through natural language.
-
Connect to QuickBooks Online Data in JRuby
Create a simple JRuby app with access to live QuickBooks Online data.
-
Establish a Live Connection with AlloyDB Data using Tableau Bridge
The CData ODBC Driver for AlloyDB enables you to integrate live AlloyDB data into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData Software JDBC Driver for Contentful in MicroStrategy Desktop
Connect to Contentful data in MicroStrategy Desktop using the CData Software JDBC Driver for Contentful.
-
How to create Visio diagrams from Blackbaud FE NXT Data
Automatically update Blackbaud FE NXT data with the changes you make to Visio master shapes.
-
Integrating Antigravity CLI with Gumroad data via CData CLI
Connect Gumroad data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating Kiro with ZohoExpense 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.
-
Use the CData Software ODBC Driver for Foursquare in SAS for Real-Time Reporting and Analytics
Connect to real-time Foursquare data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Foursquare.
-
Visualize Live NASA Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live NASA data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Automated Workflows with Live Bannerbear Data in Workato
Use CData Connect AI to connect to live Bannerbear data and build automated workflows in Workato.
-
DataBind Charts to SAP SuccessFactors LMS Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP SuccessFactors LMS 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.
-
Automated Continuous HBase Replication to AlloyDB
Use CData Sync for automated, continuous, customizable HBase replication to AlloyDB.
-
How to Build an ETL App for PayPal Data in Python with CData
Create ETL applications and real-time data pipelines for PayPal data in Python with petl.
-
Visualize Asana Data in TIBCO Spotfire through OData
Integrate Asana data into dashboards in TIBCO Spotfire.
-
Import SAP Concur Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP Concur Data and provide access to live SAP Concur data for custom reports in the Power BI Service.