CData Software - Knowledge Base
Recent Articles
-
Connect Access to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Access data using the CData Python MCP Server.
-
Connect to Bugsnag Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Bugsnag to connect to Bugsnag data and execute queries in PowerBuilder.
-
How to Connect to Live QuickBooks Online 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 QuickBooks Online data for you.
-
LINQ to Google Directory 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 Google Directory Data Provider.
-
Creating Freshteam-Connected Applications in Unqork
You can use CData Connect AI to feed Freshteam data to Unqork and build custom business apps.
-
Integrate Theia IDE with Live Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Confluence data from within the development environment.
-
Create a Data Access Object for Blackbaud FE NXT Data using JDBI
A brief overview of creating a SQL Object API for Blackbaud FE NXT data in JDBI.
-
Automated Continuous Samanage Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Samanage replication to PostgreSQL.
-
Access Freshservice Data from MySQL in PHP
Connect to Freshservice through the standard MySQL libraries in PHP.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Reckon
Provide connectivity to Reckon data through an SAP BusinessObjects universe.
-
Automated Continuous PhantomBuster Replication to SQLite
Use CData Sync for automated, continuous, customizable PhantomBuster replication to SQLite.
-
Configure the CData JDBC Driver for Microsoft Entra ID in a Connection Pool in Tomcat
Connect to Microsoft Entra ID data from a connection pool in Tomcat.
-
Add JSON Services to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for JSON with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Devin with Live SQL Server 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 SQL Server data.
-
Integrating Claude Code CLI with MariaDB 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 Manus AI to Talk to Your Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Sybase data.
-
Access Amazon Athena Data from MySQL in Amazon QuickSight
Connect to Amazon Athena and build visualizations of Amazon Athena data using a MySQL Connection in Amazon QuickSight.
-
Connect to ActiveCampaign Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ActiveCampaign as an External Source in Dremio.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for PhantomBuster
Provide connectivity to PhantomBuster data through an SAP BusinessObjects universe.
-
Build MVC Applications with Connectivity to Cohere Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Cohere from an ASP.NET MVC application.
-
Connect to Todoist Data in Aqua Data Studio
Access Todoist data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrating Kiro 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.
-
Visualize Live Freshservice Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Freshservice data into custom reports in Power BI.
-
Working with AlloyDB Data in LINQPad
Execute LINQ queries to AlloyDB data in LINQPad.
-
LINQ to Elasticsearch 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 Elasticsearch Data Provider.
-
Build Apps with Live Shopify data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Shopify data into the Adalo platform and build custom mobile and web applications with real-time Shopify data.
-
Connecting Agentforce with Shortcut 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 Shortcut data for you.
-
Automated Continuous Mocean Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Mocean replication to Apache Cassandra.
-
Integrate Google Contacts with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Contacts with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Contacts data.
-
Design BIRT Reports on MarkLogic Data
Provide current MarkLogic data to your embedded analytics.
-
Connect and Query Live Google Sheets Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Google Sheets data into Databricks and enable direct, live querying and analysis without replication.
-
Use the CData ODBC Driver for Suadeo in Microsoft Power Query
You can use the CData Suadeo ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Suadeo data into Microsoft Power Query.
-
Visualize SAP Netweaver Gateway Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load SAP Netweaver Gateway data into TIBCO Spotfire.
-
How to work with Jodoo Data in Apache Spark using SQL
Access and process Jodoo Data in Apache Spark using the CData Software JDBC Driver.
-
Replicate Retently Data to Multiple Databases via the CData Sync CLI
Replicate Retently data to disparate databases with a single configuration.
-
Integrate BenchmarkEmail Data in the Pentaho Report Designer
Publish reports based on BenchmarkEmail data in the Pentaho BI tool.
-
How to Visualize Box Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Box data in Python.
-
Perform Batch Operations with FTP Data in Apache NiFi
Connect to FTP data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to SAS xpt from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAS xpt data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate Live CSV Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live CSV data to Blue Prism using the CData ODBC Driver for CSV to create automated workflows for repetitive business tasks.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Blackbaud FE NXT
Provide connectivity to Blackbaud FE NXT data through an SAP BusinessObjects universe.
-
Consume Certinia OData Feeds in PowerBuilder
This article demonstrates how to consume Certinia data as OData feeds from PowerBuilder using the API Server.
-
Connect to ClickTime Data in Jaspersoft Studio
Execute SQL to remote ClickTime data in Jaspersoft Studio.
-
Getting Started with the CData JDBC Driver for Vimeo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Vimeo.
-
Automated Continuous Strava Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Strava replication to PostgreSQL.
-
Integrate Cline with Live Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Blackbaud FE NXT data from within your IDE.
-
Migrating data from Blackbaud FE NXT to Google BigQuery using CData SSIS Components.
Easily push Blackbaud FE NXT data to Google BigQuery using the CData SSIS Tasks for Blackbaud FE NXT and Google BigQuery.
-
Enable the MYOB AccountRight JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with MYOB AccountRight data.
-
Integrating Claude Code with Guru Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Guru data within assisted coding and automated development workflows.
-
Integrate Freshservice Data in Pentaho Data Integration
Build ETL pipelines based on Freshservice data in the Pentaho Data Integration tool.
-
Integrate Exact Online Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Exact Online data and integrate live Exact Online data into your Power Automate tasks.
-
How to Connect to Live Printify 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 Printify data for you.
-
Automated Continuous EnterpriseDB Replication to SingleStore
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to SingleStore.
-
Automate CouchDB Data Replication to SAP HANA
Use CData Sync to customize and automate CouchDB data replication to SAP HANA.
-
How to publish and share Oracle Financials Cloud Data dashboards with Tableau Server
The CData ODBC driver for Oracle Financials Cloud enables you integrate Oracle Financials Cloud data into Tableau dashboards.
-
How to Build an ETL App for Oracle Eloqua Data in Python with CData Connect AI
Build ETL pipelines that read and write live Oracle Eloqua data in Python with petl and the CData Connect AI Python SDK.
-
Replicate Teradata Data to Multiple Databases
Replicate Teradata data to disparate databases with a point-and-click configuration.
-
Integrating LangChain with DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on DB2 data within automated workflows.
-
Build Voice Agents in ElevenLabs with access to Live Dynamics 365 Business Central Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Dynamics 365 Business Central data.
-
Use CData Connect AI to Access Bitbucket Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Bitbucket data in the Power Pivot business intelligence tool.
-
How to Connect to DocuSign Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to DocuSign data. Leverage the pyodbc module for ODBC in Python.
-
Connecting Pipedream with Quickbase 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 Quickbase data in real time.
-
Access Okta Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Okta data from your Oracle system.
-
Connect to Close Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Close data in the Denodo Virtual DataPort Administrator.
-
Connect to Microsoft Entra ID Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Microsoft Entra ID.
-
How to Connect AgileCRM 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 AgileCRM data in real time using natural language.
-
DataBind Controls to LeadDesk Data in Delphi
DataBind to LeadDesk data in Delphi with standard data access components and controls.
-
DataBind CircleCI Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide CircleCI data to a chart.
-
How to Easily Query Act CRM Data in OpenOffice Base
Connect to Act CRM data in OpenOffice Base using the CData ODBC Driver for Act CRM and generate reports with live data insights.
-
Getting Started with the CData ODBC Driver for Beeminder
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Beeminder.
-
Connect to Adobe Experience Manager Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Adobe Experience Manager data in Airbyte.
-
Access Perigon Data from MySQL in PHP
Connect to Perigon through the standard MySQL libraries in PHP.
-
Operational Reporting on SAP Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP data.
-
Getting Started with the CData ADO.NET Provider for Templated
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous GraphQL Replication to SingleStore
Use CData Sync for automated, continuous, customizable GraphQL replication to SingleStore.
-
Build Agents in Relevance AI with Access to Live MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on MailChimp data within intelligent agent workflows.
-
Connect to PayPal from Asprova with CData Software ODBC Driver for PayPal
This article shows how to connect faster to PayPal data from Asprova.
-
Build Automated Google Directory-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Directory data and build automated workflows in Zapier.
-
How to Work with Datadog Data in ETL Validator JDBC
Connect to Datadog from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Tableau Connector for Zoho Inventory
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Zoho Inventory.
-
Access Live Mailgun Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Mailgun data from your Excel spreadsheets.
-
DataBind Controls to Freshdesk Data in C++Builder
DataBind to Freshdesk data in C++Builder with standard components and controls.
-
Model, Search, and Visualize Live Google Analytics Data in ThoughtSpot
Use CData Connect AI to connect to live Google Analytics data for modeling, searching, and visualizing.
-
Use the CData SSIS Components to Insert New or Update Existing Salesforce CRM Analytics Records from SQL Server
Easily push SQL Server data to Salesforce CRM Analytics using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Salesforce CRM Analytics or update existing records with data from a SQL Server database.
-
Automated Continuous Oracle HCM Cloud Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Azure SQL Database.
-
Connect to Microsoft Dataverse Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Microsoft Dataverse to connect to Microsoft Dataverse data and execute queries in PowerBuilder.
-
How to Connect to Live Jumpseller 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 Jumpseller data through natural language.
-
Analyze Workable Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Workable data in Microsoft R Open.
-
Access Live Microsoft Entra ID 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 Microsoft Entra ID data through MCP integration.
-
Automated Continuous Mouseflow Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Mouseflow replication to Amazon Redshift.
-
Connect to AgileCRM Data in Google Apps Script via Connect AI
Use CData Connect AI to access AgileCRM data in Google Apps Script.
-
Replicate Multiple Azure Data Lake Storage Accounts via the CData Sync CLI
Replicate multiple Azure Data Lake Storage accounts to one or many databases.
-
How to connect to Foursquare Data from Spring Boot
Connect to Foursquare in a Spring Boot Application using the CData API Driver for JDBC
-
DataBind Controls to Excel Data in Delphi
DataBind to Excel data in Delphi with standard data access components and controls.
-
Connect to Avro Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Avro as an External Source in Dremio.
-
Getting Started with the CData ADO.NET Provider for Customer.io
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Access Live Salesforce Marketing Data in TIBCO Data Virtualization
Use the Salesforce Marketing Tibco DV Adapter to create a Salesforce Marketing data data source in TIBCO Data Virtualization Studio and gain access to live Salesforce Marketing data from your TDV Server.
-
Automated Continuous Google Search Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Search replication to Snowflake.
-
Integrate with Mocean Data in JReport Designer
Create charts and reports based on Mocean data in JReport Designer.
-
Automated Continuous PayPal Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable PayPal replication to Google BigQuery.