CData Software - Knowledge Base
Recent Articles
-
Automate WooCommerce Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live WooCommerce and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
DataBind Controls to Superchat Data in C++Builder
DataBind to Superchat in C++Builder with standard components and controls.
-
Automated Continuous WordPress Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable WordPress replication to PostgreSQL.
-
How to Query Live JSON Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live JSON data in natural language using Python.
-
Integrate Real-Time Access to TaxJar in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to TaxJar in real time.
-
Access Live NetSuite Data in Excel 365 Online (Excel for the web)
Connect to NetSuite CRM & ERP from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to create Visio diagrams from Acumatica Data
Automatically update Acumatica ERP with the changes you make to Visio master shapes.
-
Access Live Dynamics CRM Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Dynamics CRM from your Excel spreadsheets.
-
Natively Connect to Salesforce Data in PHP
The CData ODBC driver for Salesforce enables you to create PHP applications with connectivity to Salesforce & Force.com. Leverage the native support for ODBC in PHP.
-
Use the CData Software ODBC Driver for Amazon S3 in SAS for Real-Time Reporting and Analytics
Connect to real-time Amazon S3 in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Amazon S3.
-
Access Live Asana Data in AWS Lambda
Connect to live Asana in AWS Lambda using the CData JDBC Driver.
-
Connect to Adobe Commerce Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automate Stack Exchange Data Replication to Couchbase
Use CData Sync to Customize and automate Stack Exchange replication to Couchbase.
-
Prepare, Blend, and Analyze ShipEngine Data in Alteryx Designer (ODBC)
Build workflows to access live ShipEngine for self-service data analytics.
-
How to publish and share Jira Data dashboards with Tableau Server
The CData ODBC driver for Jira enables you integrate Atlassian Jira into Tableau dashboards.
-
Build Apps with Live PostgreSQL Data Using the Low-Code Development Platform of Mendix
Connect PostgreSQL with Mendix to build apps using the CData JDBC Driver for PostgreSQL.
-
How to connect to Snowflake Data with Squirrel SQL client
Connect to Snowflake and execute queries in the Squirrel SQL Client.
-
Automated Continuous Timely Replication to SQL Server
Use CData Sync for automated, continuous, customizable Timely replication to SQL Server.
-
Getting Started with the CData ODBC Driver for Facebook Ads
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Facebook Ads.
-
Integrate with iContact Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy iContact to a JSON file on disk.
-
Integrate Theia IDE with Live Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect Jira to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Atlassian Jira using the CData Python MCP Server.
-
Connecting Pipedream with SAP Ariba Source 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 SAP Ariba Source data in real time.
-
How to connect SharePoint with Elasticsearch Data through external lists
Provide Elasticsearch to SharePoint users as an external list.
-
Automated Continuous YouTube Analytics Replication to MongoDB
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to MongoDB.
-
Integrating Codex CLI with Bitly 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 Shopify from Asprova with CData Software ODBC Driver for Shopify
This article shows how to connect faster to Shopify data from Asprova.
-
Access Telegram Data from MySQL in PHP
Connect to Telegram through the standard MySQL libraries in PHP.
-
Getting Started with the CData Python Connector for OpenWeatherMap
Learn to install and license the CData Python Connector
-
Replicate Toggl Data in Heroku for Use in Salesforce Connect
Replicate Toggl to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build a Singer.io Tap for Sendwithus With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Sendwithus data using
-
Create Power BI Reports on Real-Time MySQL Data
Use the CData ODBC Driver for MySQL to visualize MySQL in Power BI Desktop.
-
Integrating Cursor CLI with FHIR 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.
-
Query Reply.io Data in DataGrip
Create a Data Source for Reply.io in DataGrip and use SQL to query live Reply.io.
-
Work with Live API Data in Power Query
Use CData Connect AI to connect to API and work with live API in Microsoft Power Query.
-
Design BIRT Reports on Tally Data
Provide current Tally ERP to your embedded analytics.
-
Create Data Visualizations Based On Sage Cloud Accounting Data in Mode
Use CData Connect AI to connect to Sage Cloud Accounting Data from Mode and build visualizations using live
-
Replicate Oracle SCM Data in Heroku for Use in Salesforce Connect
Replicate Oracle SCM to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build SurveyMonkey-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SurveyMonkey to explore live SurveyMonkey Data in GitHub Copilot to assist with building SurveyMonkey-powered applications.
-
DataBind SAS Data Sets Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAS Data Sets with the DevExpress Windows Forms and Web controls to provide SAS Data Sets to a chart.
-
Connect Email to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Email with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software ODBC Driver for Campaigner in SAS for Real-Time Reporting and Analytics
Connect to real-time Campaigner in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Campaigner.
-
Use Claude to Talk to Your Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Salesforce Pardot for you.
-
Design BIRT Reports on Workable Data
Provide current Workable to your embedded analytics.
-
Clockify Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Clockify facts in real time.
-
Enable the Unbounce JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Unbounce.
-
Using the CData Software ODBC Driver for ScrapingBee in PyCharm
Connect to ScrapingBee as an ODBC data source in PyCharm using the CData Software ODBC Driver for ScrapingBee.
-
DataBind Insightly Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Insightly to a chart.
-
Connect to Klipfolio Data in CloverDX (formerly CloverETL)
Transfer Klipfolio using the visual workflow in the CloverDX data integration tool.
-
Query SAP HANA XS Advanced Data in ColdFusion
Write standard ColdFusion data access code to connect to SAP HANA XS Advanced.
-
How to create an RPA flow for SAP Ariba Procurement Data in UiPath Studio
Use the SAP Ariba Procurement ODBC Driver to create workflows that access real-time SAP Ariba Procurement without any coding.
-
Build Dashboards with Email Data in DBxtra
Create dynamic dashboards and perform analytics based on Email in DBxtra.
-
Rapidly Develop Reckon Accounts Hosted-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 Reckon Accounts Hosted.
-
Integrate Live Avaza Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Avaza to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Outreach.io Data from HeidiSQL
Use CData Connect AI to connect to and query live Outreach.io from HeidiSQL.
-
Integrate Theia IDE with Live Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrate Open WebUI with Live SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft SQL Server from within the chat interface.
-
Replicate Oracle HCM Cloud Data to Multiple Databases
Replicate Oracle HCM Cloud to disparate databases with a point-and-click configuration.
-
Connect to HelloSign Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Create Azure DevOps-Connected Nintex Workflows
Use CData Connect AI to connect to Azure DevOps Data from Nintex Workflow Cloud and build custom workflows using live Azure DevOps.
-
How to Create Power BI Visual Reports with Real-Time Active Directory Data
Use CData Power BI Connectors to visualize Active Directory in Power BI.
-
Getting Started with the CData SSIS Components for Tanda
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Tanda.
-
Access JotForm 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 JotForm.
-
Connect to Hugging Face Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Hugging Face as an External Source in Dremio.
-
Integrating LlamaIndex with Quickbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Quickbase in real time.
-
How to Import Data from Klaviyo into Google Sheets
Import Klaviyo into a Google spreadsheet that is automatically refreshed.
-
Import Real-Time Intercom Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Intercom in ColdFusion.
-
Migrating data from Basecamp to Databricks using CData SSIS Components.
Easily push Basecamp to Databricks using the CData SSIS Tasks for Basecamp and Databricks.
-
Manage ClickUp Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ClickUp.
-
Use the CData Software JDBC Driver for TigerGraph in MicroStrategy
Connect to TigerGraph in MicroStrategy Developer using the CData Software JDBC Driver for TigerGraph.
-
DataBind Controls to ChargeOver Data in C++Builder
DataBind to ChargeOver in C++Builder with standard components and controls.
-
Connect to Paymo Data from PowerBuilder via ADO.NET
This article demonstrates how to access Paymo from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Automate SAP Data Replication to Azure Synapse
Use CData Sync to customize and automate SAP ERP/NetWeaver replication to Azure Synapse.
-
Query Postmark Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Postmark from Node.js.
-
How to Connect to Live Certinia Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Certinia without replication.
-
Explore Geographical Relationships in SAP HANA Data with Power Map
Create data visualizations with SAP HANA in Power Map.
-
Build Marketo-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Marketo to explore live Marketo Data in GitHub Copilot to assist with building Marketo-powered applications.
-
Bridge Egnyte Connectivity with Apache NiFi
Access and process Egnyte in Apache NiFi using the CData JDBC Driver.
-
Extract, Transform, and Load Vimeo Data in Informatica PowerCenter
Create a simple Workflow for Vimeo in Informatica PowerCenter.
-
Connect to Drip Data from PowerBuilder via JDBC
This article demonstrates how to access Drip from PowerBuilder using the Drip JDBC Driver.
-
Replicate Templated Data from PowerShell
Write a quick PowerShell script to query Templated. Use connectivity to the live data to replicate Templated to SQL Server.
-
Create SSAS Tabular Models from Copper Data
How to build a SQL Server Analysis Service Tabular Model from Copper using CData drivers.
-
Automated Continuous Omnisend Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Omnisend replication to Amazon Redshift.
-
How to Connect DBeaver to VWO via a JDBC Driver
Manage VWO with visual tools in DBeaver like the query browser.
-
Perform Batch Operations with Dynamics 365 Business Central Data in Apache NiFi
Connect to Dynamics 365 Business Central and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to use SQLAlchemy ORM to access Bitbucket Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Bitbucket.
-
Getting Started with the CData JDBC Driver for DB2
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for DB2.
-
Design BIRT Reports on SAP SuccessFactors LMS Data
Provide current SAP SuccessFactors LMS to your embedded analytics.
-
Connect to MariaDB Data from PowerBuilder via ADO.NET
This article demonstrates how to access MariaDB from Appeon PowerBuilder using the CData ADO.NET Provider for MariaDB.
-
How to Seamlessly Import Mistral AI Data into IBM SPSS Modeler
Integrate Mistral AI data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Publish Reports with Customer.io Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Customer.io.
-
Connect to Redis Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate Cline with Live Cvent Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Cvent from within your IDE.
-
Build Agents in Relevance AI with Access to Live SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP BusinessObjects BI within intelligent agent workflows.
-
Automated Continuous GitLab Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable GitLab replication to PostgreSQL.
-
Feed Vault CRM Data into FineReport
How to set Veeva Vault & Vault CRM as a JDBC data source in FineReport.
-
How to integrate Couchbase with Apache Airflow
Access and process Couchbase in Apache Airflow using the CData JDBC Driver.
-
Connect to Trello Data in CloverDX (formerly CloverETL)
Transfer Trello using the visual workflow in the CloverDX data integration tool.
-
Visualize Salesforce CRM Analytics Data in Sisense
Create an ElastiCube in Sisense app with access to Salesforce CRM Analytics.
-
How to integrate Dropbox with Apache Airflow
Access and process Dropbox in Apache Airflow using the CData JDBC Driver.