CData Software - Knowledge Base
Recent Articles
-
How to Seamlessly Import CampaignMonitor Data into IBM SPSS Modeler
Integrate CampaignMonitor data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access ChartMogul Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ChartMogul data from your Oracle system.
-
Use the CData Software ODBC Driver for Optimizely in MicroStrategy Desktop
Connect to Optimizely data in MicroStrategy Desktop using the CData Software ODBC Driver for Optimizely.
-
Build NetSuite-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live NetSuite data without replication.
-
Build Data Flows from Google Ad Manager to SQL Server using SSIS
Easily back up Google Ad Manager data to SQL Server using the SSIS components for Google Ad Manager.
-
Easily Integrate Yelp Data in Lazarus Pascal IDE
Learn how to easily integrate live Yelp data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
DataBind Controls to Coda Data in Delphi
DataBind to Coda data in Delphi with standard data access components and controls.
-
Moving Data from CapsuleCRM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live CapsuleCRM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Live SAP HANA Data in Excel 365 Online (Excel for the web)
Connect to SAP HANA data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use Manus AI to Talk to Your Anaplan Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Anaplan data.
-
Automated Continuous Calendly Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Calendly replication to Azure SQL Database.
-
Getting Started with the CData Excel Add-In for ChargeOver
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ChargeOver.
-
Connect to Vault CRM Data in Jaspersoft Studio
Execute SQL to remote Vault CRM data in Jaspersoft Studio.
-
Validate TaxJar Data with QuerySurge
Access and validate TaxJar data in QuerySurge using the CData JDBC Driver.
-
Work with Live IBM Cloud Object Storage Data in Power Query
Use CData Connect AI to connect to IBM Cloud Object Storage data and work with live IBM Cloud Object Storage data in Microsoft Power Query.
-
A PostgreSQL Interface for Supabase Data using the CData ODBC Driver
Use the SQL Gateway and Supabase ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to work with Gong Data in Apache Spark using SQL
Access and process Gong Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Mocean Replication to SQLite
Use CData Sync for automated, continuous, customizable Mocean replication to SQLite.
-
Build Charts with Planio Data in Clear Analytics
Create dynamic charts and perform analytics based on Planio data in Clear Analytics.
-
Automated Continuous Strava Replication to MongoDB
Use CData Sync for automated, continuous, customizable Strava replication to MongoDB.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Grafana
Provide connectivity to Grafana data through an SAP BusinessObjects universe.
-
Migrating data from Yelp to Google BigQuery using CData SSIS Components.
Easily push Yelp data to Google BigQuery using the CData SSIS Tasks for Yelp and Google BigQuery.
-
Connect to OneNote Data in JRuby
Create a simple JRuby app with access to live OneNote data.
-
Create a Data Access Object for SAP BusinessObjects BI Data using JDBI
A brief overview of creating a SQL Object API for SAP BusinessObjects BI data in JDBI.
-
How to connect to Avro Data with Squirrel SQL client
Connect to Avro data and execute queries in the Squirrel SQL Client.
-
Access Live SAS Data Sets Data in TIBCO Data Virtualization
Use the SAS Data Sets Tibco DV Adapter to create a SAS Data Sets data data source in TIBCO Data Virtualization Studio and gain access to live SAS Data Sets data from your TDV Server.
-
Query MYOB AccountRight Data as a MySQL Database in Node.js
Execute MySQL queries against MYOB AccountRight data from Node.js.
-
Build AI/ML Models with Live Nethunt Data using Dataiku
Connect Nethunt Data with Dataiku using the CData API Driver for JDBC.
-
Connect to HubSpot Data in Ruby
Connect to HubSpot data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to create Trello federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Trello data in MySQL .
-
Choosing the Best Method to Connect Pingdom to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Pingdom data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Informatica Mappings From/To a JDBC Data Source for Salesloft
Create Salesloft data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Visualizations of Workday Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Workday data in Birst.
-
Automated Continuous PagerDuty Replication to MySQL
Use CData Sync for automated, continuous, customizable PagerDuty replication to MySQL.
-
Automate Spotify Data Replication to Azure Data Lake
Use CData Sync to customize and automate Spotify data replication to Azure Data Lake.
-
Integrate Dify with Live Optimizely Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Optimizely data.
-
Connect to Live QuickBooks Online Data in MicroStrategy through CData Connect AI
Create a live connection to QuickBooks Online Data in CData Connect AI and connect to your QuickBooks Online data from MicroStrategy.
-
How to connect to OData Services from Spring Boot
Connect to OData in a Spring Boot Application using the CData JDBC Driver for OData
-
How to Connect to Live Amazon Athena Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Amazon Athena data for you.
-
Integrating OpenCode with Sendwithus 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 Live Microsoft Exchange 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 Microsoft Exchange data through MCP integration.
-
Publish MessageBird-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live MessageBird data.
-
Automated Cosmos DB Data Replication to Teradata
Use CData Sync to Customize and automate Cosmos DB data replication to Teradata.
-
Replicate Microsoft Ads Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft Ads data to disparate databases with a single configuration.
-
Replicate Multiple MYOB AccountRight Accounts via the CData Sync CLI
Replicate multiple MYOB AccountRight accounts to one or many databases.
-
Natively Connect to Deel Data in PHP
The CData ODBC driver for Deel enables you to create PHP applications with connectivity to Deel data. Leverage the native support for ODBC in PHP.
-
How to Easily Query Smartsheet Data in OpenOffice Base
Connect to Smartsheet data in OpenOffice Base using the CData ODBC Driver for Smartsheet and generate reports with live data insights.
-
Build AI/ML Models with Live Yelp Data using Dataiku
Connect Yelp Data with Dataiku using the CData API Driver for JDBC.
-
Connect to and Query AfterShip Data in QlikView over ODBC
Create data visualizations with AfterShip data in QlikView.
-
Access Live Spotify Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Spotify data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Basecamp Reporting in OBIEE with the Basecamp JDBC Driver
Deploy the Basecamp JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Agents in Relevance AI with Access to Live Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Azure Synapse data within intelligent agent workflows.
-
How to connect to Placid Data with Squirrel SQL client
Connect to Placid data and execute queries in the Squirrel SQL Client.
-
Visualize Live AgileCRM Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live AgileCRM data into custom reports in Power BI.
-
Model, Search, and Visualize Live SendGrid Data in ThoughtSpot
Use CData Connect AI to connect to live SendGrid data for modeling, searching, and visualizing.
-
Access Qualaroo 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 Qualaroo data.
-
ETL Aweber in Oracle Data Integrator
This article shows how to transfer Aweber data into a data warehouse using Oracle Data Integrator.
-
Analyze Workday Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Workday from Power Pivot. You will use the Table Import Wizard to load Workday data. You can visually build the import query or use any SQL supported by the driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Todoist
Create an ODBC connection to Todoist in Informatica and browse and transfer Todoist data.
-
How to Connect to Live Figshare 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 Figshare data through natural language.
-
Connect to Moosend Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Moosend data in Airbyte.
-
Build Visualizations of Apollo Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Apollo data in Birst.
-
Search External Azure Data Catalog Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Azure Data Catalog data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Azure Data Catalog Data objects that you can access from apps and the dashboard.
-
Connect to Accelo Data in HULFT Integrate
Connect to Accelo as a JDBC data source in HULFT Integrate
-
Connect to Databricks Data in Google Apps Script via Connect AI
Use CData Connect AI to access Databricks data in Google Apps Script.
-
Build Apps with Live Shortcut data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Shortcut data into the Adalo platform and build custom mobile and web applications with real-time Shortcut data.
-
Create a Data Access Object for Databricks Data using JDBI
A brief overview of creating a SQL Object API for Databricks data in JDBI.
-
Getting Started with the CData Connect AI Python SDK for DocuSign
Install the CData Connect AI Python SDK to read live DocuSign data with standard DB-API 2.0 Python code.
-
Creating Salesforce Pardot-Connected Applications in Unqork
You can use CData Connect AI to feed Salesforce Pardot data to Unqork and build custom business apps.
-
Getting Started with the CData Tableau Connector for Todoist
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Getting Started with the CData Excel Add-In for Office 365
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Office 365.
-
DataBind Controls to MariaDB Data in C++Builder
DataBind to MariaDB data in C++Builder with standard components and controls.
-
Prepare, Blend, and Analyze Greenplum Data in Alteryx Designer (ODBC)
Build workflows to access live Greenplum data for self-service data analytics.
-
Automated Continuous NASA Replication to AlloyDB
Use CData Sync for automated, continuous, customizable NASA replication to AlloyDB.
-
Access Live Google Ad Manager Data in Excel 365 Online (Excel for the web)
Connect to Google Ad Manager data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Mocean Data from PowerBuilder via ADO.NET
This article demonstrates how to access Mocean data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Sendwithus Data in NetBeans
Connect to Sendwithus data in NetBeans with the data source configuration wizard.
-
Access Live Timely Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Timely data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Power BI XMLA Data from MySQL in Amazon QuickSight
Connect to Power BI XMLA and build visualizations of Power BI XMLA data using a MySQL Connection in Amazon QuickSight.
-
Process & Analyze Short.io Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Short.io Data.
-
Automate Microsoft Planner Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft Planner data replication to Azure Synapse.
-
Build IBM Informix-Connected Apps in Choreo
Use CData Connect AI to connect to IBM Informix Data from Choreo and build custom apps using live IBM Informix data.
-
Work with LinkedIn Ads Data in FoxPro
Load LinkedIn Ads data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Codat Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Codat replication to Apache Cassandra.
-
Connect to SQL Analysis Services Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SQL Analysis Services Data and connect to SQL Analysis Services data in Akorbi Digital RunMyProcess.
-
Query Mocean Data in ColdFusion
Write standard ColdFusion data access code to connect to Mocean data.
-
Access Templated Data from MySQL in PHP
Connect to Templated through the standard MySQL libraries in PHP.
-
Visualize SAP Ariba Procurement Data in TIBCO Spotfire through OData
Integrate SAP Ariba Procurement data into dashboards in TIBCO Spotfire.
-
Connect to Autopilot Data in JRuby
Create a simple JRuby app with access to live Autopilot data.
-
Getting Started with the CData Power BI Connector for Flowlu
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Integrating Dataiku with Odoo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Odoo data.
-
Getting Started with the CData Power BI Connector for AfterShip
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Getting Started with the CData Tableau Connector for Twitter Ads
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Twitter Ads.
-
Getting Started with the CData ADO.NET Provider for Codat
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous Mistral AI Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Mistral AI replication to Google BigQuery.
-
How to create Tally federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Tally data in MySQL .
-
Query Live Oracle Service Cloud Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Oracle Service Cloud data through a conversational interface.
-
Create Reckon Accounts Hosted-Connected Nintex Workflows
Use CData Connect AI to connect to Reckon Accounts Hosted Data from Nintex Workflow Cloud and build custom workflows using live Reckon Accounts Hosted data.
-
Connect to Sybase IQ Data from a Connection Pool in JBoss
Integrate Sybase IQ data into Java servlets: Use the Management Console in JBoss to install the Sybase IQ JDBC Driver.
-
Integrating Cursor with Supabase 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.