CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for Invoiced in SAS for Real-Time Reporting and Analytics
Connect to real-time Invoiced in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Invoiced.
-
Integrating Claude Code CLI with Bitly 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 connect to Cloudant Data from IntelliJ
Integrate connectivity to IBM Cloudant with wizards in IntelliJ.
-
Connect HDFS Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Apache HDFS using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect to Invoiced Data from Spring Boot
Connect to Invoiced in a Spring Boot Application using the CData API Driver for JDBC
-
Stream Freshsales Data into Apache Kafka Topics
Access and stream Freshsales in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use Biml to Build SSIS Tasks to Replicate IBM Cloud Object Storage Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate IBM Cloud Object Storage to SQL Server.
-
Getting Started with the CData ODBC Driver for Sybase
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Sybase.
-
Integrate Cloudflare Data in Pentaho Data Integration
Build ETL pipelines based on Cloudflare in the Pentaho Data Integration tool.
-
How to Query Live SFTP Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SFTP data in natural language using Python.
-
Build AI/ML Models with Live SAP HANA Data using Dataiku
Connect SAP HANA Data with Dataiku using the CData JDBC Driver for SAP HANA.
-
Connecting Moonlit Workflow with Freshservice 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 Freshservice in real time.
-
Explore Geographical Relationships in Workday Data with Power Map
Create data visualizations with Workday in Power Map.
-
Connect to Pinecone Data in CloverDX (formerly CloverETL)
Transfer Pinecone using the visual workflow in the CloverDX data integration tool.
-
Stream Teradata Data into Apache Kafka Topics
Access and stream Teradata in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Import and Visualize Float Data in Power View
Create data visualizations based on Float in Excel.
-
Migrating data from Billsby to Google BigQuery using CData SSIS Components.
Easily push Billsby to Google BigQuery using the CData SSIS Tasks for Billsby and Google BigQuery.
-
Connect to LeadDesk Data in NetBeans
Connect to LeadDesk in NetBeans with the data source configuration wizard.
-
Build Dashboards with Avalara AvaTax Data in DBxtra
Create dynamic dashboards and perform analytics based on Avalara AvaTax in DBxtra.
-
DataBind Close Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Close to a chart.
-
Replicate Multiple Datadog Accounts
Replicate multiple Datadog accounts to one or many databases.
-
Create Power BI Reports on Real-Time Gmail Data
Use the CData ODBC Driver for Gmail to visualize Gmail in Power BI Desktop.
-
Load Blackbaud FE NXT Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Blackbaud FE NXT to a database.
-
Getting Started with the CData JDBC Driver for FreeAgent
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for FreeAgent.
-
Integrate Goose with Live CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Apache CouchDB from within the local AI agent.
-
Use JayDeBeApi to access Monday.com Data in Python
Use standard Python scripting and the development environment of your choice to access live Monday.com.
-
How to connect and process Azure DevOps from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Azure DevOps.
-
Automated Continuous Slack Replication to SQL Server
Use CData Sync for automated, continuous, customizable Slack replication to SQL Server.
-
Access ChargeOver Data from MySQL in PHP
Connect to ChargeOver through the standard MySQL libraries in PHP.
-
Build Google Analytics-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Analytics and build Google Analytics-connected web apps with Axios.
-
Natively Connect to Factorial Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Factorial. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData Power BI Connector for Dropbox
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Dropbox.
-
Access Live Microsoft Dataverse Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft Dataverse (CDS) from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Easily Integrate AlloyDB Data in Lazarus Pascal IDE
Learn how to easily integrate live Google AlloyDB in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Klipfolio Data from PowerBuilder via ADO.NET
This article demonstrates how to access Klipfolio from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Access Vimeo 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 Vimeo.
-
Use the CData Software ODBC Driver for Timely in SAS for Real-Time Reporting and Analytics
Connect to real-time Timely in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Timely.
-
Connect to Retently Data in RazorSQL
Connect to Retently from wizards and query Retently from the GUI in the RazorSQL database management tool.
-
Access Cloudant Data from MySQL in PHP
Connect to Cloudant through the standard MySQL libraries in PHP.
-
Establish a Live Connection with Procore Data using Tableau Bridge
The CData ODBC Driver for Procore enables you to integrate live Procore into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Presto Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Presto and the SQL Gateway to access Presto from Google Apps Script.
-
Automated Quaderno Data Replication to Teradata
Use CData Sync to Customize and automate Quaderno replication to Teradata.
-
Build Visualizations of Superchat Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Superchat in Birst.
-
DataBind Controls to Stack Exchange Data in Delphi
DataBind to Stack Exchange in Delphi with standard data access components and controls.
-
How to connect PolyBase to Harvest
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Harvest.
-
Import and Visualize Amplitude Data in Power View
Create data visualizations based on Amplitude in Excel.
-
Import and Visualize CampaignMonitor Data in Power View
Create data visualizations based on CampaignMonitor in Excel.
-
How to integrate Metabase with LinkedIn Data
Use CData Connect AI to connect to live LinkedIn and create an interactive dashboard in Metabase from LinkedIn.
-
How to Connect DBeaver to Strava via a JDBC Driver
Manage Strava with visual tools in DBeaver like the query browser.
-
Add Google Drive Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Drive with the Informatica Enterprise Data Catalog to classify and organize data.
-
Write a Simple Go Application to work with Blackbaud FE NXT Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Blackbaud FE NXT.
-
Connect to and Visualize Live SharePoint Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft SharePoint.
-
Automated Continuous BambooHR Replication to Oracle
Use CData Sync for automated, continuous, customizable BambooHR replication to Oracle.
-
Connect to ZohoMarketingHub Data in CloverDX (formerly CloverETL)
Transfer ZohoMarketingHub using the visual workflow in the CloverDX data integration tool.
-
Connect to QuickBooks Online Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live QuickBooks Online.
-
Access Live SAP ByDesign Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Business ByDesign from your Excel spreadsheets.
-
Integrate with live Salesforce Pardot Data in Jitterbit
Use CData Connect AI to connect to and integrate live Salesforce Pardot in Jitterbit.
-
Connecting Moonlit Workflow with Azure Analysis Services 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 Azure Analysis Services in real time.
-
View Reports on Real-Time Wrike Data in Power BI Report Server
Use the CData ODBC Driver for Wrike to visualize Wrike in Power BI Desktop and then publish them to Power BI Report Server.
-
Process & Analyze Excel Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Excel Data.
-
Automated Continuous Planio Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Planio replication to AlloyDB.
-
Build Visualizations of Azure Synapse Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Azure Synapse in Birst.
-
Build GitHub-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for GitHub Data and create custom apps in Mendix.
-
Sage 200 Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Sage 200 through CData Connect AI using different applications and tools.
-
Automated Continuous Highrise Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Highrise CRM replication to OneLake in Microsoft Fabric.
-
Access Live Amazon Marketplace Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Amazon Marketplace in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Presto Data from HeidiSQL
Use CData Connect AI to connect to and query live Presto from HeidiSQL.
-
How to Work with AdRoll Data in ETL Validator JDBC
Connect to AdRoll from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software JDBC Driver for MariaDB in MicroStrategy Web
Connect to MariaDB in MicroStrategy Web using the CData Software JDBC Driver for MariaDB.
-
Query Live Shopify 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 Shopify directly from the development environment.
-
Visualize Live Adobe Target Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Adobe Target using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Redis Data in ColdFusion
Write standard ColdFusion data access code to connect to Redis.
-
How to connect to Amazon S3 Data with Squirrel SQL client
Connect to Amazon S3 and execute queries in the Squirrel SQL Client.
-
Integrate Live eBay Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to eBay from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live eBay.
-
Build Redis-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Redis Data and create custom apps in Mendix.
-
DataBind Controls to Omnisend Data in C++Builder
DataBind to Omnisend in C++Builder with standard components and controls.
-
Integrate with Suadeo Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Suadeo to a JSON file on disk.
-
Build Semantic Layer Views for Brex Data in APOS Live Data Gateway
Use the CData Connector for Brex in APOS Live Data Gateway to build Semantic Layer Views for Brex.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Klaviyo
Provide connectivity to Klaviyo through an SAP BusinessObjects universe.
-
Deploy the ADO.NET Provider for OData on an SSRS Report Server
Connect to OData 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.
-
Use the CData ODBC Driver for GitHub from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for GitHub to connect to GitHub from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring GitHub in Excel.
-
Connect to Guru Data in HULFT Integrate
Connect to Guru as a JDBC data source in HULFT Integrate
-
Connecting Agentforce with BigCommerce Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your BigCommerce for you.
-
Work with Live Dynamics CRM Data in Power Query
Use CData Connect AI to connect to Microsoft Dynamics CRM and work with live Microsoft Dynamics CRM in Microsoft Power Query.
-
Build OData-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live OData and build OData-connected web apps with Axios.
-
Use the CData Software ODBC Driver for Contentful in SAS for Real-Time Reporting and Analytics
Connect to real-time Contentful in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Contentful.
-
How to Connect to & Open Miro Data in Microsoft Excel
This article uses the CData ODBC driver for Miro to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Replicate Impala Data in Heroku for Use in Salesforce Connect
Replicate Apache Impala to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Presto-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Presto.
-
Integrating Kiro CLI with Parquet 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.
-
Easily Integrate Sage 300 Data in Lazarus Pascal IDE
Learn how to easily integrate live Sage 300 in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access SAP SuccessFactors LMS Data from MySQL in PHP
Connect to SAP SuccessFactors LMS through the standard MySQL libraries in PHP.
-
Automate Excel Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Excel and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to EnterpriseDB Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live EnterpriseDB.
-
How to Connect DBeaver to Optimizely via a JDBC Driver
Manage Optimizely with visual tools in DBeaver like the query browser.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Placid
Provide connectivity to Placid through an SAP BusinessObjects universe.
-
Access Live Redis Data in Coginiti Pro
Connect to and query live Redis from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Import Real-Time Box Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Box in ColdFusion.
-
Connect to SharePoint Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft SharePoint.
-
Connect to Front Data in Aqua Data Studio
Access Front from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.