CData Software - Knowledge Base
Recent Articles
-
Access MailerSend Data from MySQL in PHP
Connect to MailerSend through the standard MySQL libraries in PHP.
-
Visualize Reckon Data in Sisense
Create an ElastiCube in Sisense app with access to Reckon.
-
Connect to Drip Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Drip to connect to Drip and execute queries in PowerBuilder.
-
Build a Singer.io Tap for Monday.com With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Monday.com data using
-
Consume Cvent OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Cvent feeds that reflect any changes in SAP Lumira.
-
How to load Cloudant data into Elasticsearch via Logstash
Introducing a simple method to load Cloudant data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Simplesat Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Simplesat and work with Simplesat in your FileMaker application.
-
Integrating Codex CLI with Wave Financial 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 Supabase Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Supabase as an External Source in Dremio.
-
Access CircleCI Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live CircleCI from HeidiSQL.
-
Use the CData Software ODBC Driver for Teradata in MicroStrategy
Connect to Teradata in MicroStrategy Developer using the CData Software ODBC Driver for Teradata.
-
Integrate with Elasticsearch Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Elasticsearch to a JSON file on disk.
-
DataBind Controls to OneNote Data in Delphi
DataBind to Microsoft OneNote in Delphi with standard data access components and controls.
-
How to Query Everhour Data in MySQL Workbench
Execute MySQL queries against live Everhour from MySQL Workbench.
-
Connect to Amazon Marketplace Data in Aqua Data Studio
Access Amazon Marketplace from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Deploy the ADO.NET Provider for Wistia on an SSRS Report Server
Connect to Wistia 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 AfterShip Data in Jaspersoft Studio
Execute SQL to remote AfterShip in Jaspersoft Studio.
-
Natively Connect to Mistral AI Data in PHP
The CData ODBC driver for Mistral AI enables you to create PHP applications with connectivity to Mistral AI. Leverage the native support for ODBC in PHP.
-
Query NetSuite Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume NetSuite entities in PHP by modeling them as objects.
-
Build an OLAP Cube in SSAS from Everhour Data
Establish a connection to Everhour data from SQL Server Analysis Services, and use the Everhour Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Reports from SAP Ariba Source Data in Looker Studio
Use CData Connect AI to gain access to live SAP Ariba Source and create custom reports in Looker Studio.
-
Integrate Live CSV Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to CSV from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live CSV/TSV Files.
-
Access Live Superchat Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Superchat in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Configure the CData JDBC Driver for Smartsheet in a Connection Pool in Tomcat
Connect to Smartsheet from a connection pool in Tomcat.
-
Automated Continuous SAP Business One Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SAP Business One replication to Amazon Redshift.
-
How to Connect the Power BI Service to Instantly: Complete Guide
Connect to the CData Software Power BI Connector for Instantly from PowerBI.com to provide real-time Instantly across the organization.
-
Connect to Teamwork Data in HULFT Integrate
Connect to Teamwork as a JDBC data source in HULFT Integrate
-
Getting Started with the CData Tableau Connector for Dynamics NAV
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Dynamics NAV.
-
Import and Visualize Factorial Data in Power View
Create data visualizations based on Factorial in Excel.
-
Getting Started with the CData Power BI Connector for Retently
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Email actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Integrating GitHub Copilot CLI with Mouseflow 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.
-
Integrate SendPulse with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SendPulse with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SendPulse.
-
How to Access Live LinkedIn Data in Power Automate Desktop via ODBC
The CData ODBC Driver for LinkedIn enables you to integrate LinkedIn into workflows built using Microsoft Power Automate Desktop.
-
How to connect SharePoint with HubSpot Data through external lists
Provide HubSpot to SharePoint users as an external list.
-
Use the CData Software ODBC Driver for Dynamics 365 Business Central in MicroStrategy Web
Connect to Dynamics 365 Business Central in MicroStrategy Web using the CData Software ODBC Driver for Dynamics 365 Business Central.
-
Connect to Landbot Data in CloverDX (formerly CloverETL)
Transfer Landbot using the visual workflow in the CloverDX data integration tool.
-
Replicate FreeAgent Data to Multiple Databases via the CData Sync CLI
Replicate FreeAgent to disparate databases with a single configuration.
-
Connect to RSS Feeds in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Access Pinterest Data Using Entity Framework
This article shows how to access Pinterest using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect the Power BI Service to Okta: Complete Guide
Connect to the CData Software Power BI Connector for Okta from PowerBI.com to provide real-time Okta across the organization.
-
Use Databricks Agent Bricks to Talk to Your Presto Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Presto for you.
-
Create DocuSign-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to DocuSign Data from OutSystems and build custom enterprise apps using live DocuSign.
-
Access Microsoft OneDrive 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 Microsoft OneDrive.
-
Use Biml to Build SSIS Tasks to Replicate Amazon Athena Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Amazon Athena to SQL Server.
-
Add Chargebee Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Chargebee with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Live Airtable Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Build Automated Freshdesk-Connected Workflows in Zapier
Use CData Connect AI to connect to live Freshdesk and build automated workflows in Zapier.
-
Integrate Live Salesforce Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Salesforce from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Salesforce & Force.com.
-
Perform Batch Operations with SAP Netweaver Gateway Data in Apache NiFi
Connect to SAP Netweaver Gateway and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for Microsoft OneDrive in SAS for Real-Time Reporting and Analytics
Connect to real-time Microsoft OneDrive in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Microsoft OneDrive.
-
Connect to BenchmarkEmail Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for BenchmarkEmail to connect to BenchmarkEmail and execute queries in PowerBuilder.
-
Access Shortcut Data from MySQL in PHP
Connect to Shortcut through the standard MySQL libraries in PHP.
-
Build ZarMoney-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ZarMoney and build web apps with connectivity to live ZarMoney.
-
Provide OData Services of Beeminder Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Beeminder by developing a WCF Service Application.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed PagerDuty to Power BI dashboards. Simply drag and drop PagerDuty into data visuals on the Power BI canvas.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Anaplan to Power BI dashboards. Simply drag and drop Anaplan into data visuals on the Power BI canvas.
-
How to Connect to & Open Samanage Data in Microsoft Excel
This article uses the CData ODBC driver for Samanage to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Bitbucket Replication to MySQL
Use CData Sync for automated, continuous, customizable Bitbucket replication to MySQL.
-
DataBind Charts to Oracle Eloqua Reporting Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle Eloqua Reporting 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.
-
ETL Amazon S3 in Oracle Data Integrator
This article shows how to transfer Amazon S3 into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Teamgate Replication to Snowflake
Use CData Sync for automated, continuous, customizable Teamgate replication to Snowflake.
-
Integrate LibreChat with Live Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft Dataverse (CDS) from within the chat interface.
-
Connect to Microsoft Ads Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft Ads in DBeaver.
-
How to connect to Beeminder Data from IntelliJ
Integrate connectivity to Beeminder with wizards in IntelliJ.
-
Connect to LinkedIn Ads Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for LinkedIn Ads in Airbyte.
-
Analyze Pipeline CRM Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Pipeline CRM and visualize live Pipeline CRM in Infragistics Reveal.
-
How to Design Twilio Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Twilio from mobile and tablet Power Apps.
-
Use Claude to Talk to Your MySQL 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 MySQL for you.
-
Import and Visualize PhantomBuster Data in Power View
Create data visualizations based on PhantomBuster in Excel.
-
Use Databricks Agent Bricks to Talk to Your Salesforce Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Salesforce & Force.com for you.
-
Connect to Amazon S3 Data from HeidiSQL
Use CData Connect AI to connect to and query live Amazon S3 from HeidiSQL.
-
Building Dynamic Web Pages with Campaigner Data Using AngularJS
Create single-page applications with live connectivity to Campaigner using the CData API Server.
-
How to connect and process Teradata from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Teradata.
-
Integrating Antigravity CLI with ElevenLabs via CData CLI
Connect ElevenLabs to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Microsoft Dataverse Data from a Connection Pool in Jetty
The Microsoft Dataverse JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Dataverse (CDS) from Web apps in Jetty.
-
How to Work with ActiveCampaign Data in ETL Validator JDBC
Connect to ActiveCampaign from ETL Validator jobs using the CData Software JDBC Driver.
-
Prepare, Blend, and Analyze Lakebase Data in Alteryx Designer (Connect AI)
Build workflows to access live Lakebase for self-service data analytics.
-
Automated Continuous Pipeline CRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to IBM DB2.
-
Connect to Bitly Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Bitly to connect to Bitly and execute queries in PowerBuilder.
-
Create Apps from Oracle Service Cloud Data in Qlik Sense Cloud
Use CData Connect AI to connect to Oracle Service Cloud Data and build apps from live Oracle Service Cloud in Qlik Sense Cloud.
-
Connect to TigerGraph Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for TigerGraph and the Script function in FileMaker Pro to connect to TigerGraph and work with TigerGraph in your FileMaker application.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Adobe Analytics to Power BI dashboards. Simply drag and drop Adobe Analytics into data visuals on the Power BI canvas.
-
Visualize Grafana Data in Sisense
Create an ElastiCube in Sisense app with access to Grafana.
-
Replicate Multiple Avro Accounts
Replicate multiple Avro accounts to one or many databases.
-
Publish Oracle-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Oracle Database.
-
Consume Sage Cloud Accounting OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Sage Cloud Accounting feeds that reflect any changes in SAP Lumira.
-
Integrate Live Box Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Box to Blue Prism using the CData ODBC Driver for Box to create automated workflows for repetitive business tasks.
-
Access Hacker News Data from MySQL in Amazon QuickSight
Connect to Hacker News and build visualizations of Hacker News using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Reckon Accounts Hosted Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Apache Kafka.
-
Analyze SAP ByDesign Data in Looker
Use CData Connect AI to connect to SAP ByDesign Data from Looker and build custom apps using live SAP Business ByDesign.
-
How to Access Live Cloudflare Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Cloudflare enables you to integrate Cloudflare into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software JDBC Driver for Salesforce CRM Analytics in MicroStrategy
Connect to Salesforce CRM Analytics in MicroStrategy Developer using the CData Software JDBC Driver for Salesforce CRM Analytics.
-
Build Aircall-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Aircall Data in Claude Code to assist with building Aircall-powered applications.
-
Build Stack Exchange-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Stack Exchange Data in GitHub Copilot to assist with building Stack Exchange-powered applications.
-
Build Dashboards with Zoho Inventory Data in Dundas BI
Create dynamic dashboards and perform analytics based on Zoho Inventory in Dundas BI.
-
Connecting GenSpark with SAP Concur Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP Concur without any replication or custom integration required.
-
Create SAP Ariba Procurement-Connected Dashboards in Grafana
Connect to SAP Ariba Procurement Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP Ariba Procurement.
-
How to Visualize Drift Data in Python with pandas
Use pandas and other modules to analyze and visualize live Drift in Python.
-
Replicate Google Ad Manager Data to Multiple Databases via the CData Sync CLI
Replicate Google Ad Manager to disparate databases with a single configuration.