CData Software - Knowledge Base
Recent Articles
-
Integrate with Onfleet Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Onfleet data to a JSON file on disk.
-
Moving Data from ChargeOver to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ChargeOver data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Query Certinia Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Certinia entities in PHP by modeling them as objects.
-
Connect to Splunk Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Splunk and the Script function in FileMaker Pro to connect to Splunk and work with Splunk data in your FileMaker application.
-
Automated Continuous Sage 300 Replication to MongoDB
Use CData Sync for automated, continuous, customizable Sage 300 replication to MongoDB.
-
Use Biml to Build SSIS Tasks to Replicate SingleStore Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SingleStore data to SQL Server.
-
Rapidly Develop Stack Exchange-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 Stack Exchange.
-
Connect to FreeAgent Data in Aqua Data Studio
Access FreeAgent data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to connect to Phoenix Data from IntelliJ
Integrate connectivity to Phoenix data with wizards in IntelliJ.
-
Visualize Microsoft Planner Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Microsoft Planner data into TIBCO Spotfire.
-
Manage Invoiced Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Invoiced.
-
Access Live Bugsnag Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Bugsnag data into the statistical analysis tools available in SAS JMP. This article shows how to use Bugsnag data in the Graph Builder and Query Builder.
-
How to create an RPA flow for Excel Data in UiPath Studio
Use the Excel ODBC Driver to create workflows that access real-time Excel data without any coding.
-
Access Live Hugging Face Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Hugging Face data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Live CockroachDB Data in PostGresSQL Interface through CData Connect AI
Create a live connection to CockroachDB in CData Connect AI and connect to your CockroachDB data from PostgreSQL.
-
Access Live SAP Fieldglass Data in Coginiti Pro
Connect to and query live SAP Fieldglass data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Publish Azure Table-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Azure Table data.
-
Import Real-Time Azure DevOps Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Azure DevOps data in ColdFusion.
-
Use the CData ODBC Driver for Outreach.io from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Outreach.io to connect to Outreach.io data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Outreach.io data in Excel.
-
Use the CData Software ODBC Driver for Humanity in MicroStrategy Desktop
Connect to Humanity data in MicroStrategy Desktop using the CData Software ODBC Driver for Humanity.
-
Link Webex with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Webex data in Filemaker Pro for Mac or Windows.
-
ETL Zoho Books in Oracle Data Integrator
This article shows how to transfer Zoho Books data into a data warehouse using Oracle Data Integrator.
-
How to Connect Flowise AI Agents to Live ActiveCampaign Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live ActiveCampaign data without replication.
-
Connect to Live SAP Concur Data in MicroStrategy through CData Connect AI
Create a live connection to SAP Concur Data in CData Connect AI and connect to your SAP Concur data from MicroStrategy.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Yelp
Provide connectivity to Yelp data through an SAP BusinessObjects universe.
-
Create Datasets from Dynamics 365 Business Central in Domo Workbench and Build Visualizations of Dynamics 365 Business Central Data in Domo
Use the CData Software ODBC Driver for Dynamics 365 Business Central to create datasets from Dynamics 365 Business Central data in Domo Workbench and then build visualizations in the Domo service.
-
Working with Missive Data in LINQPad
Execute LINQ queries to Missive data in LINQPad.
-
Use the CData ODBC Driver for Adobe Analytics in Microsoft Power Query
You can use the CData Adobe Analytics ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Adobe Analytics data into Microsoft Power Query.
-
Access Mode 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 Mode data.
-
Use JayDeBeApi to access Mode Data in Python
Use standard Python scripting and the development environment of your choice to access live Mode data.
-
Visualize Tanda Data in Tableau
The CData ODBC driver for Tanda enables you integrate Tanda data into Tableau dashboards.
-
Access Live Timely Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Timely data into the statistical analysis tools available in SAS JMP. This article shows how to use Timely data in the Graph Builder and Query Builder.
-
Access Live Salesforce Pardot Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Salesforce Pardot data into the statistical analysis tools available in SAS JMP. This article shows how to use Salesforce Pardot data in the Graph Builder and Query Builder.
-
How to Work with Google Spanner Data in AWS Glue Jobs Using JDBC
Connect to Google Spanner from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Power BI Reports on Real-Time Close Data
Use the CData ODBC Driver for Close to visualize Close data in Power BI Desktop.
-
How to Use a Microsoft Access Database to Update XML Data in Real Time
Update XML data by creating a linked table in Microsoft Access with the CData XML ODBC Driver.
-
View Reports on Real-Time Demio Data in Power BI Report Server
Use the CData ODBC Driver for Demio to visualize Demio data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect SharePoint with ShipStation Data through external lists
Provide ShipStation data to SharePoint users as an external list.
-
Access Live Bannerbear Data in Coginiti Pro
Connect to and query live Bannerbear data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Cloudant-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Cloudant Data and create custom apps in Mendix.
-
Automate Adobe Analytics Data Replication to Couchbase
Use CData Sync to Customize and automate Adobe Analytics data replication to Couchbase.
-
Integrating GitHub Copilot with Teradata 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.
-
Visualize Onfleet Data in TIBCO Spotfire through ADO.NET
Integrate Onfleet data into dashboards in TIBCO Spotfire.
-
Use Grok to Talk to Your Dynamics NAV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Dynamics NAV data for you.
-
Access Sage 200 Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sage 200 data from your Oracle system.
-
Create Reports with Notion Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Notion data.
-
Automated Continuous Pipedrive Replication to Oracle
Use CData Sync for automated, continuous, customizable Pipedrive replication to Oracle.
-
Integrate LibreChat with Live WordPress Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live WordPress data from within the chat interface.
-
Import Real-Time Missive Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Missive data in ColdFusion.
-
Automated Continuous Oracle SCM Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Oracle SCM replication to Amazon S3.
-
How to connect SharePoint with Cassandra Data through external lists
Provide Cassandra data to SharePoint users as an external list.
-
Getting Started with the CData Python Connector for Pipedrive
Learn to install and license the CData Python Connector and configure a connection to live Pipedrive data.
-
Build Charts with Invoiced Data in Clear Analytics
Create dynamic charts and perform analytics based on Invoiced data in Clear Analytics.
-
Connect to xBase Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for xBase to connect to xBase data and execute queries in PowerBuilder.
-
Connect to Slack Data in RazorSQL
Connect to Slack from wizards and query Slack data from the GUI in the RazorSQL database management tool.
-
Analyze HDFS Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze HDFS data in Microsoft R Open.
-
Create Azure Table-Connected Applications in Appsmith
Connect to Azure Table Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Azure Table data.
-
How to integrate Oracle SCM with Apache Airflow
Access and process Oracle SCM data in Apache Airflow using the CData JDBC Driver.
-
DataBind Controls to Campaigner Data in Delphi
DataBind to Campaigner data in Delphi with standard data access components and controls.
-
Automate Cvent Data Replication to Couchbase
Use CData Sync to Customize and automate Cvent data replication to Couchbase.
-
How to integrate Azure Analysis Services with Apache Airflow
Access and process Azure Analysis Services data in Apache Airflow using the CData JDBC Driver.
-
Connecting Moonlit Workflow with TaxJar Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your TaxJar data in real time.
-
Build Apps with Live Google Ads data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Google Ads data into the Adalo platform and build custom mobile and web applications with real-time Google Ads data.
-
Integrate Cursor with Live Notion Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Notion data from within the editor.
-
Integrating Cursor with QuickBooks 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.
-
How to Build an ETL App for Azure Synapse Data in Python with CData
Create ETL applications and real-time data pipelines for Azure Synapse data in Python with petl.
-
Easily Integrate TaxJar Data in Lazarus Pascal IDE
Learn how to easily integrate live TaxJar data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect to Live LDAP Objects from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your LDAP objects for you.
-
Integrating Kiro with Coinbase 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 Dashboards with SingleStore Data in Dundas BI
Create dynamic dashboards and perform analytics based on SingleStore data in Dundas BI.
-
Automated Continuous MYOB AccountRight Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Google BigQuery.
-
Model Zoom Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Zoom, enabling the direct import of real-time Zoom data.
-
Access Live Paymo Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Paymo data from your Excel spreadsheets.
-
Visualize Live Dynamics 365 Business Central Data in the Power BI Service
Use CData Connect AI to connect to live Dynamics 365 Business Central data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Prepare, Blend, and Analyze Salesforce Data in Alteryx Designer (ODBC)
Build workflows to access live Salesforce data for self-service data analytics.
-
Connect to SAP Business One Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP Business One data in Google Apps Script.
-
Link Coinbase with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Coinbase data in Filemaker Pro for Mac or Windows.
-
Connect Rootly to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Rootly data using the CData Python MCP Server.
-
DataBind JotForm Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide JotForm data to a chart.
-
Feed Paymo Data into FineReport
How to set Paymo data as a JDBC data source in FineReport.
-
Natively Connect to Google Directory Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Directory data. Leverage the native support for ODBC in PHP.
-
Connecting Moonlit Workflow with Samanage Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Samanage data in real time.
-
Connect to Databricks Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Databricks to connect to Databricks data and execute queries in PowerBuilder.
-
DataBind Samanage Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Samanage data to a chart.
-
Connect and Query Live Azure Data Lake Storage Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Azure Data Lake Storage data into Databricks and enable direct, live querying and analysis without replication.
-
Build Agents in Relevance AI with Access to Live PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on PayPal data within intelligent agent workflows.
-
Integrate Moosend with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Moosend with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Moosend data.
-
Bidirectional Access to Zoho Creator Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Zoho Creator data in Filemaker Pro for Mac or Windows.
-
Build AI Agents with Oracle Sales 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 Oracle Sales data through CData Connect AI.
-
Connect to Google Directory from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Directory data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Xero-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Xero Data and create custom apps in Mendix.
-
Connect to Samanage Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Samanage data using standard SQL.
-
Integrate Live Salesforce 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 Salesforce data from within the IDE.
-
Use ChatGPT to Talk to Your PingOne 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 PingOne data for you.
-
Natively Connect to Foursquare Data in PHP
The CData ODBC driver for Foursquare enables you to create PHP applications with connectivity to Foursquare data. Leverage the native support for ODBC in PHP.
-
How to Connect DBeaver to Adobe Commerce via a JDBC Driver
Manage Adobe Commerce data with visual tools in DBeaver like the query browser.
-
Connect to Slack Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Slack data in the Denodo Virtual DataPort Administrator.
-
Connect to Shortcut Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Shortcut to connect to Shortcut data and execute queries in PowerBuilder.
-
Connect to Perigon Data in Jaspersoft Studio
Execute SQL to remote Perigon data in Jaspersoft Studio.
-
Getting Started with the CData Python Connector for Deel
Learn to install and license the CData Python Connector and configure a connection to live Deel data.