CData Software - Knowledge Base
Recent Articles
-
Access Live Printful Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Printful data into the statistical analysis tools available in SAS JMP. This article shows how to use Printful data in the Graph Builder and Query Builder.
-
Automated Continuous Perigon Replication to SQL Server
Use CData Sync for automated, continuous, customizable Perigon replication to SQL Server.
-
Using the CData Software ODBC Driver for WordPress in PyCharm
Connect to WordPress as an ODBC data source in PyCharm using the CData Software ODBC Driver for WordPress.
-
Write a Simple Go Application to work with Rebilly Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Rebilly data.
-
Automated Continuous Zoho Books Replication to Vertica
Use CData Sync for automated, continuous, customizable Zoho Books replication to Vertica.
-
Object-Relational Mapping (ORM) with OneNote 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 OneNote data into a Java-based ORM framework, Hibernate.
-
Integrate with SAS xpt Data in JReport Designer
Create charts and reports based on SAS xpt data in JReport Designer.
-
How to Connect to Live Facebook Ads 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 Facebook Ads data for you.
-
Automated Continuous Insightly Replication to SQL Server
Use CData Sync for automated, continuous, customizable Insightly replication to SQL Server.
-
How to create Redis federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Redis data in MySQL .
-
Connect to Samanage Data in DBeaver
Use the CData ODBC Driver to connect to Samanage data in DBeaver.
-
Use the CData Software ODBC Driver for Salesforce Pardot in MicroStrategy
Connect to Salesforce Pardot data in MicroStrategy Developer using the CData Software ODBC Driver for Salesforce Pardot.
-
DataBind Controls to Todoist Data in C++Builder
DataBind to Todoist data in C++Builder with standard components and controls.
-
Use the CData Software JDBC Driver for CouchDB in MicroStrategy Web
Connect to CouchDB data in MicroStrategy Web using the CData Software JDBC Driver for CouchDB.
-
Connect to Hive Data from PowerBuilder via JDBC
This article demonstrates how to access Hive data from PowerBuilder using the Hive JDBC Driver.
-
Automated Continuous CouchDB Replication to Snowflake
Use CData Sync for automated, continuous, customizable CouchDB replication to Snowflake.
-
Import and Visualize ElevenLabs Data in Power View
Create data visualizations based on ElevenLabs data in Excel.
-
Integrating Claude Code with TaxJar Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on TaxJar data within assisted coding and automated development workflows.
-
Query Oracle Data as a SQL Server Database in Node.js
Execute SQL Server queries against Oracle data from Node.js.
-
Integrating Claude Code with Paylocity Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Paylocity data within assisted coding and automated development workflows.
-
DataBind Controls to Snowflake Data in C++Builder
DataBind to Snowflake data in C++Builder with standard components and controls.
-
SAP Fieldglass Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP Fieldglass facts in real time.
-
Build Data Flows from Notion to SQL Server using SSIS
Easily back up Notion data to SQL Server using the SSIS components for Notion.
-
Automated Continuous Sage 300 Replication to SingleStore
Use CData Sync for automated, continuous, customizable Sage 300 replication to SingleStore.
-
How to Build an ETL App for Opsgenie Data in Python with CData
Create ETL applications and real-time data pipelines for Opsgenie data in Python with petl.
-
Integrate Theia IDE with Live SAP Ariba Procurement 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 SAP Ariba Procurement data from within the development environment.
-
Connect to IBM Informix from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from IBM Informix data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Agents in Relevance AI with Access to Live CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on CockroachDB data within intelligent agent workflows.
-
Integrate Cursor with Live SAP Ariba Procurement Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP Ariba Procurement data from within the editor.
-
Replicate Multiple SurveyMonkey Accounts via the CData Sync CLI
Replicate multiple SurveyMonkey accounts to one or many databases.
-
How to Work with OneNote Data in ETL Validator JDBC
Connect to OneNote from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate OpenCode with Live Azure Table Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Azure Table data from within your AI coding agent.
-
Create Dynamic Pinterest Grids Using the Infragistics XamDataGrid
Learn how you can connect Pinterest to Infragistics XamDataGrid to build dynamic grids.
-
Replicate PolarTeamPro Data to Multiple Databases
Replicate PolarTeamPro data to disparate databases with a point-and-click configuration.
-
Access QuickBooks Time 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 QuickBooks Time data.
-
How to import Google Translate Data into Apache Solr
Use the CData Software JDBC Driver for Google Translate in Data Import Handler and create an automated import of Google Translate data to Apache Solr Enterprise Search platform.
-
Automate Azure Synapse Data Replication to Azure Data Lake
Use CData Sync to customize and automate Azure Synapse data replication to Azure Data Lake.
-
Connect to Zoho CRM Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Zoho CRM Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Design BIRT Reports on Asana Data
Provide current Asana data to your embedded analytics.
-
Connect to WooCommerce Data in Jaspersoft Studio
Execute SQL to remote WooCommerce data in Jaspersoft Studio.
-
Integrate Microsoft Planner Data in the Pentaho Report Designer
Publish reports based on Microsoft Planner data in the Pentaho BI tool.
-
Integrate OpenCode with Live MYOB AccountRight Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live MYOB AccountRight data from within your AI coding agent.
-
Connect Azure Data Catalog to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Azure Data Catalog with IBM WebSphere for seamless data integration and connectivity.
-
Integrating OpenCode with Campaigner 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 GitHub Copilot with Exact Online 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.
-
Query Discourse Data as a MySQL Database in Node.js
Execute MySQL queries against Discourse data from Node.js.
-
Automated Continuous Asana Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Asana replication to Azure SQL Database.
-
Build Marketo-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Marketo Data and create custom apps in Mendix.
-
Interact with Live Google Ad Manager Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Google Ad Manager data.
-
How to Connect to Live HCL Domino Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your HCL Domino data for you.
-
Build Automated Workflows with Live Sendwithus Data in Workato
Use CData Connect AI to connect to live Sendwithus data and build automated workflows in Workato.
-
Build Google Sheets-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Sheets data.
-
How to connect Amazon QuickSight to Act CRM Data
Create a connection to Act CRM data in CData Connect AI and insert Act CRM data into Amazon QuickSight SPICE to build interactive dashboards.
-
Getting Started with the CData Python Connector for Sendwithus
Learn to install and license the CData Python Connector and configure a connection to live Sendwithus data.
-
Design BIRT Reports on Moosend Data
Provide current Moosend data to your embedded analytics.
-
Access Live PDFMonkey Data in Coginiti Pro
Connect to and query live PDFMonkey data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating Antigravity CLI with Stripe data via CData CLI
Connect Stripe data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Amazon Athena Data Replication to Teradata
Use CData Sync to Customize and automate Amazon Athena data replication to Teradata.
-
Use Claude to Talk to Your WordPress 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 WordPress data for you.
-
Connect to Odoo Data from PowerBuilder via ADO.NET
This article demonstrates how to access Odoo data from Appeon PowerBuilder using the CData ADO.NET Provider for Odoo.
-
Build Agents in Relevance AI with Access to Live eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on eBay data within intelligent agent workflows.
-
Integrating Dataiku with Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Workday data.
-
Connect to Zoho Creator Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Zoho Creator data from Filemaker Pro on Mac.
-
DataBind Controls to MYOB AccountRight Data in Delphi
DataBind to MYOB AccountRight data in Delphi with standard data access components and controls.
-
Automated Continuous AgileCRM Replication to MongoDB
Use CData Sync for automated, continuous, customizable AgileCRM replication to MongoDB.
-
Access Datadog Data from MySQL in PHP
Connect to Datadog through the standard MySQL libraries in PHP.
-
Analyze ZohoExpense Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of ZohoExpense data and visualize live ZohoExpense data in Infragistics Reveal.
-
Use the CData Software ODBC Driver for Paymo in SAS for Real-Time Reporting and Analytics
Connect to real-time Paymo data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Paymo.
-
Build a PostgreSQL Interface for Wistia Data using the CData JDBC Driver
Use the Remoting features of the Wistia JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Pipedrive Data in the Pentaho Report Designer
Publish reports based on Pipedrive data in the Pentaho BI tool.
-
Integrating Claude Code CLI with Auth0 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 Vimeo Data with Squirrel SQL client
Connect to Vimeo data and execute queries in the Squirrel SQL Client.
-
How to Build an ETL App for BenchmarkEmail Data in Python with CData
Create ETL applications and real-time data pipelines for BenchmarkEmail data in Python with petl.
-
Use Dash to Build to Web Apps on Guru Data
Create Python applications that use pandas and Dash to build Guru-connected web apps.
-
Connect to Pinterest Data in DBeaver
Use the CData ODBC Driver to connect to Pinterest data in DBeaver.
-
Build Semantic Layer Views for Beeminder Data in APOS Live Data Gateway
Use the CData Connector for Beeminder in APOS Live Data Gateway to build Semantic Layer Views for Beeminder data.
-
Connect to FreshBooks Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for FreshBooks to connect to FreshBooks data and execute queries in PowerBuilder.
-
Integrate Cursor with Live CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live CSV data from within the editor.
-
Analyze MariaDB Data in Looker
Use CData Connect AI to connect to MariaDB Data from Looker and build custom apps using live MariaDB data.
-
Natively Connect to Email Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Email data. Leverage the native support for ODBC in PHP.
-
Replicate Multiple Sentry Accounts
Replicate multiple Sentry accounts to one or many databases.
-
Connect to GetResponse Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for GetResponse and the SQL Gateway to access GetResponse data from Google Apps Script.
-
How to Query Live Pipeliner CRM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Pipeliner CRM data data in natural language using Python.
-
Sage 300 Reporting in OBIEE with the Sage 300 JDBC Driver
Deploy the Sage 300 JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Azure Synapse 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 Azure Synapse data.
-
Integrate Real-Time Access to SQL Server in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SQL Server data in real time.
-
Build BigCommerce-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for BigCommerce Data and create custom apps in Bubble.
-
Getting Started with the CData Excel Add-In for SharePoint
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SharePoint.
-
Integrate with live EnterpriseDB Data in Jitterbit
Use CData Connect AI to connect to and integrate live EnterpriseDB data in Jitterbit.
-
Getting Started with the CData SSIS Components for Splunk
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Splunk.
-
Query OpenWeatherMap Data as a MySQL Database in Node.js
Execute MySQL queries against OpenWeatherMap data from Node.js.
-
Create Informatica Mappings From/To an ODBC Data Source for Bitbucket
Create an ODBC connection to Bitbucket in Informatica and browse and transfer Bitbucket data.
-
Analyze Optimizely Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Optimizely data with the CData JDBC Driver for Optimizely.
-
Query ChartMogul Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ChartMogul data from Node.js.
-
Integrating OpenCode with Sybase IQ 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.
-
Build CampaignMonitor-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to CampaignMonitor data and build web apps with connectivity to live CampaignMonitor data.
-
How to Visualize Wave Financial Data in Python with pandas
Use pandas and other modules to analyze and visualize live Wave Financial data in Python.
-
Connect to Databricks Data in ACL Analytics
Connect to Databricks data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Databricks data.
-
Connect to BambooHR 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 BambooHR and work with BambooHR data in your FileMaker application.
-
Access LDAP Objects from MySQL in PHP
Connect to LDAP through the standard MySQL libraries in PHP.