CData Software - Knowledge Base
Recent Articles
-
Automated Continuous CData Connect AI Replication to IBM DB2
Use CData Sync for automated, continuous, customizable CData Connect AI replication to IBM DB2.
-
How to Build an ETL App for Sugar CRM Data in Python with CData Connect AI
Build ETL pipelines that read and write live Sugar CRM in Python with petl and the CData Connect AI Python SDK.
-
Easily Integrate MailerLite Data in Lazarus Pascal IDE
Learn how to easily integrate live MailerLite in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Create Power BI Visual Reports with Real-Time Zuora Data
Use CData Power BI Connectors to visualize Zuora in Power BI.
-
How to integrate SQL Server with Apache Airflow
Access and process Microsoft SQL Server in Apache Airflow using the CData JDBC Driver.
-
Replicate Typeform Data in Heroku for Use in Salesforce Connect
Replicate Typeform to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Replicate Zoho Projects Data to Multiple Databases
Replicate Zoho Projects to disparate databases with a point-and-click configuration.
-
Rapidly Develop Nethunt-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 Nethunt.
-
Use ChatGPT to Talk to Your Authorize.Net 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 Authorize.Net for you.
-
Build Cloudant-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Cloudant Data and create custom apps in Bubble.
-
Automated Continuous SAP Fieldglass Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to SingleStore.
-
Automated Continuous Zoho CRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Zoho CRM replication to IBM DB2.
-
How to Access Live GitLab Data in Power Automate Desktop via ODBC
The CData ODBC Driver for GitLab enables you to integrate GitLab into workflows built using Microsoft Power Automate Desktop.
-
How to Build an ETL App for Hubstaff Data in Python with CData
Create ETL applications and real-time data pipelines for Hubstaff in Python with petl.
-
How to Visualize Microsoft Planner Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft Planner in Python.
-
Access Live Azure Analysis Services 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 Azure Analysis Services through MCP integration.
-
Connect to and Query SuiteCRM Data in QlikView over ODBC
Create data visualizations with SuiteCRM in QlikView.
-
Excel Spreadsheet Automation on Kintone Data with the QUERY Formula
Pull data from Kintone, automate spreadsheets, and more with the QUERY formula.
-
DataBind Controls to Wistia Data in C++Builder
DataBind to Wistia in C++Builder with standard components and controls.
-
How to Build an ETL App for Adobe Analytics Data in Python with CData Connect AI
Build ETL pipelines that read and write live Adobe Analytics in Python with petl and the CData Connect AI Python SDK.
-
Bind Live QuickBooks Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live QuickBooks data
-
Automate Shortcut Data Replication to Azure Synapse
Use CData Sync to customize and automate Shortcut replication to Azure Synapse.
-
How to Build an ETL App for Highrise Data in Python with CData
Create ETL applications and real-time data pipelines for Highrise CRM in Python with petl.
-
Connect Sybase IQ to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sybase IQ using the CData Python MCP Server.
-
Automated Continuous CapsuleCRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to SingleStore.
-
Build Agents in Relevance AI with Access to Live Oracle Service Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Oracle Service Cloud within intelligent agent workflows.
-
How to use SQLAlchemy ORM to access Humanity Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Humanity.
-
Connect to ZarMoney Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ZarMoney as an External Source in Dremio.
-
Write a Simple Go Application to work with SFTP Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SFTP.
-
How to connect to Mouseflow Data from Spring Boot
Connect to Mouseflow in a Spring Boot Application using the CData API Driver for JDBC
-
Build Apps with Live LightSpeedRetail Data Using the Low-Code Development Platform of Mendix
Connect LightSpeedRetail with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to and Query Omnisend Data in QlikView over ODBC
Create data visualizations with Omnisend in QlikView.
-
Automated Continuous Zoom Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Zoom replication to IBM DB2.
-
Integrating Cursor CLI with Dynamics 365 Business Central 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.
-
Analyze CampaignMonitor Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze CampaignMonitor with the CData JDBC Driver for CampaignMonitor.
-
Connect to Slack Data from PowerBuilder via JDBC
This article demonstrates how to access Slack from PowerBuilder using the Slack JDBC Driver.
-
Access Live IBM Informix Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live IBM Informix from your Excel spreadsheets.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live NetSuite SuiteAnalytics within intelligent workflows.
-
Write a Simple Go Application to work with Cloudflare Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Cloudflare.
-
Automated Continuous Omnisend Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Omnisend replication to PostgreSQL.
-
Connect to Hugging Face Data from a Connection Pool in Jetty
The Hugging Face JDBC Driver supports connection pooling: This article shows how to connect faster to Hugging Face from Web apps in Jetty.
-
Query Sybase Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Sybase and perform CRUD operations on Sybase from Node.js.
-
Using the CData Software ODBC Driver for Gong in PyCharm
Connect to Gong as an ODBC data source in PyCharm using the CData Software ODBC Driver for Gong.
-
Query Live Oracle HCM Cloud 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 Oracle HCM Cloud directly from the development environment.
-
Publish Crystal Reports on SQL Analysis Services Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SQL Analysis Services.
-
How to create Visio diagrams from Oracle Service Cloud Data
Automatically update Oracle Service Cloud with the changes you make to Visio master shapes.
-
Create Dynamic Paymo Grids Using the Infragistics XamDataGrid
Learn how you can connect Paymo to Infragistics XamDataGrid to build dynamic grids.
-
Build a PostgreSQL Interface for Cosmos DB Data using the CData JDBC Driver
Use the Remoting features of the Cosmos DB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Dashboards with Quickbase Data in DBxtra
Create dynamic dashboards and perform analytics based on Quickbase in DBxtra.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Impala
Provide connectivity to Apache Impala through an SAP BusinessObjects universe.
-
Getting Started with the CData SSIS Components for Sage Cloud Accounting
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Sage Cloud Accounting.
-
Use Databricks Agent Bricks to Talk to Your Google Campaign Manager 360 Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Google Campaign Manager 360 for you.
-
Build Charts with CloudConvert Data in Clear Analytics
Create dynamic charts and perform analytics based on CloudConvert in Clear Analytics.
-
Connect to Zoho CRM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zoho CRM and the SQL Gateway to access Zoho CRM from Google Apps Script.
-
Build AI Agents with eBay Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live eBay through CData Connect AI.
-
Access Live Marketo Data in AWS Lambda
Connect to live Marketo in AWS Lambda using the CData JDBC Driver.
-
CloudConvert Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on CloudConvert facts in real time.
-
How to create Landbot federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Landbot in MySQL .
-
Provide OData Services of Google Cloud Storage Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Cloud Storage by developing a WCF Service Application.
-
Automate SAP Netweaver Gateway Data Replication to Couchbase
Use CData Sync to Customize and automate SAP Netweaver Gateway replication to Couchbase.
-
Automated Continuous Mode Replication to Oracle
Use CData Sync for automated, continuous, customizable Mode replication to Oracle.
-
Build TaxJar-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live TaxJar.
-
Build Apps with Live ShipStation Data Using the Low-Code Development Platform of Mendix
Connect ShipStation with Mendix to build apps using the CData JDBC Driver for ShipStation.
-
Import Real-Time XML Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use XML Files in ColdFusion.
-
Getting Started with the CData SSIS Components for Codat
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Codat.
-
Visualize Paddle Data in Sisense
Create an ElastiCube in Sisense app with access to Paddle.
-
Import SAP ByDesign Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP ByDesign Data and provide access to live SAP Business ByDesign for custom reports in the Power BI Service.
-
Deploy the ADO.NET Provider for Confluence on an SSRS Report Server
Connect to Atlassian Confluence 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.
-
Replicate Dynamics 365 Business Central Data from PowerShell
Write a quick PowerShell script to query Dynamics 365 Business Central. Use connectivity to the live data to replicate Dynamics 365 Business Central to SQL Server.
-
DataBind HubDB Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for HubDB with the DevExpress Windows Forms and Web controls to provide HubDB to a chart.
-
Use Microsoft Copilot Studio to talk to your Blackbaud FE NXT 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 Blackbaud FE NXT for you.
-
Connect to Facebook Ads Data in DBArtisan
Use wizards in DBArtisan to configure Facebook Ads as a data source.
-
Use the CData Software ODBC Driver for Planio in SAS for Real-Time Reporting and Analytics
Connect to real-time Planio in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Planio.
-
Connect to Miro Data from a Connection Pool in JBoss
Integrate Miro into Java servlets: Use the Management Console in JBoss to install the Miro JDBC Driver.
-
Operational Reporting on Cassandra Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Apache Cassandra.
-
Model SAP ByDesign Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP ByDesign, enabling the direct import of real-time SAP Business ByDesign.
-
How to Easily Query Salesforce Data in OpenOffice Base
Connect to Salesforce data in OpenOffice Base using the CData ODBC Driver for Salesforce and generate reports with live data insights.
-
Use Databricks Agent Bricks to Talk to Your Salesforce CRM Analytics Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Salesforce CRM Analytics for you.
-
How to connect and process Clockify from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Clockify.
-
Connect to Salesforce Marketing Data in DBeaver
Use the CData ODBC Driver to connect to Salesforce Marketing Cloud in DBeaver.
-
Build an OLAP Cube in SSAS from SurveyMonkey Data
Establish a connection to SurveyMonkey data from SQL Server Analysis Services, and use the SurveyMonkey Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Freshdesk Data from a Connection Pool in JBoss
Integrate Freshdesk into Java servlets: Use the Management Console in JBoss to install the Freshdesk JDBC Driver.
-
Access Eventbrite Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Eventbrite from HeidiSQL.
-
Connect to Mouseflow Data in HULFT Integrate
Connect to Mouseflow as a JDBC data source in HULFT Integrate
-
Integrating LangChain with Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Couchbase within automated workflows.
-
Build Charts with ZohoExpense Data in Clear Analytics
Create dynamic charts and perform analytics based on ZohoExpense in Clear Analytics.
-
Creating Oracle SCM-Connected Applications in Unqork
You can use CData Connect AI to feed Oracle SCM to Unqork and build custom business apps.
-
Integrate Bitly Data in the Pentaho Report Designer
Publish reports based on Bitly in the Pentaho BI tool.
-
Integrating Kiro CLI with SharePoint Excel Services 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.
-
Viewing TaxJar Data in RAD Studio Data Explorer
How to view TaxJar in RAD Studio Data Explorer using the CData ODBC Driver for TaxJar.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Vercel
Provide connectivity to Vercel through an SAP BusinessObjects universe.
-
Query SAP Fieldglass Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP Fieldglass from Node.js.
-
How to Connect to & Open Excel Online Data in Microsoft Excel
This article uses the CData ODBC driver for Excel Online to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Building Dynamic Web Pages with Presto Data Using AngularJS
Create single-page applications with live connectivity to Presto using the CData API Server.
-
Add Excel Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Excel with the Informatica Enterprise Data Catalog to classify and organize data.
-
Publish Reports with HubDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date HubDB.
-
How to Visualize SAS Data Sets 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 SAS Data Sets in Python.
-
Connect and Query Live Dynamics 365 Business Central Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Dynamics 365 Business Central into Databricks
-
Use the CData Software ODBC Driver for Office 365 in MicroStrategy
Connect to Microsoft Office 365 in MicroStrategy Developer using the CData Software ODBC Driver for Office 365.
-
Extend Google Sheets with ActiveCampaign Data
Make calls to ActiveCampaign from Google Apps Script via the API Server.