CData Software - Knowledge Base
Recent Articles
-
Automate Microsoft Dataverse Data Replication to SAP HANA
Use CData Sync to customize and automate Microsoft Dataverse (CDS) replication to SAP HANA.
-
Getting Started with the CData ADO.NET Provider for Mistral AI
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Power BI XMLA Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Power BI XMLA.
-
Work with Odoo Data in FoxPro
Load Odoo ERP into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData Python Connector for Copper
Learn to install and license the CData Python Connector
-
Integrate Cline with Live Google Cloud Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Cloud Storage from within your IDE.
-
Connect to Amazon Marketplace Data from Crystal Reports
Use CData Connect AI to connect to and report on live Amazon Marketplace from Crystal Reports.
-
Visualize Live AlloyDB Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google AlloyDB.
-
Access Live SAP ByDesign Data in AWS Lambda
Connect to live SAP Business ByDesign in AWS Lambda using the CData JDBC Driver.
-
How to Connect to Live Odoo 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 Odoo ERP through natural language.
-
Connect to Oracle Eloqua from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Oracle Eloqua, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Viewing Customer.io Data in RAD Studio Data Explorer
How to view Customer.io in RAD Studio Data Explorer using the CData ODBC Driver for Customer.io.
-
How to Connect to Live Quickbase 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 Quickbase for you.
-
Visualize Live Retently Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Retently.
-
Automated Continuous Clockify Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Clockify replication to Amazon Redshift.
-
Visualize Odoo 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 Odoo ERP into TIBCO Spotfire.
-
Automated Continuous Azure Data Lake Storage Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Azure SQL Database.
-
Create EnterpriseDB-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to EnterpriseDB Data from Klipfolio and build custom visualizations using live EnterpriseDB.
-
Replicate Amazon DynamoDB Data in Heroku for Use in Salesforce Connect
Replicate Amazon DynamoDB to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Live Clari Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Clari into the statistical analysis tools available in SAS JMP. This article shows how to use Clari in the Graph Builder and Query Builder.
-
Getting Started with the CData ODBC Driver for Oracle Sales
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Oracle Sales.
-
How to create an RPA flow for Sugar CRM Data in UiPath Studio
Use the Sugar CRM ODBC Driver to create workflows that access real-time Sugar CRM without any coding.
-
Model ShipStation Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and ShipStation, enabling the direct import of real-time ShipStation.
-
How to Query Azure Table Data in MySQL Workbench
Execute MySQL queries against live Azure Table Storage from MySQL Workbench.
-
Use Dash to Build to Web Apps on ActiveCampaign Data
Create Python applications that use pandas and Dash to build ActiveCampaign-connected web apps.
-
Connect to Greenhouse from a Connection Pool in WebLogic
Use the CData JDBC Driver for Greenhouse to connect to Greenhouse from Web applications running on WebLogic.
-
Build Dropbox-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Dropbox to explore live Dropbox Data in GitHub Copilot to assist with building Dropbox-powered applications.
-
Integrating Codex CLI with Power BI XMLA 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.
-
Bidirectional Access to Stripe Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Stripe in Filemaker Pro for Mac or Windows.
-
How to Visualize Elasticsearch 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 Elasticsearch in Python.
-
How to create an RPA flow for Recurly Data in UiPath Studio
Use the Recurly ODBC Driver to create workflows that access real-time Recurly without any coding.
-
Deploy the ADO.NET Provider for Bugsnag on an SSRS Report Server
Connect to Bugsnag 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.
-
Build AI Agents with ShipStation 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 ShipStation through CData Connect AI.
-
Bind Live SAP Hybris C4C Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP Hybris C4C data
-
Validate Qualaroo Data with QuerySurge
Access and validate Qualaroo in QuerySurge using the CData JDBC Driver.
-
Integrate with Tickspot Data in JReport Designer
Create charts and reports based on Tickspot in JReport Designer.
-
Getting Started with the CData JDBC Driver for Google Drive
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Google Drive.
-
How to Design Azure Synapse Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Azure Synapse from mobile and tablet Power Apps.
-
How to Connect to Live MySQL 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 MySQL through natural language.
-
Automated Continuous Mailjet Replication to Databricks
Use CData Sync for automated, continuous, customizable Mailjet replication to Databricks.
-
Create Informatica Mappings From/To an ODBC Data Source for Cosmos DB
Create an ODBC connection to Cosmos DB in Informatica and browse and transfer Azure Cosmos DB.
-
Build Bannerbear-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Bannerbear.
-
Natively Connect to OnePageCrm Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to OnePageCrm. Leverage the native support for ODBC in PHP.
-
Import Real-Time Yelp Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Yelp in ColdFusion.
-
Query Vault CRM Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Veeva Vault & Vault CRM and perform CRUD operations on Vault CRM from Node.js.
-
Access Live Bitbucket Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Bitbucket in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Query ActiveCampaign Data in MySQL Workbench
Execute MySQL queries against live ActiveCampaign from MySQL Workbench.
-
Build a Simple VCL Application for Cosmos DB Data
How to build a simple VCL Application to view Azure Cosmos DB in RAD Studio using the CData ODBC Driver for Cosmos DB.
-
Automated Continuous Marketo Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Marketo replication to PostgreSQL.
-
Analyze Gmail Data in Looker
Use CData Connect AI to connect to Gmail Data from Looker and build custom apps using live Gmail.
-
Building Dynamic Web Pages with Google Search Results Using AngularJS
Create single-page applications with live connectivity to Google Search using the CData API Server.
-
Analyze Databricks Data in Looker
Use CData Connect AI to connect to Databricks Data from Looker and build custom apps using live Databricks.
-
Automated Continuous Sybase Replication to Oracle
Use CData Sync for automated, continuous, customizable Sybase replication to Oracle.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Couchbase to Power BI dashboards. Simply drag and drop Couchbase into data visuals on the Power BI canvas.
-
Getting Started with the CData Tableau Connector for Delighted
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create Reports with Teamwork Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Teamwork.
-
Getting Started with the CData Connect AI Python SDK for DB2
Install the CData Connect AI Python SDK to read and write live IBM DB2 with standard DB-API 2.0 Python code.
-
How to Connect to Live FreshBooks 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 FreshBooks for you.
-
DataBind Zoho Books Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Zoho Books with the DevExpress Windows Forms and Web controls to provide Zoho Books to a chart.
-
Integrating Claude Code with Google Cloud Storage Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Cloud Storage within assisted coding and automated development workflows.
-
Operational Reporting on FTP Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote FTP Servers.
-
Connect to CouchDB Data in DBArtisan
Use wizards in DBArtisan to configure Apache CouchDB as a data source.
-
Create Power BI Reports on Real-Time SendPulse Data
Use the CData ODBC Driver for SendPulse to visualize SendPulse in Power BI Desktop.
-
Connecting Mastra with Cassandra 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 Apache Cassandra, no replication required.
-
Integrate with LaunchDarkly Data in JReport Designer
Create charts and reports based on LaunchDarkly in JReport Designer.
-
Write a Simple Go Application to work with SAP ByDesign Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Business ByDesign.
-
Visualize DB2 Data in TIBCO Spotfire through OData
Integrate IBM DB2 into dashboards in TIBCO Spotfire.
-
Getting Started with the CData ODBC Driver for Azure Analysis Services
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Azure Analysis Services.
-
Consume FHIR OData Feeds in PowerBuilder
This article demonstrates how to consume FHIR as OData feeds from PowerBuilder using the API Server.
-
Use JayDeBeApi to access Teradata Data in Python
Use standard Python scripting and the development environment of your choice to access live Teradata.
-
Import Quickbase Data Using Azure Data Factory
Use CData Connect AI to connect to Quickbase Data from Azure Data Factory and import live Quickbase.
-
Automated Continuous AfterShip Replication to MongoDB
Use CData Sync for automated, continuous, customizable AfterShip replication to MongoDB.
-
How to Connect Flowise AI Agents to Live Zoho Inventory Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Zoho Inventory without replication.
-
How to Import Data from Okta into Google Sheets
Import Okta into a Google spreadsheet that is automatically refreshed.
-
How to Access Live Unbounce Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Unbounce enables you to integrate Unbounce into workflows built using Microsoft Power Automate Desktop.
-
Integrate Goose with Live Tally Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Tally ERP from within the local AI agent.
-
Use the CData Software ODBC Driver for Airtable in MicroStrategy Desktop
Connect to Airtable in MicroStrategy Desktop using the CData Software ODBC Driver for Airtable.
-
Connect to MongoDB Data in Claris FileMaker Pro
Use the CData ODBC Driver for MongoDB in FileMaker Pro to connect to MongoDB and work with MongoDB in your FileMaker applications.
-
Using the CData Software ODBC Driver for RabbitMQ in PyCharm
Connect to RabbitMQ as an ODBC data source in PyCharm using the CData Software ODBC Driver for RabbitMQ.
-
Automated Continuous Cassandra Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Cassandra replication to Amazon Redshift.
-
Create Informatica Mappings From/To a JDBC Data Source for CircleCI
Create CircleCI data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to connect to Amazon DynamoDB Data with Squirrel SQL client
Connect to Amazon DynamoDB and execute queries in the Squirrel SQL Client.
-
Import and Visualize CockroachDB Data in Power View
Create data visualizations based on CockroachDB in Excel.
-
Connect to SAP SuccessFactors Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP SuccessFactors as an External Source in Dremio.
-
Replicate Multiple LDAP Accounts
Replicate multiple LDAP accounts to one or many databases.
-
Getting Started with the CData ADO.NET Provider for Oracle SCM
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Oracle SCM.
-
Getting Started with the CData ADO.NET Provider for Pushbullet
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Build an ETL App for Smartsheet Data in Python with CData
Create ETL applications and real-time data pipelines for Smartsheet in Python with petl.
-
Build an OLAP Cube in SSAS from Google Calendar Data
Establish a connection to Google Calendar data from SQL Server Analysis Services, and use the Google Calendar Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to and Query WordPress Data in QlikView over ODBC
Create data visualizations with WordPress in QlikView.
-
Use JayDeBeApi to access Azure Synapse Data in Python
Use standard Python scripting and the development environment of your choice to access live Azure Synapse.
-
How to Connect to Live Google Campaign Manager 360 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 Google Campaign Manager 360 for you.
-
Integrating GitHub Copilot CLI with Contentful 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.
-
Access Live MariaDB 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 MariaDB through MCP integration.
-
Connect to Onfleet Data in NetBeans
Connect to Onfleet in NetBeans with the data source configuration wizard.
-
Connect to Placid Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Placid as an External Source in Dremio.
-
Access Front Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Front from HeidiSQL.
-
Build a Simple VCL Application for Nethunt Data
How to build a simple VCL Application to view Nethunt in RAD Studio using the CData ODBC Driver for Nethunt.
-
How to connect to SpaceX Data in DBVisualizer
Integrate SpaceX with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to FTP from a Connection Pool in WebLogic
Use the CData JDBC Driver for FTP to connect to FTP Servers from Web applications running on WebLogic.