CData Software - Knowledge Base
Recent Articles
-
How to Query Live Beeminder Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Beeminder 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.
-
How to Design Freshdesk Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Freshdesk from mobile and tablet Power Apps.
-
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.
-
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.
-
Bidirectional Access to SAP Hybris C4C Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP Hybris C4C 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 and build Okta-connected web apps with Axios.
-
DataBind Controls to Notion Data in C++Builder
DataBind to Notion 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.
-
Build BigQuery-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google BigQuery and build web apps with connectivity to live Google BigQuery.
-
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 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 and visualize live Reckon Accounts Hosted 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 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 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 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 Apache HDFS 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 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
-
Create a Data Access Object for Mouseflow Data using JDBI
A brief overview of creating a SQL Object API for Mouseflow in JDBI.
-
How to Visualize ZohoExpense Data in Python with pandas
Use pandas and other modules to analyze and visualize live ZohoExpense in Python.
-
How to create Visio diagrams from HubSpot Data
Automatically update HubSpot 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.
-
Access QuickBooks Time Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live QuickBooks Time from HeidiSQL.
-
How to Connect DBeaver to Oracle via a JDBC Driver
Manage Oracle Database 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 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 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 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 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 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. Leverage the native support for ODBC in PHP.
-
Deploy the ADO.NET Provider for Jumpseller on an SSRS Report Server
Connect to Jumpseller 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 in Python.
-
Import Real-Time Typeform Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Typeform 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 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 in Power Apps.
-
Easily Integrate Recurly Data in Lazarus Pascal IDE
Learn how to easily integrate live Recurly 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, 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 into the statistical analysis tools available in SAS JMP. This article shows how to use YouTube Analytics in the Graph Builder and Query Builder.
-
Use the CData Software ODBC Driver for Float in MicroStrategy Desktop
Connect to Float 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 Apache CouchDB 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 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 in MySQL .
-
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 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.
-
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.
-
Automate HDFS Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Apache HDFS and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Publish Crystal Reports on NetSuite Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date NetSuite CRM & ERP.
-
How to create Printify federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Printify 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 ERP 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 Storage 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.
-
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.
-
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 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.
-
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 ERP for you.
-
How to Create Power BI Visual Reports with Real-Time HelloSign Data
Use CData Power BI Connectors to visualize HelloSign in Power BI.
-
Import and Visualize Twilio Data in Power View
Create data visualizations based on Twilio in Excel.
-
Integrate SAS xpt Data in the Pentaho Report Designer
Publish reports based on SAS XPORT 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 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Discord 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 Apache Avro, 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.
-
How to Work with Zoho Books Data in ETL Validator JDBC
Connect to Zoho Books from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Dashboards with Couchbase Data in Dundas BI
Create dynamic dashboards and perform analytics based on Couchbase in Dundas BI.
-
Integrate Cline with Live Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Sybase from within your IDE.
-
Access Live Avro Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apache Avro from your Google Sheets.
-
Use Biml to Build SSIS Tasks to Replicate SendPulse Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SendPulse to SQL Server.
-
Create Power BI Reports on Real-Time SharePoint Data
Use the CData ODBC Driver for SharePoint to visualize Microsoft SharePoint in Power BI Desktop.
-
Connect to Zuora Data from AWS Glue
Use CData Connect AI to gain access to live Zuora from your AWS Glue jobs.
-
How to Work with Oracle Eloqua Data in ETL Validator JDBC
Connect to Oracle Eloqua from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Live CloudConvert Data in AWS Lambda
Connect to live CloudConvert in AWS Lambda using the CData JDBC Driver.
-
Natively Connect to MarkLogic Data in PHP
The CData ODBC driver for MarkLogic enables you to create PHP applications with connectivity to MarkLogic. Leverage the native support for ODBC in PHP.
-
Connect to Gmail Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Gmail.
-
A PostgreSQL Interface for Aha! Data (MySQL Remoting via JDBC)
Use the Remoting features of the Aha! JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Dashboards with Jira Data in Dundas BI
Create dynamic dashboards and perform analytics based on Atlassian Jira in Dundas BI.
-
Connect to Opsgenie Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Opsgenie and work with Opsgenie in your FileMaker application.
-
Query Live Google Spanner 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 Google Spanner directly from the development environment.
-
Connect to SAP Concur Data in RapidMiner
Integrate SAP Concur with standard components and data source configuration wizards in RapidMiner Studio.
-
Deploy the ADO.NET Provider for Rootly on an SSRS Report Server
Connect to Rootly 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.
-
Feed LionDesk Data into FineReport
How to set LionDesk as a JDBC data source in FineReport.
-
Use JayDeBeApi to access Telegram Data in Python
Use standard Python scripting and the development environment of your choice to access live Telegram.
-
Consume MYOB AccountRight OData Feeds in PowerBuilder
This article demonstrates how to consume MYOB AccountRight as OData feeds from PowerBuilder using the API Server.
-
How to load Presto data into Elasticsearch via Logstash
Introducing a simple method to load Presto data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Zoho Creator in SpagoBI
Create reports featuring live Zoho Creator in SpagoBI Studio. Host Zoho Creator reports on SpagoBI Server.