CData Software - Knowledge Base
Recent Articles
-
Automate Adobe Analytics Data Replication to Couchbase
Use CData Sync to Customize and automate Adobe Analytics replication to Couchbase.
-
Integrating GitHub Copilot CLI with Teradata 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 PivotalTracker Data in Pentaho Data Integration
Build ETL pipelines based on PivotalTracker in the Pentaho Data Integration tool.
-
Visualize Onfleet Data in TIBCO Spotfire through ADO.NET
Integrate Onfleet into dashboards in TIBCO Spotfire.
-
Access Sage 200 Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sage 200 from your Oracle system.
-
Create Reports with Notion Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Notion.
-
Automated Continuous Pipedrive Replication to Oracle
Use CData Sync for automated, continuous, customizable Pipedrive replication to Oracle.
-
Integrate LibreChat with Live WordPress Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live WordPress from within the chat interface.
-
Import Real-Time Missive Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Missive in ColdFusion.
-
Automated Continuous Oracle SCM Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Oracle SCM replication to Amazon S3.
-
How to connect SharePoint with Cassandra Data through external lists
Provide Apache Cassandra to SharePoint users as an external list.
-
Getting Started with the CData Python Connector for Pipedrive
Learn to install and license the CData Python Connector
-
Build Charts with Invoiced Data in Clear Analytics
Create dynamic charts and perform analytics based on Invoiced in Clear Analytics.
-
Connect to xBase Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for xBase to connect to xBase and execute queries in PowerBuilder.
-
Connect to Slack Data in RazorSQL
Connect to Slack from wizards and query Slack from the GUI in the RazorSQL database management tool.
-
Analyze HDFS Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Apache HDFS in Microsoft R Open.
-
Create Azure Table-Connected Applications in Appsmith
Connect to Azure Table Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Azure Table Storage.
-
How to integrate Oracle SCM with Apache Airflow
Access and process Oracle SCM in Apache Airflow using the CData JDBC Driver.
-
DataBind Controls to Campaigner Data in Delphi
DataBind to Campaigner in Delphi with standard data access components and controls.
-
Automate Cvent Data Replication to Couchbase
Use CData Sync to Customize and automate Cvent replication to Couchbase.
-
How to integrate Azure Analysis Services with Apache Airflow
Access and process Azure Analysis Services in Apache Airflow using the CData JDBC Driver.
-
Build Apps with Live Google Ads in Adalo using CData Connect AI
Use CData Connect AI to integrate live Google Ads into the Adalo platform and build custom mobile and web applications with real-time Google Ads.
-
Integrating Cursor CLI with QuickBooks 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 Build an ETL App for Azure Synapse Data in Python with CData
Create ETL applications and real-time data pipelines for Azure Synapse in Python with petl.
-
Easily Integrate TaxJar Data in Lazarus Pascal IDE
Learn how to easily integrate live TaxJar in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating Kiro CLI with Coinbase 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 Dashboards with SingleStore Data in Dundas BI
Create dynamic dashboards and perform analytics based on SingleStore in Dundas BI.
-
Automated Continuous MYOB AccountRight Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Google BigQuery.
-
Model Zoom Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Zoom, enabling the direct import of real-time Zoom.
-
Visualize Live Dynamics 365 Business Central Data in the Power BI Service
Use CData Connect AI to connect to live Dynamics 365 Business Central and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Prepare, Blend, and Analyze Salesforce Data in Alteryx Designer (ODBC)
Build workflows to access live Salesforce & Force.com for self-service data analytics.
-
Connect to SAP Business One Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP Business One in Google Apps Script.
-
Bidirectional Access to Coinbase Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Coinbase in Filemaker Pro for Mac or Windows.
-
Connect Rootly to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Rootly using the CData Python MCP Server.
-
DataBind JotForm Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide JotForm to a chart.
-
Feed Paymo Data into FineReport
How to set Paymo as a JDBC data source in FineReport.
-
Natively Connect to Google Directory Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Directory. Leverage the native support for ODBC in PHP.
-
Build SAP Concur-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for SAP Concur to explore live SAP Concur Data in Cursor to assist with building SAP Concur-powered applications.
-
Connect to Databricks Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Databricks to connect to Databricks and execute queries in PowerBuilder.
-
DataBind Samanage Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Samanage to a chart.
-
Connect and Query Live Azure Data Lake Storage Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Azure Data Lake Storage into Databricks
-
Build Agents in Relevance AI with Access to Live PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on PayPal within intelligent agent workflows.
-
Integrate Moosend with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Moosend with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Moosend.
-
Bidirectional Access to Zoho Creator Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Zoho Creator in Filemaker Pro for Mac or Windows.
-
Build AI Agents with Oracle Sales Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Oracle Sales through CData Connect AI.
-
Connect to Google Directory from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Directory, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Xero-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Xero Data and create custom apps in Mendix.
-
Connect to Samanage Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Samanage using standard SQL.
-
Integrate Live Salesforce Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Natively Connect to Foursquare Data in PHP
The CData ODBC driver for Foursquare enables you to create PHP applications with connectivity to Foursquare. Leverage the native support for ODBC in PHP.
-
How to Connect DBeaver to Adobe Commerce via a JDBC Driver
Manage Adobe Commerce with visual tools in DBeaver like the query browser.
-
Connect to Slack Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Slack in the Denodo Virtual DataPort Administrator.
-
Connect to Shortcut Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Shortcut to connect to Shortcut and execute queries in PowerBuilder.
-
Connect to Perigon Data in Jaspersoft Studio
Execute SQL to remote Perigon in Jaspersoft Studio.
-
Automated Continuous Delighted Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Delighted replication to Amazon S3.
-
Getting Started with the CData Python Connector for Deel
Learn to install and license the CData Python Connector
-
Integrate Demio Data in Pentaho Data Integration
Build ETL pipelines based on Demio in the Pentaho Data Integration tool.
-
Access Live Printify Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Printify into the statistical analysis tools available in SAS JMP. This article shows how to use Printify in the Graph Builder and Query Builder.
-
Load Odoo Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Odoo ERP to a database.
-
Connect to ConstantContact Data in Ruby
Connect to ConstantContact in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect to Live NetSuite 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 NetSuite CRM & ERP for you.
-
SurveyMonkey Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SurveyMonkey through CData Connect AI using different applications and tools.
-
Create a Data Access Object for Auth0 Data using JDBI
A brief overview of creating a SQL Object API for Auth0 in JDBI.
-
Integrating OpenCode Terminal with Flowlu 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.
-
Getting Started with the CData Python Connector for JotForm
Learn to install and license the CData Python Connector
-
Build Kintone-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Kintone to explore live Kintone Data in GitHub Copilot to assist with building Kintone-powered applications.
-
How to Access Salesloft Data Using Entity Framework
This article shows how to access Salesloft using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Replicate Amplitude Data to Multiple Databases
Replicate Amplitude to disparate databases with a point-and-click configuration.
-
Integrating LangChain with Airtable Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Airtable within automated workflows.
-
Visualize MariaDB Data in TIBCO Spotfire through ADO.NET
Integrate MariaDB into dashboards in TIBCO Spotfire.
-
Connect HelloSign to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect HelloSign with IBM WebSphere for seamless data integration and connectivity.
-
How to Query IBM Informix Data in MySQL Workbench
Execute MySQL queries against live IBM Informix from MySQL Workbench.
-
Automated Continuous Spark Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Spark replication to PostgreSQL.
-
Connect to Freshsales from Asprova with CData Software ODBC Driver for Freshsales
This article shows how to connect faster to Freshsales data from Asprova.
-
Automated Continuous Oracle Eloqua Replication to MongoDB
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to MongoDB.
-
Integrate with Pipeliner CRM Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Pipeliner CRM to a JSON file on disk.
-
Integrating Boomi Agentstudio with Procore Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Procore, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
DataBind Hugging Face Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Hugging Face to a chart.
-
Connect to Amazon Marketplace Data in Claris FileMaker Pro
Use the CData ODBC Driver for Amazon Marketplace in FileMaker Pro to connect to Amazon Marketplace and work with Amazon Marketplace in your FileMaker applications.
-
How to connect to Apify Data from IntelliJ
Integrate connectivity to Apify with wizards in IntelliJ.
-
Build SAP Business One Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Business One and build visualizations in Tableau Cloud.
-
Build Dashboards with Strava Data in Dundas BI
Create dynamic dashboards and perform analytics based on Strava in Dundas BI.
-
Connect to Teamgate Data in RapidMiner
Integrate Teamgate with standard components and data source configuration wizards in RapidMiner Studio.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Discord
Provide connectivity to Discord through an SAP BusinessObjects universe.
-
How to load TigerGraph data into Elasticsearch via Logstash
Introducing a simple method to load TigerGraph data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Zuora Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Zuora.
-
Perform Batch Operations with ADP Data in Apache NiFi
Connect to ADP and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to load Outreach.io data into Elasticsearch via Logstash
Introducing a simple method to load Outreach.io data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Getting Started with the CData ODBC Driver for Google Sheets
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Sheets.
-
Integrating LangChain with SAP Fieldglass Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SAP Fieldglass within automated workflows.
-
Build Semantic Layer Views for Office 365 Data in APOS Live Data Gateway
Use the CData Connector for Office 365 in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Office 365.
-
View Reports on Real-Time OpenWeatherMap Data in Power BI Report Server
Use the CData ODBC Driver for OpenWeatherMap to visualize OpenWeatherMap in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Dashboards with XML Data in DBxtra
Create dynamic dashboards and perform analytics based on XML Files in DBxtra.
-
Use the CData Software ODBC Driver for IBM Informix in MicroStrategy
Connect to IBM Informix in MicroStrategy Developer using the CData Software ODBC Driver for IBM Informix.
-
Analyze Microsoft Ads Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft Ads in Microsoft R Open.
-
Integrate Live Exa Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Exa to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Query Dynamics CRM Data in MySQL Workbench
Execute MySQL queries against live Microsoft Dynamics CRM from MySQL Workbench.
-
Build Slack-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Slack Data and create custom apps in Mendix.
-
Connect to BambooHR Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for BambooHR to connect to BambooHR and execute queries in PowerBuilder.
-
Operational Reporting on Egnyte Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Egnyte.