CData Software - Knowledge Base
Recent Articles
-
Build Voice Agents in ElevenLabs with access to Live Neo4J Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Neo4J.
-
Visualize SendGrid Data in Tableau
The CData ODBC driver for SendGrid enables you integrate SendGrid into Tableau dashboards.
-
How to Connect Flowise AI Agents to Live MySQL 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 MySQL without replication.
-
Integrating Codex CLI with Pipeline CRM 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.
-
Getting Started with the CData ODBC Driver for Suadeo
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Suadeo.
-
Create Gong-Connected Nintex Workflows
Use CData Connect AI to connect to Gong Data from Nintex Workflow Cloud and build custom workflows using live Gong.
-
Using the CData Software ODBC Driver for Paymo in PyCharm
Connect to Paymo as an ODBC data source in PyCharm using the CData Software ODBC Driver for Paymo.
-
Visualize SparkPost Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SparkPost.
-
Connect to MarkLogic Data in RapidMiner
Integrate MarkLogic with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Asana Data from a Connection Pool in JBoss
Integrate Asana into Java servlets: Use the Management Console in JBoss to install the Asana JDBC Driver.
-
Use the CData Software ODBC Driver for Printify in MicroStrategy
Connect to Printify in MicroStrategy Developer using the CData Software ODBC Driver for Printify.
-
Connecting GenSpark with HubSpot Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to HubSpot without any replication or custom integration required.
-
Publish Reports with Dynamics 365 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Dynamics 365.
-
Automated Continuous Mailgun Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Mailgun replication to Amazon S3.
-
Access Grafana Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Grafana from HeidiSQL.
-
Consume SAP Fieldglass OData Feeds in PowerBuilder
This article demonstrates how to consume SAP Fieldglass as OData feeds from PowerBuilder using the API Server.
-
Build SAP Hybris C4C Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Hybris C4C and build visualizations in Tableau Cloud.
-
ETL Klaviyo in Oracle Data Integrator
This article shows how to transfer Klaviyo into a data warehouse using Oracle Data Integrator.
-
Access Auth0 Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Auth0 from your Oracle system.
-
How to Build an ETL App for Bullhorn CRM Data in Python with CData
Create ETL applications and real-time data pipelines for Bullhorn CRM in Python with petl.
-
How to connect Amazon QuickSight to Neo4J Data
Create a connection to Neo4J in CData Connect AI and insert Neo4J into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrating LangChain with LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on LinkedIn Ads within automated workflows.
-
How to Connect DBeaver to Humanity via a JDBC Driver
Manage Humanity with visual tools in DBeaver like the query browser.
-
Bridge SAP Connectivity with Apache NiFi
Access and process SAP ERP/NetWeaver in Apache NiFi using the CData JDBC Driver.
-
Deploy the ADO.NET Provider for BigQuery on an SSRS Report Server
Connect to Google BigQuery 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.
-
Import and Visualize JSON Services in Power View
Create data visualizations based on JSON in Excel.
-
Access HCL Domino 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 HCL Domino.
-
Connect to HBase Data in Google Apps Script via Connect AI
Use CData Connect AI to access Apache HBase in Google Apps Script.
-
Automated Continuous Dynamics 365 Business Central Replication to MySQL
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to MySQL.
-
How to Connect to AfterShip Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to AfterShip. Leverage the pyodbc module for ODBC in Python.
-
Stream CircleCI Data into Apache Kafka Topics
Access and stream CircleCI in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Live Klaviyo Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Klaviyo in CData Connect AI and connect to your Klaviyo from PostgreSQL.
-
Use the CData ODBC Driver for Todoist from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Todoist to connect to Todoist from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Todoist in Excel.
-
How to Build an ETL App for Beeminder Data in Python with CData
Create ETL applications and real-time data pipelines for Beeminder in Python with petl.
-
Integrating Auth0 Data in Talend Cloud Data Management Platform
Connect Auth0 Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Publish Reports with CockroachDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date CockroachDB.
-
How to Access Live Drift Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Drift enables you to integrate Drift into workflows built using Microsoft Power Automate Desktop.
-
Integrate Cursor with Live OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Microsoft OneNote from within the editor.
-
ETL SAP Fieldglass in Oracle Data Integrator
This article shows how to transfer SAP Fieldglass into a data warehouse using Oracle Data Integrator.
-
Query, Visualize, and Share live MongoDB Data in Redash
Use CData Connect AI to connect to live MongoDB in Redash for querying, visualizing, and sharing.
-
Analyze SAP ByDesign Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP Business ByDesign and visualize SAP Business ByDesign in SAP Analytics Cloud.
-
How to Connect to & Open Mailjet Data in Microsoft Excel
This article uses the CData ODBC driver for Mailjet to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Import Real-Time Tally Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Tally ERP in ColdFusion.
-
Consume Azure Synapse OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Azure Synapse feeds that reflect any changes in SAP Lumira.
-
Use the CData Software ODBC Driver for Google Calendar in MicroStrategy Web
Connect to Google Calendar in MicroStrategy Web using the CData Software ODBC Driver for Google Calendar.
-
Getting Started with the CData Tableau Connector for Salesloft
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Salesloft.
-
How to Create Power BI Visual Reports with Real-Time Excel Online Data
Use CData Power BI Connectors to visualize Microsoft Excel Online in Power BI.
-
How to Connect to Live Act CRM Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Act CRM without replication.
-
Moving Data from HubDB to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live HubDB data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Visualize Azure Data Lake Storage Data in TIBCO Spotfire through ADO.NET
Integrate Azure Data Lake Storage into dashboards in TIBCO Spotfire.
-
Build Charts with PayPal Data in Clear Analytics
Create dynamic charts and perform analytics based on PayPal in Clear Analytics.
-
Getting Started with the CData Tableau Connector for Databricks
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Databricks.
-
Replicate Multiple Adobe Target Accounts via the CData Sync CLI
Replicate multiple Adobe Target accounts to one or many databases.
-
Connect to Highrise Data in RazorSQL
Connect to Highrise from wizards and query Highrise CRM from the GUI in the RazorSQL database management tool.
-
How to Access Live Active Directory Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Active Directory enables you to integrate Active Directory into workflows built using Microsoft Power Automate Desktop.
-
Create Xero-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Xero Data from Klipfolio and build custom visualizations using live Xero Accounting.
-
Natively Connect to Google Ads Data in PHP
The CData ODBC driver for Google Ads enables you to create PHP applications with connectivity to Google Ads. Leverage the native support for ODBC in PHP.
-
Connect to CouchDB Data in RapidMiner
Integrate Apache CouchDB with standard components and data source configuration wizards in RapidMiner Studio.
-
DataBind Controls to Timely Data in Delphi
DataBind to Timely in Delphi with standard data access components and controls.
-
How to Query Live SAS Data Sets Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAS Data Sets data in natural language using Python.
-
Integrate with live Azure Synapse Data in Jitterbit
Use CData Connect AI to connect to and integrate live Azure Synapse in Jitterbit.
-
Model Microsoft Ads Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Microsoft Ads, enabling the direct import of real-time Microsoft Ads.
-
Excel Add-In: Retrieving Custom Reports Using Define New Table
In this entry, you will define a custom report and expose it as a table using the CData Excel Add-In 'Define New Table' functionality.
-
Connect to and Visualize Live Sage Intacct Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sage Intacct.
-
Automate VWO Data Replication to Azure Synapse
Use CData Sync to customize and automate VWO replication to Azure Synapse.
-
Natively Connect to PingOne Data in PHP
The CData ODBC driver for PingOne enables you to create PHP applications with connectivity to PingOne. Leverage the native support for ODBC in PHP.
-
Import Real-Time Facebook Ads Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Facebook Ads in ColdFusion.
-
Automated Continuous Airtable Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Airtable replication to Apache Cassandra.
-
Replicate Elorus Data to Multiple Databases via the CData Sync CLI
Replicate Elorus to disparate databases with a single configuration.
-
Automated Continuous Eventbrite Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Eventbrite replication to Google Cloud SQL.
-
Analyze ChartMogul Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ChartMogul with the CData JDBC Driver for ChartMogul.
-
Use Dash to Build Web Apps on Procore Data via CData Connect AI
Build interactive Dash web apps on live Procore using pandas and the CData Connect AI Python SDK.
-
Connect to and Visualize Live Spotify Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Spotify.
-
Create Dashboards and Visualize Live Adobe Commerce Data in Geckoboard
Use CData Connect AI to connect to live Adobe Commerce and create dashboards for real-time monitoring and visualization in Geckoboard.
-
A PostgreSQL Interface for JSON Services (MySQL Remoting via JDBC)
Use the Remoting features of the JSON JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Short.io Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Short.io data access from reports, embedded analytics, and more.
-
Establish a Live Connection with Azure Data Catalog Data using Tableau Bridge
The CData ODBC Driver for Azure Data Catalog enables you to integrate live Azure Data Catalog into Tableau Cloud dashboards using the Tableau Bridge.
-
DB2 Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on DB2 facts in real time.
-
Use the CData Software ODBC Driver for SFTP in MicroStrategy Web
Connect to SFTP in MicroStrategy Web using the CData Software ODBC Driver for SFTP.
-
Analyze Templated Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Templated with the CData JDBC Driver for Templated.
-
Connect to Drift Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to HubDB Data in RapidMiner
Integrate HubDB with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Build an ETL App for FTP Data in Python with CData Connect AI
Build ETL pipelines that read and write live FTP Servers in Python with petl and the CData Connect AI Python SDK.
-
Publish FTP-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live FTP Servers.
-
Visualize SharePoint Data in TIBCO Spotfire through ADO.NET
Integrate Microsoft SharePoint into dashboards in TIBCO Spotfire.
-
Easily Integrate Webex Data in Lazarus Pascal IDE
Learn how to easily integrate live Webex in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating Kiro CLI with Redshift 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.
-
Integrate Amazon Athena Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Amazon Athena from Informatica Cloud.
-
Migrating data from Google Search to Google BigQuery using CData SSIS Components.
Easily push Google Search to Google BigQuery using the CData SSIS Tasks for Google Search and Google BigQuery.
-
Query Reckon Accounts Hosted Data as a MySQL Database in Node.js
Execute MySQL queries against Reckon Accounts Hosted from Node.js.
-
How to publish and share Perplexity Data dashboards with Tableau Server
The CData ODBC driver for Perplexity enables you integrate Perplexity into Tableau dashboards.
-
Automate Zoho CRM Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Zoho CRM and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Access Live Greenplum Data in TIBCO Data Virtualization
Use the Greenplum Tibco DV Adapter to create a Pivotal GreenPlum data source in TIBCO Data Virtualization Studio and gain access to live Pivotal GreenPlum from your TDV Server.
-
Use Biml to Build SSIS Tasks to Replicate SAP Ariba Procurement Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Ariba Procurement to SQL Server.
-
Import Box Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Box Data and provide access to live Box for custom reports in the Power BI Service.
-
Viewing SAP Concur Data in RAD Studio Data Explorer
How to view SAP Concur in RAD Studio Data Explorer using the CData ODBC Driver for SAP Concur.
-
Connect to Microsoft Entra ID Data in RazorSQL
Connect to Microsoft Entra ID from wizards and query Microsoft Entra ID from the GUI in the RazorSQL database management tool.
-
Connect to Gong Data in DBArtisan
Use wizards in DBArtisan to configure Gong as a data source.
-
Feed Hacker News Data into FineReport
How to set Hacker News as a JDBC data source in FineReport.
-
Build a PostgreSQL Interface for Accelo Data using the CData JDBC Driver
Use the Remoting features of the Accelo JDBC Driver to create a PostgreSQL entry-point for data access.