CData Software - Knowledge Base
Recent Articles
-
Connect to MySQL Data in DBArtisan
Use wizards in DBArtisan to configure MySQL as a data source.
-
How to Query Live Oracle Financials Cloud Data in Perplexity MacOS Desktop
Connect to and query live Oracle Financials Cloud Data in Perplexity Desktop using CData MCP Server.
-
Integrate Live Oracle SCM Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Kafka Reporting in OBIEE with the Kafka JDBC Driver
Deploy the Kafka JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData ODBC Driver for MarkLogic from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for MarkLogic to connect to MarkLogic from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring MarkLogic in Excel.
-
Create VWO Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time VWO data access from reports, embedded analytics, and more.
-
Getting Started with the CData Excel Add-In for Dotmailer
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Dotmailer.
-
Build DB2-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live IBM DB2.
-
Integrating Claude Code with Odoo Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Odoo ERP within assisted coding and automated development workflows.
-
Integrate Oracle with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Oracle with External Services.
-
Airtable Reporting in OBIEE with the Airtable JDBC Driver
Deploy the Airtable JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to BenchmarkEmail Data in NetBeans
Connect to BenchmarkEmail in NetBeans with the data source configuration wizard.
-
Connect to CockroachDB Data from HeidiSQL
Use CData Connect AI to connect to and query live CockroachDB from HeidiSQL.
-
Access Live SAP HANA Data in Coginiti Pro
Connect to and query live SAP HANA from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Access Live Spark Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Spark enables you to integrate Apache Spark SQL into workflows built using Microsoft Power Automate Desktop.
-
Visualize Live Workday Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Workday.
-
Connect to Zoho CRM Data in Jaspersoft Studio
Execute SQL to remote Zoho CRM in Jaspersoft Studio.
-
Publish Crystal Reports on ZeroBounce Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ZeroBounce.
-
Create GitHub-Connected Nintex Workflows
Use CData Connect AI to connect to GitHub Data from Nintex Workflow Cloud and build custom workflows using live GitHub.
-
How to Connect to Live SurveyMonkey 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 SurveyMonkey for you.
-
Model MariaDB Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and MariaDB, enabling the direct import of real-time MariaDB.
-
Build Agents in Relevance AI with Access to Live Gmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Gmail within intelligent agent workflows.
-
Migrating data from Aha! to Databricks using CData SSIS Components.
Easily push Aha! to Databricks using the CData SSIS Tasks for Aha! and Databricks.
-
Access Redis 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 Redis.
-
Access Live Amazon Athena Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Amazon Athena from your Excel spreadsheets.
-
Connect to Azure Synapse Data in JRuby
Create a simple JRuby app with access to live Azure Synapse.
-
Build Data Flows from BenchmarkEmail to SQL Server using SSIS
Easily back up BenchmarkEmail to SQL Server using the SSIS components for BenchmarkEmail.
-
Access Qualaroo Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Qualaroo from HeidiSQL.
-
Create Power BI Reports on Real-Time Cloudflare Data
Use the CData ODBC Driver for Cloudflare to visualize Cloudflare in Power BI Desktop.
-
Use the CData ODBC Driver for LightSpeedRetail in Microsoft Power Query
You can use the CData LightSpeedRetail ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import LightSpeedRetail into Microsoft Power Query.
-
Visualize Workable Data in Sisense
Create an ElastiCube in Sisense app with access to Workable.
-
Query Act-On Data in ColdFusion
Write standard ColdFusion data access code to connect to Act-On.
-
Connect to Google Contacts Data in ACL Analytics
Connect to Google Contacts via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Contacts.
-
How to Build an ETL App for Greenhouse Data in Python with CData
Create ETL applications and real-time data pipelines for Greenhouse in Python with petl.
-
Moving Data from Azure DevOps to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Azure DevOps data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Feed SendPulse Data into FineReport
How to set SendPulse as a JDBC data source in FineReport.
-
Build Campaigner-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Campaigner.
-
Integrate with PDFMonkey Data in JReport Designer
Create charts and reports based on PDFMonkey in JReport Designer.
-
How to connect PolyBase to Oracle Eloqua
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Oracle Eloqua.
-
Replicate Kintone Data to Multiple Databases
Replicate Kintone to disparate databases with a point-and-click configuration.
-
Connect to PostgreSQL Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for PostgreSQL and the SQL Gateway to access PostgreSQL from Google Apps Script.
-
Automated Continuous HCL Domino Replication to MongoDB
Use CData Sync for automated, continuous, customizable HCL Domino replication to MongoDB.
-
Connect to EnterpriseDB Data in RapidMiner
Integrate EnterpriseDB with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Jumpseller Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Jumpseller from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect to Sybase IQ Data in DBVisualizer
Integrate Sybase IQ with visual data analysis tools and data connection wizards in DBVisualizer
-
Query TaxJar Data from Node.js
Use the OData endpoint of the CData API Server to connect to your TaxJar and perform CRUD operations on TaxJar from Node.js.
-
Connect to Dynamics NAV Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Dynamics NAV.
-
Integrate Live Hubstaff Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Hubstaff to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Calendly Data from PowerBuilder via ADO.NET
This article demonstrates how to access Calendly from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use Manus AI to Talk to Your OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Microsoft OneNote.
-
Automated Continuous WooCommerce Replication to MySQL
Use CData Sync for automated, continuous, customizable WooCommerce replication to MySQL.
-
Create Informatica Mappings From/To an ODBC Data Source for Attio
Create an ODBC connection to Attio in Informatica and browse and transfer Attio.
-
Connect to LinkedIn Ads Data in Aqua Data Studio
Access LinkedIn Ads from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to XML Data in HULFT Integrate
Connect to XML as a JDBC data source in HULFT Integrate
-
DataBind Controls to Microsoft Ads Data in C++Builder
DataBind to Microsoft Ads in C++Builder with standard components and controls.
-
Access Google Translate Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Translate from HeidiSQL.
-
Connect to and Visualize Live Excel Online Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Excel Online.
-
Connect to Supabase Data from PowerBuilder via ADO.NET
This article demonstrates how to access Supabase from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Connect to Live Salesforce CRM Analytics Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Salesforce CRM Analytics without replication.
-
Access Beeminder 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 Beeminder.
-
Automated Continuous Kintone Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Kintone replication to Azure SQL Database.
-
A PostgreSQL Interface for PagerDuty Data (MySQL Remoting via JDBC)
Use the Remoting features of the PagerDuty JDBC Driver to create a PostgreSQL entry-point for data access.
-
Natively Connect to SurveyMonkey Data in PHP
The CData ODBC driver for SurveyMonkey enables you to create PHP applications with connectivity to SurveyMonkey. Leverage the native support for ODBC in PHP.
-
How to Import Data from SAP Fieldglass into Google Sheets
Import SAP Fieldglass into a Google spreadsheet that is automatically refreshed.
-
Connect to Greenhouse Data in NetBeans
Connect to Greenhouse in NetBeans with the data source configuration wizard.
-
Connect to PivotalTracker Data in Jaspersoft Studio
Execute SQL to remote PivotalTracker in Jaspersoft Studio.
-
Perform Batch Operations with Airtable Data in Apache NiFi
Connect to Airtable and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
DataBind Egnyte Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Egnyte to a chart.
-
Build Semantic Layer Views for NASA Data in APOS Live Data Gateway
Use the CData Connector for NASA in APOS Live Data Gateway to build Semantic Layer Views for NASA.
-
How to Connect to Live IBM Cloud Object Storage Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your IBM Cloud Object Storage for you.
-
Connect and Query Live Raisers Edge NXT Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Raisers Edge NXT into Databricks
-
Connect to MessageBird Data in DBeaver
Use the CData ODBC Driver to connect to MessageBird in DBeaver.
-
Use Dash to Build to Web Apps on ZohoDesk Data
Create Python applications that use pandas and Dash to build ZohoDesk-connected web apps.
-
Integrate Live Blackbaud FE NXT Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Blackbaud FE NXT from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Blackbaud FE NXT.
-
How to Work with Scrapfly Data in AWS Glue Jobs Using JDBC
Connect to Scrapfly from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Zoho Creator 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 Zoho Creator.
-
Connect to Harvest Data in NetBeans
Connect to Harvest in NetBeans with the data source configuration wizard.
-
Edit and Search Airtable External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Airtable to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Airtable objects that you can access from apps and the dashboard.
-
Viewing Codat Data in RAD Studio Data Explorer
How to view Codat in RAD Studio Data Explorer using the CData ODBC Driver for Codat.
-
Visualize Productboard Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Productboard.
-
Connect to Real-Time Oracle Service Cloud Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Oracle Service Cloud and Dataflow to import and use Oracle Service Cloud in Power Apps.
-
Getting Started with the CData ODBC Driver for Adobe Target
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Adobe Target.
-
How to Connect to Live eBay Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live eBay without replication.
-
Use Databricks Agent Bricks to Talk to Your Tally Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Tally ERP for you.
-
Create Dynamic EnterpriseDB Grids Using the Infragistics XamDataGrid
Learn how you can connect EnterpriseDB to Infragistics XamDataGrid to build dynamic grids.
-
Operational Reporting on Drip Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Drip.
-
How to create Toggl federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Toggl in MySQL .
-
How to create an RPA flow for Freshteam Data in UiPath Studio
Use the Freshteam ODBC Driver to create workflows that access real-time Freshteam without any coding.
-
View Reports on Real-Time Jumpseller Data in Power BI Report Server
Use the CData ODBC Driver for Jumpseller to visualize Jumpseller in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Easily Query Google Drive Data in OpenOffice Base
Connect to Google Drive data in OpenOffice Base using the CData ODBC Driver for Google Drive and generate reports with live data insights.
-
Create Onfleet Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Onfleet from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to create an RPA flow for Copper Data in UiPath Studio
Use the Copper ODBC Driver to create workflows that access real-time Copper without any coding.
-
Access Live Freshservice Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Freshservice from your Excel spreadsheets.
-
Getting Started with the CData JDBC Driver for Azure Data Lake Storage
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Azure Data Lake Storage.
-
Analyze Snapchat Ads Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Snapchat Ads from Power Pivot. You will use the Table Import Wizard to load Snapchat Ads. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Procore Data in HULFT Integrate
Connect to Procore as a JDBC data source in HULFT Integrate
-
Create Dynamic Dynamics CRM Grids Using the Infragistics XamDataGrid
Learn how you can connect Dynamics CRM to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Google Analytics Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Google Analytics replication to Amazon Redshift.
-
How to Connect Flowise AI Agents to Live Asana Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Asana without replication.
-
How to create an RPA flow for Mailjet Data in UiPath Studio
Use the Mailjet ODBC Driver to create workflows that access real-time Mailjet without any coding.