CData Software - Knowledge Base
Recent Articles
-
Integrate Live SingleStore Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SingleStore and integrate live SingleStore into apps built in Microsoft Power Apps.
-
Integrate LibreChat with Live IBM Informix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live IBM Informix from within the chat interface.
-
Viewing MessageBird Data in RAD Studio Data Explorer
How to view MessageBird in RAD Studio Data Explorer using the CData ODBC Driver for MessageBird.
-
How to Access Live Hubstaff Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Hubstaff enables you to integrate Hubstaff into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Sage 300 Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Sage 300 replication to OneLake in Microsoft Fabric.
-
Connect to Asana Data in Claris FileMaker Pro
Use the CData ODBC Driver for Asana in FileMaker Pro to connect to Asana and work with Asana in your FileMaker applications.
-
Use the CData ODBC Driver for Productboard in Microsoft Power Query
You can use the CData Productboard ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Productboard into Microsoft Power Query.
-
Build Salesforce Pardot-Connected Apps in Choreo
Use CData Connect AI to connect to Salesforce Pardot Data from Choreo and build custom apps using live Salesforce Pardot.
-
Automated Sugar CRM Data Replication to Teradata
Use CData Sync to Customize and automate Sugar CRM replication to Teradata.
-
How to publish and share Nuclia Data dashboards with Tableau Server
The CData ODBC driver for Nuclia enables you integrate Nuclia into Tableau dashboards.
-
How to Build an ETL App for Calendly Data in Python with CData
Create ETL applications and real-time data pipelines for Calendly in Python with petl.
-
How to Query Live Redis Data in Perplexity MacOS Desktop
Connect to and query live Redis Data in Perplexity Desktop using CData MCP Server.
-
Query Exa Data as a MySQL Database in Node.js
Execute MySQL queries against Exa from Node.js.
-
Connect to ElevenLabs Data in RazorSQL
Connect to ElevenLabs from wizards and query ElevenLabs from the GUI in the RazorSQL database management tool.
-
How to use SQLAlchemy ORM to access ZohoDesk Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ZohoDesk.
-
Access Live Avalara AvaTax Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Avalara AvaTax through MCP integration.
-
Import and Visualize Microsoft Dataverse Data in Power View
Create data visualizations based on Microsoft Dataverse (CDS) in Excel.
-
Use the CData ODBC Driver for Oracle Financials Cloud in Microsoft Power Query
You can use the CData Oracle Financials Cloud ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Oracle Financials Cloud into Microsoft Power Query.
-
Replicate Multiple ConstantContact Accounts
Replicate multiple ConstantContact accounts to one or many databases.
-
Automated Continuous Box Replication to Vertica
Use CData Sync for automated, continuous, customizable Box replication to Vertica.
-
Integrating Antigravity CLI with Parallel via CData CLI
Connect Parallel to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Spotify Data in CloverDX (formerly CloverETL)
Transfer Spotify using the visual workflow in the CloverDX data integration tool.
-
Establish a Live Connection with Google Sheets Data using Tableau Bridge
The CData ODBC Driver for Google Sheets enables you to integrate live Google Sheets into Tableau Cloud dashboards using the Tableau Bridge.
-
Analyze Sage Cloud Accounting Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Sage Business Cloud Accounting and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Operational Reporting on Freshsales Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Freshsales.
-
Automated Continuous MarkLogic Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable MarkLogic replication to delimited files (CSV/TSV).
-
How to Connect to Live Authorize.Net 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 Authorize.Net for you.
-
Automate Microsoft Exchange Data Replication to SAP HANA
Use CData Sync to customize and automate Microsoft Exchange replication to SAP HANA.
-
Automated Continuous FHIR Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable FHIR replication to Apache Cassandra.
-
Creating Azure Data Lake Storage-Connected Applications in Unqork
You can use CData Connect AI to feed Azure Data Lake Storage to Unqork and build custom business apps.
-
Build an OLAP Cube in SSAS from FreshBooks Data
Establish a connection to FreshBooks data from SQL Server Analysis Services, and use the FreshBooks Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access MailChimp Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access MailChimp from your Oracle system.
-
Natively Connect to Humanity Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Humanity. Leverage the native support for ODBC in PHP.
-
Access Live Pipedrive Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Pipedrive in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData Software JDBC Driver for CircleCI in MicroStrategy Desktop
Connect to CircleCI in MicroStrategy Desktop using the CData Software JDBC Driver for CircleCI.
-
DataBind Charts to Oracle HCM Cloud Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle HCM Cloud 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.
-
Trigger Redis IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Redis with standard wizards in Logic Apps.
-
Connect to Brex Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Brex to connect to Brex and execute queries in PowerBuilder.
-
Work with Amazon Marketplace Data in FoxPro
Load Amazon Marketplace into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to ZohoSubscriptions Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ZohoSubscriptions and work with ZohoSubscriptions in your FileMaker applications.
-
How to integrate ZohoSubscriptions with Apache Airflow
Access and process ZohoSubscriptions in Apache Airflow using the CData JDBC Driver.
-
Working with Keap Data in LINQPad
Execute LINQ queries to Keap in LINQPad.
-
Rapidly Develop Bullhorn CRM-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Bullhorn CRM.
-
Access Live GitHub Data in TIBCO Data Virtualization
Use the GitHub Tibco DV Adapter to create a GitHub data source in TIBCO Data Virtualization Studio and gain access to live GitHub from your TDV Server.
-
Connect to LDAP Objects as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for LDAP.
-
How to Connect to Live eBay Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your eBay for you.
-
How to Access LeadDesk Data Using Entity Framework
This article shows how to access LeadDesk using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrating Antigravity CLI with Procore via CData CLI
Connect Procore to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Analyze Trello Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Trello and visualize live Trello in Infragistics Reveal.
-
How to Seamlessly Import Zoho Projects Data into IBM SPSS Modeler
Integrate Zoho Projects data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Troubleshoot QuickBooks Errors
In this entry you will find resolutions for the most common issues that can occur while connecting to QuickBooks.
-
How to Query Live Superchat Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Superchat data in natural language using Python.
-
How to create SAS xpt federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAS XPORT in MySQL .
-
Automated Neo4J Data Replication to Teradata
Use CData Sync to Customize and automate Neo4J replication to Teradata.
-
Use JayDeBeApi to access SAS Data Sets Data in Python
Use standard Python scripting and the development environment of your choice to access live SAS Data Sets.
-
Build AI/ML Models with Live Typeform Data using Dataiku
Connect Typeform Data with Dataiku using the CData API Driver for JDBC.
-
Import and Visualize Freshsales Data in Power View
Create data visualizations based on Freshsales in Excel.
-
Import Real-Time Aircall Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Aircall in ColdFusion.
-
Analyze Google Forms Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Forms from Power Pivot. You will use the Table Import Wizard to load Google Forms. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Codex CLI with Microsoft SharePoint 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.
-
Integrate Goose with Live Airtable Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Airtable from within the local AI agent.
-
Automated Continuous AgileCRM Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable AgileCRM replication to PostgreSQL.
-
Access JobNimbus Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for JobNimbus.
-
How to Build an ETL App for Google Directory Data in Python with CData
Create ETL applications and real-time data pipelines for Google Directory in Python with petl.
-
Connect to eBay 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 eBay.
-
Using the CData Software ODBC Driver for Redshift in PyCharm
Connect to Redshift as an ODBC data source in PyCharm using the CData Software ODBC Driver for Redshift.
-
Integrating Antigravity CLI with Google Ads via CData CLI
Connect Google Ads to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Feed HDFS Data into FineReport
How to set Apache HDFS as a JDBC data source in FineReport.
-
Connect to Mouseflow Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Mouseflow and the SQL Gateway to access Mouseflow from Google Apps Script.
-
Connecting Mastra with CockroachDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time CockroachDB, no replication required.
-
Automate Cassandra Data Replication to Azure Synapse
Use CData Sync to customize and automate Apache Cassandra replication to Azure Synapse.
-
Connect to and Visualize Live GitLab Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live GitLab.
-
Publish Reports with Sage Intacct Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sage Intacct.
-
Connect to Sage Cloud Accounting Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Sage Cloud Accounting Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Reports from Zoho Inventory Data in Looker Studio
Use CData Connect AI to gain access to live Zoho Inventory and create custom reports in Looker Studio.
-
Automated Continuous Zuora Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Zuora replication to Apache Kafka.
-
Connect to Amazon DynamoDB in SpagoBI
Create reports featuring live Amazon DynamoDB in SpagoBI Studio. Host Amazon DynamoDB reports on SpagoBI Server.
-
Create Reports from Kintone Data in Looker Studio
Use CData Connect AI to gain access to live Kintone and create custom reports in Looker Studio.
-
Connect to Twitter Ads Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Twitter Ads from Filemaker Pro on Mac.
-
Build Apps with Live HCL Domino Data Using the Low-Code Development Platform of Mendix
Connect HCL Domino with Mendix to build apps using the CData JDBC Driver for HCL Domino.
-
Integrating Claude Code CLI with SendInBlue 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.
-
Build Confluence-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Atlassian Confluence.
-
Use the CData Software ODBC Driver for Salesforce Marketing in SAS for Real-Time Reporting and Analytics
Connect to real-time Salesforce Marketing Cloud in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Salesforce Marketing.
-
How to create an RPA flow for Contentful Data in UiPath Studio
Use the Contentful ODBC Driver to create workflows that access real-time Contentful without any coding.
-
How to Connect Flowise AI Agents to Live Lakebase 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 Lakebase without replication.
-
Visualize SAS Data Sets Data in TIBCO Spotfire through ADO.NET
Integrate SAS Data Sets into dashboards in TIBCO Spotfire.
-
Use the CData Software ODBC Driver for JobNimbus in MicroStrategy Desktop
Connect to JobNimbus in MicroStrategy Desktop using the CData Software ODBC Driver for JobNimbus.
-
How to Access Live Oracle Financials Cloud Data in Visual Studio Code via Cline
Run CData MCP Server for Oracle Financials Cloud on Windows Subsytem for Linux (WSL) and connect to live Oracle Financials Cloud from the Cline extension in Visual Studio Code.
-
Visualize Clari Data in TIBCO Spotfire through ADO.NET
Integrate Clari into dashboards in TIBCO Spotfire.
-
Integrating Cursor CLI with Oracle Sales 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.
-
Integrate Webflow Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Webflow from Informatica Cloud.
-
Use the CData API Server to Access Microsoft Teams Data in Microsoft PowerPivot
Use the CData API Server to connect to live Microsoft Teams in the Power Pivot business intelligence tool.
-
Validate Delighted Data with QuerySurge
Access and validate Delighted in QuerySurge using the CData JDBC Driver.
-
Process & Analyze Facebook Ads Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Facebook Ads Data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Avaza
Provide connectivity to Avaza through an SAP BusinessObjects universe.
-
Add Azure Table Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Azure Table with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Adobe Target to Power BI dashboards. Simply drag and drop Adobe Target into data visuals on the Power BI canvas.
-
Connecting Pipedream with CockroachDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on CockroachDB data in real time.
-
Automated Continuous LDAP Replication to Oracle
Use CData Sync for automated, continuous, customizable LDAP replication to Oracle.
-
Import SAP Fieldglass Data Using Azure Data Factory
Use CData Connect AI to connect to SAP Fieldglass Data from Azure Data Factory and import live SAP Fieldglass.