CData Software - Knowledge Base
Recent Articles
-
Build a Simple VCL Application for PabblySubscriptions Data
How to build a simple VCL Application to view PabblySubscriptions data in RAD Studio using the CData ODBC Driver for PabblySubscriptions.
-
A PostgreSQL Interface for Email Data using the CData ODBC Driver
Use the SQL Gateway and Email ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to and Visualize Live WooCommerce Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live WooCommerce data.
-
Integrating Kiro with Acumatica 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 Live SAP Ariba Procurement 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 SAP Ariba Procurement data for you.
-
Connect to Apollo Data from HeidiSQL
Use CData Connect AI to connect to and query live Apollo data from HeidiSQL.
-
Query EnterpriseDB Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume EnterpriseDB entities in PHP by modeling them as objects.
-
Prepare, Blend, and Analyze Coda Data in Alteryx Designer (ODBC)
Build workflows to access live Coda data for self-service data analytics.
-
Replicate MYOB AccountRight Data to Multiple Databases
Replicate MYOB AccountRight data to disparate databases with a point-and-click configuration.
-
Integrate Devin with Live Shopify 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 Shopify data.
-
Build Dashboards with SingleStore Data in DBxtra
Create dynamic dashboards and perform analytics based on SingleStore data in DBxtra.
-
How to Connect to Live Twilio 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 Twilio data through natural language.
-
Work with Live GitLab Data in Power Query
Use CData Connect AI to connect to GitLab data and work with live GitLab data in Microsoft Power Query.
-
Connect to Bitly Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Bitly and work with Bitly data in your FileMaker applications.
-
Getting Started with the CData Tableau Connector for Beeminder
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Query SAP Ariba Source Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP Ariba Source data from Node.js.
-
Connect to SendPulse 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 SendPulse data.
-
Integrate OneNote Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to OneNote data and integrate live OneNote data into your Power Automate tasks.
-
Create Bannerbear-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Bannerbear Data from Klipfolio and build custom visualizations using live Bannerbear data.
-
Integrating Dataiku with Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Google Campaign Manager 360 data.
-
Getting Started with the CData SSIS Components for Vercel
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Vercel.
-
Easily Build Angular2 Database Apps
Use the API Server and Angular 2 to Build Dynamic Web Apps with Live Database Data.
-
Build AI Agents with BigQuery 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 BigQuery data through CData Connect AI.
-
Seamlessly Bring Notion Data into Retool Using CData Connect AI
Integrate Notion data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Create Dynamic Office 365 Grids Using the Infragistics XamDataGrid
Learn how you can connect Office 365 to Infragistics XamDataGrid to build dynamic grids.
-
Analyze Gorgias Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Gorgias data with the CData JDBC Driver for Gorgias.
-
Getting Started with the CData ODBC Driver for SAP HANA
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP HANA.
-
Visualize Live Adobe Target Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Adobe Target data.
-
Use the CData ODBC Driver for Gumroad from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Gumroad to connect to Gumroad data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Gumroad data in Excel.
-
Connect to and Visualize Live Tickspot Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Tickspot data.
-
Moving Data from Highrise to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Highrise data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to publish and share Opsgenie Data dashboards with Tableau Server
The CData ODBC driver for Opsgenie enables you integrate Opsgenie data into Tableau dashboards.
-
Create Reports with Hubstaff Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Hubstaff data.
-
Automated Continuous Optimizely Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Optimizely replication to delimited files (CSV/TSV).
-
Integrate Open WebUI with Live Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Azure Analysis Services data from within the chat interface.
-
Use Databricks Agent Bricks to Talk to Your Attio Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Attio data for you.
-
Connect to FHIR Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to FHIR.
-
How to Connect to Live Azure Synapse Data 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 Azure Synapse data for you.
-
DataBind PostgreSQL Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for PostgreSQL with the DevExpress Windows Forms and Web controls to provide PostgreSQL data to a chart.
-
Model Snowflake Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Snowflake, enabling the direct import of real-time Snowflake data.
-
Add JDBC-ODBC Bridge Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for JDBC-ODBC Bridge with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous SAP Ariba Source Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to SQL Server.
-
Easily Integrate Basecamp Data in Lazarus Pascal IDE
Learn how to easily integrate live Basecamp data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating OpenCode with Phoenix 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.
-
Integrating Claude Code CLI with CapsuleCRM 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.
-
Feed YouTube Analytics Data into FineReport
How to set YouTube Analytics data as a JDBC data source in FineReport.
-
Connect to BambooHR Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to BambooHR and work with BambooHR data in your FileMaker applications.
-
Use the CData Software ODBC Driver for Freshsales in MicroStrategy Web
Connect to Freshsales data in MicroStrategy Web using the CData Software ODBC Driver for Freshsales.
-
Connect to Airtable Data in Ruby
Connect to Airtable data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Perform Batch Operations with Access Data in Apache NiFi
Connect to Access data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
DataBind Controls to Microsoft OneDrive Data in Delphi
DataBind to Microsoft OneDrive data in Delphi with standard data access components and controls.
-
Integrate Live Reckon Accounts Hosted Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Reckon Accounts Hosted from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Reckon Accounts Hosted data.
-
Use CData Connect AI to Access Okta Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Okta data in the Power Pivot business intelligence tool.
-
Create Informatica Mappings From/To an ODBC Data Source for Trello
Create an ODBC connection to Trello in Informatica and browse and transfer Trello data.
-
Use the CData Software ODBC Driver for SAP HANA in MicroStrategy Desktop
Connect to SAP HANA data in MicroStrategy Desktop using the CData Software ODBC Driver for SAP HANA.
-
How to Connect to Webex Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Webex data. Leverage the pyodbc module for ODBC in Python.
-
Publish Reports with Oracle Eloqua Reporting Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle Eloqua Reporting data.
-
Access Live Box Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Box data into the statistical analysis tools available in SAS JMP. This article shows how to use Box data in the Graph Builder and Query Builder.
-
Connect and Query Live Microsoft Ads Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Microsoft Ads data into Databricks and enable direct, live querying and analysis without replication.
-
Access Amazon Athena Data from MySQL in PHP
Connect to Amazon Athena through the standard MySQL libraries in PHP.
-
How to connect to ConvertKit Data from IntelliJ
Integrate connectivity to ConvertKit data with wizards in IntelliJ.
-
Build AI/ML Models with Live Notion Data using Dataiku
Connect Notion Data with Dataiku using the CData API Driver for JDBC.
-
Build Bullhorn CRM-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Bullhorn CRM data.
-
Automated Vertica Data Replication to Teradata
Use CData Sync to Customize and automate Vertica data replication to Teradata.
-
Create a Data Access Object for Email Data using JDBI
A brief overview of creating a SQL Object API for Email data in JDBI.
-
Automate Float Data Replication to Azure Data Lake
Use CData Sync to customize and automate Float data replication to Azure Data Lake.
-
Automate Marketo Data Replication to Couchbase
Use CData Sync to Customize and automate Marketo data replication to Couchbase.
-
Getting Started with the CData SSIS Components for Adobe Commerce
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Adobe Commerce.
-
Build Freshdesk-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Freshdesk data and build Freshdesk-connected web apps with Axios.
-
Connect to MarkLogic Data in Jaspersoft Studio
Execute SQL to remote MarkLogic data in Jaspersoft Studio.
-
Query Superchat Data in DataGrip
Create a Data Source for Superchat in DataGrip and use SQL to query live Superchat data.
-
Connecting Pipedream with Amazon DynamoDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Amazon DynamoDB data in real time.
-
Publish Databricks-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Databricks data.
-
How to Easily Query Cloudflare Data in OpenOffice Base
Connect to Cloudflare data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create Datasets from PostgreSQL in Domo Workbench and Build Visualizations of PostgreSQL Data in Domo
Use the CData Software ODBC Driver for PostgreSQL to create datasets from PostgreSQL data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Sybase IQ Data from PowerBuilder via ADO.NET
This article demonstrates how to access Sybase IQ data from Appeon PowerBuilder using the CData ADO.NET Provider for Sybase IQ.
-
Create Salesforce CRM Analytics-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Salesforce CRM Analytics Data from OutSystems and build custom enterprise apps using live Salesforce CRM Analytics data.
-
Build Automated Workflows with Live SAP ByDesign Data in Workato
Use CData Connect AI to connect to live SAP ByDesign data and build automated workflows in Workato.
-
Build an OLAP Cube in SSAS from Teamgate Data
Establish a connection to Teamgate data data from SQL Server Analysis Services, and use the Teamgate Data Provider to build OLAP cubes for use in analytics and reporting.
-
Getting Started with the CData Connect AI Python SDK for Oracle Eloqua
Install the CData Connect AI Python SDK to read and write live Oracle Eloqua data with standard DB-API 2.0 Python code.
-
Feed ZohoPeople Data into FineReport
How to set ZohoPeople data as a JDBC data source in FineReport.
-
Connecting Moonlit Workflow with Power BI XMLA 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 Power BI XMLA data in real time.
-
How to import Trello Data into Apache Solr
Use the CData Software JDBC Driver for Trello in Data Import Handler and create an automated import of Trello data to Apache Solr Enterprise Search platform.
-
Connect to Billsby Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Billsby and the SQL Gateway to access Billsby data from Google Apps Script.
-
Build Shortcut-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Shortcut data.
-
Build Apps with Live Monday.com data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Monday.com data into the Adalo platform and build custom mobile and web applications with real-time Monday.com data.
-
Integrate Open WebUI with Live Anaplan Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Anaplan data from within the chat interface.
-
Automated Continuous Exact Online Replication to SQL Server
Use CData Sync for automated, continuous, customizable Exact Online replication to SQL Server.
-
How to Connect to Live SageHR 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 SageHR data for you.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Printify
Provide connectivity to Printify data through an SAP BusinessObjects universe.
-
Connect to Oracle HCM Cloud Data in RapidMiner
Integrate Oracle HCM Cloud data with standard components and data source configuration wizards in RapidMiner Studio.
-
Interact with Live SAP ByDesign Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SAP ByDesign data.
-
Integrate with MongoDB Data in SnapLogic
Use CData Connect AI to connect to and integrate with live MongoDB data in SnapLogic.
-
How to import SAP Concur Data into Apache Solr
Use the CData Software JDBC Driver for SAP Concur in Data Import Handler and create an automated import of SAP Concur data to Apache Solr Enterprise Search platform.
-
Connect to NetSuite SuiteAnalytics Data from HeidiSQL
Use CData Connect AI to connect to and query live NetSuite SuiteAnalytics data from HeidiSQL.
-
Connect to Paymo 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 Paymo data.
-
Integrate with Facebook Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Facebook data in SnapLogic.
-
How to connect Amazon QuickSight to Bright Data Data
Create a connection to Bright Data data in CData Connect AI and insert Bright Data data into Amazon QuickSight SPICE to build interactive dashboards.
-
Use the CData Software ODBC Driver for Microsoft Ads in MicroStrategy Web
Connect to Microsoft Ads data in MicroStrategy Web using the CData Software ODBC Driver for Microsoft Ads.
-
Access Live Office 365 Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Office 365 data from your Excel spreadsheets.