CData Software - Knowledge Base
Recent Articles
-
Connect to Billsby Data in RapidMiner
Integrate Billsby with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Sage Cloud Accounting Data from MySQL in PHP
Connect to Sage Cloud Accounting through the standard MySQL libraries in PHP.
-
How to create Superchat federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Superchat in MySQL .
-
DataBind Controls to Oracle Sales Data in Delphi
DataBind to Oracle Sales in Delphi with standard data access components and controls.
-
Automated Continuous Airtable Replication to SingleStore
Use CData Sync for automated, continuous, customizable Airtable replication to SingleStore.
-
Analyze Dynamics 365 Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft Dynamics 365 in Microsoft R Open.
-
Replicate NetSuite Data in Heroku for Use in Salesforce Connect
Replicate NetSuite CRM & ERP to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Design Spark Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Spark from mobile and tablet Power Apps.
-
Migrating data from Dynamics CRM to Databricks using CData SSIS Components.
Easily push Microsoft Dynamics CRM to Databricks using the CData SSIS Tasks for Dynamics CRM and Databricks.
-
Integrate Open WebUI with Live MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live MongoDB from within the chat interface.
-
Connect to Square Data from a Connection Pool in JBoss
Integrate Square into Java servlets: Use the Management Console in JBoss to install the Square JDBC Driver.
-
Use Manus AI to Talk to Your Oracle HCM Cloud 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 Oracle HCM Cloud.
-
Use Microsoft Copilot Studio to talk to your Facebook 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 Facebook for you.
-
Integrating Cursor CLI with Zoho Inventory 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 to Avalara AvaTax Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Avalara AvaTax Data and connect to Avalara AvaTax in Akorbi Digital RunMyProcess.
-
Automated Continuous Dynamics 365 Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Azure SQL Database.
-
Create Power BI Reports on Real-Time Yelp Data
Use the CData ODBC Driver for Yelp to visualize Yelp in Power BI Desktop.
-
Access ADP Data from MySQL in Amazon QuickSight
Connect to ADP and build visualizations of ADP using a MySQL Connection in Amazon QuickSight.
-
Build Visualizations of Sugar CRM Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Sugar CRM in Birst.
-
Import and Visualize Mixpanel Data in Power View
Create data visualizations based on Mixpanel in Excel.
-
Connect to Sage 300 Data in Jaspersoft Studio
Execute SQL to remote Sage 300 in Jaspersoft Studio.
-
Access Live Box 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 Box through MCP integration.
-
Build Visualizations of FormSite Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of FormSite in Birst.
-
Getting Started with the CData Excel Add-In for Microsoft Entra ID
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Microsoft Entra ID.
-
Build Exact Online-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Exact Online to explore live Exact Online Data in Gemini Code Assist to assist with building Exact Online-powered applications.
-
Build a Simple VCL Application for Demio Data
How to build a simple VCL Application to view Demio in RAD Studio using the CData ODBC Driver for Demio.
-
How to Query Live Retently Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Retently data in natural language using Python.
-
How to Access Live ElevenLabs Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ElevenLabs enables you to integrate ElevenLabs into workflows built using Microsoft Power Automate Desktop.
-
Connect to Teamwork Data in Aqua Data Studio
Access Teamwork from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrating Kiro CLI with Certinia 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.
-
Edit and Search External Facebook Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Facebook to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Facebook Data objects that you can access from apps and the dashboard.
-
Establish a Live Connection with Google Ads Data using Tableau Bridge
The CData ODBC Driver for Google Ads enables you to integrate live Google Ads into Tableau Cloud dashboards using the Tableau Bridge.
-
Analyze Bugsnag Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Bugsnag and visualize live Bugsnag in Infragistics Reveal.
-
How to Work with AgileCRM Data in AWS Glue Jobs Using JDBC
Connect to AgileCRM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating Claude Code with Active Directory Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Active Directory within assisted coding and automated development workflows.
-
How to Seamlessly Import Freshsales Data into IBM SPSS Modeler
Integrate Freshsales data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Import Snowflake Data Using Azure Data Factory
Use CData Connect AI to connect to Snowflake Data from Azure Data Factory and import live Snowflake.
-
Prepare, Blend, and Analyze Jira Data in Alteryx Designer (Connect AI)
Build workflows to access live Atlassian Jira for self-service data analytics.
-
Migrating data from iContact to Google BigQuery using CData SSIS Components.
Easily push iContact to Google BigQuery using the CData SSIS Tasks for iContact and Google BigQuery.
-
Create Reports from Sage Cloud Accounting Data in Looker Studio
Use CData Connect AI to gain access to live Sage Business Cloud Accounting and create custom reports in Looker Studio.
-
Access Live Everhour Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Everhour into the statistical analysis tools available in SAS JMP. This article shows how to use Everhour in the Graph Builder and Query Builder.
-
Create Data Visualizations in Cognos BI with Amazon DynamoDB Data
Access Amazon DynamoDB as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Informatica Mappings From/To a JDBC Data Source for Tickspot
Create Tickspot data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Eventbrite Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Eventbrite replication to Amazon S3.
-
Visualize Auth0 Data in Tableau
The CData ODBC driver for Auth0 enables you integrate Auth0 into Tableau dashboards.
-
Connect to Square Data in DBArtisan
Use wizards in DBArtisan to configure Square as a data source.
-
Integrate Sendwithus with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Sendwithus with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Sendwithus.
-
Work with Cloudant Data in FoxPro
Load IBM Cloudant into a FoxPro database. This article includes full code and a walk-through of the process.
-
Bridge LaunchDarkly Connectivity with Apache NiFi
Access and process LaunchDarkly in Apache NiFi using the CData JDBC Driver.
-
Import Real-Time QuickBooks Online Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use QuickBooks Online in ColdFusion.
-
Creating Active Directory-Connected Applications in Unqork
You can use CData Connect AI to feed Active Directory to Unqork and build custom business apps.
-
Connect to Webflow Data in Jaspersoft Studio
Execute SQL to remote Webflow in Jaspersoft Studio.
-
Build a PostgreSQL Interface for Epicor Kinetic Data using the CData JDBC Driver
Use the Remoting features of the Epicor Kinetic JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build AI Agents with Apollo Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Apollo through CData Connect AI.
-
Automated Continuous SAP Hybris C4C Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to SingleStore.
-
Connect to Apify Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Apify and work with Apify in your FileMaker applications.
-
Connect to Shortcut in SpagoBI
Create reports featuring live Shortcut in SpagoBI Studio. Host Shortcut reports on SpagoBI Server.
-
ETL Google Campaign Manager 360 in Oracle Data Integrator
This article shows how to transfer Google Campaign Manager 360 into a data warehouse using Oracle Data Integrator.
-
Use Microsoft Copilot Studio to talk to your ServiceNow 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 ServiceNow for you.
-
Establish a Live Connection with Guru Data using Tableau Bridge
The CData ODBC Driver for Guru enables you to integrate live Guru into Tableau Cloud dashboards using the Tableau Bridge.
-
Prepare, Blend, and Analyze Google Ad Manager Data in Alteryx Designer (ODBC)
Build workflows to access live Google Ad Manager for self-service data analytics.
-
How to Build an ETL App for ZohoDesk Data in Python with CData
Create ETL applications and real-time data pipelines for ZohoDesk in Python with petl.
-
Working with LightSpeedRetail Data in LINQPad
Execute LINQ queries to LightSpeedRetail in LINQPad.
-
Integrate with live Act CRM Data in Jitterbit
Use CData Connect AI to connect to and integrate live Act CRM in Jitterbit.
-
Build Dashboards with Amazon Athena Data in DBxtra
Create dynamic dashboards and perform analytics based on Amazon Athena in DBxtra.
-
How to connect to Freshservice Data with Squirrel SQL client
Connect to Freshservice and execute queries in the Squirrel SQL Client.
-
Connect to FTP Data as an External Source in Dremio
Use the CData JDBC Driver to connect to FTP as an External Source in Dremio.
-
Viewing Greenhouse Data in RAD Studio Data Explorer
How to view Greenhouse in RAD Studio Data Explorer using the CData ODBC Driver for Greenhouse.
-
Integrate Live Apollo Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Apollo and integrate live Apollo into apps built in Microsoft Power Apps.
-
Create Freshservice Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Freshservice from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build a Simple VCL Application for MariaDB Data
How to build a simple VCL Application to view MariaDB in RAD Studio using the CData ODBC Driver for MariaDB.
-
How to Connect to & Open WordPress Data in Microsoft Excel
This article uses the CData ODBC driver for WordPress to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Analyze Stack Exchange Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Stack Exchange and visualize live Stack Exchange in Infragistics Reveal.
-
Replicate Square Data to Multiple Databases via the CData Sync CLI
Replicate Square to disparate databases with a single configuration.
-
Connect to VWO from Asprova with CData Software ODBC Driver for VWO
This article shows how to connect faster to VWO data from Asprova.
-
Use the CData Software ODBC Driver for Google Contacts in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Contacts in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Contacts.
-
Use Manus AI to Talk to Your Couchbase 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 Couchbase.
-
Automated Continuous CouchDB Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable CouchDB replication to Google BigQuery.
-
Model, Search, and Visualize Live BigQuery Data in ThoughtSpot
Use CData Connect AI to connect to live Google BigQuery for modeling, searching, and visualizing.
-
Model, Search, and Visualize Live LinkedIn Ads Data in ThoughtSpot
Use CData Connect AI to connect to live LinkedIn Ads for modeling, searching, and visualizing.
-
How to Work with Cassandra Data in ETL Validator JDBC
Connect to Cassandra from ETL Validator jobs using the CData Software JDBC Driver.
-
Connecting Moonlit Workflow with Facebook Ads 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 Facebook Ads in real time.
-
Connect to ChartMogul Data in DBeaver
Use the CData ODBC Driver to connect to ChartMogul in DBeaver.
-
Configure the CData JDBC Driver for SurveyMonkey in a Connection Pool in Tomcat
Connect to SurveyMonkey from a connection pool in Tomcat.
-
Build Google Directory Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Directory and build visualizations in Tableau Cloud.
-
Consume Wave Financial OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Wave Financial feeds that reflect any changes in SAP Lumira.
-
How to Design Zoho Projects Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Zoho Projects from mobile and tablet Power Apps.
-
Use Manus AI to Talk to Your Salesforce Pardot 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 Salesforce Pardot.
-
Connect to Zoho Projects from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Zoho Projects, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Import Data from FreeAgent into Google Sheets
Import FreeAgent into a Google spreadsheet that is automatically refreshed.
-
Connect to Toggl Data in RazorSQL
Connect to Toggl from wizards and query Toggl from the GUI in the RazorSQL database management tool.
-
Build Voice Agents in ElevenLabs with access to Live Google Calendar Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google Calendar.
-
Connecting GenSpark with Square Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Square without any replication or custom integration required.
-
Integrating Cursor CLI with GraphQL 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.
-
Automate JDBC-ODBC Bridge Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live JDBC-ODBC Bridge and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Edit and Search PDFMonkey External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of PDFMonkey to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create PDFMonkey objects that you can access from apps and the dashboard.
-
Automated Continuous Jira Assets Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Jira Assets replication to Google Cloud SQL.
-
Build Data Flows from SQL Server to Google Contacts through SSIS
Easily push SQL Server data to Google Contacts using the CData SSIS Tasks for Google Contacts.
-
Publish Crystal Reports on Landbot Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Landbot.
-
Using the CData Software ODBC Driver for Simplesat in PyCharm
Connect to Simplesat as an ODBC data source in PyCharm using the CData Software ODBC Driver for Simplesat.