CData Software - Knowledge Base
Recent Articles
-
How to connect to Hive Data from IntelliJ
Integrate connectivity to Apache Hive with wizards in IntelliJ.
-
Connect to Twilio Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Twilio in the Denodo Virtual DataPort Administrator.
-
Import Real-Time Optimizely Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Optimizely in ColdFusion.
-
Connect to Sage Cloud Accounting from Asprova with CData Software ODBC Driver for Sage Cloud Accounting
This article shows how to connect faster to Sage Cloud Accounting data from Asprova.
-
Create Helpscout Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Helpscout from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to create an RPA flow for Sybase Data in UiPath Studio
Use the Sybase ODBC Driver to create workflows that access real-time Sybase without any coding.
-
Connect CockroachDB to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect CockroachDB with IBM WebSphere for seamless data integration and connectivity.
-
Connect to ChartMogul Data in RapidMiner
Integrate ChartMogul with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Slack Data from HeidiSQL
Use CData Connect AI to connect to and query live Slack from HeidiSQL.
-
Automate SingleStore Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SingleStore and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Access Teamwork 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 Teamwork.
-
Access Live Presto Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Presto from your Excel spreadsheets.
-
Getting Started with the CData Connect AI Python SDK for Power BI XMLA
Install the CData Connect AI Python SDK to read and write live Power BI XMLA with standard DB-API 2.0 Python code.
-
Connect QuickBooks Time to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live QuickBooks Time using the CData Python MCP Server.
-
Create CouchDB Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time CouchDB data access from reports, embedded analytics, and more.
-
Use the CData ODBC Driver for Samanage in Microsoft Power Query
You can use the CData Samanage ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Samanage into Microsoft Power Query.
-
Build Zoho Inventory-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Zoho Inventory to explore live Zoho Inventory Data in GitHub Copilot to assist with building Zoho Inventory-powered applications.
-
How to use SQLAlchemy ORM to access Google Analytics Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Analytics.
-
Replicate Zuora Data to Multiple Databases via the CData Sync CLI
Replicate Zuora to disparate databases with a single configuration.
-
Use Dash to Build to Web Apps on Oracle Eloqua Reporting Data
Create Python applications that use pandas and Dash to build Oracle Eloqua Reporting-connected web apps.
-
Connecting Agentforce with Freshdesk 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 Freshdesk for you.
-
Build Dashboards with Slack Data in Dundas BI
Create dynamic dashboards and perform analytics based on Slack in Dundas BI.
-
Query Google Forms Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Forms from Node.js.
-
Replicate Cvent Data to Multiple Databases via the CData Sync CLI
Replicate Cvent to disparate databases with a single configuration.
-
Analyze Oracle SCM Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Oracle SCM and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate ConvertKit Data in Pentaho Data Integration
Build ETL pipelines based on ConvertKit in the Pentaho Data Integration tool.
-
Build Automated NetSuite SuiteAnalytics-Connected Workflows in Zapier
Use CData Connect AI to connect to live NetSuite SuiteAnalytics and build automated workflows in Zapier.
-
Connect to Real-Time Cvent Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Cvent and Dataflow to import and use Cvent in Power Apps.
-
Connect to Kintone Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Kintone using standard SQL.
-
Use Biml to Build SSIS Tasks to Replicate ADP Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ADP to SQL Server.
-
Build Automated Workflows with Live BambooHR Data in Workato
Use CData Connect AI to connect to live BambooHR and build automated workflows in Workato.
-
Ingest Data into Salesforce Data 360 Using CData JDBC Driver
Ingest external data into Salesforce Data 360 using the CData Salesforce Data 360 JDBC Driver.
-
Load OpenWeatherMap Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load OpenWeatherMap to a database.
-
Connect to Pushbullet Data from PowerBuilder via ADO.NET
This article demonstrates how to access Pushbullet from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to publish and share Zoom Data dashboards with Tableau Server
The CData ODBC driver for Zoom enables you integrate Zoom into Tableau dashboards.
-
Connect to and Visualize Live SAP Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP ERP/NetWeaver.
-
Build Visualizations of Amazon DynamoDB Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Amazon DynamoDB in Birst.
-
Enable the Splunk JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Splunk.
-
Object-Relational Mapping (ORM) with SpaceX Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SpaceX into a Java-based ORM framework, Hibernate.
-
How to Connect Exact Online 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 Exact Online data in real time using natural language.
-
Connect to LightSpeedRetail Data in NetBeans
Connect to LightSpeedRetail in NetBeans with the data source configuration wizard.
-
Create CouchDB-Connected Dashboards in Grafana
Connect to CouchDB Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Apache CouchDB.
-
Automated Continuous Attio Replication to Oracle
Use CData Sync for automated, continuous, customizable Attio replication to Oracle.
-
Getting Started with the CData JDBC Driver for Outlook
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Outlook.
-
Build Hive-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Hive Data and create custom apps in Mendix.
-
Query Bullhorn CRM Data in ColdFusion
Write standard ColdFusion data access code to connect to Bullhorn CRM.
-
Integrate ZohoMarketingHub Data in Pentaho Data Integration
Build ETL pipelines based on ZohoMarketingHub in the Pentaho Data Integration tool.
-
Build AI Agents with Kintone 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 Kintone through CData Connect AI.
-
Viewing Email Data in RAD Studio Data Explorer
How to view Email in RAD Studio Data Explorer using the CData ODBC Driver for Email.
-
Build Jira-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Jira to explore live Jira Data in Claude Code to assist with building Jira-powered applications.
-
How to Work with REST Data in ETL Validator JDBC
Connect to REST from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Datasets from Zoho Creator in Domo Workbench and Build Visualizations of Zoho Creator Data in Domo
Use the CData Software ODBC Driver for Zoho Creator to create datasets from Zoho Creator in Domo Workbench and then build visualizations in the Domo service.
-
Connect to ZohoSubscriptions 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 ZohoSubscriptions and work with ZohoSubscriptions in your FileMaker application.
-
Create Apps from Epicor Kinetic Data in Qlik Sense Cloud
Use CData Connect AI to connect to Epicor Kinetic Data and build apps from live Epicor Kinetic in Qlik Sense Cloud.
-
Connect Miro to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Miro using the CData Python MCP Server.
-
Excel Spreadsheet Automation on Smartsheet Data with the QUERY Formula
Pull data from Smartsheet, automate spreadsheets, and more with the QUERY formula.
-
Use the CData ODBC Driver for Exa in Microsoft Power Query
You can use the CData Exa ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Exa into Microsoft Power Query.
-
Integrating LangGraph with SAP Netweaver Gateway Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SAP Netweaver Gateway within automated workflows.
-
Bidirectional Access to SAP HANA XS Advanced Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP HANA XS Advanced in Filemaker Pro for Mac or Windows.
-
Use Dash to Build Web Apps on Splunk Data via CData Connect AI
Build interactive Dash web apps on live Splunk using pandas and the CData Connect AI Python SDK.
-
Extract, Transform, and Load Oracle Financials Cloud Data in Informatica PowerCenter
Create a simple Workflow for Oracle Financials Cloud in Informatica PowerCenter.
-
Build Paylocity Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Paylocity and build visualizations in Tableau.
-
Use the CData SSIS Components to Insert New or Update Existing Highrise Records from SQL Server
Easily push SQL Server data to Highrise using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Highrise or update existing records with data from a SQL Server database.
-
Automated Continuous Snapchat Ads Replication to Databricks
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Databricks.
-
Automated Continuous Reckon Accounts Hosted Replication to SQLite
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to SQLite.
-
Getting Started with the CData ADO.NET Provider for Planio
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrating GitHub Copilot CLI with Timely 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 Azure Data Lake Storage-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Azure Data Lake Storage Data and create custom apps in Bubble.
-
Getting Started with the CData Connect AI Python SDK for MailChimp
Install the CData Connect AI Python SDK to read and write live MailChimp with standard DB-API 2.0 Python code.
-
How to integrate Metabase with Blackbaud FE NXT Data
Use CData Connect AI to connect to live Blackbaud FE NXT and create an interactive dashboard in Metabase from Blackbaud FE NXT.
-
Build Automated Workflows with Live FreshBooks Data in Workato
Use CData Connect AI to connect to live FreshBooks and build automated workflows in Workato.
-
Integrate Redis with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Redis with External Services.
-
Use Dash to Build to Web Apps on eBay Data
Create Python applications that use pandas and Dash to build eBay-connected web apps.
-
Create Informatica Mappings From/To a JDBC Data Source for Salesforce Marketing
Create Salesforce Marketing data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Twitter Ads-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Twitter Ads to explore live Twitter Ads Data in Claude Code to assist with building Twitter Ads-powered applications.
-
Integrating Boomi Agentstudio with Google Ads Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Ads, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automate Procore Data Replication to Couchbase
Use CData Sync to Customize and automate Procore replication to Couchbase.
-
Getting Started with the CData SSIS Components for Clio
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Clio.
-
Connect to Vault CRM Data in NetBeans
Connect to Veeva Vault & Vault CRM in NetBeans with the data source configuration wizard.
-
Prepare, Blend, and Analyze CockroachDB Data in Alteryx Designer (Connect AI)
Build workflows to access live CockroachDB for self-service data analytics.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Facebook to Power BI dashboards. Simply drag and drop Facebook into data visuals on the Power BI canvas.
-
Integrate Live Quaderno Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Quaderno to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Create Google Spanner Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Spanner from PowerBI.com to create Power BI Dataflows with real-time data.
-
Import Real-Time SAP Business Warehouse Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP Business Warehouse in ColdFusion.
-
Integrate SurveyMonkey with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SurveyMonkey with External Services.
-
Access Auth0 Data from MySQL in Amazon QuickSight
Connect to Auth0 and build visualizations of Auth0 using a MySQL Connection in Amazon QuickSight.
-
Use Claude to Talk to Your MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your MailChimp for you.
-
Automated Continuous IBM Informix Replication to Vertica
Use CData Sync for automated, continuous, customizable IBM Informix replication to Vertica.
-
Load FTP Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load FTP Servers to a database.
-
Connect to Microsoft Entra ID Data in Google Apps Script via Connect AI
Use CData Connect AI to access Microsoft Entra ID in Google Apps Script.
-
Build Dashboards with Pipeline CRM Data in DBxtra
Create dynamic dashboards and perform analytics based on Pipeline CRM in DBxtra.
-
Automate Cvent Data Replication to Azure Data Lake
Use CData Sync to customize and automate Cvent replication to Azure Data Lake.
-
Access Live Dynamics 365 Business Central Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Dynamics 365 Business Central from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Zoho Books within intelligent workflows.
-
Object-Relational Mapping (ORM) with Gumroad Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Gumroad into a Java-based ORM framework, Hibernate.
-
DataBind Charts to Google Drive Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Drive from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
How to create an RPA flow for Guru Data in UiPath Studio
Use the Guru ODBC Driver to create workflows that access real-time Guru without any coding.
-
Import and Visualize Egnyte Data in Power View
Create data visualizations based on Egnyte in Excel.
-
Use the CData Software ODBC Driver for EmailOctopus in MicroStrategy Desktop
Connect to EmailOctopus in MicroStrategy Desktop using the CData Software ODBC Driver for EmailOctopus.
-
How to connect PolyBase to MariaDB
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live MariaDB.