CData Software - Knowledge Base
Recent Articles
-
Create GraphQL-Connected Nintex Workflows
Use CData Connect AI to connect to GraphQL Data from Nintex Workflow Cloud and build custom workflows using live GraphQL data.
-
Connect to Paylocity Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Paylocity as an External Source in Dremio.
-
A PostgreSQL Interface for Salesforce Data using the CData ODBC Driver
Use the SQL Gateway and Salesforce ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Spotify Data Replication to Couchbase
Use CData Sync to Customize and automate Spotify data replication to Couchbase.
-
Connect to Webflow Data in Aqua Data Studio
Access Webflow data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to create Drip federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Drip data in MySQL .
-
Build a Simple VCL Application for Missive Data
How to build a simple VCL Application to view Missive data in RAD Studio using the CData ODBC Driver for Missive.
-
Build Visualizations of Autopilot Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Autopilot data in Birst.
-
How to connect to BigQuery Data in DBVisualizer
Integrate BigQuery data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Dify with Live Greenplum 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 Greenplum data.
-
Integrating Kiro with IBM Cloud Object Storage 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.
-
How to Connect to Live Sage 300 Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Sage 300 data for you.
-
Connect to Live Power BI XMLA Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Power BI XMLA in CData Connect AI and connect to your Power BI XMLA data from PostgreSQL.
-
Integrate LibreChat with Live SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SAP Hybris C4C data from within the chat interface.
-
Query Google Spanner Data in DataGrip
Create a Data Source for Google Spanner in DataGrip and use SQL to query live Google Spanner data.
-
Integrating Claude Code CLI with Mistral AI 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 Freshdesk from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Freshdesk data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Query Live Amazon S3 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 Amazon S3 data through a conversational interface.
-
Automated Continuous ZohoMarketingHub Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to delimited files (CSV/TSV).
-
Create Oracle Sales-Connected Business Apps in AppSheet
Connect to Oracle Sales Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Oracle Sales data.
-
Build Google Drive-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Drive data.
-
Process & Analyze Paddle Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Paddle Data.
-
Create SSAS Tabular Models from Neo4J Data
How to build a SQL Server Analysis Service Tabular Model from Neo4J data using CData drivers.
-
Integrating LangChain with Certinia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Certinia data within automated workflows.
-
Automated Continuous Tickspot Replication to Vertica
Use CData Sync for automated, continuous, customizable Tickspot replication to Vertica.
-
Import and Visualize Rootly Data in Power View
Create data visualizations based on Rootly data in Excel.
-
Build Pipelines with Live Lakebase Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Lakebase from Google Cloud Data Fusion, enabling the integration of live Lakebase data into the building and management of effective data pipelines.
-
Connect to GraphQL Data from PowerBuilder via ADO.NET
This article demonstrates how to access GraphQL data from Appeon PowerBuilder using the CData ADO.NET Provider for GraphQL.
-
Use the CData Software JDBC Driver for Retently in MicroStrategy Desktop
Connect to Retently data in MicroStrategy Desktop using the CData Software JDBC Driver for Retently.
-
Prepare, Blend, and Analyze Parquet Data in Alteryx Designer (ODBC)
Build workflows to access live Parquet data for self-service data analytics.
-
Access Live Sybase IQ Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sybase IQ data from your Excel spreadsheets.
-
Connect to Square in SpagoBI
Create reports featuring live Square data in SpagoBI Studio. Host Square reports on SpagoBI Server.
-
Analyze HBase Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of HBase data and visualize live HBase data in Infragistics Reveal.
-
Replicate GetResponse Data from PowerShell
Write a quick PowerShell script to query GetResponse data. Use connectivity to the live data to replicate GetResponse data to SQL Server.
-
How to Visualize Paymo Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Paymo data in Python.
-
Create ZohoInvoice Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ZohoInvoice data access from reports, embedded analytics, and more.
-
Getting Started with the CData Connect AI Python SDK for Cassandra
Install the CData Connect AI Python SDK to read and write live Cassandra data with standard DB-API 2.0 Python code.
-
Connect to Facebook in SpagoBI
Create reports featuring live Facebook data in SpagoBI Studio. Host Facebook reports on SpagoBI Server.
-
Integrating LangGraph with CockroachDB Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on CockroachDB data within automated workflows.
-
Use the CData ODBC Driver for HBase in Microsoft Power Query
You can use the CData HBase ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import HBase data into Microsoft Power Query.
-
Integrating Claude Code CLI with FTP 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.
-
Use Databricks Agent Bricks to Talk to Your Square Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Square data for you.
-
Replicate Multiple SendInBlue Accounts
Replicate multiple SendInBlue accounts to one or many databases.
-
Automated Continuous Outlook Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Outlook replication to Amazon S3.
-
Import Real-Time Power BI XMLA Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Power BI XMLA data in ColdFusion.
-
Connect to AfterShip Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for AfterShip to connect to AfterShip data and execute queries in PowerBuilder.
-
How to Connect to Live CSV 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 CSV data for you.
-
How to connect to Greenhouse Data from IntelliJ
Integrate connectivity to Greenhouse data with wizards in IntelliJ.
-
Connect to Sage Cloud Accounting Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Sage Cloud Accounting.
-
Automate Avro Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Avro data from PowerShell? This article demonstrates how to utilize the Avro Cmdlets for tasks like connecting to Avro data, automating operations, downloading data, and more.
-
Use the CData Software ODBC Driver for Elasticsearch in MicroStrategy
Connect to Elasticsearch data in MicroStrategy Developer using the CData Software ODBC Driver for Elasticsearch.
-
Connect to SingleStore Data in Aqua Data Studio
Access SingleStore data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to and Query Shortcut Data in QlikView over ODBC
Create data visualizations with Shortcut data in QlikView.
-
How to Connect to & Open Invoiced Data in Microsoft Excel
This article uses the CData ODBC driver for Invoiced to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize Live SuiteCRM Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SuiteCRM data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Work with Gong Data in ETL Validator JDBC
Connect to Gong from ETL Validator jobs using the CData Software JDBC Driver.
-
Query Browserless Data as a MySQL Database in Node.js
Execute MySQL queries against Browserless data from Node.js.
-
Migrating data from SuiteCRM to Snowflake using CData SSIS Components.
Easily push SuiteCRM data to Snowflake using the CData SSIS Tasks for SuiteCRM and Snowflake.
-
Import Real-Time Azure Data Catalog Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Azure Data Catalog data in ColdFusion.
-
Automated Continuous Dynamics NAV Replication to Databricks
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Databricks.
-
Build Teamwork-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Teamwork data and build web apps with connectivity to live Teamwork data.
-
Access Live Exa Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Exa data from your Google Sheets.
-
Visualize Live MailChimp Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live MailChimp data into custom reports in Power BI.
-
Connect and Query Live Azure Analysis Services Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Azure Analysis Services data into Databricks and enable direct, live querying and analysis without replication.
-
Build Semantic Layer Views for ServiceNow Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for ServiceNow data.
-
Connect to EnterpriseDB Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to EnterpriseDB.
-
How to connect PolyBase to Onfleet
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Onfleet data.
-
Seamlessly Bring Zoho Projects Data into Retool Using CData Connect AI
Integrate Zoho Projects data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build a Singer.io Tap for Strava With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Strava data using the CData Python Connector.
-
View Reports on Real-Time Guru Data in Power BI Report Server
Use the CData ODBC Driver for Guru to visualize Guru data in Power BI Desktop and then publish them to Power BI Report Server.
-
Visualize SAP HANA Data in TIBCO Spotfire through ADO.NET
Integrate SAP HANA data into dashboards in TIBCO Spotfire.
-
Access Teamgate Data from MySQL in PHP
Connect to Teamgate through the standard MySQL libraries in PHP.
-
Analyze NetSuite Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of NetSuite data and visualize NetSuite data in SAP Analytics Cloud.
-
Connect to SingleStore from a Connection Pool in WebLogic
Use the CData JDBC Driver for SingleStore to connect to SingleStore data from Web applications running on WebLogic.
-
Visualize SAP Data in Tableau
The CData ODBC driver for SAP enables you integrate SAP data into Tableau dashboards.
-
Integrating Gumloop with Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Pipedrive data within automated workflows.
-
Use the CData ODBC Driver for Teamwork from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Teamwork to connect to Teamwork data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Teamwork data in Excel.
-
Build Adobe Experience Manager-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Adobe Experience Manager data.
-
Connect to Monday.com Data in Claris FileMaker Pro
Use the CData ODBC Driver for Monday.com in FileMaker Pro to connect to Monday.com and work with Monday.com data in your FileMaker applications.
-
How to import Figshare Data into Apache Solr
Use the CData Software JDBC Driver for Figshare in Data Import Handler and create an automated import of Figshare data to Apache Solr Enterprise Search platform.
-
Analyze xBase Data in Cognos Analytics
Use CData Connect AI to connect to xBase Data from Cognos Analytics and analyze live xBase data.
-
Replicate Databricks Data in Heroku for Use in Salesforce Connect
Replicate Databricks data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Operational Reporting on Jira Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Jira data.
-
Migrating data from CSV to Google BigQuery using CData SSIS Components.
Easily push CSV data to Google BigQuery using the CData SSIS Tasks for CSV and Google BigQuery.
-
How to connect to Microsoft Ads Data from IntelliJ
Integrate connectivity to Microsoft Ads data with wizards in IntelliJ.
-
Integrate Live Pipedrive Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Pipedrive from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Pipedrive data.
-
Connect to PabblySubscriptions Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to PabblySubscriptions.
-
How to Query Live ZohoPeople Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ZohoPeople data data in natural language using Python.
-
Connect to ClickUp Data in ACL Analytics
Connect to ClickUp data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to ClickUp data.
-
Build Apps with Live Google Translate Data Using the Low-Code Development Platform of Mendix
Connect Google Translate data with Mendix to build apps using the CData API Driver for JDBC.
-
Use Microsoft Copilot Studio to talk to your Zoho CRM 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 Zoho CRM data for you.
-
Connect to Templated Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Templated data.
-
Integrate Live ClickUp Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to ClickUp from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live ClickUp data.
-
Query Adobe Analytics Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Adobe Analytics data from Node.js.
-
Connect to Box Data in JRuby
Create a simple JRuby app with access to live Box data.
-
Query Amazon DynamoDB Data as a SQL Server Database in Node.js
Execute SQL Server queries against Amazon DynamoDB data from Node.js.
-
Consume QuickBooks Online OData Feeds in SAP Lumira
Use the API Server to create data visualizations on QuickBooks Online feeds that reflect any changes in SAP Lumira.
-
Replicate Optimizely Data in Heroku for Use in Salesforce Connect
Replicate Optimizely data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Getting Started with the CData Connect AI Python SDK for Google Campaign Manager 360
Install the CData Connect AI Python SDK to read and write live Google Campaign Manager 360 data with standard DB-API 2.0 Python code.
-
Add Excel Online Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Excel Online with the Informatica Enterprise Data Catalog to classify and organize data.