CData Software - Knowledge Base
Recent Articles
-
Manage Zoho Books Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Zoho Books.
-
Access Live SQL Analysis Services Data in TIBCO Data Virtualization
Use the SQL Analysis Services Tibco DV Adapter to create a SQL Analysis Services data data source in TIBCO Data Virtualization Studio and gain access to live SQL Analysis Services data from your TDV Server.
-
Analyze Teamwork Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Teamwork from Power Pivot. You will use the Table Import Wizard to load Teamwork data. You can visually build the import query or use any SQL supported by the driver.
-
Use Dash to Build Web Apps on Avalara AvaTax Data via CData Connect AI
Build interactive Dash web apps on live Avalara AvaTax data using pandas and the CData Connect AI Python SDK.
-
Use Agno to Talk to Your Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Vertica data for you.
-
Moving Data from DB2 to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live DB2 data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Query LinkedIn Data as a MySQL Database in Node.js
Execute MySQL queries against LinkedIn data from Node.js.
-
Connect to Vault CRM Data from AWS Glue
Use CData Connect AI to gain access to live Vault CRM data from your AWS Glue jobs.
-
How to Build an ETL App for SAP Ariba Source Data in Python with CData Connect AI
Build ETL pipelines that read and write live SAP Ariba Source data in Python with petl and the CData Connect AI Python SDK.
-
Connect to SAP Concur Data in JRuby
Create a simple JRuby app with access to live SAP Concur data.
-
Connect to Zendesk 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 Zendesk data.
-
Query Act CRM Data in ColdFusion
Write standard ColdFusion data access code to connect to Act CRM data.
-
Deploy the ADO.NET Provider for Optimizely on an SSRS Report Server
Connect to Optimizely data 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.
-
Automate SharePoint Data Replication to Couchbase
Use CData Sync to Customize and automate SharePoint data replication to Couchbase.
-
How to use SQLAlchemy ORM to access iContact Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of iContact data.
-
Build PostgreSQL-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live PostgreSQL data.
-
Connect to AlloyDB Data from a Connection Pool in Jetty
The AlloyDB JDBC Driver supports connection pooling: This article shows how to connect faster to AlloyDB data from Web apps in Jetty.
-
Configure the CData JDBC Driver for Dotmailer in a Connection Pool in Tomcat
Connect to Dotmailer data from a connection pool in Tomcat.
-
How to Connect DBeaver to MySQL via a JDBC Driver
Manage MySQL data with visual tools in DBeaver like the query browser.
-
Interact with Live Oracle Financials Cloud Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Oracle Financials Cloud data.
-
Getting Started with the CData Connect AI Python SDK for Shortcut
Install the CData Connect AI Python SDK to read live Shortcut data with standard DB-API 2.0 Python code.
-
Connect to Authorize.Net Data in HULFT Integrate
Connect to Authorize.Net as a JDBC data source in HULFT Integrate
-
Visualize Live LinkedIn Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live LinkedIn data.
-
Connect to SendPulse Data in Ruby
Connect to SendPulse data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData ODBC Driver for Tavily in Microsoft Power Query
You can use the CData Tavily ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Tavily data into Microsoft Power Query.
-
Build Agents in Relevance AI with Access to Live Suadeo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Suadeo data within intelligent agent workflows.
-
Integrate Lakebase Data in Pentaho Data Integration
Build ETL pipelines based on Lakebase data in the Pentaho Data Integration tool.
-
Feed Adobe Analytics Data into FineReport
How to set Adobe Analytics data as a JDBC data source in FineReport.
-
Import and Visualize Xero Data in Power View
Create data visualizations based on Xero data in Excel.
-
Access Live Microsoft Ads Data in Coginiti Pro
Connect to and query live Microsoft Ads data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use CData Connect AI to Access Google Campaign Manager 360 Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Campaign Manager 360 data in the Power Pivot business intelligence tool.
-
Connect to Google Analytics Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Analytics data.
-
Integrating LangChain with Samanage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Samanage data within automated workflows.
-
Create Informatica Mappings From/To a JDBC Data Source for Sage Intacct
Create Sage Intacct data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Google Contacts-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Contacts data and build Google Contacts-connected web apps with Axios.
-
Connect to Live Adobe Analytics Data in MicroStrategy through CData Connect AI
Create a live connection to Adobe Analytics Data in CData Connect AI and connect to your Adobe Analytics data from MicroStrategy.
-
Access Teamwork Data from MySQL in PHP
Connect to Teamwork through the standard MySQL libraries in PHP.
-
How to Connect to & Open Calendly Data in Microsoft Excel
This article uses the CData ODBC driver for Calendly to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Replicate Raisers Edge NXT Data to Multiple Databases
Replicate Raisers Edge NXT data to disparate databases with a point-and-click configuration.
-
Connect to Datadog from a Connection Pool in WebLogic
Use the CData JDBC Driver for Datadog to connect to Datadog data from Web applications running on WebLogic.
-
Migrating data from Invoiced to Databricks using CData SSIS Components.
Easily push Invoiced data to Databricks using the CData SSIS Tasks for Invoiced and Databricks.
-
Viewing Access Data in RAD Studio Data Explorer
How to view Access data in RAD Studio Data Explorer using the CData ODBC Driver for Access.
-
How to Query Salesforce Data 360 Data in MySQL Workbench
Execute MySQL queries against live Salesforce Data 360 data from MySQL Workbench.
-
Integrate Cursor with Live Tavily Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Tavily data from within the editor.
-
How to integrate Metabase with Twilio Data
Use CData Connect AI to connect to live Twilio data and create an interactive dashboard in Metabase from Twilio data.
-
Connect to Zoho Inventory Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Zoho Inventory Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Visualize Google Spanner Data in TIBCO Spotfire through ADO.NET
Integrate Google Spanner data into dashboards in TIBCO Spotfire.
-
Extract, Transform, and Load Elasticsearch Data in Informatica PowerCenter
Create a simple Workflow for Elasticsearch data in Informatica PowerCenter.
-
Connecting Mastra with AlloyDB 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 AlloyDB data, no replication required.
-
Integrating Antigravity CLI with Qualaroo data via CData CLI
Connect Qualaroo data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
ETL Placid in Oracle Data Integrator
This article shows how to transfer Placid data into a data warehouse using Oracle Data Integrator.
-
Create Power BI Reports on Real-Time AlloyDB Data
Use the CData ODBC Driver for AlloyDB to visualize AlloyDB data in Power BI Desktop.
-
DataBind Controls to Authorize.Net Data in Delphi
DataBind to Authorize.Net data in Delphi with standard data access components and controls.
-
Create Datasets from Omnisend in Domo Workbench and Build Visualizations of Omnisend Data in Domo
Use the CData Software ODBC Driver for Omnisend to create datasets from Omnisend data in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to Google Translate Data from IntelliJ
Integrate connectivity to Google Translate data with wizards in IntelliJ.
-
Automated Continuous Zoho Creator Replication to Vertica
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Vertica.
-
Integrate Cursor with Live LDAP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live LDAP objects from within the editor.
-
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 data 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 data 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 data 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.
-
Create Data Visualizations in Cognos BI with Shopify Data
Access Shopify data 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 Phoenix data to a database.
-
Working with eBay Data in LINQPad
Execute LINQ queries to eBay data 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 data 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 data within intelligent agent workflows.
-
Build a Simple VCL Application for ShipStation Data
How to build a simple VCL Application to view ShipStation data 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 data.
-
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 data.
-
Getting Started with the CData Python Connector for Unbounce
Learn to install and license the CData Python Connector and configure a connection to live Unbounce data.
-
Visualize Box Data in Tableau
The CData ODBC driver for Box enables you integrate Box data into Tableau dashboards.
-
Use the CData Software JDBC Driver for Smartsheet in MicroStrategy Web
Connect to Smartsheet data 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 data in the Denodo Virtual DataPort Administrator.
-
Query Paddle Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Paddle data 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 data in your FileMaker applications.
-
Working with PostgreSQL Data in LINQPad
Execute LINQ queries to PostgreSQL data 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 data 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 data for custom reports in the Power BI Service.
-
Replicate Beeminder Data from PowerShell
Write a quick PowerShell script to query Beeminder data. Use connectivity to the live data to replicate Beeminder data to SQL Server.
-
Query Shippo Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Shippo data 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 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 data replication to Couchbase.
-
Build Automated SuiteCRM-Connected Workflows in Zapier
Use CData Connect AI to connect to live SuiteCRM data and build automated workflows in Zapier.
-
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 data through CData Connect AI using different applications and tools.
-
Visualize Power BI XMLA Data in TIBCO Spotfire through OData
Integrate Power BI XMLA data 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 data from your Oracle system.
-
Use Dash to Build Web Apps on MariaDB Data via CData Connect AI
Build interactive Dash web apps on live MariaDB data using pandas and the CData Connect AI Python SDK.