CData Software - Knowledge Base
Recent Articles
-
How to Access Live SAS Data Sets Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAS Data Sets enables you to integrate SAS Data Sets into workflows built using Microsoft Power Automate Desktop.
-
DataBind Controls to Workday Data in Delphi
DataBind to Workday in Delphi with standard data access components and controls.
-
Use Biml to Build SSIS Tasks to Replicate Google Directory Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Directory to SQL Server.
-
Visualize Dynamics CRM Data in TIBCO Spotfire through ADO.NET
Integrate Microsoft Dynamics CRM into dashboards in TIBCO Spotfire.
-
Integrate LibreChat with Live Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google Sheets from within the chat interface.
-
Build Salesforce Pardot-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Salesforce Pardot and build web apps with connectivity to live Salesforce Pardot.
-
Use the CData ODBC Driver for ClickUp in Microsoft Power Query
You can use the CData ClickUp ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ClickUp into Microsoft Power Query.
-
How to Create Power BI Visual Reports with Real-Time CloudConvert Data
Use CData Power BI Connectors to visualize CloudConvert in Power BI.
-
Connect to SurveyMonkey Data from a Connection Pool in Jetty
The SurveyMonkey JDBC Driver supports connection pooling: This article shows how to connect faster to SurveyMonkey from Web apps in Jetty.
-
Connect to Templated in SpagoBI
Create reports featuring live Templated in SpagoBI Studio. Host Templated reports on SpagoBI Server.
-
A Comparison of Database Drivers for SQL Server
A performance comparison of the CData JDBC Driver for SQL Server and the native JDBC Driver for SQL Server (updated May 2020)
-
How to integrate Metabase with Zoho Inventory Data
Use CData Connect AI to connect to live Zoho Inventory and create an interactive dashboard in Metabase from Zoho Inventory.
-
Automated Continuous API Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable API replication to Google Cloud SQL.
-
Access Live NetSuite Data in AWS Lambda
Connect to live NetSuite CRM & ERP in AWS Lambda using the CData JDBC Driver.
-
How to work with Google Drive Data in Apache Spark using SQL
Access and process Google Drive Data in Apache Spark using the CData Software JDBC Driver.
-
Manage JDBC-ODBC Bridge Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for JDBC-ODBC Bridge.
-
Integrate API Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to API and integrate live API into your Power Automate tasks.
-
How to Easily Query Bullhorn CRM Data in OpenOffice Base
Connect to Bullhorn CRM data in OpenOffice Base using the CData ODBC Driver for Bullhorn CRM and generate reports with live data insights.
-
Connect to SAP Netweaver Gateway Data in Aqua Data Studio
Access SAP Netweaver Gateway from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Reports from SAP Hybris C4C Data in Looker Studio
Use CData Connect AI to gain access to live SAP Hybris C4C and create custom reports in Looker Studio.
-
Create MYOB AccountRight-Connected Nintex Workflows
Use CData Connect AI to connect to MYOB AccountRight Data from Nintex Workflow Cloud and build custom workflows using live MYOB AccountRight.
-
How to Query Live MessageBird Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live MessageBird data in natural language using Python.
-
How to Design Kafka Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Kafka from mobile and tablet Power Apps.
-
Integrating OpenCode Terminal with EnterpriseDB 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.
-
Visualize Couchbase 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 Couchbase into TIBCO Spotfire.
-
Build Freshsales-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Freshsales and build web apps with connectivity to live Freshsales.
-
Use Databricks Agent Bricks to Talk to Your Cassandra Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Apache Cassandra for you.
-
Use Grok to Talk to Your EnterpriseDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your EnterpriseDB for you.
-
How to Query Live Oracle Sales Data in Perplexity MacOS Desktop
Connect to and query live Oracle Sales Data in Perplexity Desktop using CData MCP Server.
-
Integrating Claude Code CLI with Brex 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.
-
Natively Connect to LeadDesk Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to LeadDesk. Leverage the native support for ODBC in PHP.
-
Build Dashboards with SAP ByDesign Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP Business ByDesign in Dundas BI.
-
Getting Started with the CData Tableau Connector for Cloudflare
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build Google Ads-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Google AdWords to explore live Google Ads Data in GitHub Copilot to assist with building Google Ads-powered applications.
-
Natively Connect to Moosend Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Moosend. Leverage the native support for ODBC in PHP.
-
Build DB2-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for IBM DB2 to explore live DB2 Data in Cursor to assist with building DB2-powered applications.
-
Integrate with Clio Data in JReport Designer
Create charts and reports based on Clio in JReport Designer.
-
Integrating Cursor CLI with Chargebee 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.
-
Getting Started with the CData SSIS Components for Jumpseller
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Jumpseller.
-
Replicate Multiple Act-On Accounts
Replicate multiple Act-On accounts to one or many databases.
-
Query JotForm Data through ODBC in Node.js
Use node-odbc to execute SQL queries against JotForm from Node.js.
-
How to create an RPA flow for Google Ads Data in UiPath Studio
Use the Google Ads ODBC Driver to create workflows that access real-time Google Ads without any coding.
-
Use Microsoft Copilot Studio to talk to your Google Drive 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 Google Drive for you.
-
Create Apps from Freshdesk Data in Qlik Sense Cloud
Use CData Connect AI to connect to Freshdesk Data and build apps from live Freshdesk in Qlik Sense Cloud.
-
Use Dash to Build to Web Apps on Sugar CRM Data
Create Python applications that use pandas and Dash to build Sugar CRM-connected web apps.
-
Build AI/ML Models with Live Klaviyo Data using Dataiku
Connect Klaviyo Data with Dataiku using the CData JDBC Driver for Klaviyo.
-
Use the CData Software JDBC Driver for Avro in MicroStrategy Desktop
Connect to Apache Avro in MicroStrategy Desktop using the CData Software JDBC Driver for Avro.
-
How to Work with Mocean Data in AWS Glue Jobs Using JDBC
Connect to Mocean from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Migrating data from SAS xpt to Google BigQuery using CData SSIS Components.
Easily push SAS XPORT to Google BigQuery using the CData SSIS Tasks for SAS xpt and Google BigQuery.
-
Use Grok to Talk to Your Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Procore for you.
-
Build SurveyMonkey-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for SurveyMonkey to explore live SurveyMonkey Data in Cursor to assist with building SurveyMonkey-powered applications.
-
Visualize Live Google Directory Data in the Power BI Service
Use CData Connect AI to connect to live Google Directory and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous SpaceX Replication to Vertica
Use CData Sync for automated, continuous, customizable SpaceX replication to Vertica.
-
Integrate LibreChat with Live Square Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Square from within the chat interface.
-
Work with Azure DevOps Data in FoxPro
Load Azure DevOps into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software JDBC Driver for Mocean in MicroStrategy Desktop
Connect to Mocean in MicroStrategy Desktop using the CData Software JDBC Driver for Mocean.
-
Create Basecamp-Connected Nintex Workflows
Use CData Connect AI to connect to Basecamp Data from Nintex Workflow Cloud and build custom workflows using live Basecamp.
-
Access Live Office 365 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 Microsoft Office 365 through MCP integration.
-
Replicate CampaignMonitor Data in Heroku for Use in Salesforce Connect
Replicate CampaignMonitor to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to and Query VWO Data in QlikView over ODBC
Create data visualizations with VWO in QlikView.
-
Extend Google Sheets with Zoho CRM Data
Make calls to Zoho CRM from Google Apps Script via the API Server.
-
Publish Crystal Reports on ActiveCampaign Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ActiveCampaign.
-
Build Visualizations of Zoho Projects Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zoho Projects in Birst.
-
Trigger SAP SuccessFactors IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SAP SuccessFactors with standard wizards in Logic Apps.
-
Automated Continuous Bitbucket Replication to Databricks
Use CData Sync for automated, continuous, customizable Bitbucket replication to Databricks.
-
Connect to Bright Data Data in RapidMiner
Integrate Bright Data with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Dynamic Marketo Grids Using the Infragistics XamDataGrid
Learn how you can connect Marketo to Infragistics XamDataGrid to build dynamic grids.
-
How to Query Live Suadeo Data in Claude Desktop
Connect to and query live Suadeo Data in Claude Desktop using CData MCP Server.
-
Access MySQL Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live MySQL from HeidiSQL.
-
Use Grok to Talk to Your DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your IBM DB2 for you.
-
Integrate Live Oracle Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Oracle Database and integrate live Oracle Database into apps built in Microsoft Power Apps.
-
How to connect to DocuSign Data with Squirrel SQL client
Connect to DocuSign and execute queries in the Squirrel SQL Client.
-
How to connect and process Optimizely from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Optimizely.
-
Design BIRT Reports on eBay Data
Provide current eBay to your embedded analytics.
-
Connect to and Visualize Live OpenWeatherMap Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live OpenWeatherMap.
-
Design BIRT Reports on ScrapingBee Data
Provide current ScrapingBee to your embedded analytics.
-
Connect to SAS Data Sets Data in Aqua Data Studio
Access SAS Data Sets from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build a PostgreSQL Interface for Insightly Data using the CData JDBC Driver
Use the Remoting features of the Insightly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query, Visualize, and Share live Phoenix Data in Redash
Use CData Connect AI to connect to live Apache Phoenix in Redash for querying, visualizing, and sharing.
-
Replicate Multiple Salesforce Pardot Accounts
Replicate multiple Salesforce Pardot accounts to one or many databases.
-
Connect to Databricks Data from PowerBuilder via ADO.NET
This article demonstrates how to access Databricks from Appeon PowerBuilder using the CData ADO.NET Provider for Databricks.
-
Automated ShipStation Data Replication to Teradata
Use CData Sync to Customize and automate ShipStation replication to Teradata.
-
Connect to Kintone Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Kintone and the SQL Gateway to access Kintone from Google Apps Script.
-
Automated Continuous Intercom Replication to SingleStore
Use CData Sync for automated, continuous, customizable Intercom replication to SingleStore.
-
Create Informatica Mappings From/To a JDBC Data Source for JSON
Create JSON data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query Rootly Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Rootly entities in PHP by modeling them as objects.
-
Load ZohoInvoice Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ZohoInvoice to a database.
-
How to Connect to BigQuery Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google BigQuery. Leverage the pyodbc module for ODBC in Python.
-
Connect to Opsgenie Data in RazorSQL
Connect to Opsgenie from wizards and query Opsgenie from the GUI in the RazorSQL database management tool.
-
How to connect SharePoint with Tally Data through external lists
Provide Tally ERP to SharePoint users as an external list.
-
How to connect to Mocean Data from IntelliJ
Integrate connectivity to Mocean with wizards in IntelliJ.
-
Automated Continuous ZohoSubscriptions Replication to Vertica
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Vertica.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Google Ad Manager to Power BI dashboards. Simply drag and drop Google Ad Manager into data visuals on the Power BI canvas.
-
Connect to IBM Informix Data in DBArtisan
Use wizards in DBArtisan to configure IBM Informix as a data source.
-
Extend Google Sheets with Pipeliner CRM Data
Make calls to Pipeliner CRM from Google Apps Script via the API Server.
-
How to Query Live Mouseflow Data in Perplexity MacOS Desktop
Connect to and query live Mouseflow Data in Perplexity Desktop using CData MCP Server.
-
Create Tally-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Tally Data from OutSystems and build custom enterprise apps using live Tally ERP.
-
Build Apps with Live Zoho Projects in Adalo using CData Connect AI
Use CData Connect AI to integrate live Zoho Projects into the Adalo platform and build custom mobile and web applications with real-time Zoho Projects.
-
Integrate Microsoft Planner Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Microsoft Planner and integrate live Microsoft Planner into your Power Automate tasks.
-
Integrate with live Xero Data in Jitterbit
Use CData Connect AI to connect to and integrate live Xero Accounting in Jitterbit.