CData Software - Knowledge Base
Recent Articles
-
How to connect and process Drip from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Drip.
-
Bridge Pingdom Connectivity with Apache NiFi
Access and process Pingdom in Apache NiFi using the CData JDBC Driver.
-
Build iContact-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live iContact Data in GitHub Copilot to assist with building iContact-powered applications.
-
Extract, Transform, and Load Avro Data in Informatica PowerCenter
Create a simple Workflow for Apache Avro in Informatica PowerCenter.
-
Integrate Real-Time Access to AgileCRM in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to AgileCRM in real time.
-
Automated Continuous Zoho Books Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Zoho Books replication to PostgreSQL.
-
How to connect and process Raisers Edge NXT from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Raisers Edge NXT.
-
Integrate Open WebUI with Live HBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Apache HBase from within the chat interface.
-
Connect to Live NetSuite SuiteAnalytics Data in PostGresSQL Interface through CData Connect AI
Create a live connection to NetSuite SuiteAnalytics in CData Connect AI and connect to your NetSuite SuiteAnalytics from PostgreSQL.
-
Validate Asana Data with QuerySurge
Access and validate Asana in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Box Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Box replication to Amazon Redshift.
-
Getting Started with the CData ADO.NET Provider for Teamwork
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build Visualizations of Azure Table Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Azure Table Storage in Birst.
-
Access Jumpseller Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Jumpseller from your Oracle system.
-
Act-On Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Act-On through CData Connect AI using different applications and tools.
-
Migrating data from PagerDuty to Snowflake using CData SSIS Components.
Easily push PagerDuty to Snowflake using the CData SSIS Tasks for PagerDuty and Snowflake.
-
Connect to Live Oracle HCM Cloud Data in MicroStrategy through CData Connect AI
Create a live connection to Oracle HCM Cloud Data in CData Connect AI and connect to your Oracle HCM Cloud from MicroStrategy.
-
View Reports on Real-Time Stack Exchange Data in Power BI Report Server
Use the CData ODBC Driver for Stack Exchange to visualize Stack Exchange in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Outreach.io Data from PowerBuilder via ADO.NET
This article demonstrates how to access Outreach.io from Appeon PowerBuilder using the CData ADO.NET Provider for Outreach.io.
-
How to Use a Microsoft Access Database to Update QuickBooks Online Data in Real Time
Update QuickBooks Online data by creating a linked table in Microsoft Access with the CData QuickBooks Online ODBC Driver.
-
Build a Simple VCL Application for Paddle Data
How to build a simple VCL Application to view Paddle in RAD Studio using the CData ODBC Driver for Paddle.
-
HCL Domino REST API Part 1: How to set up the environment
The first article in an article series that goes over the HCL Domino REST API. This article is a guide for how to get started with and setup the Domino REST API.
-
Build Charts with WordPress Data in Clear Analytics
Create dynamic charts and perform analytics based on WordPress in Clear Analytics.
-
Build Semantic Layer Views for Azure DevOps Data in APOS Live Data Gateway
Use the CData Connector for Azure DevOps in APOS Live Data Gateway to build Semantic Layer Views for Azure DevOps.
-
Visualize Rebilly Data in Tableau
The CData ODBC driver for Rebilly enables you integrate Rebilly into Tableau dashboards.
-
Query SAP BusinessObjects BI Data as a MySQL Database in Node.js
Execute MySQL queries against SAP BusinessObjects BI from Node.js.
-
Edit and Search External Amazon Athena Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Amazon Athena to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Amazon Athena Data objects that you can access from apps and the dashboard.
-
Create Informatica Mappings From/To a JDBC Data Source for Bugsnag
Create Bugsnag data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Twilio-Connected Applications in Appsmith
Connect to Twilio Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Twilio.
-
How to Work with Front Data in AWS Glue Jobs Using JDBC
Connect to Front from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate with SAP Ariba Procurement Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP Ariba Procurement in SnapLogic.
-
Integrate Live Outreach.io Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Use Microsoft Copilot Studio to talk to your Microsoft Planner 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 Microsoft Planner for you.
-
Feed ConvertAPI Data into FineReport
How to set ConvertAPI as a JDBC data source in FineReport.
-
Connect to xBase Data in DBeaver
Use the CData ODBC Driver to connect to xBase in DBeaver.
-
Access Live Avaza Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Avaza data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Publish Sybase IQ-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Sybase IQ.
-
Create OData-Connected Nintex Workflows
Use CData Connect AI to connect to OData Services from Nintex Workflow Cloud and build custom workflows using live OData.
-
Analyze Square Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Square in Microsoft R Open.
-
Integrate Live Cvent Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Cvent from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Cvent.
-
Build a Singer.io Tap for ADP With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ADP data using
-
Access Live Sugar CRM Data in Excel 365 Online (Excel for the web)
Connect to Sugar CRM from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Stream Facebook Data into Apache Kafka Topics
Access and stream Facebook in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Query Sage Cloud Accounting Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Sage Business Cloud Accounting from Node.js.
-
Access Ontraport 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 Ontraport.
-
How to integrate MailerSend with Apache Airflow
Access and process MailerSend in Apache Airflow using the CData JDBC Driver.
-
A PostgreSQL Interface for Reckon Accounts Hosted Data (MySQL Remoting via JDBC)
Use the Remoting features of the Reckon Accounts Hosted JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to LightSpeedRetail Data from a Connection Pool in JBoss
Integrate LightSpeedRetail into Java servlets: Use the Management Console in JBoss to install the LightSpeedRetail JDBC Driver.
-
Consume Amazon DynamoDB OData Feeds in PowerBuilder
This article demonstrates how to consume Amazon DynamoDB as OData feeds from PowerBuilder using the API Server.
-
Create Datasets from LeadDesk in Domo Workbench and Build Visualizations of LeadDesk Data in Domo
Use the CData Software ODBC Driver for LeadDesk to create datasets from LeadDesk in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Vertica Replication to SQL Server
Use CData Sync for automated, continuous, customizable Vertica replication to SQL Server.
-
How to connect SharePoint with Pinecone Data through external lists
Provide Pinecone to SharePoint users as an external list.
-
Visualize SAP Business One Data in Sisense
Create an ElastiCube in Sisense app with access to SAP Business One.
-
DataBind Charts to Salesforce Pardot Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Salesforce Pardot 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 load RSS data into Elasticsearch via Logstash
Introducing a simple method to load RSS data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Klaviyo Data in Coginiti Pro
Connect to and query live Klaviyo from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Extend Google Sheets with Teradata Data
Make calls to Teradata from Google Apps Script via the API Server.
-
Work with Guru Data in FoxPro
Load Guru into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Codex CLI with Vercel 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.
-
Bidirectional Access to Rebilly Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Rebilly in Filemaker Pro for Mac or Windows.
-
Build an OLAP Cube in SSAS from ChargeOver Data
Establish a connection to ChargeOver data from SQL Server Analysis Services, and use the ChargeOver Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Microsoft OneDrive Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft OneDrive and build visualizations in Tableau.
-
Connect to Codat Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Codat as an External Source in Dremio.
-
How to Create Power BI Visual Reports with Real-Time Zuora Data
Use CData Power BI Connectors to visualize Zuora in Power BI.
-
Replicate Zoho Projects Data to Multiple Databases
Replicate Zoho Projects to disparate databases with a point-and-click configuration.
-
Access GitLab Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live GitLab from HeidiSQL.
-
Stream Tickspot Data into Apache Kafka Topics
Access and stream Tickspot in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Configure the CData JDBC Driver for Certinia in a Connection Pool in Tomcat
Connect to Certinia from a connection pool in Tomcat.
-
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.
-
Automated Continuous Amplitude Replication to MongoDB
Use CData Sync for automated, continuous, customizable Amplitude replication to MongoDB.
-
How to Create Power BI Visual Reports with Real-Time Amazon S3 Data
Use CData Power BI Connectors to visualize Amazon S3 in Power BI.
-
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 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.
-
Integrate with live Zoho Inventory Data in Jitterbit
Use CData Connect AI to connect to and integrate live Zoho Inventory in Jitterbit.
-
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.
-
Migrating data from SAP to Snowflake using CData SSIS Components.
Easily push SAP ERP/NetWeaver to Snowflake using the CData SSIS Tasks for SAP and Snowflake.
-
Connect to and Query SuiteCRM Data in QlikView over ODBC
Create data visualizations with SuiteCRM in QlikView.
-
DataBind Controls to Wistia Data in C++Builder
DataBind to Wistia in C++Builder with standard components and controls.
-
DataBind Controls to Salesforce CRM Analytics Data in Delphi
DataBind to Salesforce CRM Analytics in Delphi with standard data access components and controls.
-
A PostgreSQL Interface for MariaDB Data (MySQL Remoting via JDBC)
Use the Remoting features of the MariaDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Xero Data in AWS Lambda
Connect to live Xero Accounting in AWS Lambda using the CData JDBC Driver.
-
Integrating LangChain with Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Directory within automated workflows.
-
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.
-
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.
-
Build Apps with Live DocuSign in Adalo using CData Connect AI
Use CData Connect AI to integrate live DocuSign into the Adalo platform and build custom mobile and web applications with real-time DocuSign.
-
Automated Continuous CapsuleCRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to SingleStore.
-
Automate Zoho Projects Data Replication to Couchbase
Use CData Sync to Customize and automate Zoho Projects replication to Couchbase.
-
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.
-
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.
-
Build Voice Agents in ElevenLabs with access to Live BigQuery Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google BigQuery.
-
Visualize Live VWO Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live VWO using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
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.
-
Automated Continuous Twitter Ads Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Amazon S3.
-
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.
-
Connect to FreeAgent Data as an External Source in Dremio
Use the CData JDBC Driver to connect to FreeAgent as an External Source in Dremio.