CData Software - Knowledge Base
Recent Articles
-
Access Unbounce Data from MySQL in PHP
Connect to Unbounce through the standard MySQL libraries in PHP.
-
Replicate Parallel Data to Multiple Databases
Replicate Parallel data to disparate databases with a point-and-click configuration.
-
Import Real-Time Sybase IQ Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Sybase IQ data in ColdFusion.
-
How to connect SharePoint with Splunk Data through external lists
Provide Splunk data to SharePoint users as an external list.
-
Query Live Tavily Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Tavily data directly from the development environment.
-
How to update MYOB AccountRight from Excel
This article explains how to transfer data from Excel to MYOB AccountRight using the Excel Add-In for MYOB AccountRight.
-
Visualize SAP Ariba Source Data in TIBCO Spotfire through ADO.NET
Integrate SAP Ariba Source data into dashboards in TIBCO Spotfire.
-
Connect to and Visualize Live Datadog Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Datadog data.
-
Integrating Cursor with Billsby 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.
-
Validate Placid Data with QuerySurge
Access and validate Placid data in QuerySurge using the CData JDBC Driver.
-
Connect to Google Forms Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Forms as an External Source in Dremio.
-
Natively Connect to Microsoft Exchange Data in PHP
The CData ODBC driver for Microsoft Exchange enables you to create PHP applications with connectivity to Microsoft Exchange data. Leverage the native support for ODBC in PHP.
-
How to connect to Templated Data from Spring Boot
Connect to Templated in a Spring Boot Application using the CData API Driver for JDBC
-
Import ZohoDesk Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to ZohoDesk Data and provide access to live ZohoDesk data for custom reports in the Power BI Service.
-
Work with Vimeo Data in FoxPro
Load Vimeo data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize Live Google Sheets Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Sheets data.
-
Demio Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Demio facts in real time.
-
How to connect to MailerSend Data from IntelliJ
Integrate connectivity to MailerSend data with wizards in IntelliJ.
-
How to use SQLAlchemy ORM to access Missive Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Missive data.
-
Perform Batch Operations with YouTube Analytics Data in Apache NiFi
Connect to YouTube Analytics data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Getting Started with the CData SSIS Components for Missive
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Missive.
-
How to Connect to Live Zuora Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Zuora data through natural language.
-
Use the CData Software JDBC Driver for Cloudflare in MicroStrategy Desktop
Connect to Cloudflare data in MicroStrategy Desktop using the CData Software JDBC Driver for Cloudflare.
-
A PostgreSQL Interface for Box Data (MySQL Remoting via JDBC)
Use the Remoting features of the Box JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import and Visualize Attio Data in Power View
Create data visualizations based on Attio data in Excel.
-
Connect to FHIR Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for FHIR and the Script function in FileMaker Pro to connect to FHIR and work with FHIR data in your FileMaker application.
-
Use Biml to Build SSIS Tasks to Replicate Zoho Creator Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zoho Creator data to SQL Server.
-
Build SAP Business One-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SAP Business One Data from Zoho Analytics and import live SAP Business One data.
-
Build Data Flows from Bannerbear to SQL Server using SSIS
Easily back up Bannerbear data to SQL Server using the SSIS components for Bannerbear.
-
Connect to Live FreshBooks Data in MicroStrategy through CData Connect AI
Create a live connection to FreshBooks Data in CData Connect AI and connect to your FreshBooks data from MicroStrategy.
-
How to Connect to Live RSS Feeds in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your RSS feeds for you.
-
Integrate Azure Table with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Azure Table with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Azure Table data.
-
Connecting Mastra with SAP Business One Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time SAP Business One data, no replication required.
-
Publish Crystal Reports on WooCommerce Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date WooCommerce data.
-
Feed Printify Data into FineReport
How to set Printify data as a JDBC data source in FineReport.
-
Access Live Epicor Kinetic Data in Coginiti Pro
Connect to and query live Epicor Kinetic data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to ElevenLabs Data in Jaspersoft Studio
Execute SQL to remote ElevenLabs data in Jaspersoft Studio.
-
Replicate SingleStore Data to Multiple Databases via the CData Sync CLI
Replicate SingleStore data to disparate databases with a single configuration.
-
Connect to Avaza Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Avaza and work with Avaza data in your FileMaker applications.
-
How to import CircleCI Data into Apache Solr
Use the CData Software JDBC Driver for CircleCI in Data Import Handler and create an automated import of CircleCI data to Apache Solr Enterprise Search platform.
-
Analyze Amazon Marketplace Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Amazon Marketplace data and visualize live Amazon Marketplace data in Infragistics Reveal.
-
Connect to Pushbullet Data from PowerBuilder via JDBC
This article demonstrates how to access Pushbullet data from PowerBuilder using the Pushbullet JDBC Driver.
-
A PostgreSQL Interface for MySQL Data (MySQL Remoting via JDBC)
Use the Remoting features of the MySQL JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating LangChain with Square Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Square data within automated workflows.
-
Create Reports from Bright Data Data in Looker Studio
Use CData Connect AI to gain access to live Bright Data data and create custom reports in Looker Studio.
-
Build a Simple VCL Application for eBay Analytics Data
How to build a simple VCL Application to view eBay Analytics data in RAD Studio using the CData ODBC Driver for eBay Analytics.
-
ETL Accelo in Oracle Data Integrator
This article shows how to transfer Accelo data into a data warehouse using Oracle Data Integrator.
-
Access Live Testmonitor Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Testmonitor data from your Google Sheets.
-
Integrating Gumloop with Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Exact Online data within automated workflows.
-
Integrating Claude Code with Kintone Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Kintone data within assisted coding and automated development workflows.
-
How to integrate Google Spanner with Apache Airflow
Access and process Google Spanner data in Apache Airflow using the CData JDBC Driver.
-
Query Odoo Data in ColdFusion
Write standard ColdFusion data access code to connect to Odoo data.
-
Getting Started with the CData Tableau Connector for Discord
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build AI/ML Models with Live Jodoo Data using Dataiku
Connect Jodoo Data with Dataiku using the CData API Driver for JDBC.
-
Integrate with live Teradata Data in Jitterbit
Use CData Connect AI to connect to and integrate live Teradata data in Jitterbit.
-
Access Elorus 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 Elorus data.
-
Build a PostgreSQL Interface for Billsby Data using the CData JDBC Driver
Use the Remoting features of the Billsby JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Cursor with Vimeo 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.
-
Connect to MarkLogic Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time MarkLogic data using standard SQL.
-
Use Azure AI Foundry to Talk to Your Yelp 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 Yelp data for you.
-
Integrate Live BenchmarkEmail Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to BenchmarkEmail from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live BenchmarkEmail data.
-
Build Charts with Authorize.Net Data in Clear Analytics
Create dynamic charts and perform analytics based on Authorize.Net data in Clear Analytics.
-
Use the CData ODBC Driver for Oracle Sales in Microsoft Power Query
You can use the CData Oracle Sales ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Oracle Sales data into Microsoft Power Query.
-
Build Optimizely-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Optimizely data without replication.
-
Automated Continuous Telegram Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Telegram replication to Apache Cassandra.
-
Automate Authorize.Net Data Replication to Azure Data Lake
Use CData Sync to customize and automate Authorize.Net data replication to Azure Data Lake.
-
Getting Started with the CData SSIS Components for Greenhouse
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Greenhouse.
-
Access Live Greenhouse Data in Excel 365 Online (Excel for the web)
Connect to Greenhouse data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Easily Integrate Microsoft OneDrive Data in Lazarus Pascal IDE
Learn how to easily integrate live Microsoft OneDrive data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Import Real-Time Invoiced Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Invoiced data in ColdFusion.
-
Access Live HubSpot Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to HubSpot data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Visualize Avalara AvaTax Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Avalara AvaTax data.
-
How to load JotForm data into Elasticsearch via Logstash
Introducing a simple method to load JotForm data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automate Asana Data Replication to Couchbase
Use CData Sync to Customize and automate Asana data replication to Couchbase.
-
Choosing the Best Method to Connect Oracle Financials Cloud to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Oracle Financials Cloud data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build a Singer.io Tap for Flowlu With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Flowlu data using the CData Python Connector.
-
Deploy the ADO.NET Provider for Redshift on an SSRS Report Server
Connect to Redshift data 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.
-
How to Connect to Live WooCommerce 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 WooCommerce data for you.
-
Create Reports with Guru Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Guru data.
-
Create Avro-Connected Dashboards in Grafana
Connect to Avro Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Avro data.
-
FreeAgent Reporting in OBIEE with the FreeAgent JDBC Driver
Deploy the FreeAgent JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Replicate Contentful Data to Multiple Databases
Replicate Contentful data to disparate databases with a point-and-click configuration.
-
Connect to Oracle Eloqua Data in Google Apps Script via Connect AI
Use CData Connect AI to access Oracle Eloqua data in Google Apps Script.
-
Model QuickBooks Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and QuickBooks, enabling the direct import of real-time QuickBooks data.
-
Build SAS xpt-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SAS xpt Data from Zoho Analytics and import live SAS xpt data.
-
Integrating LlamaIndex with Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Avro data in real time.
-
Working with NASA Data in LINQPad
Execute LINQ queries to NASA data in LINQPad.
-
Operational Reporting on Miro Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Miro data.
-
How to import Spotify Data into Apache Solr
Use the CData Software JDBC Driver for Spotify in Data Import Handler and create an automated import of Spotify data to Apache Solr Enterprise Search platform.
-
Use Manus AI to Talk to Your LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on LinkedIn data.
-
ETL IBM Informix in Oracle Data Integrator
This article shows how to transfer IBM Informix data into a data warehouse using Oracle Data Integrator.
-
Build Dashboards with Smartsheet Data in Dundas BI
Create dynamic dashboards and perform analytics based on Smartsheet data in Dundas BI.
-
Integrate Cline with Live Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Redis data from within your IDE.
-
Analyze Active Directory Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Active Directory data with the CData JDBC Driver for Active Directory.
-
Connect Cvent Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Cvent data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Azure DevOps-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Azure DevOps Data from Zoho Analytics and import live Azure DevOps data.
-
Build Apps with Live SparkPost Data Using the Low-Code Development Platform of Mendix
Connect SparkPost data with Mendix to build apps using the CData API Driver for JDBC.
-
How to Easily Query Amazon Athena Data in OpenOffice Base
Connect to Amazon Athena data in OpenOffice Base using the CData ODBC Driver for Amazon Athena and generate reports with live data insights.
-
Connect to Zoho Recruit Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zoho Recruit and the SQL Gateway to access Zoho Recruit data from Google Apps Script.
-
Access Live Mailgun Data in Coginiti Pro
Connect to and query live Mailgun data from the GUI in the Coginiti Pro: SQL Analytics Tool.