CData Software - Knowledge Base
Recent Articles
-
Migrating data from Workday to Databricks using CData SSIS Components.
Easily push Workday to Databricks using the CData SSIS Tasks for Workday and Databricks.
-
Use the CData Software JDBC Driver for PabblySubscriptions in MicroStrategy Web
Connect to PabblySubscriptions in MicroStrategy Web using the CData Software JDBC Driver for PabblySubscriptions.
-
Build SAP HANA Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP HANA and build visualizations in Tableau.
-
Build Apps with Live Sentry Data Using the Low-Code Development Platform of Mendix
Connect Sentry with Mendix to build apps using the CData API Driver for JDBC.
-
Visualize YouTube Analytics Data in Tableau
The CData ODBC driver for YouTube Analytics enables you integrate YouTube Analytics into Tableau dashboards.
-
Visualize PingOne Data in Tableau
The CData ODBC driver for PingOne enables you integrate PingOne into Tableau dashboards.
-
Getting Started with the CData Excel Add-In for Certinia
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Certinia.
-
Automated Continuous PivotalTracker Replication to MySQL
Use CData Sync for automated, continuous, customizable PivotalTracker replication to MySQL.
-
Build a Simple VCL Application for Opsgenie Data
How to build a simple VCL Application to view Opsgenie in RAD Studio using the CData ODBC Driver for Opsgenie.
-
How to Build an ETL App for BigQuery Data in Python with CData
Create ETL applications and real-time data pipelines for Google BigQuery in Python with petl.
-
Connect to Confluence Data in Aqua Data Studio
Access Atlassian Confluence from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Mocean Data in NetBeans
Connect to Mocean in NetBeans with the data source configuration wizard.
-
Query Tally Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Tally ERP from Node.js.
-
Automated Continuous Procore Replication to SQL Server
Use CData Sync for automated, continuous, customizable Procore replication to SQL Server.
-
Edit and Search Adobe Analytics External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Adobe Analytics to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Adobe Analytics objects that you can access from apps and the dashboard.
-
How to Query Hugging Face Data in MySQL Workbench
Execute MySQL queries against live Hugging Face from MySQL Workbench.
-
How to Connect to Live Greenplum 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 Pivotal GreenPlum for you.
-
Create Discord Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Discord data access from reports, embedded analytics, and more.
-
Manage SAP HANA Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP HANA.
-
Integrating Kiro CLI with Zuora 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.
-
Replicate Azure Synapse Data to Multiple Databases via the CData Sync CLI
Replicate Azure Synapse to disparate databases with a single configuration.
-
How to Seamlessly Import Vercel Data into IBM SPSS Modeler
Integrate Vercel data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Lakebase
Provide connectivity to Lakebase through an SAP BusinessObjects universe.
-
Create Data Visualizations in Cognos BI with Microsoft OneDrive Data
Access Microsoft OneDrive as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Gumloop with Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Smartsheet within automated workflows.
-
Build Dashboards with Vercel Data in Dundas BI
Create dynamic dashboards and perform analytics based on Vercel in Dundas BI.
-
Access MYOB AccountRight 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 MYOB AccountRight.
-
ETL ZohoSubscriptions in Oracle Data Integrator
This article shows how to transfer ZohoSubscriptions into a data warehouse using Oracle Data Integrator.
-
Import Real-Time AlloyDB Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google AlloyDB in ColdFusion.
-
Easily Integrate NetSuite Data in Lazarus Pascal IDE
Learn how to easily integrate live NetSuite CRM & ERP in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to LinkedIn Data from AWS Glue
Use CData Connect AI to gain access to live LinkedIn from your AWS Glue jobs.
-
Getting Started with the CData ODBC Driver for Google Tasks
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Tasks.
-
Publish Sage 200-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Sage 200.
-
Automated Continuous Excel Online Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Excel Online replication to Apache Cassandra.
-
How to integrate Sage 200 with Apache Airflow
Access and process Sage 200 in Apache Airflow using the CData JDBC Driver.
-
Build Agents in Relevance AI with Access to Live Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Trello within intelligent agent workflows.
-
Manage Reply.io Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Reply.io.
-
Visualize SAP Ariba Source Data in TIBCO Spotfire through OData
Integrate SAP Ariba Source into dashboards in TIBCO Spotfire.
-
Connect JobNimbus to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect JobNimbus with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData ODBC Driver for Snapchat Ads in Microsoft Power Query
You can use the CData Snapchat Ads ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Snapchat Ads into Microsoft Power Query.
-
Enable the Google Spanner JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Spanner.
-
Configure the CData JDBC Driver for SendInBlue in a Connection Pool in Tomcat
Connect to SendInBlue from a connection pool in Tomcat.
-
BambooHR Reporting in OBIEE with the BambooHR JDBC Driver
Deploy the BambooHR JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Auth0 from Asprova with CData Software ODBC Driver for Auth0
This article shows how to connect faster to Auth0 data from Asprova.
-
Integrate SAP BusinessObjects BI Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP BusinessObjects BI from Informatica Cloud.
-
Query Parallel Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Parallel from Node.js.
-
A PostgreSQL Interface for ServiceNow Data using the CData ODBC Driver
Use the SQL Gateway and ServiceNow ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to SAP Hybris C4C Data from Spring Boot
Connect to SAP Hybris C4C in a Spring Boot Application using the CData JDBC Driver for SAP Hybris C4C
-
Integrate Live Workday Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to Build an ETL App for Google Calendar Data in Python with CData
Create ETL applications and real-time data pipelines for Google Calendar in Python with petl.
-
How to connect to Google Translate Data with Squirrel SQL client
Connect to Google Translate and execute queries in the Squirrel SQL Client.
-
Use Agno to Talk to Your MailChimp 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 MailChimp for you.
-
Connect to Clari Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Clari to connect to Clari and execute queries in PowerBuilder.
-
How to connect Amazon QuickSight to HBase Data
Create a connection to Apache HBase in CData Connect AI and insert Apache HBase into Amazon QuickSight SPICE to build interactive dashboards.
-
A PostgreSQL Interface for Spotify Data (MySQL Remoting via JDBC)
Use the Remoting features of the Spotify JDBC Driver to create a PostgreSQL entry-point for data access.
-
Easily Integrate Ontraport Data in Lazarus Pascal IDE
Learn how to easily integrate live Ontraport in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use CData Connect AI to Access Azure Data Lake Storage Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Azure Data Lake Storage in the Power Pivot business intelligence tool.
-
View Reports on Real-Time ServiceDesk Plus Data in Power BI Report Server
Use the CData ODBC Driver for ServiceDesk Plus to visualize ServiceDesk Plus in Power BI Desktop and then publish them to Power BI Report Server.
-
Connecting Mastra with Dynamics CRM 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 Microsoft Dynamics CRM, no replication required.
-
Build Semantic Layer Views for Sage Cloud Accounting Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Sage Business Cloud Accounting.
-
Integrating OpenCode Terminal with NetSuite 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.
-
Use the CData Software ODBC Driver for VWO in MicroStrategy Desktop
Connect to VWO in MicroStrategy Desktop using the CData Software ODBC Driver for VWO.
-
ChartMogul Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ChartMogul facts in real time.
-
Connect to Guru Data from PowerBuilder via ADO.NET
This article demonstrates how to access Guru from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Microsoft Exchange Data in Aqua Data Studio
Access Microsoft Exchange from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Getting Started with the CData Power BI Connector for Apollo
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Guru Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Guru in the Denodo Virtual DataPort Administrator.
-
Create Data Visualizations in Cognos BI with Pingdom Data
Access Pingdom as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Using the CData Software ODBC Driver for JSON in PyCharm
Connect to JSON as an ODBC data source in PyCharm using the CData Software ODBC Driver for JSON.
-
Connect LaunchDarkly to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect LaunchDarkly with IBM WebSphere for seamless data integration and connectivity.
-
Getting Started with the CData Connect AI Python SDK for NetSuite
Install the CData Connect AI Python SDK to read and write live NetSuite CRM & ERP with standard DB-API 2.0 Python code.
-
Connect Superchat Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Superchat using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Google Tasks Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Tasks data access from reports, embedded analytics, and more.
-
Build Apps with Live Dynamics 365 Data Using the Low-Code Development Platform of Mendix
Connect Microsoft Dynamics 365 with Mendix to build apps using the CData JDBC Driver for Dynamics 365.
-
Build Microsoft Dataverse-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft Dataverse (CDS) and build Microsoft Dataverse-connected web apps with Axios.
-
How to Connect the Power BI Service to Elorus: Complete Guide
Connect to the CData Software Power BI Connector for Elorus from PowerBI.com to provide real-time Elorus across the organization.
-
How to Work with Foursquare Data in ETL Validator JDBC
Connect to Foursquare from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Discourse Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Discourse from Informatica Cloud.
-
Build Dashboards with SendInBlue Data in DBxtra
Create dynamic dashboards and perform analytics based on SendInBlue in DBxtra.
-
Integrating Cursor CLI with Authorize.Net 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.
-
Automated Continuous Helpscout Replication to Databricks
Use CData Sync for automated, continuous, customizable Helpscout replication to Databricks.
-
Build Data Flows from SQL Server to LDAP through SSIS
Easily push SQL Server data to LDAP using the CData SSIS Tasks for LDAP.
-
Use Dash to Build to Web Apps on Calendly Data
Create Python applications that use pandas and Dash to build Calendly-connected web apps.
-
Connect to SAP ByDesign Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP Business ByDesign from Appeon PowerBuilder using the CData ADO.NET Provider for SAP ByDesign.
-
Automated Continuous WordPress Replication to SQL Server
Use CData Sync for automated, continuous, customizable WordPress replication to SQL Server.
-
Establish a Live Connection with Coda Data using Tableau Bridge
The CData ODBC Driver for Coda enables you to integrate live Coda into Tableau Cloud dashboards using the Tableau Bridge.
-
Build SAP Concur-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SAP Concur and build SAP Concur-connected web apps with Axios.
-
Automated BambooHR Data Replication to Teradata
Use CData Sync to Customize and automate BambooHR replication to Teradata.
-
Build AI/ML Models with Live SendInBlue Data using Dataiku
Connect SendInBlue Data with Dataiku using the CData API Driver for JDBC.
-
Edit and Search SharePoint External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Microsoft SharePoint to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SharePoint objects that you can access from apps and the dashboard.
-
Access Freshteam Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Freshteam from HeidiSQL.
-
Build Data Flows from PivotalTracker to SQL Server using SSIS
Easily back up PivotalTracker to SQL Server using the SSIS components for PivotalTracker.
-
Back Up xBase to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for xBase. In this article, we will employ an SSIS workflow to populate a database with xBase data.
-
How to Connect to Live MailChimp 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 MailChimp through natural language.
-
How to Access Live WordPress Data in Visual Studio Code via Cline
Run CData MCP Server for WordPress on Windows Subsytem for Linux (WSL) and connect to live WordPress from the Cline extension in Visual Studio Code.
-
DataBind Controls to Shortcut Data in C++Builder
DataBind to Shortcut in C++Builder with standard components and controls.
-
Build an OLAP Cube in SSAS from Paymo Data
Establish a connection to Paymo data from SQL Server Analysis Services, and use the Paymo Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Zoho CRM in SpagoBI
Create reports featuring live Zoho CRM in SpagoBI Studio. Host Zoho CRM reports on SpagoBI Server.
-
Connect to Live SAP SuccessFactors LMS Data in MicroStrategy through CData Connect AI
Create a live connection to SAP SuccessFactors LMS Data in CData Connect AI and connect to your SAP SuccessFactors LMS from MicroStrategy.
-
How to load IBM Cloud Object Storage data into Elasticsearch via Logstash
Introducing a simple method to load IBM Cloud Object Storage data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.