CData Software - Knowledge Base
Recent Articles
-
Automated Continuous GetResponse Replication to SQL Server
Use CData Sync for automated, continuous, customizable GetResponse replication to SQL Server.
-
ETL Cohere in Oracle Data Integrator
This article shows how to transfer Cohere data into a data warehouse using Oracle Data Integrator.
-
Getting Started with the CData Power BI Connector for TaxJar
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for TaxJar.
-
Establish a Live Connection with Facebook Ads Data using Tableau Bridge
The CData ODBC Driver for Facebook Ads enables you to integrate live Facebook Ads data into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live Okta Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Okta data from your Google Sheets.
-
Visualize PabblySubscriptions Data in TIBCO Spotfire through ADO.NET
Integrate PabblySubscriptions data into dashboards in TIBCO Spotfire.
-
How to Connect to ZohoInvoice Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ZohoInvoice data. Leverage the pyodbc module for ODBC in Python.
-
Analyze SFTP Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SFTP from Power Pivot. You will use the Table Import Wizard to load SFTP data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Microsoft OneDrive Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Microsoft OneDrive data from Filemaker Pro on Mac.
-
Getting Started with the CData Excel Add-In for ClickUp
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ClickUp.
-
Use Azure AI Foundry to Talk to Your Bitly Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Bitly data for you.
-
Access Oracle Eloqua Reporting Data from MySQL in PHP
Connect to Oracle Eloqua Reporting through the standard MySQL libraries in PHP.
-
Use the CData Software JDBC Driver for YouTube Analytics in MicroStrategy Desktop
Connect to YouTube Analytics data in MicroStrategy Desktop using the CData Software JDBC Driver for YouTube Analytics.
-
Use ChatGPT to Talk to Your Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Zendesk data for you.
-
Use JayDeBeApi to access Autopilot Data in Python
Use standard Python scripting and the development environment of your choice to access live Autopilot data.
-
Link iContact with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate iContact data in Filemaker Pro for Mac or Windows.
-
Integrating Claude Code with Cloudflare Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Cloudflare data within assisted coding and automated development workflows.
-
Getting Started with the CData JDBC Driver for Procore
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Procore.
-
Build AlloyDB-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for AlloyDB Data and create custom apps in Bubble.
-
Integrate Real-Time Access to Paylocity in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Paylocity data in real time.
-
Analyze Oracle Financials Cloud Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Oracle Financials Cloud from Power Pivot. You will use the Table Import Wizard to load Oracle Financials Cloud data. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData ODBC Driver for Accelo from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Accelo to connect to Accelo data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Accelo data in Excel.
-
DataBind Charts to Greenplum Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Greenplum 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.
-
Connect to SAP Data in RapidMiner
Integrate SAP data with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Datasets from IBM Informix in Domo Workbench and Build Visualizations of IBM Informix Data in Domo
Use the CData Software ODBC Driver for IBM Informix to create datasets from IBM Informix data in Domo Workbench and then build visualizations in the Domo service.
-
Use Manus AI to Talk to Your Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Cassandra data.
-
Create Informatica Mappings From/To an ODBC Data Source for Miro
Create an ODBC connection to Miro in Informatica and browse and transfer Miro data.
-
Use Dash to Build Web Apps on Kafka Data via CData Connect AI
Build interactive Dash web apps on live Kafka data using pandas and the CData Connect AI Python SDK.
-
Connect to Okta Data from HeidiSQL
Use CData Connect AI to connect to and query live Okta data from HeidiSQL.
-
Analyze HDFS Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze HDFS data with the CData JDBC Driver for HDFS.
-
How to connect to DB2 Data from IntelliJ
Integrate connectivity to DB2 data with wizards in IntelliJ.
-
Automated Continuous Rebilly Replication to SQLite
Use CData Sync for automated, continuous, customizable Rebilly replication to SQLite.
-
Connect to Freshsales Data in CloverDX (formerly CloverETL)
Transfer Freshsales data using the visual workflow in the CloverDX data integration tool.
-
Feed Factorial Data into FineReport
How to set Factorial data as a JDBC data source in FineReport.
-
Connect to Active Directory Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Active Directory as an External Source in Dremio.
-
How to Connect Typeform 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 Typeform data in real time using natural language.
-
How to Connect to Live SAP Hybris C4C Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SAP Hybris C4C data without replication.
-
Connect to ServiceDesk Plus Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live ServiceDesk Plus data.
-
Query Live Bullhorn CRM Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Bullhorn CRM data through a conversational interface.
-
Getting Started with the CData Connect AI Python SDK for Sage 300
Install the CData Connect AI Python SDK to read live Sage 300 data with standard DB-API 2.0 Python code.
-
Integrate Google's Antigravity Agent with Live SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP Ariba Source data using the Model Context Protocol.
-
Use the CData Software ODBC Driver for Shortcut in MicroStrategy Web
Connect to Shortcut data in MicroStrategy Web using the CData Software ODBC Driver for Shortcut.
-
Connect to GitHub Data in RazorSQL
Connect to GitHub from wizards and query GitHub data from the GUI in the RazorSQL database management tool.
-
Connect to Oracle HCM Cloud Data in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle HCM Cloud in FileMaker Pro to connect to Oracle HCM Cloud and work with Oracle HCM Cloud data in your FileMaker applications.
-
Automated Continuous Rootly Replication to SingleStore
Use CData Sync for automated, continuous, customizable Rootly replication to SingleStore.
-
Query Adobe Analytics Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Adobe Analytics entities in PHP by modeling them as objects.
-
Visualize Redshift Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Redshift data into TIBCO Spotfire.
-
Analyze Splunk Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Splunk data in Microsoft R Open.
-
Query Google Ad Manager Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Ad Manager data from Node.js.
-
Create Data Visualizations in Cognos BI with SAP Concur Data
Access SAP Concur data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Create Power BI Visual Reports with Real-Time Databricks Data
Use CData Power BI Connectors to visualize Databricks data in Power BI.
-
Analyze Google Spanner Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Spanner from Power Pivot. You will use the Table Import Wizard to load Google Spanner data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to PolarTeamPro from Asprova with CData Software ODBC Driver for PolarTeamPro
This article shows how to connect faster to PolarTeamPro data from Asprova.
-
Provide OData Services of Tanda Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Tanda data by developing a WCF Service Application.
-
Easily Integrate Dynamics CRM Data in Lazarus Pascal IDE
Learn how to easily integrate live Dynamics CRM data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Greenplum Data from HeidiSQL
Use CData Connect AI to connect to and query live Greenplum data from HeidiSQL.
-
Integrate Google's Vertex AI Agent with Live Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Paylocity data within intelligent workflows.
-
Replicate Multiple Bitbucket Accounts via the CData Sync CLI
Replicate multiple Bitbucket accounts to one or many databases.
-
How to Connect to Live FTP 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 FTP data for you.
-
How to Connect Flowise AI Agents to Live SAP Business Warehouse 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 SAP Business Warehouse data without replication.
-
Manage Workable Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Workable.
-
Create Printify-Connected Nintex Workflows
Use CData Connect AI to connect to Printify Data from Nintex Workflow Cloud and build custom workflows using live Printify data.
-
Integrate Dify with Live Klipfolio Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Klipfolio data.
-
Publish Mixpanel-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Mixpanel data.
-
Connect to Salesloft Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Salesloft and the SQL Gateway to access Salesloft data from Google Apps Script.
-
How to connect PolyBase to Oracle SCM
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Oracle SCM data.
-
Integrating OpenCode with Spotify 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.
-
Connect and Visualize Live Oracle SCM Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Oracle SCM data into the Databricks platform and create visualization dashboards with real-time Oracle SCM data.
-
Use Databricks Agent Bricks to Talk to Your SFTP Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SFTP data for you.
-
Getting Started with the CData Python Connector for GetResponse
Learn to install and license the CData Python Connector and configure a connection to live GetResponse data.
-
Connect to Oracle Eloqua 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 Oracle Eloqua data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Elasticsearch
Provide connectivity to Elasticsearch data through an SAP BusinessObjects universe.
-
Connect to Sybase IQ Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Sybase IQ data from Filemaker Pro on Mac.
-
Connect to Aircall Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Aircall to connect to Aircall data and execute queries in PowerBuilder.
-
Create Data Visualizations Based On Suadeo Data in Mode
Use CData Connect AI to connect to Suadeo Data from Mode and build visualizations using live Suadeo data.
-
Use the CData Software ODBC Driver for Retently in MicroStrategy
Connect to Retently data in MicroStrategy Developer using the CData Software ODBC Driver for Retently.
-
Connect ElevenLabs Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ElevenLabs data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData JDBC Driver for SAP Netweaver Gateway
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP Netweaver Gateway.
-
Prepare, Blend, and Analyze Zoho Creator Data in Alteryx Designer (Connect AI)
Build workflows to access live Zoho Creator data for self-service data analytics.
-
Stream FHIR Data into Apache Kafka Topics
Access and stream FHIR data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate with ShipStation Data in JReport Designer
Create charts and reports based on ShipStation data in JReport Designer.
-
Publish FreeAgent-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live FreeAgent data.
-
Connect Bright Data to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Bright Data data using the CData Python MCP Server.
-
Integrate Google's Antigravity Agent with Live LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live LinkedIn data using the Model Context Protocol.
-
Create Reports from Redis Data in Looker Studio
Use CData Connect AI to gain access to live Redis data and create custom reports in Looker Studio.
-
Connect to Google Campaign Manager 360 Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Campaign Manager 360 and the SQL Gateway to access Google Campaign Manager 360 data from Google Apps Script.
-
Operational Reporting on Paymo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Paymo data.
-
Access Live Kintone Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Kintone data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Getting Started with the CData JDBC Driver for PingOne
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for PingOne.
-
Connect to Phoenix Data in Google Apps Script via Connect AI
Use CData Connect AI to access Phoenix data in Google Apps Script.
-
Integrate HDFS Data in Pentaho Data Integration
Build ETL pipelines based on HDFS data in the Pentaho Data Integration tool.
-
Connect to Jira Data from PowerBuilder via JDBC
This article demonstrates how to access Jira data from PowerBuilder using the Jira JDBC Driver.
-
Visualize Live Dynamics 365 Business Central Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Dynamics 365 Business Central data into custom reports in Power BI.
-
Connect to MailChimp Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with MailChimp Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Establish a Live Connection with Avalara AvaTax Data using Tableau Bridge
The CData ODBC Driver for Avalara AvaTax enables you to integrate live Avalara AvaTax data into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData Software JDBC Driver for Google Forms in MicroStrategy
Connect to Google Forms data in MicroStrategy Developer using the CData Software JDBC Driver for Google Forms.
-
Connect to Real-Time Keap Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Keap data in Power Apps.
-
Easily Integrate SingleStore Data in Lazarus Pascal IDE
Learn how to easily integrate live SingleStore data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect to Live XML 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 XML data through natural language.
-
Getting Started with the CData ADO.NET Provider for Sentry
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.