CData Software - Knowledge Base
Recent Articles
-
Query Epicor Kinetic Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Epicor Kinetic entities in PHP by modeling them as objects.
-
Getting Started with the CData Tableau Connector for LeadDesk
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate with Live Egnyte Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Egnyte from the MuleSoft Anypoint Platform to integrate live Egnyte data into custom reports and dashboards.
-
Connect to Apify 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 Apify data.
-
Link FreshBooks with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate FreshBooks data in Filemaker Pro for Mac or Windows.
-
Automate Clari Data Replication to SAP HANA
Use CData Sync to customize and automate Clari data replication to SAP HANA.
-
Use JayDeBeApi to access ZohoInvoice Data in Python
Use standard Python scripting and the development environment of your choice to access live ZohoInvoice data.
-
Connect to Dropbox Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Dropbox data.
-
Automated Continuous Rebilly Replication to Vertica
Use CData Sync for automated, continuous, customizable Rebilly replication to Vertica.
-
Automated Continuous Exact Online Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Exact Online replication to Amazon Redshift.
-
Connect to RSS Feeds as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for RSS feeds.
-
Analyze eBay Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for eBay from Power Pivot. You will use the Table Import Wizard to load eBay data. You can visually build the import query or use any SQL supported by the driver.
-
Load Discord Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Discord data to a database.
-
Query Live Amazon DynamoDB Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Amazon DynamoDB data directly from the development environment.
-
Use the CData Software JDBC Driver for GraphQL in MicroStrategy Desktop
Connect to GraphQL data in MicroStrategy Desktop using the CData Software JDBC Driver for GraphQL.
-
Build Charts with HubSpot Data in Clear Analytics
Create dynamic charts and perform analytics based on HubSpot data in Clear Analytics.
-
How to Query Live Freshsales Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Freshsales data data in natural language using Python.
-
Build LinkedIn Ads-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 LinkedIn Ads data without replication.
-
Create Dashboards and Visualize Live ActiveCampaign Data in Geckoboard
Use CData Connect AI to connect to live ActiveCampaign data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Voice Agents in ElevenLabs with access to Live Freshdesk Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Freshdesk data.
-
Import Real-Time Planio Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Planio data in ColdFusion.
-
How to Build an ETL App for Sage 200 Data in Python with CData
Create ETL applications and real-time data pipelines for Sage 200 data in Python with petl.
-
Connect to and Visualize Live ServiceNow Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ServiceNow data.
-
Connect to SFTP Data in RazorSQL
Connect to SFTP from wizards and query SFTP data from the GUI in the RazorSQL database management tool.
-
How to Connect Flowise AI Agents to Live BambooHR 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 BambooHR data without replication.
-
How to Visualize Freshsales Data in Python with pandas
Use pandas and other modules to analyze and visualize live Freshsales data in Python.
-
Connect to Stripe in SpagoBI
Create reports featuring live Stripe data in SpagoBI Studio. Host Stripe reports on SpagoBI Server.
-
Connect to Shortcut Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Shortcut Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to connect to JobNimbus Data from IntelliJ
Integrate connectivity to JobNimbus data with wizards in IntelliJ.
-
Connect to SFTP Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to SFTP.
-
Connecting Agentforce with Greenhouse Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Greenhouse data for you.
-
Load Gmail Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Gmail data to a database.
-
How to Connect to Live Confluence 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 Confluence data through natural language.
-
Visualize Amazon Athena Data in Tableau
The CData ODBC driver for Amazon Athena enables you integrate Amazon Athena data into Tableau dashboards.
-
Replicate Calendly Data to Multiple Databases
Replicate Calendly data to disparate databases with a point-and-click configuration.
-
Link ZohoInvoice with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ZohoInvoice data in Filemaker Pro for Mac or Windows.
-
Operational Reporting on Email Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Email data.
-
Connect to Elasticsearch Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Elasticsearch data in Airbyte.
-
Build a Singer.io Tap for Recurly With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Recurly data using the CData Python Connector.
-
DataBind Controls to MailChimp Data in Delphi
DataBind to MailChimp data in Delphi with standard data access components and controls.
-
How to Build an ETL App for Tanda Data in Python with CData
Create ETL applications and real-time data pipelines for Tanda data in Python with petl.
-
How to Query Sugar CRM Data in MySQL Workbench
Execute MySQL queries against live Sugar CRM data from MySQL Workbench.
-
Build Okta-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Okta Data and create custom apps in Mendix.
-
Build Semantic Layer Views for Vertica Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Vertica data.
-
Integrate Cursor with Live Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Zoho Projects data from within the editor.
-
Connecting Pipedream with ConstantContact Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on ConstantContact data in real time.
-
Connect to SAS Data Sets Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAS Data Sets data from Filemaker Pro on Mac.
-
Build SAP BusinessObjects BI-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP BusinessObjects BI Data and create custom apps in Mendix.
-
Establish a Live Connection with Gong Data using Tableau Bridge
The CData ODBC Driver for Gong enables you to integrate live Gong data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Data Flows from Azure Analysis Services to SQL Server using SSIS
Easily back up Azure Analysis Services data to SQL Server using the SSIS components for Azure Analysis Services.
-
Build Lakebase-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Lakebase Data from Zoho Analytics and import live Lakebase data.
-
How to publish and share Google Campaign Manager 360 Data dashboards with Tableau Server
The CData ODBC driver for Google Campaign Manager 360 enables you integrate Google Campaign Manager 360 data into Tableau dashboards.
-
Build Automated Workflows with Live Azure Synapse Data in Workato
Use CData Connect AI to connect to live Azure Synapse data and build automated workflows in Workato.
-
How to Connect to Live Exact Online Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Exact Online data for you.
-
Connect to MongoDB Data in DBeaver
Use the CData ODBC Driver to connect to MongoDB data in DBeaver.
-
Automated Continuous Guru Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Guru replication to Apache Kafka.
-
Build Apps with Live Aircall Data Using the Low-Code Development Platform of Mendix
Connect Aircall data with Mendix to build apps using the CData API Driver for JDBC.
-
Getting Started: Build a Customer Health AI Agent with Microsoft Copilot Studio and CData Connect AI
Learn how to build a customer health AI agent in Microsoft Copilot Studio using CData Connect AI to analyze sample customer data from Google Sheets.
-
Connect to Zoho Creator Data from HeidiSQL
Use CData Connect AI to connect to and query live Zoho Creator data from HeidiSQL.
-
Use Claude to Talk to Your PingOne 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 PingOne data for you.
-
Use the CData Software JDBC Driver for Qualaroo in MicroStrategy Web
Connect to Qualaroo data in MicroStrategy Web using the CData Software JDBC Driver for Qualaroo.
-
How to Connect Google Directory Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Google Directory data in real time using natural language.
-
Work with ZarMoney Data in FoxPro
Load ZarMoney data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Kafka Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Kafka replication to Google BigQuery.
-
Automated Continuous Bullhorn CRM Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to Google BigQuery.
-
Access Discord Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Discord data from HeidiSQL.
-
Connect to Reckon Accounts Hosted Data from PowerBuilder via ADO.NET
This article demonstrates how to access Reckon Accounts Hosted data from Appeon PowerBuilder using the CData ADO.NET Provider for Reckon Accounts Hosted.
-
Replicate ZohoSubscriptions Data to Multiple Databases via the CData Sync CLI
Replicate ZohoSubscriptions data to disparate databases with a single configuration.
-
Integrate Live SparkPost Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SparkPost from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SparkPost data.
-
Connect to Splunk Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Splunk and the SQL Gateway to access Splunk data from Google Apps Script.
-
Analyze Aweber Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Aweber data in Microsoft R Open.
-
Integrate Real-Time Access to PayPal in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to PayPal data in real time.
-
Connect to Pinterest Data in Jaspersoft Studio
Execute SQL to remote Pinterest data in Jaspersoft Studio.
-
Automate Freshteam Data Replication to SAP HANA
Use CData Sync to customize and automate Freshteam data replication to SAP HANA.
-
Automated Continuous ActiveCampaign Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to Google BigQuery.
-
Build Charts with Humanity Data in Clear Analytics
Create dynamic charts and perform analytics based on Humanity data in Clear Analytics.
-
Create Reports from SAP Ariba Procurement Data in Looker Studio
Use CData Connect AI to gain access to live SAP Ariba Procurement data and create custom reports in Looker Studio.
-
Create Dynamic Hive Grids Using the Infragistics XamDataGrid
Learn how you can connect Hive to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData Software JDBC Driver for Vimeo in MicroStrategy
Connect to Vimeo data in MicroStrategy Developer using the CData Software JDBC Driver for Vimeo.
-
How to Use a Microsoft Access Database to Update Google Calendar Data in Real Time
Update Google Calendar data by creating a linked table in Microsoft Access with the CData Google Calendar ODBC Driver.
-
Connect to Jodoo Data in Aqua Data Studio
Access Jodoo data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Migrating data from Timely to Google BigQuery using CData SSIS Components.
Easily push Timely data to Google BigQuery using the CData SSIS Tasks for Timely and Google BigQuery.
-
Integrating Cursor with Scrapfly 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.
-
Build Data Flows from Attio to SQL Server using SSIS
Easily back up Attio data to SQL Server using the SSIS components for Attio.
-
Configure the CData JDBC Driver for Instantly in a Connection Pool in Tomcat
Connect to Instantly data from a connection pool in Tomcat.
-
Use the CData Software ODBC Driver for PolarTeamPro in MicroStrategy Web
Connect to PolarTeamPro data in MicroStrategy Web using the CData Software ODBC Driver for PolarTeamPro.
-
Access Sendwithus 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 Sendwithus data.
-
Automated Continuous ZeroBounce Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ZeroBounce replication to Google Cloud SQL.
-
Create Microsoft Entra ID Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Microsoft Entra ID from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to CouchDB 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 CouchDB data.
-
A PostgreSQL Interface for Retently Data using the CData ODBC Driver
Use the SQL Gateway and Retently ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Snowflake Data in TIBCO Data Virtualization
Use the Snowflake Tibco DV Adapter to create a Snowflake data data source in TIBCO Data Virtualization Studio and gain access to live Snowflake data from your TDV Server.
-
Build Automated QuickBooks Time-Connected Workflows in Zapier
Use CData Connect AI to connect to live QuickBooks Time data and build automated workflows in Zapier.
-
Connect to Beeminder Data in DBArtisan
Use wizards in DBArtisan to configure Beeminder data as a data source.
-
Build Data Flows from SQL Server to Bullhorn CRM through SSIS
Easily push SQL Server data to Bullhorn CRM using the CData SSIS Tasks for Bullhorn CRM.
-
Create Informatica Mappings From/To a JDBC Data Source for Oracle Eloqua Reporting
Create Oracle Eloqua Reporting data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to SendPulse Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SendPulse data from Filemaker Pro on Mac.
-
Integrate Real-Time Access to Act CRM in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Act CRM data in real time.
-
Integrate Live Sage Intacct Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Sage Intacct data from within the IDE.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SingleStore
Provide connectivity to SingleStore data through an SAP BusinessObjects universe.