CData Software - Knowledge Base
Recent Articles
-
Use Microsoft Copilot Studio to talk to your Sugar 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 Sugar CRM data for you.
-
Connect to Live XML Data in PostGresSQL Interface through CData Connect AI
Create a live connection to XML in CData Connect AI and connect to your XML data from PostgreSQL.
-
Operational Reporting on AlloyDB Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote AlloyDB data.
-
Build Apps with Live Workday data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Workday data into the Adalo platform and build custom mobile and web applications with real-time Workday data.
-
Connecting Pipedream with ZohoDesk 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 ZohoDesk data in real time.
-
Natively Connect to Office 365 Data in PHP
The CData ODBC driver for Office 365 enables you to create PHP applications with connectivity to Office 365 data. Leverage the native support for ODBC in PHP.
-
Integrating OpenCode with Mixpanel 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 Slack Data in RapidMiner
Integrate Slack data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Basecamp Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Basecamp replication to PostgreSQL.
-
Use Microsoft Copilot Studio to talk to your Freshteam 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 Freshteam data for you.
-
Build Dashboards with Apify Data in DBxtra
Create dynamic dashboards and perform analytics based on Apify data in DBxtra.
-
Integrate Live Webflow Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Webflow data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Getting Started with the CData ADO.NET Provider for Humanity
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create Mouseflow Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Mouseflow data access from reports, embedded analytics, and more.
-
Connect to Testmonitor Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Testmonitor to connect to Testmonitor data and execute queries in PowerBuilder.
-
Replicate Kafka Data to Multiple Databases via the CData Sync CLI
Replicate Kafka data to disparate databases with a single configuration.
-
DataBind Sendwithus Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Sendwithus data to a chart.
-
Visualize Blackbaud FE NXT 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 Blackbaud FE NXT data into TIBCO Spotfire.
-
DataBind Charts to Reply.io Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Reply.io 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.
-
How to Connect Flowise AI Agents to Live SurveyMonkey 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 SurveyMonkey data without replication.
-
How to Access Live ADP Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ADP enables you to integrate ADP data into workflows built using Microsoft Power Automate Desktop.
-
Create Spark-Connected Nintex Workflows
Use CData Connect AI to connect to Spark Data from Nintex Workflow Cloud and build custom workflows using live Spark data.
-
Create ServiceNow-Connected Nintex Workflows
Use CData Connect AI to connect to ServiceNow Data from Nintex Workflow Cloud and build custom workflows using live ServiceNow data.
-
Connecting Mastra with Zoho Projects 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 Zoho Projects data, no replication required.
-
Use the CData ODBC Driver for Microsoft OneDrive from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Microsoft OneDrive to connect to Microsoft OneDrive data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft OneDrive data in Excel.
-
Deploy the ADO.NET Provider for PhantomBuster on an SSRS Report Server
Connect to PhantomBuster 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.
-
Connect to Amazon Athena from a Connection Pool in WebLogic
Use the CData JDBC Driver for Amazon Athena to connect to Amazon Athena data from Web applications running on WebLogic.
-
Connect to Oracle Financials Cloud Data in ACL Analytics
Connect to Oracle Financials Cloud data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Oracle Financials Cloud data.
-
Query Google Tasks Data in ColdFusion
Write standard ColdFusion data access code to connect to Google Tasks data.
-
Automated Tanda Data Replication to Teradata
Use CData Sync to Customize and automate Tanda data replication to Teradata.
-
Access Snapchat Ads 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 Snapchat Ads data.
-
Use the CData Software JDBC Driver for PayPal in MicroStrategy Web
Connect to PayPal data in MicroStrategy Web using the CData Software JDBC Driver for PayPal.
-
Automated Continuous SAP HANA XS Advanced Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Azure SQL Database.
-
Build Data Flows from Kintone to SQL Server using SSIS
Easily back up Kintone data to SQL Server using the SSIS components for Kintone.
-
Build Tally-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Tally Data and create custom apps in Mendix.
-
Write a Simple Go Application to work with LightSpeedRetail Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to LightSpeedRetail data.
-
Build a Simple VCL Application for RabbitMQ Data
How to build a simple VCL Application to view RabbitMQ data in RAD Studio using the CData ODBC Driver for RabbitMQ.
-
Explore Geographical Relationships in Asana Data with Power Map
Create data visualizations with Asana data in Power Map.
-
Stream Trello Data into Apache Kafka Topics
Access and stream Trello data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating LangChain with Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Amazon DynamoDB data within automated workflows.
-
Automated Continuous IBM Cloud Object Storage Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Apache Kafka.
-
Access Mailjet Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Mailjet data from your Oracle system.
-
Integrate with live Highrise Data in Jitterbit
Use CData Connect AI to connect to and integrate live Highrise data in Jitterbit.
-
Use the CData Software JDBC Driver for Notion in MicroStrategy
Connect to Notion data in MicroStrategy Developer using the CData Software JDBC Driver for Notion.
-
Automated Continuous Codat Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Codat replication to PostgreSQL.
-
Integrate Live Amazon Marketplace Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Amazon Marketplace data from within the IDE.
-
Connect to Odoo Data in Aqua Data Studio
Access Odoo data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Using the CData Software ODBC Driver for JobNimbus in PyCharm
Connect to JobNimbus as an ODBC data source in PyCharm using the CData Software ODBC Driver for JobNimbus.
-
Build a Simple VCL Application for Gmail Data
How to build a simple VCL Application to view Gmail data in RAD Studio using the CData ODBC Driver for Gmail.
-
Getting Started with the CData SSIS Components for SAP Business One
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP Business One.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Sheets
Provide connectivity to Google Sheets data through an SAP BusinessObjects universe.
-
Natively Connect to Google Contacts Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Contacts data. Leverage the native support for ODBC in PHP.
-
Connect to Hive Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Hive and the Script function in FileMaker Pro to connect to Hive and work with Hive data in your FileMaker application.
-
Bidirectional Access to Quickbase Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Quickbase data in Filemaker Pro for Mac or Windows.
-
Connect Facebook to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Facebook data using the CData Python MCP Server.
-
DataBind Kintone Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Kintone with the DevExpress Windows Forms and Web controls to provide Kintone data to a chart.
-
Create Datasets from Databricks in Domo Workbench and Build Visualizations of Databricks Data in Domo
Use the CData Software ODBC Driver for Databricks to create datasets from Databricks data in Domo Workbench and then build visualizations in the Domo service.
-
Access Live SingleStore Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SingleStore data from your Google Sheets.
-
Use the CData Software ODBC Driver for Insightly in SAS for Real-Time Reporting and Analytics
Connect to real-time Insightly data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Insightly.
-
Connect to API Data from AWS Glue
Use CData Connect AI to gain access to live API data from your AWS Glue jobs.
-
Connect SAP Netweaver Gateway Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP Netweaver Gateway data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect to Live Adobe Analytics 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 Adobe Analytics data for you.
-
Automated Continuous Oracle Service Cloud Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to AlloyDB.
-
Analyze Facebook Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Facebook data in Microsoft R Open.
-
Publish Crystal Reports on Strava Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Strava data.
-
Use the CData SSIS Components to Insert New or Update Existing Square Records from SQL Server
Easily push SQL Server data to Square using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Square or update existing records with data from a SQL Server database.
-
Getting Started with the CData Power BI Connector for CampaignMonitor
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Replicate Instantly Data to Multiple Databases
Replicate Instantly data to disparate databases with a point-and-click configuration.
-
Model IBM Cloud Object Storage Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and IBM Cloud Object Storage, enabling the direct import of real-time IBM Cloud Object Storage data.
-
Connect to Jumpseller Data in ACL Analytics
Connect to Jumpseller data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Jumpseller data.
-
How to Query Live SAP Fieldglass Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP Fieldglass data data in natural language using Python.
-
Automated Continuous Reckon Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Reckon replication to AlloyDB.
-
Use ChatGPT to Talk to Your Salesforce Pardot 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 Salesforce Pardot data for you.
-
Replicate Multiple Azure Synapse Accounts via the CData Sync CLI
Replicate multiple Azure Synapse accounts to one or many databases.
-
Integrating OpenCode with Vimeo 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 PhantomBuster Data from a Connection Pool in JBoss
Integrate PhantomBuster data into Java servlets: Use the Management Console in JBoss to install the PhantomBuster JDBC Driver.
-
How to Access Access Data Using Entity Framework
This article shows how to access Access data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate with live Databricks Data in Jitterbit
Use CData Connect AI to connect to and integrate live Databricks data in Jitterbit.
-
Create Blackbaud FE NXT-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Blackbaud FE NXT Data from Klipfolio and build custom visualizations using live Blackbaud FE NXT data.
-
How to import Dropbox Data into Apache Solr
Use the CData Software JDBC Driver for Dropbox in Data Import Handler and create an automated import of Dropbox data to Apache Solr Enterprise Search platform.
-
How to connect and process Cassandra data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Cassandra data.
-
Natively Connect to CockroachDB Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to CockroachDB data. Leverage the native support for ODBC in PHP.
-
Use JayDeBeApi to access Guru Data in Python
Use standard Python scripting and the development environment of your choice to access live Guru data.
-
Rapidly Develop MariaDB-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 MariaDB.
-
Visualize Live TaxJar Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live TaxJar data.
-
Connect to Float Data in HULFT Integrate
Connect to Float as a JDBC data source in HULFT Integrate
-
Work with Freshdesk Data in FoxPro
Load Freshdesk data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Link Contentful with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Contentful data in Filemaker Pro for Mac or Windows.
-
Search External Oracle SCM Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Oracle SCM data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Oracle SCM Data objects that you can access from apps and the dashboard.
-
Replicate Amazon Marketplace Data from PowerShell
Write a quick PowerShell script to query Amazon Marketplace data. Use connectivity to the live data to replicate Amazon Marketplace data to SQL Server.
-
Analyze Omnisend Data in Cognos Analytics
Use CData Connect AI to connect to Omnisend Data from Cognos Analytics and analyze live Omnisend data.
-
Connect to iContact Data from AWS Glue
Use CData Connect AI to gain access to live iContact data from your AWS Glue jobs.
-
Visualize Parallel Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Parallel data.
-
Create Informatica Mappings From/To an ODBC Data Source for Grafana
Create an ODBC connection to Grafana in Informatica and browse and transfer Grafana data.
-
Use the CData Software JDBC Driver for Neo4J in MicroStrategy Desktop
Connect to Neo4J data in MicroStrategy Desktop using the CData Software JDBC Driver for Neo4J.
-
Integrate Cline with Live SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP Concur data from within your IDE.
-
Access Live xBase Data in TIBCO Data Virtualization
Use the xBase Tibco DV Adapter to create a xBase data data source in TIBCO Data Virtualization Studio and gain access to live xBase data from your TDV Server.
-
Getting Started with the CData Connect AI Python SDK for Acumatica
Install the CData Connect AI Python SDK to read and write live Acumatica data with standard DB-API 2.0 Python code.
-
Prepare, Blend, and Analyze Cohere Data in Alteryx Designer (ODBC)
Build workflows to access live Cohere data for self-service data analytics.
-
Create Data Visualizations in Cognos BI with Nuclia Data
Access Nuclia data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.