CData Software - Knowledge Base
Recent Articles
-
How to integrate ZohoMarketingHub with Apache Airflow
Access and process ZohoMarketingHub data in Apache Airflow using the CData JDBC Driver.
-
Integrate Live Klaviyo Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Klaviyo data to Blue Prism using the CData ODBC Driver for Klaviyo to create automated workflows for repetitive business tasks.
-
Migrating data from ADP to Databricks using CData SSIS Components.
Easily push ADP data to Databricks using the CData SSIS Tasks for ADP and Databricks.
-
Seamlessly Bring Shortcut Data into Retool Using CData Connect AI
Integrate Shortcut data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Connect to Live SAP Business One 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 SAP Business One data for you.
-
Visualize Onfleet Data in Sisense
Create an ElastiCube in Sisense app with access to Onfleet data.
-
Connect to Avaza Data in DBArtisan
Use wizards in DBArtisan to configure Avaza data as a data source.
-
Automated Continuous MongoDB Replication to MySQL
Use CData Sync for automated, continuous, customizable MongoDB replication to MySQL.
-
How to Easily Query Avro Data in OpenOffice Base
Connect to Avro data in OpenOffice Base using the CData ODBC Driver for Avro and generate reports with live data insights.
-
Creating Zoho Books-Connected Applications in Unqork
You can use CData Connect AI to feed Zoho Books data to Unqork and build custom business apps.
-
Automated Continuous Deel Replication to MySQL
Use CData Sync for automated, continuous, customizable Deel replication to MySQL.
-
Automated Continuous Typeform Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Typeform replication to Google Cloud SQL.
-
Integrating Dataiku with Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Act-On data.
-
How to import Microsoft Teams Data into Apache Solr
Use the CData Software JDBC Driver for Microsoft Teams in Data Import Handler and create an automated import of Microsoft Teams data to Apache Solr Enterprise Search platform.
-
Publish Reports with Oracle Service Cloud Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle Service Cloud data.
-
How to Access GitHub Data Using Entity Framework
This article shows how to access GitHub data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create OpenWeatherMap Dataflows on PowerBI.com
Connect to the CData Power BI Connector for OpenWeatherMap from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect to Live GetResponse 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 GetResponse data through natural language.
-
Build Visualizations of TaxJar Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of TaxJar data in Birst.
-
Automated Continuous ChargeOver Replication to SingleStore
Use CData Sync for automated, continuous, customizable ChargeOver replication to SingleStore.
-
Integrate LibreChat with Live Twilio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Twilio data from within the chat interface.
-
Automate Quaderno Data Replication to Azure Data Lake
Use CData Sync to customize and automate Quaderno data replication to Azure Data Lake.
-
Use Manus AI to Talk to Your QuickBooks Online 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 QuickBooks Online data.
-
Create Data Visualizations in Cognos BI with Samanage Data
Access Samanage data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live Freshdesk Data in Excel 365 Online (Excel for the web)
Connect to Freshdesk data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Publish Crystal Reports on ClickUp Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ClickUp data.
-
Work with Placid Data in FoxPro
Load Placid data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Migrating data from Act CRM to Databricks using CData SSIS Components.
Easily push Act CRM data to Databricks using the CData SSIS Tasks for Act CRM and Databricks.
-
How to create an RPA flow for ZohoDesk Data in UiPath Studio
Use the ZohoDesk ODBC Driver to create workflows that access real-time ZohoDesk data without any coding.
-
Process & Analyze Outlook Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Outlook Data.
-
How to Query Live Microsoft OneDrive Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft OneDrive data data in natural language using Python.
-
Connect to Zoho Creator Data from PowerBuilder via JDBC
This article demonstrates how to access Zoho Creator data from PowerBuilder using the Zoho Creator JDBC Driver.
-
How to Visualize MongoDB Data in Python with pandas
Use pandas and other modules to analyze and visualize live MongoDB data in Python.
-
Search External Phoenix Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Phoenix data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Phoenix Data objects that you can access from apps and the dashboard.
-
Access Zuora Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Zuora data from HeidiSQL.
-
Work with SAP SuccessFactors Data in FoxPro
Load SAP SuccessFactors data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build ADP-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 ADP data without replication.
-
Create MariaDB Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time MariaDB data access from reports, embedded analytics, and more.
-
Create Reports with Aweber Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Aweber data.
-
Connect to SAP SuccessFactors LMS Data from a Connection Pool in Jetty
The SAP SuccessFactors LMS JDBC Driver supports connection pooling: This article shows how to connect faster to SAP SuccessFactors LMS data from Web apps in Jetty.
-
Use the CData ODBC Driver for PostgreSQL from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for PostgreSQL to connect to PostgreSQL data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring PostgreSQL data in Excel.
-
Connect to Exa Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Exa to connect to Exa data and execute queries in PowerBuilder.
-
Replicate Multiple Mocean Accounts via the CData Sync CLI
Replicate multiple Mocean accounts to one or many databases.
-
Create SSAS Tabular Models from Perplexity Data
How to build a SQL Server Analysis Service Tabular Model from Perplexity data using CData drivers.
-
How to Easily Query Procore Data in OpenOffice Base
Connect to Procore data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Access Live IBM Cloud Object Storage Data in TIBCO Data Virtualization
Use the IBM Cloud Object Storage Tibco DV Adapter to create a IBM Cloud Object Storage data data source in TIBCO Data Virtualization Studio and gain access to live IBM Cloud Object Storage data from your TDV Server.
-
Query Dynamics 365 Business Central Data in ColdFusion
Write standard ColdFusion data access code to connect to Dynamics 365 Business Central data.
-
Connecting GenSpark with Sendwithus Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Sendwithus data without any replication or custom integration required.
-
Trigger BigQuery IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for BigQuery with standard wizards in Logic Apps.
-
Connect to Shippo Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Shippo data from Filemaker Pro on Mac.
-
Excel Spreadsheet Automation on ServiceDesk Plus Data with the QUERY Formula
Pull data from ServiceDesk Plus, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous RSS Replication to Snowflake
Use CData Sync for automated, continuous, customizable RSS replication to Snowflake.
-
Integrate Short.io Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Short.io data from Informatica Cloud.
-
Access Live Attio Data in Excel 365 Online (Excel for the web)
Connect to Attio data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automate SharePoint Data Replication to Azure Synapse
Use CData Sync to customize and automate SharePoint data replication to Azure Synapse.
-
Validate MessageBird Data with QuerySurge
Access and validate MessageBird data in QuerySurge using the CData JDBC Driver.
-
Connect to MessageBird Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for MessageBird to connect to MessageBird data and execute queries in PowerBuilder.
-
Automated Continuous Telegram Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Telegram replication to Apache Kafka.
-
Access Live Omnisend Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Omnisend data from your Excel spreadsheets.
-
Access Freshsales 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 Freshsales data.
-
Analyze xBase Data in Looker
Use CData Connect AI to connect to xBase Data from Looker and build custom apps using live xBase data.
-
Validate Superchat Data with QuerySurge
Access and validate Superchat data in QuerySurge using the CData JDBC Driver.
-
Integrating LlamaIndex with SparkPost Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SparkPost data in real time.
-
Use the CData ODBC Driver for Azure Synapse from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Azure Synapse to connect to Azure Synapse data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Azure Synapse data in Excel.
-
How to Connect to Live SAP Ariba Procurement 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 SAP Ariba Procurement data for you.
-
Integrate Real-Time Access to Salesforce Data 360 in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Salesforce Data 360 data in real time.
-
Connecting Agentforce with SQL Server Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your SQL Server data for you.
-
Use the CData ODBC Driver for HelloSign in Microsoft Power Query
You can use the CData HelloSign ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import HelloSign data into Microsoft Power Query.
-
Connect to Quickbase Data in DBeaver
Use the CData ODBC Driver to connect to Quickbase data in DBeaver.
-
Access Live QuickBooks Time Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live QuickBooks Time data from your Google Sheets.
-
Connecting Mastra with Gmail 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 Gmail data, no replication required.
-
Automated Continuous Planio Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Planio replication to Apache Cassandra.
-
Connect to eBay Analytics Data in Claris FileMaker Pro
Use the CData ODBC Driver for eBay Analytics in FileMaker Pro to connect to eBay Analytics and work with eBay Analytics data in your FileMaker applications.
-
Access Live Bannerbear 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 Bannerbear data through MCP integration.
-
Integrate SuiteCRM Data in Pentaho Data Integration
Build ETL pipelines based on SuiteCRM data in the Pentaho Data Integration tool.
-
Write a Simple Go Application to work with Google Calendar Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Calendar data.
-
Use the CData Software ODBC Driver for SAP Ariba Source in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP Ariba Source data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP Ariba Source.
-
Replicate Salesforce Pardot Data to Multiple Databases
Replicate Salesforce Pardot data to disparate databases with a point-and-click configuration.
-
How to Connect DBeaver to Monday.com via a JDBC Driver
Manage Monday.com data with visual tools in DBeaver like the query browser.
-
Easily Integrate Sybase IQ Data in Lazarus Pascal IDE
Learn how to easily integrate live Sybase IQ data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Operational Reporting on MailerLite Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote MailerLite data.
-
Build Reckon Accounts Hosted-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Reckon Accounts Hosted Data from Zoho Analytics and import live Reckon Accounts Hosted data.
-
DataBind Dynamics 365 Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Dynamics 365 with the DevExpress Windows Forms and Web controls to provide Dynamics 365 data to a chart.
-
Connect to Elorus Data in Jaspersoft Studio
Execute SQL to remote Elorus data in Jaspersoft Studio.
-
Analyze Live eBay Data in SAS Viya
Use CData Connect AI to connect to eBay data from SAS Viya and deploy self-service analytics using live eBay data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Confluence
Provide connectivity to Confluence data through an SAP BusinessObjects universe.
-
Work with Stripe Data in FoxPro
Load Stripe data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query Oracle Financials Cloud Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Oracle Financials Cloud entities in PHP by modeling them as objects.
-
Automated Continuous Salesloft Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Salesloft replication to Google BigQuery.
-
Automate SAP HANA XS Advanced Data Replication to Azure Synapse
Use CData Sync to customize and automate SAP HANA XS Advanced data replication to Azure Synapse.
-
Create Wrike Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Wrike from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Google Ads Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Google Ads to connect to Google Ads data and execute queries in PowerBuilder.
-
How to Access Data from a SharePoint List Based on a Custom View
We use Server Explorer in Visual Studio to show how the CData provider data model exposes custom views of SharePoint lists.
-
Build FTP-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for FTP Data and create custom apps in Mendix.
-
Connect to SpaceX Data in RapidMiner
Integrate SpaceX data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous eBay Analytics Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable eBay Analytics replication to Google Cloud SQL.
-
Access Paymo Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Paymo data from HeidiSQL.
-
Integrate Google's Antigravity Agent with Live Square Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Square data using the Model Context Protocol.
-
How to connect PolyBase to Presto
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Presto data.
-
Use the CData ODBC Driver for Jumpseller in Microsoft Power Query
You can use the CData Jumpseller ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Jumpseller data into Microsoft Power Query.