CData Software - Knowledge Base
Recent Articles
-
Analyze MailChimp Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of MailChimp and visualize live MailChimp in Infragistics Reveal.
-
Establish a Live Connection with Apify Data using Tableau Bridge
The CData ODBC Driver for Apify enables you to integrate live Apify into Tableau Cloud dashboards using the Tableau Bridge.
-
Use JayDeBeApi to access MailerLite Data in Python
Use standard Python scripting and the development environment of your choice to access live MailerLite.
-
How to Connect to Google Sheets Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Sheets. Leverage the pyodbc module for ODBC in Python.
-
Process & Analyze Omnisend Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Omnisend Data.
-
Automated Continuous Wistia Replication to Vertica
Use CData Sync for automated, continuous, customizable Wistia replication to Vertica.
-
Automated ActiveCampaign Data Replication to Teradata
Use CData Sync to Customize and automate ActiveCampaign replication to Teradata.
-
Analyze Pipeline CRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Pipeline CRM from Power Pivot. You will use the Table Import Wizard to load Pipeline CRM. You can visually build the import query or use any SQL supported by the driver.
-
REST Easy with CData Drivers
Our Drivers offer unmatched utility in connecting to and integrating with REST resources as databases.
-
Replicate Multiple HCL Domino Accounts via the CData Sync CLI
Replicate multiple HCL Domino accounts to one or many databases.
-
Integrating Kiro CLI with Google Campaign Manager 360 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 integrate Metabase with JSON Services
Use CData Connect AI to connect to live JSON and create an interactive dashboard in Metabase from JSON.
-
Use the CData Software JDBC Driver for Confluence in MicroStrategy Web
Connect to Atlassian Confluence in MicroStrategy Web using the CData Software JDBC Driver for Confluence.
-
Connect to FHIR from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from FHIR, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData Power BI Connector for SharePoint Excel Services
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SharePoint Excel Services.
-
Connect to IBM Cloud Object Storage Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for IBM Cloud Object Storage and the SQL Gateway to access IBM Cloud Object Storage from Google Apps Script.
-
Build Voice Agents in ElevenLabs with access to Live YouTube Analytics Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live YouTube Analytics.
-
How to Access Live DocuSign Data in Visual Studio Code via Cline
Run CData MCP Server for DocuSign on Windows Subsytem for Linux (WSL) and connect to live DocuSign from the Cline extension in Visual Studio Code.
-
Getting Started with the CData Connect AI Python SDK for Impala
Install the CData Connect AI Python SDK to read and write live Apache Impala with standard DB-API 2.0 Python code.
-
Use Agno to Talk to Your Zoho Books 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 Zoho Books for you.
-
Connect to Paylocity Data in RazorSQL
Connect to Paylocity from wizards and query Paylocity from the GUI in the RazorSQL database management tool.
-
Working with Yelp Data in LINQPad
Execute LINQ queries to Yelp in LINQPad.
-
Analyze Box Data in Looker
Use CData Connect AI to connect to Box Data from Looker and build custom apps using live Box.
-
Configure the CData JDBC Driver for Zendesk in a Connection Pool in Tomcat
Connect to Zendesk from a connection pool in Tomcat.
-
Build Automated Workflows with Live Trello Data in Workato
Use CData Connect AI to connect to live Trello and build automated workflows in Workato.
-
Load CouchDB Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Apache CouchDB to a database.
-
Connecting GenSpark with Paylocity Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Paylocity without any replication or custom integration required.
-
Connect to Toggl Data in Ruby
Connect to Toggl in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous HBase Replication to Snowflake
Use CData Sync for automated, continuous, customizable HBase replication to Snowflake.
-
Integrating Antigravity CLI with YouTube Analytics via CData CLI
Connect YouTube Analytics to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Copper Data from PowerBuilder via ADO.NET
This article demonstrates how to access Copper from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use Dash to Build to Web Apps on Marketo Data
Create Python applications that use pandas and Dash to build Marketo-connected web apps.
-
Integrate Cline with Live Square Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Square from within your IDE.
-
Connect to and Query SendGrid Data in QlikView over ODBC
Create data visualizations with SendGrid in QlikView.
-
Connect to Bullhorn CRM Data from PowerBuilder via JDBC
This article demonstrates how to access Bullhorn CRM from PowerBuilder using the Bullhorn CRM JDBC Driver.
-
Integrate Live Freshdesk Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Freshdesk from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Freshdesk.
-
Access Live LinkedIn Data in Coginiti Pro
Connect to and query live LinkedIn from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate with Live Outreach.io Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Outreach.io from the MuleSoft Anypoint Platform to integrate live Outreach.io into custom reports and dashboards.
-
How to Use a Microsoft Access Database to Update Wave Financial Data in Real Time
Update Wave Financial data by creating a linked table in Microsoft Access with the CData Wave Financial ODBC Driver.
-
How to Build an ETL App for Sage 200 Data in Python with CData Connect AI
Build ETL pipelines that read and write live Sage 200 in Python with petl and the CData Connect AI Python SDK.
-
Connect to Xero Data from HeidiSQL
Use CData Connect AI to connect to and query live Xero Accounting from HeidiSQL.
-
Visualize SurveyMonkey Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SurveyMonkey.
-
Oracle Eloqua Reporting Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Oracle Eloqua Reporting facts in real time.
-
Establish a Live Connection with ConvertKit Data using Tableau Bridge
The CData ODBC Driver for ConvertKit enables you to integrate live ConvertKit into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Everhour Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Everhour replication to OneLake in Microsoft Fabric.
-
Integrating Antigravity CLI with Cvent via CData CLI
Connect Cvent to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Factorial Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Factorial using standard SQL.
-
Build Apps with Live MailChimp Data Using the Low-Code Development Platform of Mendix
Connect MailChimp with Mendix to build apps using the CData JDBC Driver for MailChimp.
-
Automate ChargeOver Data Replication to SAP HANA
Use CData Sync to customize and automate ChargeOver replication to SAP HANA.
-
Connect to and Visualize Live SendInBlue Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SendInBlue.
-
LINQ to Zoho CRM Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Zoho CRM Data Provider.
-
Connect to HubDB Data from a Connection Pool in Jetty
The HubDB JDBC Driver supports connection pooling: This article shows how to connect faster to HubDB from Web apps in Jetty.
-
How to connect Amazon QuickSight to Microsoft Ads Data
Create a connection to Microsoft Ads in CData Connect AI and insert Microsoft Ads into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Connect to Live Google Search Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google Search securely in real time.
-
Build Paylocity-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Paylocity.
-
Extract, Transform, and Load Email Data in Informatica PowerCenter
Create a simple Workflow for Email in Informatica PowerCenter.
-
Use the CData API Server to Access WooCommerce Data in Microsoft PowerPivot
Use the CData API Server to connect to live WooCommerce in the Power Pivot business intelligence tool.
-
Use JayDeBeApi to access Optimizely Data in Python
Use standard Python scripting and the development environment of your choice to access live Optimizely.
-
How to Build an ETL App for Box Data in Python with CData
Create ETL applications and real-time data pipelines for Box in Python with petl.
-
Connect to RabbitMQ Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for RabbitMQ to connect to RabbitMQ and execute queries in PowerBuilder.
-
Create Apps from PostgreSQL Data in Qlik Sense Cloud
Use CData Connect AI to connect to PostgreSQL Data and build apps from live PostgreSQL in Qlik Sense Cloud.
-
Access Live SAP Netweaver Gateway Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live SAP Netweaver Gateway through MCP integration.
-
Integrating LlamaIndex with Zoho Creator Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Zoho Creator in real time.
-
Using the CData Software ODBC Driver for Lakebase in PyCharm
Connect to Lakebase as an ODBC data source in PyCharm using the CData Software ODBC Driver for Lakebase.
-
Build Acumatica-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Acumatica to explore live Acumatica Data in GitHub Copilot to assist with building Acumatica-powered applications.
-
How to Visualize Vault CRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live Veeva Vault & Vault CRM in Python.
-
Explore Geographical Relationships in Oracle SCM Data with Power Map
Create data visualizations with Oracle SCM in Power Map.
-
Automated Continuous xBase Replication to SingleStore
Use CData Sync for automated, continuous, customizable xBase replication to SingleStore.
-
Stream Billsby Data into Apache Kafka Topics
Access and stream Billsby in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Replicate Multiple Mouseflow Accounts via the CData Sync CLI
Replicate multiple Mouseflow accounts to one or many databases.
-
Use the CData Software ODBC Driver for Jodoo in SAS for Real-Time Reporting and Analytics
Connect to real-time Jodoo in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Jodoo.
-
Import Real-Time Salesforce Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Salesforce & Force.com in ColdFusion.
-
Use Databricks Agent Bricks to Talk to Your Gmail Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Gmail for you.
-
Create Dynamic Teradata Grids Using the Infragistics XamDataGrid
Learn how you can connect Teradata to Infragistics XamDataGrid to build dynamic grids.
-
Bidirectional Access to Microsoft Dataverse Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Dataverse (CDS) in Filemaker Pro for Mac or Windows.
-
How to Query Live Customer.io Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Customer.io data in natural language using Python.
-
Access Procore Data from MySQL in PHP
Connect to Procore through the standard MySQL libraries in PHP.
-
Build a PostgreSQL Interface for Zendesk Data using the CData JDBC Driver
Use the Remoting features of the Zendesk JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Front-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Front and build web apps with connectivity to live Front.
-
Automated Continuous Highrise Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Highrise replication to Apache Cassandra.
-
How to import Azure Data Catalog Data into Apache Solr
Use the CData Software JDBC Driver for Azure Data Catalog in Data Import Handler and create an automated import of Azure Data Catalog to Apache Solr Enterprise Search platform.
-
How to Connect to Live LinkedIn Ads 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 LinkedIn Ads for you.
-
Getting Started with the CData Excel Add-In for Google Translate
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Translate.
-
Bidirectional Access to Customer.io Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Customer.io in Filemaker Pro for Mac or Windows.
-
Access Instantly 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 Instantly.
-
How to Connect to Live SAP Netweaver Gateway 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 SAP Netweaver Gateway for you.
-
Connect to NetSuite SuiteAnalytics Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live NetSuite SuiteAnalytics.
-
Create NetSuite SuiteAnalytics-Connected Dashboards in Grafana
Connect to NetSuite SuiteAnalytics Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to NetSuite SuiteAnalytics.
-
Replicate Multiple Greenplum Accounts
Replicate multiple Greenplum accounts to one or many databases.
-
Automated SageHR Data Replication to Teradata
Use CData Sync to Customize and automate SageHR replication to Teradata.
-
Build PingOne-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live PingOne.
-
Edit and Search External Dynamics CRM Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft Dynamics CRM to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Dynamics CRM Data objects that you can access from apps and the dashboard.
-
Use Dash to Build to Web Apps on Retently Data
Create Python applications that use pandas and Dash to build Retently-connected web apps.
-
Connect Grafana Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Grafana using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to and Query Kintone Data in QlikView over ODBC
Create data visualizations with Kintone in QlikView.
-
How to Connect to Live SAP Ariba Procurement 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 Ariba Procurement for you.
-
Moving Data from LinkedIn to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live LinkedIn data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Microsoft OneDrive-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft OneDrive and build Microsoft OneDrive-connected web apps with Axios.
-
Viewing Azure Data Catalog Data in RAD Studio Data Explorer
How to view Azure Data Catalog in RAD Studio Data Explorer using the CData ODBC Driver for Azure Data Catalog.
-
Connect to Sentry Data from a Connection Pool in JBoss
Integrate Sentry into Java servlets: Use the Management Console in JBoss to install the Sentry JDBC Driver.