CData Software - Knowledge Base
Recent Articles
-
Natively Connect to IBM Informix Data in PHP
The CData ODBC driver for IBM Informix enables you to create PHP applications with connectivity to IBM Informix data. Leverage the native support for ODBC in PHP.
-
Connect to MailerLite from a Connection Pool in WebLogic
Use the CData JDBC Driver for MailerLite to connect to MailerLite data from Web applications running on WebLogic.
-
Load Salesloft Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Salesloft data to a database.
-
How to Connect Smartsheet Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Smartsheet data in real time using natural language.
-
Connect to Snowflake Data in RazorSQL
Connect to Snowflake from wizards and query Snowflake data from the GUI in the RazorSQL database management tool.
-
Access Microsoft Entra ID Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Entra ID data from HeidiSQL.
-
Replicate CloudConvert Data in Heroku for Use in Salesforce Connect
Replicate CloudConvert data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
View Reports on Real-Time Avro Data in Power BI Report Server
Use the CData ODBC Driver for Avro to visualize Avro data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating GitHub Copilot with Cohere 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 Easily Query Microsoft Dataverse Data in OpenOffice Base
Connect to Microsoft Dataverse data in OpenOffice Base using the CData ODBC Driver for Microsoft Dataverse and generate reports with live data insights.
-
Process & Analyze Oracle Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Oracle Data.
-
Integrate Theia IDE with Live Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Microsoft Dataverse data from within the development environment.
-
Build AI Agents with Presto 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 Presto data through CData Connect AI.
-
Create a Data Access Object for Microsoft Teams Data using JDBI
A brief overview of creating a SQL Object API for Microsoft Teams data in JDBI.
-
How to Connect to Live Dynamics NAV 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 Dynamics NAV data for you.
-
Create Gmail-Connected Nintex Workflows
Use CData Connect AI to connect to Gmail Data from Nintex Workflow Cloud and build custom workflows using live Gmail data.
-
How to Connect to Live JSON Services 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 JSON services for you.
-
How to Query Live Beeminder Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Beeminder data data in natural language using Python.
-
Integrating Claude Code CLI with Odoo 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.
-
Enable the Stack Exchange JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Stack Exchange data.
-
Automated Continuous CouchDB Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable CouchDB replication to delimited files (CSV/TSV).
-
How to use SQLAlchemy ORM to access Amazon S3 Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Amazon S3 data.
-
Build SAP Business One-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP Business One data.
-
Bidirectional Access to SAP Hybris C4C Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP Hybris C4C data in Filemaker Pro for Mac or Windows.
-
Build Okta-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Okta data and build Okta-connected web apps with Axios.
-
DataBind Controls to Notion Data in C++Builder
DataBind to Notion data in C++Builder with standard components and controls.
-
How to Seamlessly Import Shopify Data into IBM SPSS Modeler
Integrate Shopify data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize JobNimbus Data in Sisense
Create an ElastiCube in Sisense app with access to JobNimbus data.
-
Build BigQuery-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to BigQuery data and build web apps with connectivity to live BigQuery data.
-
Excel Spreadsheet Automation on Calendly Data with the QUERY Formula
Pull data from Calendly, automate spreadsheets, and more with the QUERY formula.
-
Import and Visualize Zoho Recruit Data in Power View
Create data visualizations based on Zoho Recruit data in Excel.
-
Analyze Reckon Accounts Hosted Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Reckon Accounts Hosted data and visualize live Reckon Accounts Hosted data in Infragistics Reveal.
-
Automated Continuous Harvest Replication to MySQL
Use CData Sync for automated, continuous, customizable Harvest replication to MySQL.
-
Use the CData Software ODBC Driver for Bugsnag in MicroStrategy Desktop
Connect to Bugsnag data in MicroStrategy Desktop using the CData Software ODBC Driver for Bugsnag.
-
Query Redis Data as a SQL Server Database in Node.js
Execute SQL Server queries against Redis data from Node.js.
-
Connect to Smartsheet Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Smartsheet and the SQL Gateway to access Smartsheet data from Google Apps Script.
-
How to Access Live HDFS Data in Power Automate Desktop via ODBC
The CData ODBC Driver for HDFS enables you to integrate HDFS data into workflows built using Microsoft Power Automate Desktop.
-
Create SSAS Tabular Models from Google Directory Data
How to build a SQL Server Analysis Service Tabular Model from Google Directory data using CData drivers.
-
Create Data Visualizations Based On Box Data in Mode
Use CData Connect AI to connect to Box Data from Mode and build visualizations using live Box data.
-
Create a Data Access Object for Mouseflow Data using JDBI
A brief overview of creating a SQL Object API for Mouseflow data in JDBI.
-
How to Visualize ZohoExpense Data in Python with pandas
Use pandas and other modules to analyze and visualize live ZohoExpense data in Python.
-
How to create Visio diagrams from HubSpot Data
Automatically update HubSpot data with the changes you make to Visio master shapes.
-
Connect to and Visualize Live Raisers Edge NXT Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Raisers Edge NXT data.
-
Interact with Live AgileCRM Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live AgileCRM data.
-
Access QuickBooks Time Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live QuickBooks Time data from HeidiSQL.
-
How to Connect DBeaver to Oracle via a JDBC Driver
Manage Oracle data with visual tools in DBeaver like the query browser.
-
Access Oracle HCM Cloud Data from MySQL in Amazon QuickSight
Connect to Oracle HCM Cloud and build visualizations of Oracle HCM Cloud data using a MySQL Connection in Amazon QuickSight.
-
Establish a Live Connection with Testmonitor Data using Tableau Bridge
The CData ODBC Driver for Testmonitor enables you to integrate live Testmonitor data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Keep Microsoft Access Working After the Salesforce Connector Discontinuation
A guide on using the CData Salesforce ODBC Driver to restore Microsoft Access connectivity after the native Salesforce connector retirement, enabling teams to run existing queries against live Salesforce data without rebuilding workflows.
-
LINQ to AdRoll Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the AdRoll Data Provider.
-
Migrating data from SendInBlue to Databricks using CData SSIS Components.
Easily push SendInBlue data to Databricks using the CData SSIS Tasks for SendInBlue and Databricks.
-
Getting Started with the CData SSIS Components for Certinia
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Certinia.
-
Migrating data from ZohoInvoice to Google BigQuery using CData SSIS Components.
Easily push ZohoInvoice data to Google BigQuery using the CData SSIS Tasks for ZohoInvoice and Google BigQuery.
-
How to Work with Cosmos DB Data in ETL Validator JDBC
Connect to Cosmos DB from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData ADO.NET Provider for Act-On
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Act-On.
-
Connecting GenSpark with Oracle Financials Cloud Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Oracle Financials Cloud data without any replication or custom integration required.
-
Natively Connect to Exa Data in PHP
The CData ODBC driver for Exa enables you to create PHP applications with connectivity to Exa data. Leverage the native support for ODBC in PHP.
-
Deploy the ADO.NET Provider for Jumpseller on an SSRS Report Server
Connect to Jumpseller 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 Visualize Notion Data in Python with pandas
Use pandas and other modules to analyze and visualize live Notion data in Python.
-
How to Build an ETL App for LDAP Objects in Python with CData Connect AI
Build ETL pipelines that read and write live LDAP objects in Python with petl and the CData Connect AI Python SDK.
-
Integrating Dataiku with AfterShip Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live AfterShip data.
-
Import Real-Time Typeform Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Typeform data in ColdFusion.
-
Getting Started with the CData Power BI Connector for Bannerbear
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Connect DBeaver to Azure Synapse via a JDBC Driver
Manage Azure Synapse data with visual tools in DBeaver like the query browser.
-
Connect to Real-Time ChargeOver Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ChargeOver data in Power Apps.
-
Easily Integrate Recurly Data in Lazarus Pascal IDE
Learn how to easily integrate live Recurly data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating Boomi Agentstudio with MariaDB Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to MariaDB data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Access Live YouTube Analytics Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate YouTube Analytics data into the statistical analysis tools available in SAS JMP. This article shows how to use YouTube Analytics data in the Graph Builder and Query Builder.
-
Use the CData Software ODBC Driver for Float in MicroStrategy Desktop
Connect to Float data in MicroStrategy Desktop using the CData Software ODBC Driver for Float.
-
Establish a Live Connection with CouchDB Data using Tableau Bridge
The CData ODBC Driver for CouchDB enables you to integrate live CouchDB data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Visualizations of Microsoft OneDrive Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft OneDrive data in Birst.
-
Automated Continuous EnterpriseDB Replication to Databricks
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Databricks.
-
How to create Zendesk federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Zendesk data in MySQL .
-
Integrate Dify with Live Lakebase Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Lakebase data.
-
Automated Continuous SendGrid Replication to Snowflake
Use CData Sync for automated, continuous, customizable SendGrid replication to Snowflake.
-
Choosing the Best Method to Connect Sybase to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sybase data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Work with PagerDuty Data in AWS Glue Jobs Using JDBC
Connect to PagerDuty from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Easily Query Demio Data in OpenOffice Base
Connect to Demio data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Jumpseller from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Jumpseller data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create Informatica Mappings From/To a JDBC Data Source for SQL Analysis Services
Create SQL Analysis Services data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Interact with Live Google Analytics Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Google Analytics data.
-
Publish Crystal Reports on NetSuite Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date NetSuite data.
-
How to create Printify federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Printify data in MySQL .
-
Seamlessly Bring Amazon S3 Data into Retool Using CData Connect AI
Integrate Amazon S3 data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Bridge Acumatica Connectivity with Apache NiFi
Access and process Acumatica data in Apache NiFi using the CData JDBC Driver.
-
Query Live Azure Table 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 Azure Table data directly from the development environment.
-
Build Twitter Ads-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Twitter Ads data.
-
Automated Continuous Datadog Replication to SingleStore
Use CData Sync for automated, continuous, customizable Datadog replication to SingleStore.
-
Rapidly Develop Copper-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 Copper.
-
How to use SQLAlchemy ORM to access Todoist Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Todoist data.
-
Interact with Live ZohoMarketingHub Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live ZohoMarketingHub data.
-
Connect to PingOne Data in Claris FileMaker Pro
Use the CData ODBC Driver for PingOne in FileMaker Pro to connect to PingOne and work with PingOne data in your FileMaker applications.
-
Connect to Mixpanel Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Mixpanel data.
-
How to Connect to Live Tally 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 Tally data for you.
-
How to Create Power BI Visual Reports with Real-Time HelloSign Data
Use CData Power BI Connectors to visualize HelloSign data in Power BI.
-
Import and Visualize Twilio Data in Power View
Create data visualizations based on Twilio data in Excel.
-
Integrate SAS xpt Data in the Pentaho Report Designer
Publish reports based on SAS xpt data in the Pentaho BI tool.
-
Use the CData ODBC Driver for Discord from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Discord to connect to Discord data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Discord data in Excel.
-
Integrating Boomi Agentstudio with Avro Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Avro data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Voice Agents in ElevenLabs with access to Live WooCommerce Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live WooCommerce data.