CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Zoho Creator Replication to Vertica
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Vertica.
-
Connect IBM Cloud Object Storage to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live IBM Cloud Object Storage using the CData Python MCP Server.
-
Integrating Claude Code CLI with Klaviyo 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 Seamlessly Import TaxJar Data into IBM SPSS Modeler
Integrate TaxJar data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use the CData Software JDBC Driver for Sage 300 in MicroStrategy Desktop
Connect to Sage 300 in MicroStrategy Desktop using the CData Software JDBC Driver for Sage 300.
-
Create Postmark Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Postmark data access from reports, embedded analytics, and more.
-
Integrate LinkedIn Ads Data into Power Automate Desktop using CData Connect
CData Connect for LinkedIn Ads Data enables you to integrate LinkedIn Ads into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous SharePoint Excel Services Replication to MySQL
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to MySQL.
-
Connect to Delighted Data in JRuby
Create a simple JRuby app with access to live Delighted.
-
Create Data Visualizations in Cognos BI with Shopify Data
Access Shopify as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Load Phoenix Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Apache Phoenix to a database.
-
Working with eBay Data in LINQPad
Execute LINQ queries to eBay in LINQPad.
-
Getting Started with the CData Tableau Connector for Dropbox
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Dropbox.
-
Provide OData Services of ADP Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ADP by developing a WCF Service Application.
-
Build Agents in Relevance AI with Access to Live Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Asana within intelligent agent workflows.
-
Build a Simple VCL Application for ShipStation Data
How to build a simple VCL Application to view ShipStation in RAD Studio using the CData ODBC Driver for ShipStation.
-
Getting Started with the CData ODBC Driver for OData
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for OData.
-
Create Dynamic Perigon Grids Using the Infragistics XamDataGrid
Learn how you can connect Perigon to Infragistics XamDataGrid to build dynamic grids.
-
Build Cloudflare-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Cloudflare.
-
Connect MailChimp to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect MailChimp with IBM WebSphere for seamless data integration and connectivity.
-
Create SAP BusinessObjects BI-Connected Applications in Appsmith
Connect to SAP BusinessObjects BI Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP BusinessObjects BI.
-
Getting Started with the CData Python Connector for Unbounce
Learn to install and license the CData Python Connector
-
Visualize Box Data in Tableau
The CData ODBC driver for Box enables you integrate Box into Tableau dashboards.
-
Use the CData Software JDBC Driver for Smartsheet in MicroStrategy Web
Connect to Smartsheet in MicroStrategy Web using the CData Software JDBC Driver for Smartsheet.
-
Connect to Sage Intacct Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Sage Intacct Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to MYOB AccountRight Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for MYOB AccountRight in the Denodo Virtual DataPort Administrator.
-
Extend Google Sheets with Salesforce Marketing Data
Make calls to Salesforce Marketing from Google Apps Script via the API Server.
-
Query Paddle Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Paddle from Node.js.
-
Connect to Zuora Data in Claris FileMaker Pro
Use the CData ODBC Driver for Zuora in FileMaker Pro to connect to Zuora and work with Zuora in your FileMaker applications.
-
Working with PostgreSQL Data in LINQPad
Execute LINQ queries to PostgreSQL in LINQPad.
-
Getting Started with the CData SSIS Components for JotForm
Complete guide to installing, licensing, and connecting with the CData SSIS Components for JotForm.
-
Connect to Lakebase Data in DBeaver
Use the CData ODBC Driver to connect to Lakebase in DBeaver.
-
Import Sybase Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Sybase Data and provide access to live Sybase for custom reports in the Power BI Service.
-
Replicate Beeminder Data from PowerShell
Write a quick PowerShell script to query Beeminder. Use connectivity to the live data to replicate Beeminder to SQL Server.
-
Query Shippo Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Shippo from Node.js.
-
Automated Continuous LinkedIn Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable LinkedIn replication to Google Cloud SQL.
-
Integrating OpenCode Terminal with Rebilly 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 Seamlessly Import Everhour Data into IBM SPSS Modeler
Integrate Everhour data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automate ShipStation Data Replication to Couchbase
Use CData Sync to Customize and automate ShipStation replication to Couchbase.
-
Using the CData Software ODBC Driver for ShipEngine in PyCharm
Connect to ShipEngine as an ODBC data source in PyCharm using the CData Software ODBC Driver for ShipEngine.
-
Automated Continuous PayPal Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable PayPal replication to Apache Kafka.
-
Zoho Projects Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Zoho Projects through CData Connect AI using different applications and tools.
-
Visualize Power BI XMLA Data in TIBCO Spotfire through OData
Integrate Power BI XMLA into dashboards in TIBCO Spotfire.
-
Access Pingdom Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Pingdom from your Oracle system.
-
Extend Google Sheets with Quickbase Data
Make calls to Quickbase from Google Apps Script via the API Server.
-
Use Dash to Build Web Apps on MariaDB Data via CData Connect AI
Build interactive Dash web apps on live MariaDB using pandas and the CData Connect AI Python SDK.
-
Access Parquet Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Apache Parquet from your Oracle system.
-
Connect to Bannerbear Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Bannerbear to connect to Bannerbear and execute queries in PowerBuilder.
-
Automated Continuous Dynamics 365 Replication to Databricks
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Databricks.
-
Provide OData Services of Jumpseller Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Jumpseller by developing a WCF Service Application.
-
Visualize Authorize.Net Data in Tableau
The CData ODBC driver for Authorize.Net enables you integrate Authorize.Net into Tableau dashboards.
-
How to Connect to Live Odoo 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 Odoo ERP for you.
-
Create Datasets from Google Cloud Storage in Domo Workbench and Build Visualizations of Google Cloud Storage Data in Domo
Use the CData Software ODBC Driver for Google Cloud Storage to create datasets from Google Cloud Storage in Domo Workbench and then build visualizations in the Domo service.
-
Import SAP ByDesign Data Using Azure Data Factory
Use CData Connect AI to connect to SAP ByDesign Data from Azure Data Factory and import live SAP Business ByDesign.
-
DataBind Controls to SAP ByDesign Data in Delphi
DataBind to SAP Business ByDesign in Delphi with standard data access components and controls.
-
Visualize SurveyMonkey Data in Sisense
Create an ElastiCube in Sisense app with access to SurveyMonkey.
-
Access Live NetSuite Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live NetSuite CRM & ERP through MCP integration.
-
Extract, Transform, and Load Google Contacts Data in Informatica PowerCenter
Create a simple Workflow for Google Contacts in Informatica PowerCenter.
-
Build Data Flows from SQL Server to Sybase through SSIS
Easily push SQL Server data to Sybase using the CData SSIS Tasks for Sybase.
-
Build API-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to API Data from Zoho Analytics and import live API.
-
Integrate ScrapingBee with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ScrapingBee with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ScrapingBee.
-
ETL Teamgate in Oracle Data Integrator
This article shows how to transfer Teamgate into a data warehouse using Oracle Data Integrator.
-
How to Connect to & Open Oracle HCM Cloud Data in Microsoft Excel
This article uses the CData ODBC driver for Oracle HCM Cloud to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for AgileCRM
Provide connectivity to AgileCRM through an SAP BusinessObjects universe.
-
Build Cloudant-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Cloudant to explore live Cloudant Data in Claude Code to assist with building Cloudant-powered applications.
-
Integrating Boomi Agentstudio with CouchDB Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Apache CouchDB, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Planio Replication to SQL Server
Use CData Sync for automated, continuous, customizable Planio replication to SQL Server.
-
Replicate Multiple Recurly Accounts via the CData Sync CLI
Replicate multiple Recurly accounts to one or many databases.
-
Design BIRT Reports on Yelp Data
Provide current Yelp to your embedded analytics.
-
Migrating data from ADP to Databricks using CData SSIS Components.
Easily push ADP to Databricks using the CData SSIS Tasks for ADP and Databricks.
-
Automated Continuous Vault CRM Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Vault CRM replication to AlloyDB.
-
Automated Continuous MongoDB Replication to MySQL
Use CData Sync for automated, continuous, customizable MongoDB replication to MySQL.
-
Connect to Reckon Accounts Hosted 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 Reckon Accounts Hosted.
-
Use the CData Software ODBC Driver for ElevenLabs in SAS for Real-Time Reporting and Analytics
Connect to real-time ElevenLabs in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ElevenLabs.
-
Connect to SAP Business One Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP Business One from HeidiSQL.
-
Migrating data from ZohoExpense to Databricks using CData SSIS Components.
Easily push ZohoExpense to Databricks using the CData SSIS Tasks for ZohoExpense and Databricks.
-
Integrating OpenCode Terminal with GetResponse 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.
-
Automate Salesforce Marketing Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Salesforce Marketing Cloud from PowerShell? This article demonstrates how to utilize the Salesforce Marketing Cmdlets for tasks like connecting to Salesforce Marketing Cloud, automating operations, downloading data, and more.
-
Connect to XML Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for XML to connect to XML Files and execute queries in PowerBuilder.
-
Use the CData ODBC Driver for Opsgenie in Microsoft Power Query
You can use the CData Opsgenie ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Opsgenie into Microsoft Power Query.
-
Connect to Optimizely Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrating Codat Data in Talend Cloud Data Management Platform
Connect Codat Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous SharePoint Excel Services Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to OneLake in Microsoft Fabric.
-
Replicate Delighted Data from PowerShell
Write a quick PowerShell script to query Delighted. Use connectivity to the live data to replicate Delighted to SQL Server.
-
Use the CData Software JDBC Driver for Google Contacts in MicroStrategy
Connect to Google Contacts in MicroStrategy Developer using the CData Software JDBC Driver for Google Contacts.
-
Create Bullhorn CRM-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Bullhorn CRM Data from Klipfolio and build custom visualizations using live Bullhorn CRM.
-
How to Query Live Excel Online Data in Claude Desktop
Connect to and query live Excel Online Data in Claude Desktop using CData MCP Server.
-
How to connect to Recurly Data in DBVisualizer
Integrate Recurly with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Facebook Ads Data in Aqua Data Studio
Access Facebook Ads from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous SAP ByDesign Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP Business ByDesign replication to OneLake in Microsoft Fabric.
-
Integrate with Google Contacts Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Contacts to a JSON file on disk.
-
Integrate LDAP Objects in Pentaho Data Integration
Build ETL pipelines based on LDAP in the Pentaho Data Integration tool.
-
Connect to Browserless Data in HULFT Integrate
Connect to Browserless as a JDBC data source in HULFT Integrate
-
Excel Spreadsheet Automation on ZohoInvoice Data with the QUERY Formula
Pull data from ZohoInvoice, automate spreadsheets, and more with the QUERY formula.
-
Connect to MailChimp Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for MailChimp and the Script function in FileMaker Pro to connect to MailChimp and work with MailChimp in your FileMaker application.
-
Replicate Sentry Data from PowerShell
Write a quick PowerShell script to query Sentry. Use connectivity to the live data to replicate Sentry to SQL Server.
-
Use the CData ODBC Driver for PostgreSQL from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for PostgreSQL to connect to PostgreSQL from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring PostgreSQL in Excel.
-
Automated PivotalTracker Data Replication to Teradata
Use CData Sync to Customize and automate PivotalTracker replication to Teradata.
-
Integrating OpenCode Terminal with Salesloft 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.
-
Access Spark Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Apache Spark SQL from HeidiSQL.