CData Software - Knowledge Base
Recent Articles
-
Connect Mocean Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Mocean data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Configure the CData JDBC Driver for MailerLite in a Connection Pool in Tomcat
Connect to MailerLite data from a connection pool in Tomcat.
-
How to work with Phoenix Data in Apache Spark using SQL
Access and process Phoenix Data in Apache Spark using the CData Software JDBC Driver.
-
Feed Bright Data Data into FineReport
How to set Bright Data data as a JDBC data source in FineReport.
-
Create PayPal-Connected Applications in Appsmith
Connect to PayPal Data via CData Connect AI in Appsmith and create custom business applications with real-time access to PayPal data.
-
How to Connect to Live ZohoSubscriptions 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 ZohoSubscriptions data for you.
-
Access ZohoDesk Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ZohoDesk data from HeidiSQL.
-
Create Reports with Microsoft Teams Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Teams data.
-
Getting Started with the CData Excel Add-In for Salesforce Data 360
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Salesforce Data 360.
-
Create SSAS Tabular Models from FTP Data
How to build a SQL Server Analysis Service Tabular Model from FTP data using CData drivers.
-
Connect to Real-Time Pushbullet Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Pushbullet data in Power Apps.
-
How to Access Live Azure DevOps Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Azure DevOps enables you to integrate Azure DevOps data into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software ODBC Driver for Bitbucket in MicroStrategy Web
Connect to Bitbucket data in MicroStrategy Web using the CData Software ODBC Driver for Bitbucket.
-
A PostgreSQL Interface for MYOB AccountRight Data (MySQL Remoting via JDBC)
Use the Remoting features of the MYOB AccountRight JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Adobe Target 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 Adobe Target data through MCP integration.
-
Integrate Devin with Live Google Contacts Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Google Contacts data.
-
Create Dynamic Zoho Books Grids Using the Infragistics XamDataGrid
Learn how you can connect Zoho Books to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Kintone Data in Pentaho Data Integration
Build ETL pipelines based on Kintone data in the Pentaho Data Integration tool.
-
How to Connect Flowise AI Agents to Live Testmonitor 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 Testmonitor data without replication.
-
Replicate Multiple Exa Accounts via the CData Sync CLI
Replicate multiple Exa accounts to one or many databases.
-
Build Dashboards with Klipfolio Data in DBxtra
Create dynamic dashboards and perform analytics based on Klipfolio data in DBxtra.
-
Connect to Mouseflow Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Mouseflow data in the Denodo Virtual DataPort Administrator.
-
Connect to ZohoInvoice Data in RazorSQL
Connect to ZohoInvoice from wizards and query ZohoInvoice data from the GUI in the RazorSQL database management tool.
-
Natively Connect to Stack Exchange Data in PHP
The CData ODBC driver for Stack Exchange enables you to create PHP applications with connectivity to Stack Exchange data. Leverage the native support for ODBC in PHP.
-
Use Claude to Talk to Your Cloudflare 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 Cloudflare data for you.
-
Design BIRT Reports on Microsoft Ads Data
Provide current Microsoft Ads data to your embedded analytics.
-
Query Live Egnyte Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Egnyte data through a conversational interface.
-
Access Live Templated Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Templated data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Analyze HBase Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of HBase data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Visualize Live SAP SuccessFactors Data in the Power BI Service
Use CData Connect AI to connect to live SAP SuccessFactors data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Dynamics 365 Business Central Data in TIBCO Spotfire through OData
Integrate Dynamics 365 Business Central data into dashboards in TIBCO Spotfire.
-
Build Xero-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Xero data.
-
Automated Continuous ZohoSubscriptions Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Apache Kafka.
-
Moving Data from FHIR to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live FHIR data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Visualize Insightly Data in Tableau
The CData ODBC driver for Insightly enables you integrate Insightly data into Tableau dashboards.
-
How to integrate Hugging Face with Apache Airflow
Access and process Hugging Face data in Apache Airflow using the CData JDBC Driver.
-
How to work with Planio Data in Apache Spark using SQL
Access and process Planio Data in Apache Spark using the CData Software JDBC Driver.
-
Creating SAP Business Warehouse-Connected Applications in Unqork
You can use CData Connect AI to feed SAP Business Warehouse data to Unqork and build custom business apps.
-
Model Bright Data Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Bright Data, enabling the direct import of real-time Bright Data data.
-
Visualize Stripe Data in TIBCO Spotfire through ADO.NET
Integrate Stripe data into dashboards in TIBCO Spotfire.
-
Use Biml to Build SSIS Tasks to Replicate Shortcut Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Shortcut data to SQL Server.
-
Build Data Flows from Guru to SQL Server using SSIS
Easily back up Guru data to SQL Server using the SSIS components for Guru.
-
Migrating data from MongoDB to Snowflake using CData SSIS Components.
Easily push MongoDB data to Snowflake using the CData SSIS Tasks for MongoDB and Snowflake.
-
Connect to Zoom Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Zoom data using standard SQL.
-
Load SAP ByDesign Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP ByDesign data to a database.
-
How to Connect DBeaver to Wrike via a JDBC Driver
Manage Wrike data with visual tools in DBeaver like the query browser.
-
Build a Simple VCL Application for Wrike Data
How to build a simple VCL Application to view Wrike data in RAD Studio using the CData ODBC Driver for Wrike.
-
Connect to Google Contacts Data in Claris FileMaker Pro
Use the CData ODBC Driver for Google Contacts in FileMaker Pro to connect to Google Contacts and work with Google Contacts data in your FileMaker applications.
-
Connecting Moonlit Workflow with WordPress 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 WordPress data in real time.
-
Create AlloyDB-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to AlloyDB Data from OutSystems and build custom enterprise apps using live AlloyDB data.
-
Integrate Real-Time Access to SFTP in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SFTP data in real time.
-
Integrating LangGraph with Elasticsearch Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Elasticsearch data within automated workflows.
-
Integrating LlamaIndex with Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Procore data in real time.
-
How to Connect to Live Google Spanner Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Google Spanner data for you.
-
Connect to Moosend Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Moosend data.
-
Import and Visualize ZarMoney Data in Power View
Create data visualizations based on ZarMoney data in Excel.
-
Automated Continuous Google Analytics Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Analytics replication to MongoDB.
-
Build Accelo-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Accelo data and build web apps with connectivity to live Accelo data.
-
How to Query Live Samanage Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Samanage data data in natural language using Python.
-
Access Live ZohoInvoice Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ZohoInvoice data from your Excel spreadsheets.
-
Building Dynamic Web Pages with RSS Feeds Using AngularJS
Create single-page applications with live connectivity to RSS using the CData API Server.
-
Integrating OpenCode with ZohoInvoice 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 Power BI Reports on Real-Time ServiceNow Data
Use the CData ODBC Driver for ServiceNow to visualize ServiceNow data in Power BI Desktop.
-
Build Apps with Live Testmonitor Data Using the Low-Code Development Platform of Mendix
Connect Testmonitor data with Mendix to build apps using the CData API Driver for JDBC.
-
Build Charts with Amplitude Data in Clear Analytics
Create dynamic charts and perform analytics based on Amplitude data in Clear Analytics.
-
How to Connect to Live Freshteam Data 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 Freshteam data for you.
-
How to Create Power BI Visual Reports with Real-Time Wrike Data
Use CData Power BI Connectors to visualize Wrike data in Power BI.
-
Feed Notion Data into FineReport
How to set Notion data as a JDBC data source in FineReport.
-
Replicate ZarMoney Data from PowerShell
Write a quick PowerShell script to query ZarMoney data. Use connectivity to the live data to replicate ZarMoney data to SQL Server.
-
Load SAP SuccessFactors LMS Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP SuccessFactors LMS data to a database.
-
Automated Continuous Unbounce Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Unbounce replication to delimited files (CSV/TSV).
-
Visualize Intercom Data in TIBCO Spotfire through ADO.NET
Integrate Intercom data into dashboards in TIBCO Spotfire.
-
Integrating Amazon Marketplace Data in Talend Cloud Data Management Platform
Connect Amazon Marketplace Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Amazon Marketplace.
-
Create Data Visualizations in Cognos BI with SAP Data
Access SAP data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Greenhouse Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Greenhouse as an External Source in Dremio.
-
Build AI/ML Models with Live Oracle Service Cloud Data using Dataiku
Connect Oracle Service Cloud Data with Dataiku using the CData JDBC Driver for Oracle Service Cloud.
-
How to connect to Ontraport Data in DBVisualizer
Integrate Ontraport data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous MySQL Replication to Oracle
Use CData Sync for automated, continuous, customizable MySQL replication to Oracle.
-
Automated Nuclia Data Replication to Teradata
Use CData Sync to Customize and automate Nuclia data replication to Teradata.
-
Cosmos DB Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Cosmos DB facts in real time.
-
Visualize REST Data in TIBCO Spotfire through OData
Integrate REST data into dashboards in TIBCO Spotfire.
-
Connecting Moonlit Workflow with Moosend 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 Moosend data in real time.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Helpscout
Provide connectivity to Helpscout data through an SAP BusinessObjects universe.
-
Getting Started with the CData ODBC Driver for Greenhouse
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Greenhouse.
-
Connect to Excel Data in Jaspersoft Studio
Execute SQL to remote Excel data in Jaspersoft Studio.
-
Connect to Typeform Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Typeform and the SQL Gateway to access Typeform data from Google Apps Script.
-
Query PostgreSQL Data through ODBC in Node.js
Use node-odbc to execute SQL queries against PostgreSQL data from Node.js.
-
Create Datasets from ActiveCampaign in Domo Workbench and Build Visualizations of ActiveCampaign Data in Domo
Use the CData Software ODBC Driver for ActiveCampaign to create datasets from ActiveCampaign data in Domo Workbench and then build visualizations in the Domo service.
-
Integrating OpenCode with Placid 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.
-
View Reports on Real-Time Microsoft Exchange Data in Power BI Report Server
Use the CData ODBC Driver for Microsoft Exchange to visualize Microsoft Exchange data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Gumloop with Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Workday data within automated workflows.
-
Getting Started with the CData JDBC Driver for AgileCRM
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for AgileCRM.
-
Getting Started with the CData ODBC Driver for Raisers Edge NXT
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Raisers Edge NXT.
-
Automated Continuous AlloyDB Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable AlloyDB replication to delimited files (CSV/TSV).
-
Connect to Parallel Data in DBeaver
Use the CData ODBC Driver to connect to Parallel data in DBeaver.
-
How to Easily Query SFTP Data in OpenOffice Base
Connect to SFTP data in OpenOffice Base using the CData ODBC Driver for SFTP and generate reports with live data insights.
-
Integrate Live IBM Informix Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live IBM Informix data to Blue Prism using the CData ODBC Driver for IBM Informix to create automated workflows for repetitive business tasks.
-
Connect to Sage 300 Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Sage 300 data from Filemaker Pro on Mac.
-
How to load Amazon Athena data into Elasticsearch via Logstash
Introducing a simple method to load Amazon Athena data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to publish and share Amazon Athena Data dashboards with Tableau Server
The CData ODBC driver for Amazon Athena enables you integrate Amazon Athena data into Tableau dashboards.