CData Software - Knowledge Base
Recent Articles
-
Connecting Mastra with FreshBooks 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 FreshBooks data, no replication required.
-
Integrate Devin with Live Freshteam 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 Freshteam data.
-
DataBind Controls to CSV Data in Delphi
DataBind to CSV data in Delphi with standard data access components and controls.
-
How to connect to Oracle Sales Data in DBVisualizer
Integrate Oracle Sales data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build ShipEngine Visualizations in Tableau Desktop
Use CData Connect AI to connect to live ShipEngine data and build visualizations in Tableau.
-
Automate Perplexity Data Replication to Couchbase
Use CData Sync to Customize and automate Perplexity data replication to Couchbase.
-
How to connect PolyBase to CloudConvert
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live CloudConvert data.
-
Build an OLAP Cube in SSAS from Salesforce Marketing Data
Establish a connection to Salesforce Marketing data data from SQL Server Analysis Services, and use the Salesforce Marketing Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Front 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 Front and work with Front data in your FileMaker application.
-
Connect to Real-Time xBase Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for xBase and Dataflow to import and use xBase data in Power Apps.
-
Replicate Recurly Data to Multiple Databases
Replicate Recurly data to disparate databases with a point-and-click configuration.
-
Working with Active Directory Data in LINQPad
Execute LINQ queries to Active Directory data in LINQPad.
-
Build Apps with Live Tally data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Tally data into the Adalo platform and build custom mobile and web applications with real-time Tally data.
-
Build Dashboards with Hacker News Data in Dundas BI
Create dynamic dashboards and perform analytics based on Hacker News data in Dundas BI.
-
Getting Started with the CData Connect AI Python SDK for Exa
Install the CData Connect AI Python SDK to read live Exa data with standard DB-API 2.0 Python code.
-
Integrating Boomi Agentstudio with Azure Table Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Azure Table data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Visualize IBM Cloud Object Storage Data in TIBCO Spotfire through ADO.NET
Integrate IBM Cloud Object Storage data into dashboards in TIBCO Spotfire.
-
View Reports on Real-Time Snapchat Ads Data in Power BI Report Server
Use the CData ODBC Driver for Snapchat Ads to visualize Snapchat Ads data in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Gong-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Gong Data from Zoho Analytics and import live Gong data.
-
Build Dashboards with Apollo Data in DBxtra
Create dynamic dashboards and perform analytics based on Apollo data in DBxtra.
-
Access Live Snapchat Ads Data in Coginiti Pro
Connect to and query live Snapchat Ads data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live Blackbaud FE NXT Data in TIBCO Data Virtualization
Use the Blackbaud FE NXT Tibco DV Adapter to create a Blackbaud FE NXT data data source in TIBCO Data Virtualization Studio and gain access to live Blackbaud FE NXT data from your TDV Server.
-
Integrating Claude Code CLI with PDFMonkey 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.
-
DataBind Charts to Telegram Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Telegram data 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.
-
Explore Geographical Relationships in SuiteCRM Data with Power Map
Create data visualizations with SuiteCRM data in Power Map.
-
Automated Continuous RabbitMQ Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable RabbitMQ replication to Apache Kafka.
-
Back Up ZohoDesk data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with ZohoDesk data data.
-
Getting Started with the CData Excel Add-In for Gorgias
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Gorgias.
-
Work with Sentry Data in FoxPro
Load Sentry data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build AlloyDB-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 AlloyDB data without replication.
-
Edit and Search External OneNote Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of OneNote data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create OneNote Data objects that you can access from apps and the dashboard.
-
Integrate Certinia Data into Power Automate Desktop using CData Connect
CData Connect for Certinia Data enables you to integrate Certinia data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Live ZohoInvoice Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to ZohoInvoice data and integrate live ZohoInvoice data into apps built in Microsoft Power Apps.
-
Query Live SAP Ariba Procurement Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live SAP Ariba Procurement data directly from the development environment.
-
Automate Cloudflare Data Replication to Couchbase
Use CData Sync to Customize and automate Cloudflare data replication to Couchbase.
-
Connect to Oracle from Asprova with CData Software ODBC Driver for Oracle
This article shows how to connect faster to Oracle data from Asprova.
-
Use Azure AI Foundry to Talk to Your Microsoft Planner 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 Microsoft Planner data for you.
-
Access Live Azure Data Catalog Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Azure Data Catalog data from your Excel spreadsheets.
-
Replicate Browserless Data to Multiple Databases via the CData Sync CLI
Replicate Browserless data to disparate databases with a single configuration.
-
Automated Couchbase Data Replication to Teradata
Use CData Sync to Customize and automate Couchbase data replication to Teradata.
-
Connect to Bright Data Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Bright Data Data and connect to Bright Data data in Akorbi Digital RunMyProcess.
-
Connect to SendInBlue Data in Aqua Data Studio
Access SendInBlue data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Deploy the ADO.NET Provider for Azure Analysis Services on an SSRS Report Server
Connect to Azure Analysis Services 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.
-
Build a Simple VCL Application for Google Ads Data
How to build a simple VCL Application to view Google Ads data in RAD Studio using the CData ODBC Driver for Google Ads.
-
Connect to HBase Data from a Connection Pool in JBoss
Integrate HBase data into Java servlets: Use the Management Console in JBoss to install the HBase JDBC Driver.
-
Access Live Guru Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Guru data into the statistical analysis tools available in SAS JMP. This article shows how to use Guru data in the Graph Builder and Query Builder.
-
Getting Started with the CData Python Connector for Couchbase
Learn to install and license the CData Python Connector and configure a connection to live Couchbase data.
-
Use Grok to Talk to Your Cosmos DB 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 Cosmos DB data for you.
-
Use Dash to Build to Web Apps on Workday Data
Create Python applications that use pandas and Dash to build Workday-connected web apps.
-
Analyze Google Forms Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google Forms data in Microsoft R Open.
-
Connect to Onfleet 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 Onfleet and work with Onfleet data in your FileMaker application.
-
Rapidly Develop Amazon DynamoDB-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 Amazon DynamoDB.
-
Build AI/ML Models with Live Discourse Data using Dataiku
Connect Discourse Data with Dataiku using the CData API Driver for JDBC.
-
Migrating data from Sugar CRM to Databricks using CData SSIS Components.
Easily push Sugar CRM data to Databricks using the CData SSIS Tasks for Sugar CRM and Databricks.
-
Templated Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Templated facts in real time.
-
Integrate JotForm Data in Pentaho Data Integration
Build ETL pipelines based on JotForm data in the Pentaho Data Integration tool.
-
Automated Continuous Attio Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Attio replication to IBM DB2.
-
Connect to Salesforce Data 360 Data in RazorSQL
Connect to Salesforce Data 360 from wizards and query Salesforce Data 360 data from the GUI in the RazorSQL database management tool.
-
Access Live Cloudflare Data in AWS Lambda
Connect to live Cloudflare data in AWS Lambda using the CData JDBC Driver.
-
Access Live Snowflake Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Snowflake data into the statistical analysis tools available in SAS JMP. This article shows how to use Snowflake data in the Graph Builder and Query Builder.
-
Replicate Close Data to Multiple Databases via the CData Sync CLI
Replicate Close data to disparate databases with a single configuration.
-
Use Manus AI to Talk to Your SuiteCRM 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 SuiteCRM data.
-
Use the CData ODBC Driver for Zoho CRM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Zoho CRM to connect to Zoho CRM data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Zoho CRM data in Excel.
-
How to Connect to Live Monday.com Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Monday.com data through natural language.
-
Connect to Testmonitor 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 Testmonitor and work with Testmonitor data in your FileMaker application.
-
Back Up Salesforce Marketing data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Salesforce Marketing. In this article, we will employ an SSIS workflow to populate a database with Salesforce Marketing data data.
-
Interact with Live SAP Business Warehouse Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SAP Business Warehouse data.
-
Integrating LangChain with ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on ADP data within automated workflows.
-
How to create Smartsheet federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Smartsheet data in MySQL .
-
Use Dash to Build Web Apps on Azure DevOps Data via CData Connect AI
Build interactive Dash web apps on live Azure DevOps data using pandas and the CData Connect AI Python SDK.
-
Publish SAP Netweaver Gateway-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP Netweaver Gateway data.
-
How to Connect to & Open Recurly Data in Microsoft Excel
This article uses the CData ODBC driver for Recurly to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Automated Odoo-Connected Workflows in Zapier
Use CData Connect AI to connect to live Odoo data and build automated workflows in Zapier.
-
Automated Continuous FreshBooks Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable FreshBooks replication to Google Cloud SQL.
-
Migrating data from FormSite to Snowflake using CData SSIS Components.
Easily push FormSite data to Snowflake using the CData SSIS Tasks for FormSite and Snowflake.
-
Connecting Pipedream with Highrise 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 Highrise data in real time.
-
Integrate Discord with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Discord with External Services.
-
Build Bitbucket-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Bitbucket Data from Zoho Analytics and import live Bitbucket data.
-
DataBind Controls to SendInBlue Data in C++Builder
DataBind to SendInBlue data in C++Builder with standard components and controls.
-
Connect to Parallel Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Parallel.
-
Use ChatGPT to Talk to Your Paylocity 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 Paylocity data for you.
-
Use JayDeBeApi to access Omnisend Data in Python
Use standard Python scripting and the development environment of your choice to access live Omnisend data.
-
Query Paylocity Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Paylocity data from Node.js.
-
Automated Continuous QuickBooks Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable QuickBooks replication to PostgreSQL.
-
Dynamics 365 Business Central Reporting in OBIEE with the Dynamics 365 Business Central JDBC Driver
Deploy the Dynamics 365 Business Central JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Shippo Data in Ruby
Connect to Shippo data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Viewing HubDB Data in RAD Studio Data Explorer
How to view HubDB data in RAD Studio Data Explorer using the CData ODBC Driver for HubDB.
-
How to Connect to Live FreshBooks 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 FreshBooks data for you.
-
How to Connect to Brex Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Brex data. Leverage the pyodbc module for ODBC in Python.
-
Replicate HBase Data in Heroku for Use in Salesforce Connect
Replicate HBase data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Power BI Reports on Real-Time ShipStation Data
Use the CData ODBC Driver for ShipStation to visualize ShipStation data in Power BI Desktop.
-
Build an OLAP Cube in SSAS from Reckon Data
Establish a connection to Reckon data data from SQL Server Analysis Services, and use the Reckon Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to AgileCRM Data from a Connection Pool in JBoss
Integrate AgileCRM data into Java servlets: Use the Management Console in JBoss to install the AgileCRM JDBC Driver.
-
Build Dashboards with Outreach.io Data in Dundas BI
Create dynamic dashboards and perform analytics based on Outreach.io data in Dundas BI.
-
Integrating Codex with Avro 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.
-
Import and Visualize xBase Data in Power View
Create data visualizations based on xBase data in Excel.
-
Automated Continuous ADP Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ADP replication to delimited files (CSV/TSV).
-
Automated Continuous Paddle Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Paddle data replication to OneLake in Microsoft Fabric.
-
Build Cloudant Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Cloudant data and build visualizations in Tableau.
-
Validate Okta Data with QuerySurge
Access and validate Okta data in QuerySurge using the CData JDBC Driver.