CData Software - Knowledge Base
Recent Articles
-
Create Dashboards and Visualize Live Oracle Service Cloud Data in Geckoboard
Use CData Connect AI to connect to live Oracle Service Cloud and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Deploy the ADO.NET Provider for Mocean on an SSRS Report Server
Connect to Mocean 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.
-
Integrating LangChain with Cvent Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Cvent within automated workflows.
-
How to Connect to & Open ActiveCampaign Data in Microsoft Excel
This article uses the CData ODBC driver for ActiveCampaign to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Epicor Kinetic Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Epicor Kinetic data access from reports, embedded analytics, and more.
-
Automated Continuous XML Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable XML replication to Azure SQL Database.
-
Connect to MySQL through SSH Using the Built-In Client
A detailed overview of the SQL Gateway, its function, and its features.
-
Operational Reporting on Twilio Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Twilio.
-
Integrate Cursor with Live Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Trello from within the editor.
-
Create Data Visualizations in Cognos BI with Shortcut Data
Access Shortcut as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build SAP Hybris C4C-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP Hybris C4C and build web apps with connectivity to live SAP Hybris C4C.
-
Getting Started with the CData SSIS Components for Supabase
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Supabase.
-
Enable the Azure Table JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Azure Table Storage.
-
Integrate Live JSON Services into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live JSON to Blue Prism using the CData ODBC Driver for JSON to create automated workflows for repetitive business tasks.
-
Model, Search, and Visualize Live Zoom Data in ThoughtSpot
Use CData Connect AI to connect to live Zoom for modeling, searching, and visualizing.
-
Connect to Oracle HCM Cloud Data from PowerBuilder via ADO.NET
This article demonstrates how to access Oracle HCM Cloud from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle HCM Cloud.
-
Use the CData ODBC Driver for ConvertKit in Microsoft Power Query
You can use the CData ConvertKit ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ConvertKit into Microsoft Power Query.
-
Viewing Demio Data in RAD Studio Data Explorer
How to view Demio in RAD Studio Data Explorer using the CData ODBC Driver for Demio.
-
Build Dashboards with Webex Data in Dundas BI
Create dynamic dashboards and perform analytics based on Webex in Dundas BI.
-
Integrate Cline with Live Gmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Gmail from within your IDE.
-
Query FHIR Data through ODBC in Node.js
Use node-odbc to execute SQL queries against FHIR from Node.js.
-
Automated Continuous Microsoft OneLake Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to Google BigQuery.
-
Query Eventbrite Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Eventbrite from Node.js.
-
Create Reports with Monday.com Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Monday.com.
-
Connect to Cosmos DB Data from PowerBuilder via ADO.NET
This article demonstrates how to access Azure Cosmos DB from Appeon PowerBuilder using the CData ADO.NET Provider for Cosmos DB.
-
Getting Started with the CData SSIS Components for Planio
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Planio.
-
Access CampaignMonitor 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 CampaignMonitor.
-
Establish a Live Connection with xBase Data using Tableau Bridge
The CData ODBC Driver for xBase enables you to integrate live xBase into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to and Query Telegram Data in QlikView over ODBC
Create data visualizations with Telegram in QlikView.
-
Migrating data from Short.io to Databricks using CData SSIS Components.
Easily push Short.io to Databricks using the CData SSIS Tasks for Short.io and Databricks.
-
A PostgreSQL Interface for Amazon Athena Data using the CData ODBC Driver
Use the SQL Gateway and Amazon Athena ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build BigQuery-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for BigQuery to explore live BigQuery Data in GitHub Copilot to assist with building BigQuery-powered applications.
-
Connect to ZarMoney Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ZarMoney to connect to ZarMoney and execute queries in PowerBuilder.
-
Visualize Salesforce Pardot Data in Tableau
The CData ODBC driver for Salesforce Pardot enables you integrate Salesforce Pardot into Tableau dashboards.
-
Connect to Sage Intacct Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Sage Intacct as an External Source in Dremio.
-
Connect to Egnyte Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Egnyte.
-
Working with Greenplum Data in LINQPad
Execute LINQ queries to Pivotal GreenPlum in LINQPad.
-
How to connect to Sage Intacct Data from Spring Boot
Connect to Sage Intacct in a Spring Boot Application using the CData JDBC Driver for Sage Intacct
-
Work with Live Marketo Data in Power Query
Use CData Connect AI to connect to Marketo and work with live Marketo in Microsoft Power Query.
-
How to connect SharePoint with Zuora Data through external lists
Provide Zuora to SharePoint users as an external list.
-
Integrate Live Retently Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Retently to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to and Query Anaplan Data in QlikView over ODBC
Create data visualizations with Anaplan in QlikView.
-
Connect to Zoho Inventory Data in Google Apps Script via Connect AI
Use CData Connect AI to access Zoho Inventory in Google Apps Script.
-
Create Informatica Mappings From/To a JDBC Data Source for FormSite
Create FormSite data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Trigger Xero IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Xero with standard wizards in Logic Apps.
-
Automate Tasks in Power Automate Using the CData API Server
Automate BigCommerce actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Publish Reports with Zoho Books Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoho Books.
-
How to Work with CampaignMonitor Data in ETL Validator JDBC
Connect to CampaignMonitor from ETL Validator jobs using the CData Software JDBC Driver.
-
Visualize Google Spanner Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Spanner.
-
Connect to JSON from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from JSON, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData JDBC Driver for Humanity
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Humanity.
-
Use JayDeBeApi to access Copper Data in Python
Use standard Python scripting and the development environment of your choice to access live Copper.
-
Build a PostgreSQL Interface for HBase Data using the CData JDBC Driver
Use the Remoting features of the HBase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Copper in MicroStrategy Desktop
Connect to Copper in MicroStrategy Desktop using the CData Software JDBC Driver for Copper.
-
Build XML-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for XML to explore live XML Data in Cursor to assist with building XML-powered applications.
-
Bidirectional Access to Zoho Books Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Zoho Books in Filemaker Pro for Mac or Windows.
-
Analyze Smartsheet Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Smartsheet in Microsoft R Open.
-
Connect to Codat Data in CloverDX (formerly CloverETL)
Transfer Codat using the visual workflow in the CloverDX data integration tool.
-
Connect to EmailOctopus Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for EmailOctopus in the Denodo Virtual DataPort Administrator.
-
Publish Google Ads-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Ads.
-
Integrating Delighted Data in Talend Cloud Data Management Platform
Connect Delighted Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build Apps with Live ZohoInvoice Data Using the Low-Code Development Platform of Mendix
Connect ZohoInvoice with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to NetSuite Data from HeidiSQL
Use CData Connect AI to connect to and query live NetSuite CRM & ERP from HeidiSQL.
-
Integrate Instantly Data in Pentaho Data Integration
Build ETL pipelines based on Instantly in the Pentaho Data Integration tool.
-
Analyze ADP Data in Looker
Use CData Connect AI to connect to ADP Data from Looker and build custom apps using live ADP.
-
How to work with Mixpanel Data in Apache Spark using SQL
Access and process Mixpanel Data in Apache Spark using the CData Software JDBC Driver.
-
How to import ZarMoney Data into Apache Solr
Use the CData Software JDBC Driver for ZarMoney in Data Import Handler and create an automated import of ZarMoney to Apache Solr Enterprise Search platform.
-
How to create Visio diagrams from DB2 Data
Automatically update IBM DB2 with the changes you make to Visio master shapes.
-
Natively Connect to Deel Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Deel. Leverage the native support for ODBC in PHP.
-
Seamlessly Bring Kintone Data into Retool Using CData Connect AI
Integrate Kintone data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Operational Reporting on Sybase Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Sybase.
-
Integrate Perigon with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Perigon with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Perigon.
-
Connect to Google Spanner Data from Crystal Reports
Use CData Connect AI to connect to and report on live Google Spanner from Crystal Reports.
-
How to import Close Data into Apache Solr
Use the CData Software JDBC Driver for Close in Data Import Handler and create an automated import of Close to Apache Solr Enterprise Search platform.
-
A PostgreSQL Interface for Notion Data using the CData ODBC Driver
Use the SQL Gateway and Notion ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Microsoft Dataverse Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Microsoft Dataverse (CDS) replication to OneLake in Microsoft Fabric.
-
Provide OData Services of Eventbrite Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Eventbrite by developing a WCF Service Application.
-
Visualize SAP Data in TIBCO Spotfire through ADO.NET
Integrate SAP ERP/NetWeaver into dashboards in TIBCO Spotfire.
-
Integrate SAP Hybris C4C Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SAP Hybris C4C and integrate live SAP Hybris C4C into your Power Automate tasks.
-
Automated Continuous Act-On Replication to MySQL
Use CData Sync for automated, continuous, customizable Act-On replication to MySQL.
-
Import and Visualize Amazon Marketplace Data in Power View
Create data visualizations based on Amazon Marketplace in Excel.
-
Integrate Real-Time Access to Airtable in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Airtable in real time.
-
Replicate Paymo Data to Multiple Databases
Replicate Paymo to disparate databases with a point-and-click configuration.
-
Automated Egnyte Data Replication to Teradata
Use CData Sync to Customize and automate Egnyte replication to Teradata.
-
Process & Analyze Eventbrite Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Eventbrite Data.
-
Create Informatica Mappings From/To a JDBC Data Source for Gong
Create Gong data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Design Impala Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Impala from mobile and tablet Power Apps.
-
How to Visualize Zendesk Data in Python with pandas
Use pandas and other modules to analyze and visualize live Zendesk in Python.
-
Create Informatica Mappings From/To a JDBC Data Source for Ontraport
Create Ontraport data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Replicate Multiple Pipeliner CRM Accounts via the CData Sync CLI
Replicate multiple Pipeliner CRM accounts to one or many databases.
-
LINQ to MessageBird 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 MessageBird Data Provider.
-
Back Up Scrapfly to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Scrapfly data.
-
Use Dash to Build to Web Apps on RSS Feeds
Create Python applications that use pandas and Dash to build RSS-connected web apps.
-
Integrating Gumloop with Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google Search within automated workflows.
-
Integrating Dataiku with FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live FHIR.
-
Integrating Kiro CLI with GitHub 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.
-
Connect Drift to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Drift using the CData Python MCP Server.
-
Publish Perplexity-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Perplexity.
-
Build Visualizations of Webflow Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Webflow in Birst.
-
Integrating OpenCode Terminal with ChartMogul 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.