CData Software - Knowledge Base
Recent Articles
-
Integrate with Live Basecamp Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Basecamp from the MuleSoft Anypoint Platform to integrate live Basecamp into custom reports and dashboards.
-
Use Databricks Agent Bricks to Talk to Your Monday.com Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Monday.com for you.
-
Connect to AgileCRM Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for AgileCRM in the Denodo Virtual DataPort Administrator.
-
Process & Analyze MailChimp Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live MailChimp Data.
-
How to integrate Opsgenie with Apache Airflow
Access and process Opsgenie in Apache Airflow using the CData JDBC Driver.
-
Visualize Hugging Face Data in Sisense
Create an ElastiCube in Sisense app with access to Hugging Face.
-
Establish a Live Connection with LightSpeedRetail Data using Tableau Bridge
The CData ODBC Driver for LightSpeedRetail enables you to integrate live LightSpeedRetail into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData ODBC Driver for Humanity from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Humanity to connect to Humanity from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Humanity in Excel.
-
Use Biml to Build SSIS Tasks to Replicate Everhour Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Everhour to SQL Server.
-
Integrating Claude Code CLI with Amazon Athena 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.
-
Build Apps with Live Freshdesk in Adalo using CData Connect AI
Use CData Connect AI to integrate live Freshdesk into the Adalo platform and build custom mobile and web applications with real-time Freshdesk.
-
Integrate Cline with Live Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Facebook from within your IDE.
-
Import YouTube Analytics Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access YouTube Analytics. In this article, you will use the OData format to import YouTube Analytics into Microsoft Power Query.
-
Process & Analyze Samanage Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Samanage Data.
-
Automated Continuous HubDB Replication to SQL Server
Use CData Sync for automated, continuous, customizable HubDB replication to SQL Server.
-
How to publish and share Databricks Data dashboards with Tableau Server
The CData ODBC driver for Databricks enables you integrate Databricks into Tableau dashboards.
-
How to Work with Snowflake Data in ETL Validator JDBC
Connect to Snowflake from ETL Validator jobs using the CData Software JDBC Driver.
-
How to integrate Demio with Apache Airflow
Access and process Demio in Apache Airflow using the CData JDBC Driver.
-
Connect to Freshservice Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Freshservice Data and connect to Freshservice in Akorbi Digital RunMyProcess.
-
Access Live MarkLogic Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live MarkLogic from your Excel spreadsheets.
-
How to Easily Query Calendly Data in OpenOffice Base
Connect to Calendly data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Query Cosmos DB Data as a SQL Server Database in Node.js
Execute SQL Server queries against Azure Cosmos DB from Node.js.
-
Connect to and Visualize Live ConvertAPI Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ConvertAPI.
-
Load Lakebase Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Lakebase to a database.
-
How to Easily Query SQL Analysis Services Data in OpenOffice Base
Connect to SQL Analysis Services data in OpenOffice Base using the CData ODBC Driver for SQL Analysis Services and generate reports with live data insights.
-
Analyze FormSite Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze FormSite in Microsoft R Open.
-
Connect to Jumpseller Data in NetBeans
Connect to Jumpseller in NetBeans with the data source configuration wizard.
-
Connect to Authorize.Net Data in RapidMiner
Integrate Authorize.Net with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect to Live Cloudant 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 IBM Cloudant for you.
-
Access Live Twitter Ads Data in Excel 365 Online (Excel for the web)
Connect to Twitter Ads from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous Power BI XMLA Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to delimited files (CSV/TSV).
-
How to load CloudConvert data into Elasticsearch via Logstash
Introducing a simple method to load CloudConvert data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Authorize.Net Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Authorize.Net from your Excel spreadsheets.
-
Build Visualizations of ShipEngine Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ShipEngine in Birst.
-
Use JayDeBeApi to access SAP BusinessObjects BI Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP BusinessObjects BI.
-
Moving Data from Azure Analysis Services to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Azure Analysis Services data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Visualizations of Nethunt Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Nethunt in Birst.
-
Query Figshare Data in DataGrip
Create a Data Source for Figshare in DataGrip and use SQL to query live Figshare.
-
Automate ZohoMarketingHub Data Replication to Couchbase
Use CData Sync to Customize and automate ZohoMarketingHub replication to Couchbase.
-
Automated Continuous Google Forms Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Forms replication to Snowflake.
-
Analyze ADP Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of ADP and visualize live ADP in Infragistics Reveal.
-
How to Access Live Smartsheet Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Smartsheet enables you to integrate Smartsheet into workflows built using Microsoft Power Automate Desktop.
-
Connect to Act-On Data in Google Apps Script via Connect AI
Use CData Connect AI to access Act-On in Google Apps Script.
-
Perform Batch Operations with Salesforce Marketing Data in Apache NiFi
Connect to Salesforce Marketing Cloud and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Short.io 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 Short.io and work with Short.io in your FileMaker application.
-
Automated Continuous Procore Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Procore replication to IBM DB2.
-
How to connect and process Sage Intacct from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Sage Intacct.
-
Query, Visualize, and Share live Google Sheets Data in Redash
Use CData Connect AI to connect to live Google Sheets in Redash for querying, visualizing, and sharing.
-
Connect to Zoho Inventory Data in ACL Analytics
Connect to Zoho Inventory via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Zoho Inventory.
-
Build DocuSign Visualizations in Tableau Cloud
Use CData Connect AI to connect to live DocuSign and build visualizations in Tableau Cloud.
-
Use JayDeBeApi to access Dotmailer Data in Python
Use standard Python scripting and the development environment of your choice to access live Dotmailer.
-
Build MVC Applications with Connectivity to Simplesat Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Simplesat from an ASP.NET MVC application.
-
Automated Continuous Aircall Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Aircall replication to IBM DB2.
-
Use the CData Software ODBC Driver for Avalara AvaTax in MicroStrategy Desktop
Connect to Avalara AvaTax in MicroStrategy Desktop using the CData Software ODBC Driver for Avalara AvaTax.
-
Query, Visualize, and Share live Redshift Data in Redash
Use CData Connect AI to connect to live Amazon Redshift in Redash for querying, visualizing, and sharing.
-
Prepare, Blend, and Analyze Google Cloud Storage Data in Alteryx Designer (Connect AI)
Build workflows to access live Google Cloud Storage for self-service data analytics.
-
Use the CData Software ODBC Driver for Discord in MicroStrategy Web
Connect to Discord in MicroStrategy Web using the CData Software ODBC Driver for Discord.
-
Automated Continuous LDAP Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable LDAP replication to Apache Cassandra.
-
Edit and Search Redshift External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Amazon Redshift to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Redshift objects that you can access from apps and the dashboard.
-
Automated Continuous Act-On Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Act-On replication to OneLake in Microsoft Fabric.
-
Automated Continuous Lakebase Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Lakebase replication to IBM DB2.
-
Connect to Dynamics NAV Data in JRuby
Create a simple JRuby app with access to live Microsoft Dynamics NAV.
-
Build a Singer.io Tap for Postmark With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Postmark data using
-
Automated Continuous HCL Domino Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable HCL Domino replication to delimited files (CSV/TSV).
-
Analyze Epicor Kinetic Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Epicor Kinetic and visualize live Epicor Kinetic in Infragistics Reveal.
-
Connect to BigCommerce Data from Crystal Reports
Use CData Connect AI to connect to and report on live BigCommerce from Crystal Reports.
-
Access Certinia Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Certinia from your Oracle system.
-
Analyze Zuora Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Zuora and visualize Zuora in SAP Analytics Cloud.
-
Build a Simple VCL Application for Epicor Kinetic Data
How to build a simple VCL Application to view Epicor Kinetic in RAD Studio using the CData ODBC Driver for Epicor Kinetic.
-
Seamlessly Bring Apollo Data into Retool Using CData Connect AI
Integrate Apollo data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate Live SQL Server Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
DataBind Controls to SAS xpt Data in C++Builder
DataBind to SAS XPORT in C++Builder with standard components and controls.
-
Edit and Search External Impala Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Apache Impala to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Impala Data objects that you can access from apps and the dashboard.
-
Connect Billsby to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Billsby using the CData Python MCP Server.
-
Automated Continuous Adobe Analytics Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to Apache Cassandra.
-
Rapidly Develop Couchbase-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 Couchbase.
-
Analyze Superchat Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Superchat in Microsoft R Open.
-
Process & Analyze SAP Ariba Procurement Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Ariba Procurement Data.
-
Extract, Transform, and Load Active Directory Data in Informatica PowerCenter
Create a simple Workflow for Active Directory in Informatica PowerCenter.
-
Automated Continuous Pipedrive Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Pipedrive replication to PostgreSQL.
-
Integrate Live SAP HANA XS Advanced Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP HANA XS Advanced to Blue Prism using the CData ODBC Driver for SAP HANA XS Advanced to create automated workflows for repetitive business tasks.
-
Integrate SQL Server with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SQL Server with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Microsoft SQL Server.
-
ETL ZohoDesk in Oracle Data Integrator
This article shows how to transfer ZohoDesk into a data warehouse using Oracle Data Integrator.
-
How to Create Power BI Visual Reports with Real-Time Zoho Recruit Data
Use CData Power BI Connectors to visualize Zoho Recruit in Power BI.
-
Validate Zoho Projects Data with QuerySurge
Access and validate Zoho Projects in QuerySurge using the CData JDBC Driver.
-
Use Microsoft Copilot Studio to talk to your Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Couchbase for you.
-
Access Live SAP Business One Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAP Business One from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to load Okta data into Elasticsearch via Logstash
Introducing a simple method to load Okta data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
A PostgreSQL Interface for Teamwork Data (MySQL Remoting via JDBC)
Use the Remoting features of the Teamwork JDBC Driver to create a PostgreSQL entry-point for data access.
-
Building Dynamic Web Pages with Kafka Data Using AngularJS
Create single-page applications with live connectivity to Kafka using the CData API Server.
-
Bidirectional Access to Delighted Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Delighted in Filemaker Pro for Mac or Windows.
-
Create Tally-Connected Business Apps in AppSheet
Connect to Tally Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Tally ERP.
-
Easily Integrate Factorial Data in Lazarus Pascal IDE
Learn how to easily integrate live Factorial in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Agents in Relevance AI with Access to Live Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Salesforce & Force.com within intelligent agent workflows.
-
Stream BenchmarkEmail Data into Apache Kafka Topics
Access and stream BenchmarkEmail in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to use SQLAlchemy ORM to access Typeform Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Typeform.
-
Integrating Claude Code CLI with Microsoft Planner 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.
-
Integrate Open WebUI with Live Okta Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Okta from within the chat interface.
-
Connect to Sendwithus Data in Ruby
Connect to Sendwithus in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Analyze Neo4J Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Neo4J in Microsoft R Open.