CData Software - Knowledge Base
Recent Articles
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Calendar
Provide connectivity to Google Calendar data through an SAP BusinessObjects universe.
-
Extract, Transform, and Load Avro Data in Informatica PowerCenter
Create a simple Workflow for Avro data in Informatica PowerCenter.
-
How to Access Live MYOB AccountRight Data in Power Automate Desktop via ODBC
The CData ODBC Driver for MYOB AccountRight enables you to integrate MYOB AccountRight data into workflows built using Microsoft Power Automate Desktop.
-
Use CData Connect AI to Access Acumatica Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Acumatica data in the Power Pivot business intelligence tool.
-
How to connect to Elasticsearch Data in DBVisualizer
Integrate Elasticsearch data with visual data analysis tools and data connection wizards in DBVisualizer
-
Natively Connect to SAP HANA XS Advanced Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SAP HANA XS Advanced data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Zoho Books Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Zoho Books replication to PostgreSQL.
-
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 HBase data from within the chat interface.
-
Excel Spreadsheet Automation on Onfleet Data with the QUERY Formula
Pull data from Onfleet, automate spreadsheets, and more with the QUERY formula.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP SuccessFactors
Create an ODBC connection to SAP SuccessFactors in Informatica and browse and transfer SAP SuccessFactors data.
-
Create Dashboards and Visualize Live Kafka Data in Geckoboard
Use CData Connect AI to connect to live Kafka data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Validate Asana Data with QuerySurge
Access and validate Asana data in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Keap Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Keap replication to Amazon Redshift.
-
Visualize Live Google Translate Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Translate data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Query Certinia Data in MySQL Workbench
Execute MySQL queries against live Certinia data from MySQL Workbench.
-
Build Visualizations of Azure Table Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Azure Table data in Birst.
-
Integrate Real-Time Access to Microsoft Ads in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft Ads data in real time.
-
DataBind QuickBooks Online Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for QuickBooks Online with the DevExpress Windows Forms and Web controls to provide QuickBooks Online data to a chart.
-
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 data in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Dashboards with Zoho Books Data in Dundas BI
Create dynamic dashboards and perform analytics based on Zoho Books data in Dundas BI.
-
Visualize Live Avalara AvaTax Data in the Power BI Service
Use CData Connect AI to connect to live Avalara AvaTax data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Dify with Live Mode Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Mode data.
-
Replicate Sage Intacct Data to Multiple Databases
Replicate Sage Intacct data to disparate databases with a point-and-click configuration.
-
Query Typeform Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Typeform data from Node.js.
-
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.
-
Provide OData Services of RabbitMQ Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for RabbitMQ data by developing a WCF Service Application.
-
Connect to Gorgias Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Gorgias data using standard SQL.
-
Use the CData Software JDBC Driver for Google Calendar in MicroStrategy
Connect to Google Calendar data in MicroStrategy Developer using the CData Software JDBC Driver for Google Calendar.
-
Publish Perigon-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Perigon data.
-
Integrate with Azure Data Catalog Data in JReport Designer
Create charts and reports based on Azure Data Catalog data in JReport Designer.
-
Analyze Pinterest Data in Cognos Analytics
Use CData Connect AI to connect to Pinterest Data from Cognos Analytics and analyze live Pinterest data.
-
Automated Continuous Timely Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Timely replication to IBM DB2.
-
Visualize Rebilly Data in Tableau
The CData ODBC driver for Rebilly enables you integrate Rebilly data into Tableau dashboards.
-
Connect to ShipStation in SpagoBI
Create reports featuring live ShipStation data in SpagoBI Studio. Host ShipStation reports on SpagoBI Server.
-
Build a PostgreSQL Interface for Quaderno Data using the CData JDBC Driver
Use the Remoting features of the Quaderno JDBC Driver to create a PostgreSQL entry-point for data access.
-
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 data.
-
Qualaroo Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Qualaroo facts in real time.
-
How to Easily Query Zoho CRM Data in OpenOffice Base
Connect to Zoho CRM data in OpenOffice Base using the CData ODBC Driver for Zoho CRM and generate reports with live data insights.
-
Integrate Live Outreach.io Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Outreach.io data from within the IDE.
-
Access Sybase Data from MySQL in PHP
Connect to Sybase through the standard MySQL libraries in PHP.
-
Getting Started with the CData Connect AI Python SDK for FTP
Install the CData Connect AI Python SDK to read and write live FTP data with standard DB-API 2.0 Python code.
-
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 data for you.
-
How to Easily Query ElevenLabs Data in OpenOffice Base
Connect to ElevenLabs data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Connect to Live Certinia Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Certinia data for you.
-
Connect to xBase Data in DBeaver
Use the CData ODBC Driver to connect to xBase data in DBeaver.
-
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 services.
-
Analyze Square Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Square data in Microsoft R Open.
-
Work with Oracle Data in FoxPro
Load Oracle data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live Sugar CRM Data in Excel 365 Online (Excel for the web)
Connect to Sugar CRM data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrating OpenCode with Mistral AI 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.
-
Create Informatica Mappings From/To an ODBC Data Source for Qualaroo
Create an ODBC connection to Qualaroo in Informatica and browse and transfer Qualaroo data.
-
How to Easily Query Pinecone Data in OpenOffice Base
Connect to Pinecone data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create Gong Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Gong data access from reports, embedded analytics, and more.
-
How to connect SharePoint with Salesforce CRM Analytics Data through external lists
Provide Salesforce CRM Analytics data to SharePoint users as an external list.
-
Automate AfterShip Data Replication to Azure Synapse
Use CData Sync to customize and automate AfterShip data replication to Azure Synapse.
-
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 data.
-
Connect to Sage Intacct Data from PowerBuilder via ADO.NET
This article demonstrates how to access Sage Intacct data from Appeon PowerBuilder using the CData ADO.NET Provider for Sage Intacct.
-
Connect to LightSpeedRetail Data from a Connection Pool in JBoss
Integrate LightSpeedRetail data into Java servlets: Use the Management Console in JBoss to install the LightSpeedRetail JDBC Driver.
-
ETL Google Drive in Oracle Data Integrator
This article shows how to transfer Google Drive data into a data warehouse using Oracle Data Integrator.
-
How to Work with Act-On Data in AWS Glue Jobs Using JDBC
Connect to Act-On from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
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 data in Domo Workbench and then build visualizations in the Domo service.
-
Consume Google Search OData Feeds in PowerBuilder
This article demonstrates how to consume Google Search results as OData feeds from PowerBuilder using the API Server.
-
Automated Continuous Vertica Replication to SQL Server
Use CData Sync for automated, continuous, customizable Vertica replication to SQL Server.
-
DataBind Charts to ElevenLabs Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ElevenLabs data 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.
-
Build Apps with Live Pinterest data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Pinterest data into the Adalo platform and build custom mobile and web applications with real-time Pinterest data.
-
DataBind Charts to Salesforce Pardot Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Salesforce Pardot data 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.
-
Automated Continuous Google Calendar Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Calendar replication to SQLite.
-
Connect to Google Spanner Data in JRuby
Create a simple JRuby app with access to live Google Spanner data.
-
Access Live Klaviyo Data in Coginiti Pro
Connect to and query live Klaviyo data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Import Real-Time Azure Analysis Services Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Azure Analysis Services data in ColdFusion.
-
Write a Simple Go Application to work with Zuora Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zuora data.
-
How to work with Amplitude Data in Apache Spark using SQL
Access and process Amplitude Data in Apache Spark using the CData Software JDBC Driver.
-
Prepare, Blend, and Analyze BenchmarkEmail Data in Alteryx Designer (Connect AI)
Build workflows to access live BenchmarkEmail data for self-service data analytics.
-
Use Azure AI Foundry to Talk to Your Epicor Kinetic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Epicor Kinetic data for you.
-
How to Query ZohoPeople Data in MySQL Workbench
Execute MySQL queries against live ZohoPeople data from MySQL Workbench.
-
Operational Reporting on SAP SuccessFactors LMS Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP SuccessFactors LMS data.
-
Link Rebilly with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Rebilly data in Filemaker Pro for Mac or Windows.
-
Build a Simple VCL Application for Jira Data
How to build a simple VCL Application to view Jira data in RAD Studio using the CData ODBC Driver for Jira.
-
Integrate Amplitude with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Amplitude with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Amplitude data.
-
Import Real-Time Elasticsearch Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Elasticsearch data in ColdFusion.
-
Visualize Live OneNote Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live OneNote data.
-
Use the CData Software ODBC Driver for Splunk in MicroStrategy Web
Connect to Splunk data in MicroStrategy Web using the CData Software ODBC Driver for Splunk.
-
Connect to and Visualize Live Printful Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Printful data.
-
Automated Continuous Facebook Replication to SQLite
Use CData Sync for automated, continuous, customizable Facebook replication to SQLite.
-
Access Mocean Data from MySQL in Amazon QuickSight
Connect to Mocean and build visualizations of Mocean data using a MySQL Connection in Amazon QuickSight.
-
How to load Samanage data into Elasticsearch via Logstash
Introducing a simple method to load Samanage data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating LangChain with Tavily Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Tavily data within automated workflows.
-
Connect to Gong Data in Jaspersoft Studio
Execute SQL to remote Gong data in Jaspersoft Studio.
-
Connect to SpaceX Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SpaceX to connect to SpaceX data and execute queries in PowerBuilder.
-
DataBind Controls to Apollo Data in C++Builder
DataBind to Apollo data in C++Builder with standard components and controls.
-
Integrate Cline with Live Attio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Attio data from within your IDE.
-
Explore Geographical Relationships in Accelo Data with Power Map
Create data visualizations with Accelo data in Power Map.
-
How to Visualize Microsoft Planner Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft Planner data 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 data through MCP integration.
-
Integrate Goose with Live ShipEngine Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live ShipEngine data from within the local AI agent.
-
Getting Started with the CData Power BI Connector for Moosend
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Access Short.io 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 Short.io data.
-
DataBind Controls to Salesforce CRM Analytics Data in Delphi
DataBind to Salesforce CRM Analytics data in Delphi with standard data access components and controls.
-
Build a Simple VCL Application for Factorial Data
How to build a simple VCL Application to view Factorial data in RAD Studio using the CData ODBC Driver for Factorial.
-
How to Connect to & Open MySQL Data in Microsoft Excel
This article uses the CData ODBC driver for MySQL to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.