CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Excel Add-In for YouTube Analytics
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for YouTube Analytics.
-
Connecting GenSpark with Sybase Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Sybase data without any replication or custom integration required.
-
How to create IBM Informix federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for IBM Informix data in MySQL .
-
Build Yelp-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Yelp Data and create custom apps in Bubble.
-
Connect to Shippo Data in JRuby
Create a simple JRuby app with access to live Shippo data.
-
Viewing Front Data in RAD Studio Data Explorer
How to view Front data in RAD Studio Data Explorer using the CData ODBC Driver for Front.
-
Stream Freshservice Data into Apache Kafka Topics
Access and stream Freshservice data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build SAP BusinessObjects BI-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SAP BusinessObjects BI Data from Zoho Analytics and import live SAP BusinessObjects BI data.
-
Deploy the ADO.NET Provider for Google Sheets on an SSRS Report Server
Connect to Google Sheets data 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.
-
Automated Continuous Miro Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Miro replication to PostgreSQL.
-
Connect and Visualize Live Authorize.Net Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Authorize.Net data into the Databricks platform and create visualization dashboards with real-time Authorize.Net data.
-
DataBind Controls to Browserless Data in Delphi
DataBind to Browserless data in Delphi with standard data access components and controls.
-
Integrating XML Data in Talend Cloud Data Management Platform
Connect XML Data with Talend Cloud Data Management Platform using the CData JDBC Driver for XML.
-
Build an OLAP Cube in SSAS from Zoho Books Data
Establish a connection to Zoho Books data data from SQL Server Analysis Services, and use the Zoho Books Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use Azure AI Foundry to Talk to Your API 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 API data for you.
-
Prepare, Blend, and Analyze Google Tasks Data in Alteryx Designer (ODBC)
Build workflows to access live Google Tasks data for self-service data analytics.
-
How to Connect to & Open Pinecone Data in Microsoft Excel
This article uses the CData ODBC driver for Pinecone to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Spotify Replication to SingleStore
Use CData Sync for automated, continuous, customizable Spotify replication to SingleStore.
-
Integrating Claude Code CLI with Clockify 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.
-
Create Zoho Creator-Connected Nintex Workflows
Use CData Connect AI to connect to Zoho Creator Data from Nintex Workflow Cloud and build custom workflows using live Zoho Creator data.
-
How to Access Live Wrike Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Wrike enables you to integrate Wrike data into workflows built using Microsoft Power Automate Desktop.
-
Creating Google Search-Connected Applications in Unqork
You can use CData Connect AI to feed Google Search results to Unqork and build custom business apps.
-
Build Jira Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Jira data and build visualizations in Tableau Cloud.
-
Integrating LangGraph with WordPress Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on WordPress data within automated workflows.
-
Use Manus AI to Talk to Your Amazon S3 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 Amazon S3 data.
-
Getting Started with the CData SSIS Components for QuickBooks Online
Complete guide to installing, licensing, and connecting with the CData SSIS Components for QuickBooks Online.
-
Stream OpenWeatherMap Data into Apache Kafka Topics
Access and stream OpenWeatherMap data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Excel Online Data in DBArtisan
Use wizards in DBArtisan to configure Excel Online data as a data source.
-
Automated Continuous AgileCRM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable AgileCRM data replication to OneLake in Microsoft Fabric.
-
How to connect and process SAP SuccessFactors LMS data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP SuccessFactors LMS data.
-
Automated Continuous Amazon DynamoDB Replication to SQLite
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to SQLite.
-
How to integrate Metabase with Reckon Accounts Hosted Data
Use CData Connect AI to connect to live Reckon Accounts Hosted data and create an interactive dashboard in Metabase from Reckon Accounts Hosted data.
-
Link Dotmailer with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Dotmailer data in Filemaker Pro for Mac or Windows.
-
Integrate Bannerbear Data in Pentaho Data Integration
Build ETL pipelines based on Bannerbear data in the Pentaho Data Integration tool.
-
How to Query Brex Data in MySQL Workbench
Execute MySQL queries against live Brex data from MySQL Workbench.
-
How to Connect to Qualaroo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Qualaroo data. Leverage the pyodbc module for ODBC in Python.
-
Configure the CData JDBC Driver for eBay in a Connection Pool in Tomcat
Connect to eBay data from a connection pool in Tomcat.
-
Build QuickBooks Time-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 QuickBooks Time data without replication.
-
Build Dashboards with Productboard Data in DBxtra
Create dynamic dashboards and perform analytics based on Productboard data in DBxtra.
-
Automated Continuous Parallel Replication to Oracle
Use CData Sync for automated, continuous, customizable Parallel replication to Oracle.
-
Create Informatica Mappings From/To an ODBC Data Source for Parallel
Create an ODBC connection to Parallel in Informatica and browse and transfer Parallel data.
-
Use the CData Software JDBC Driver for Guru in MicroStrategy Web
Connect to Guru data in MicroStrategy Web using the CData Software JDBC Driver for Guru.
-
Access Shopify Data from MySQL in PHP
Connect to Shopify through the standard MySQL libraries in PHP.
-
Manage Hubstaff Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Hubstaff.
-
Connect to Authorize.Net Data in DBArtisan
Use wizards in DBArtisan to configure Authorize.Net data as a data source.
-
Extract, Transform, and Load ConvertKit Data in Informatica PowerCenter
Create a simple Workflow for ConvertKit data in Informatica PowerCenter.
-
Replicate Multiple OpenWeatherMap Accounts
Replicate multiple OpenWeatherMap accounts to one or many databases.
-
Automated Continuous ZohoPeople Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ZohoPeople replication to Apache Kafka.
-
Create Data Visualizations in Cognos BI with Adobe Commerce Data
Access Adobe Commerce data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Boomi Agentstudio with Impala Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Impala data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Add Redis Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Redis with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Microsoft Copilot Studio to talk to your Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Freshdesk data for you.
-
Use Claude to Talk to Your SAP Business Warehouse 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 SAP Business Warehouse data for you.
-
How to Query Testmonitor Data in MySQL Workbench
Execute MySQL queries against live Testmonitor data from MySQL Workbench.
-
Connect to and Query Couchbase Data in QlikView over ODBC
Create data visualizations with Couchbase data in QlikView.
-
Connect to Amplitude Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Amplitude and work with Amplitude data in your FileMaker application.
-
Access Live LeadDesk Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate LeadDesk data into the statistical analysis tools available in SAS JMP. This article shows how to use LeadDesk data in the Graph Builder and Query Builder.
-
Replicate Slack Data to Multiple Databases
Replicate Slack data to disparate databases with a point-and-click configuration.
-
Automate Dotmailer Data Replication to Couchbase
Use CData Sync to Customize and automate Dotmailer data replication to Couchbase.
-
Build Pipelines with Live SAP Business One Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP Business One from Google Cloud Data Fusion, enabling the integration of live SAP Business One data into the building and management of effective data pipelines.
-
Automated Continuous Snapchat Ads Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Apache Kafka.
-
Viewing Sage 300 Data in RAD Studio Data Explorer
How to view Sage 300 data in RAD Studio Data Explorer using the CData ODBC Driver for Sage 300.
-
Integrating Antigravity CLI with Sage 200 data via CData CLI
Connect Sage 200 data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Migrating data from Active Directory to Google BigQuery using CData SSIS Components.
Easily push Active Directory data to Google BigQuery using the CData SSIS Tasks for Active Directory and Google BigQuery.
-
Connect to Avro Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Avro and the Script function in FileMaker Pro to connect to Avro and work with Avro data in your FileMaker application.
-
Provide OData Services of Campaigner Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Campaigner data by developing a WCF Service Application.
-
Build Apps with Live AlloyDB Data Using the Low-Code Development Platform of Mendix
Connect AlloyDB data with Mendix to build apps using the CData JDBC Driver for AlloyDB.
-
Integrate Devin with Live Zuora Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Zuora data.
-
Access Live Klaviyo Data in AWS Lambda
Connect to live Klaviyo data in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous SurveyMonkey Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Google BigQuery.
-
Build AI/ML Models with Live SageHR Data using Dataiku
Connect SageHR Data with Dataiku using the CData API Driver for JDBC.
-
Query Mailjet Data as a MySQL Database in Node.js
Execute MySQL queries against Mailjet data from Node.js.
-
Build SFTP-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 SFTP data without replication.
-
Integrate Gorgias Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Gorgias data from Informatica Cloud.
-
Create SSAS Tabular Models from Dynamics 365 Data
How to build a SQL Server Analysis Service Tabular Model from Dynamics 365 data using CData drivers.
-
Connect to Hive Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Hive data in Airbyte.
-
Automated Continuous JSON Replication to SQL Server
Use CData Sync for automated, continuous, customizable JSON replication to SQL Server.
-
Integrate Planio Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Planio data from Informatica Cloud.
-
Build Pipelines with Live Google Sheets Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Sheets from Google Cloud Data Fusion, enabling the integration of live Google Sheets data into the building and management of effective data pipelines.
-
Integrate Vimeo with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Vimeo with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Vimeo data.
-
Integrating OpenCode with Simplesat 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.
-
Create Reports from SAP Fieldglass Data in Looker Studio
Use CData Connect AI to gain access to live SAP Fieldglass data and create custom reports in Looker Studio.
-
Access Live Avro Data in Excel 365 Online (Excel for the web)
Connect to Avro data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Connect to Live SingleStore Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SingleStore data securely in real time.
-
Connecting Moonlit Workflow with SurveyMonkey 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 SurveyMonkey data in real time.
-
Build a Simple VCL Application for Phoenix Data
How to build a simple VCL Application to view Phoenix data in RAD Studio using the CData ODBC Driver for Phoenix.
-
Use ChatGPT to Talk to Your SAP Ariba Procurement 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 SAP Ariba Procurement data for you.
-
Build Attio-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Attio data.
-
Use the CData ODBC Driver for Chargebee in Microsoft Power Query
You can use the CData Chargebee ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Chargebee data into Microsoft Power Query.
-
Connecting Moonlit Workflow with AfterShip 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 AfterShip data in real time.
-
Connect to Sugar CRM Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Sugar CRM data in the Denodo Virtual DataPort Administrator.
-
Integrate Cursor with Live FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live FTP data from within the editor.
-
Automate Azure Synapse Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Azure Synapse data from PowerShell? This article demonstrates how to utilize the Azure Synapse Cmdlets for tasks like connecting to Azure Synapse data, automating operations, downloading data, and more.
-
Use the CData Software ODBC Driver for Microsoft OneDrive in MicroStrategy Web
Connect to Microsoft OneDrive data in MicroStrategy Web using the CData Software ODBC Driver for Microsoft OneDrive.
-
Create Data Visualizations Based On Kintone Data in Mode
Use CData Connect AI to connect to Kintone Data from Mode and build visualizations using live Kintone data.
-
View Reports on Real-Time Pipeliner CRM Data in Power BI Report Server
Use the CData ODBC Driver for Pipeliner CRM to visualize Pipeliner CRM data in Power BI Desktop and then publish them to Power BI Report Server.
-
Working with Azure Analysis Services Data in LINQPad
Execute LINQ queries to Azure Analysis Services data in LINQPad.
-
Bind Live Pipedrive Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Pipedrive data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect to Copper Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Copper.
-
Automated Continuous Helpscout Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Helpscout replication to Google Cloud SQL.