CData Software - Knowledge Base
Recent Articles
-
Connect to Zoho CRM 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 Zoho CRM data.
-
Integrating LangGraph with Adobe Commerce Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Adobe Commerce data within automated workflows.
-
Publish Reports with iContact Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date iContact data.
-
Automate CapsuleCRM Data Replication to SAP HANA
Use CData Sync to customize and automate CapsuleCRM data replication to SAP HANA.
-
How to create Figshare federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Figshare data in MySQL .
-
How to Query Trello Data in MySQL Workbench
Execute MySQL queries against live Trello data from MySQL Workbench.
-
How to Connect the Power BI Service to AlloyDB: Complete Guide
Connect to the CData Software Power BI Connector for AlloyDB from PowerBI.com to provide real-time AlloyDB data across the organization.
-
Automated Continuous Elasticsearch Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Elasticsearch replication to Google Cloud SQL.
-
Connect to WordPress Data in Google Apps Script via Connect AI
Use CData Connect AI to access WordPress data in Google Apps Script.
-
Integrate Live Freshdesk Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Freshdesk data to Blue Prism using the CData ODBC Driver for Freshdesk to create automated workflows for repetitive business tasks.
-
Connecting Moonlit Workflow with ZohoMarketingHub Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your ZohoMarketingHub data in real time.
-
How to connect to Adobe Commerce Data with Squirrel SQL client
Connect to Adobe Commerce data and execute queries in the Squirrel SQL Client.
-
Access Confluence Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Confluence data from HeidiSQL.
-
Getting Started with the CData Connect AI Python SDK for Jira Assets
Install the CData Connect AI Python SDK to read and write live Jira Assets data with standard DB-API 2.0 Python code.
-
Rapidly Develop Aircall-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Aircall.
-
Replicate Landbot Data in Heroku for Use in Salesforce Connect
Replicate Landbot data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Replicate Microsoft Dataverse Data from PowerShell
Write a quick PowerShell script to query Microsoft Dataverse data. Use connectivity to the live data to replicate Microsoft Dataverse data to SQL Server.
-
DataBind Charts to OnePageCrm Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to OnePageCrm data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Use the CData Software ODBC Driver for Wistia in MicroStrategy
Connect to Wistia data in MicroStrategy Developer using the CData Software ODBC Driver for Wistia.
-
How to integrate Rebilly with Apache Airflow
Access and process Rebilly data in Apache Airflow using the CData JDBC Driver.
-
Create Power BI Reports on Real-Time Float Data
Use the CData ODBC Driver for Float to visualize Float data in Power BI Desktop.
-
Integrating Cursor with Gong 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 SpaceX Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SpaceX replication to Azure SQL Database.
-
View Reports on Real-Time GetResponse Data in Power BI Report Server
Use the CData ODBC Driver for GetResponse to visualize GetResponse data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect to Live Dynamics CRM 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 Dynamics CRM data for you.
-
Stream ElevenLabs Data into Apache Kafka Topics
Access and stream ElevenLabs data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Getting Started with the CData Excel Add-In for Airtable
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Airtable.
-
Model LinkedIn Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and LinkedIn, enabling the direct import of real-time LinkedIn data.
-
Integrating Claude Code CLI with Instantly 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.
-
Visualize Live LinkedIn Data in the Power BI Service
Use CData Connect AI to connect to live LinkedIn data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Planio Data to Multiple Databases via the CData Sync CLI
Replicate Planio data to disparate databases with a single configuration.
-
Visualize Live Shippo Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Shippo data into custom reports in Power BI.
-
Integrate Google's Antigravity Agent with Live ZohoPeople Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live ZohoPeople data using the Model Context Protocol.
-
Bidirectional Access to Paylocity Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Paylocity data in Filemaker Pro for Mac or Windows.
-
Access Live Sendwithus Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Sendwithus data from your Excel spreadsheets.
-
Getting Started with the CData JDBC Driver for Tickspot
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Tickspot.
-
Automated Continuous Google Ad Manager Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to IBM DB2.
-
Automated Continuous HelloSign Replication to SQL Server
Use CData Sync for automated, continuous, customizable HelloSign replication to SQL Server.
-
Automated Continuous Klaviyo Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Klaviyo replication to Amazon S3.
-
Connect to Chargebee Data in NetBeans
Connect to Chargebee data in NetBeans with the data source configuration wizard.
-
Connect to Pinecone Data in DBArtisan
Use wizards in DBArtisan to configure Pinecone data as a data source.
-
How to Query Qualaroo Data in MySQL Workbench
Execute MySQL queries against live Qualaroo data from MySQL Workbench.
-
Publish HelloSign-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live HelloSign data.
-
Create Power BI Reports on Real-Time Power BI XMLA Data
Use the CData ODBC Driver for Power BI XMLA to visualize Power BI XMLA data in Power BI Desktop.
-
Connect to Datadog Data from a Connection Pool in Jetty
The Datadog JDBC Driver supports connection pooling: This article shows how to connect faster to Datadog data from Web apps in Jetty.
-
Build Apps with Live Freshsales Data Using the Low-Code Development Platform of Mendix
Connect Freshsales data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Gong Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Gong data in the Denodo Virtual DataPort Administrator.
-
How to Connect Flowise AI Agents to Live Oracle Sales 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 Oracle Sales data without replication.
-
Connect to Contentful from a Connection Pool in WebLogic
Use the CData JDBC Driver for Contentful to connect to Contentful data from Web applications running on WebLogic.
-
Integrating Antigravity CLI with Humanity data via CData CLI
Connect Humanity data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to and Visualize Live Unbounce Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Unbounce data.
-
Integrate with live AgileCRM Data in Jitterbit
Use CData Connect AI to connect to and integrate live AgileCRM data in Jitterbit.
-
Integrating LangChain with CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on CockroachDB data within automated workflows.
-
How to Work with Intercom Data in AWS Glue Jobs Using JDBC
Connect to Intercom from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect to Live SAP HANA XS Advanced 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 SAP HANA XS Advanced data for you.
-
Import Real-Time Salesforce Data 360 Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Salesforce Data 360 data in ColdFusion.
-
Access FHIR 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 FHIR data.
-
Getting Started with the CData Tableau Connector for Postmark
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Analyze Microsoft Teams Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft Teams data with the CData JDBC Driver for Microsoft Teams.
-
Prepare, Blend, and Analyze Monday.com Data in Alteryx Designer (ODBC)
Build workflows to access live Monday.com data for self-service data analytics.
-
How to Visualize SAP HANA Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP HANA data in Python.
-
Bridge SharePoint Connectivity with Apache NiFi
Access and process SharePoint data in Apache NiFi using the CData JDBC Driver.
-
Moving Data from LightSpeedRetail to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live LightSpeedRetail data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access ConvertKit Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ConvertKit data from your Oracle system.
-
Create Reports from Highrise Data in Looker Studio
Use CData Connect AI to gain access to live Highrise data and create custom reports in Looker Studio.
-
Build Pipelines with Live Azure Synapse Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Azure Synapse from Google Cloud Data Fusion, enabling the integration of live Azure Synapse data into the building and management of effective data pipelines.
-
Automated Continuous API Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable API replication to delimited files (CSV/TSV).
-
Build Stripe-Connected Apps in Choreo
Use CData Connect AI to connect to Stripe Data from Choreo and build custom apps using live Stripe data.
-
Connect to IBM Informix Data in Ruby
Connect to IBM Informix data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect and Query Live Sugar CRM Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Sugar CRM data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to Invoiced Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Invoiced as an External Source in Dremio.
-
How to connect to Cosmos DB Data from Spring Boot
Connect to Cosmos DB in a Spring Boot Application using the CData JDBC Driver for Cosmos DB
-
Visualize Mistral AI Data in Tableau
The CData ODBC driver for Mistral AI enables you integrate Mistral AI data into Tableau dashboards.
-
Trigger Cassandra IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Cassandra with standard wizards in Logic Apps.
-
How to import SAP Ariba Procurement Data into Apache Solr
Use the CData Software JDBC Driver for SAP Ariba Procurement in Data Import Handler and create an automated import of SAP Ariba Procurement data to Apache Solr Enterprise Search platform.
-
How to connect PolyBase to Exact Online
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Exact Online data.
-
Use the CData ODBC Driver for Salesforce from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Salesforce to connect to Salesforce data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Salesforce data in Excel.
-
Feed xBase Data into FineReport
How to set xBase data as a JDBC data source in FineReport.
-
Use Claude to Talk to Your Aweber Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Aweber data for you.
-
How to integrate Metabase with Highrise Data
Use CData Connect AI to connect to live Highrise data and create an interactive dashboard in Metabase from Highrise data.
-
How to connect to ServiceNow Data from Spring Boot
Connect to ServiceNow in a Spring Boot Application using the CData JDBC Driver for ServiceNow
-
Use the CData Software JDBC Driver for Pushbullet in MicroStrategy Web
Connect to Pushbullet data in MicroStrategy Web using the CData Software JDBC Driver for Pushbullet.
-
Import Cassandra Data Using Azure Data Factory
Use CData Connect AI to connect to Cassandra Data from Azure Data Factory and import live Cassandra data.
-
Create Dynamic SQL Analysis Services Grids Using the Infragistics XamDataGrid
Learn how you can connect SQL Analysis Services to Infragistics XamDataGrid to build dynamic grids.
-
Model Authorize.Net Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Authorize.Net, enabling the direct import of real-time Authorize.Net data.
-
Analyze Dynamics 365 Business Central Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Dynamics 365 Business Central data and visualize Dynamics 365 Business Central data in SAP Analytics Cloud.
-
How to connect PolyBase to WordPress
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live WordPress data.
-
Visualize Guru Data in TIBCO Spotfire through ADO.NET
Integrate Guru data into dashboards in TIBCO Spotfire.
-
Viewing RabbitMQ Data in RAD Studio Data Explorer
How to view RabbitMQ data in RAD Studio Data Explorer using the CData ODBC Driver for RabbitMQ.
-
Easily Integrate Notion Data in Lazarus Pascal IDE
Learn how to easily integrate live Notion data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Extract, Transform, and Load SpaceX Data in Informatica PowerCenter
Create a simple Workflow for SpaceX data in Informatica PowerCenter.
-
Use the CData Software JDBC Driver for Kafka in MicroStrategy Web
Connect to Kafka data in MicroStrategy Web using the CData Software JDBC Driver for Kafka.
-
Integrating Cursor with Dynamics CRM 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 connect to Kintone Data from IntelliJ
Integrate connectivity to Kintone data with wizards in IntelliJ.
-
View Reports on Real-Time ADP Data in Power BI Report Server
Use the CData ODBC Driver for ADP to visualize ADP data in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData JDBC Driver for Microsoft Exchange
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Microsoft Exchange.
-
Automated Continuous Cohere Replication to Snowflake
Use CData Sync for automated, continuous, customizable Cohere replication to Snowflake.
-
Connect to ServiceDesk Plus Data from a Connection Pool in JBoss
Integrate ServiceDesk Plus data into Java servlets: Use the Management Console in JBoss to install the ServiceDesk Plus JDBC Driver.
-
Choosing the Best Method to Connect Onfleet to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Onfleet data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Presto Data from a Connection Pool in Jetty
The Presto JDBC Driver supports connection pooling: This article shows how to connect faster to Presto data from Web apps in Jetty.