CData Software - Knowledge Base
Recent Articles
-
Design BIRT Reports on Cvent Data
Provide current Cvent to your embedded analytics.
-
Automated Continuous ServiceNow Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ServiceNow replication to delimited files (CSV/TSV).
-
Connect to Presto Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Presto in the Denodo Virtual DataPort Administrator.
-
Process & Analyze Foursquare Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Foursquare Data.
-
Connect to OpenWeatherMap Data in Jaspersoft Studio
Execute SQL to remote OpenWeatherMap in Jaspersoft Studio.
-
How to Use a Microsoft Access Database to Update Shopify Data in Real Time
Update Shopify data by creating a linked table in Microsoft Access with the CData Shopify ODBC Driver.
-
Visualize GitHub Data in TIBCO Spotfire through ADO.NET
Integrate GitHub into dashboards in TIBCO Spotfire.
-
Use JayDeBeApi to access Everhour Data in Python
Use standard Python scripting and the development environment of your choice to access live Everhour.
-
Connecting GenSpark with Basecamp Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Basecamp without any replication or custom integration required.
-
Connect to ZohoInvoice Data in CloverDX (formerly CloverETL)
Transfer ZohoInvoice using the visual workflow in the CloverDX data integration tool.
-
How to load Shopify data into Elasticsearch via Logstash
Introducing a simple method to load Shopify data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Informatica Mappings From/To a JDBC Data Source for Azure DevOps
Create Azure DevOps data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to AdRoll Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to AdRoll and work with AdRoll in your FileMaker applications.
-
Connect to Hugging Face Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Hugging Face in the Denodo Virtual DataPort Administrator.
-
Getting Started with the CData JDBC Driver for LDAP
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for LDAP.
-
Connect to Oracle Financials Cloud Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle Financials Cloud and the Script function in FileMaker Pro to connect to Oracle Financials Cloud and work with Oracle Financials Cloud in your FileMaker application.
-
Integrate Cursor with Live MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live MYOB AccountRight from within the editor.
-
Consume SAP BusinessObjects BI OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP BusinessObjects BI feeds that reflect any changes in SAP Lumira.
-
A PostgreSQL Interface for Aircall Data using the CData ODBC Driver
Use the SQL Gateway and Aircall ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Impala in MicroStrategy
Connect to Apache Impala in MicroStrategy Developer using the CData Software JDBC Driver for Impala.
-
Integrating Boomi Agentstudio with Oracle Eloqua Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Oracle Eloqua, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate Greenhouse with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Greenhouse with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Greenhouse.
-
Use the CData ODBC Driver for Google Contacts in Microsoft Power Query
You can use the CData Google Contacts ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Contacts into Microsoft Power Query.
-
How to Connect DBeaver to TigerGraph via a JDBC Driver
Manage TigerGraph with visual tools in DBeaver like the query browser.
-
Use the CData Software ODBC Driver for Outreach.io in MicroStrategy Web
Connect to Outreach.io in MicroStrategy Web using the CData Software ODBC Driver for Outreach.io.
-
How to integrate Metabase with SAP SuccessFactors LMS Data
Use CData Connect AI to connect to live SAP SuccessFactors LMS and create an interactive dashboard in Metabase from SAP SuccessFactors LMS.
-
Quick Setup Guide for CData HubSpot Drivers
Easy guide for using CData HubSpot Drivers and Connectors for the first time.
-
Visualize Stripe Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Stripe into TIBCO Spotfire.
-
Connect to Postmark from Asprova with CData Software ODBC Driver for Postmark
This article shows how to connect faster to Postmark data from Asprova.
-
Automated Continuous Zendesk Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Zendesk replication to AlloyDB.
-
How to Create Power BI Visual Reports with Real-Time ZohoPeople Data
Use CData Power BI Connectors to visualize ZohoPeople in Power BI.
-
Getting Started with the CData Power BI Connector for Intercom
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Access Live DocuSign Data in Power Automate Desktop via ODBC
The CData ODBC Driver for DocuSign enables you to integrate DocuSign into workflows built using Microsoft Power Automate Desktop.
-
DataBind Controls to Google Campaign Manager 360 Data in Delphi
DataBind to Google Campaign Manager 360 in Delphi with standard data access components and controls.
-
Import Azure Table Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Azure Table Storage. In this article, you will use the OData format to import Azure Table Storage into Microsoft Power Query.
-
Use the CData ODBC Driver for Pinterest in Microsoft Power Query
You can use the CData Pinterest ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Pinterest into Microsoft Power Query.
-
How to Build an ETL App for Confluence Data in Python with CData
Create ETL applications and real-time data pipelines for Atlassian Confluence in Python with petl.
-
Integrate Acumatica Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Acumatica ERP and integrate live Acumatica ERP into your Power Automate tasks.
-
Design BIRT Reports on SAS xpt Data
Provide current SAS XPORT to your embedded analytics.
-
Design BIRT Reports on Zoho Projects Data
Provide current Zoho Projects to your embedded analytics.
-
Connect to Smartsheet Data in DBeaver
Use the CData ODBC Driver to connect to Smartsheet in DBeaver.
-
How to connect PolyBase to YouTube Analytics
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live YouTube Analytics.
-
Use JayDeBeApi to access Ontraport Data in Python
Use standard Python scripting and the development environment of your choice to access live Ontraport.
-
Stream Codat Data into Apache Kafka Topics
Access and stream Codat in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Wistia
Provide connectivity to Wistia through an SAP BusinessObjects universe.
-
Connect to Zuora Data in CloverDX (formerly CloverETL)
Transfer Zuora using the visual workflow in the CloverDX data integration tool.
-
How to Use a Microsoft Access Database to Update Office 365 Data in Real Time
Update Office 365 data by creating a linked table in Microsoft Access with the CData Office 365 ODBC Driver.
-
Build Semantic Layer Views for CampaignMonitor Data in APOS Live Data Gateway
Use the CData Connector for CampaignMonitor in APOS Live Data Gateway to build Semantic Layer Views for CampaignMonitor.
-
Visualize Live Qualaroo Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Qualaroo using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate PabblySubscriptions Data in the Pentaho Report Designer
Publish reports based on PabblySubscriptions in the Pentaho BI tool.
-
Build an OLAP Cube in SSAS from Oracle Service Cloud Data
Establish a connection to Oracle Service Cloud data from SQL Server Analysis Services, and use the Oracle Service Cloud Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Aha! Data in Aqua Data Studio
Access Aha! from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Getting Started with the CData SSIS Components for Cloudflare
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Cloudflare.
-
Integrate Live LinkedIn Ads Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to LinkedIn Ads and integrate live LinkedIn Ads into apps built in Microsoft Power Apps.
-
Load Superchat Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Superchat to a database.
-
How to Connect to Live Certinia 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 Certinia for you.
-
Create Reports from Impala Data in Looker Studio
Use CData Connect AI to gain access to live Apache Impala and create custom reports in Looker Studio.
-
Use Microsoft Copilot Studio to talk to your Google Cloud Storage 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 Google Cloud Storage for you.
-
Build SAP HANA-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SAP HANA to explore live SAP HANA Data in Claude Code to assist with building SAP HANA-powered applications.
-
Visualize Aha! Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Aha! into TIBCO Spotfire.
-
Work with Live Amazon Marketplace Data in Power Query
Use CData Connect AI to connect to Amazon Marketplace and work with live Amazon Marketplace in Microsoft Power Query.
-
Integrating Antigravity CLI with Gorgias via CData CLI
Connect Gorgias to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Live HBase Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Create Blackbaud FE NXT-Connected Dashboards in Grafana
Connect to Blackbaud FE NXT Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Blackbaud FE NXT.
-
Create SSAS Tabular Models from Bannerbear Data
How to build a SQL Server Analysis Service Tabular Model from Bannerbear using CData drivers.
-
Create Dynamic MySQL Grids Using the Infragistics XamDataGrid
Learn how you can connect MySQL to Infragistics XamDataGrid to build dynamic grids.
-
Prepare, Blend, and Analyze Box Data in Alteryx Designer (Connect AI)
Build workflows to access live Box for self-service data analytics.
-
Easily Integrate Coda Data in Lazarus Pascal IDE
Learn how to easily integrate live Coda in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build a Salesforce Lead Manager with Python and MCP Server
Build a Salesforce Lead Management GUI application in Python using AI-assisted development with CData MCP Server and Claude Code
-
Access Live Bullhorn CRM Data in AWS Lambda
Connect to live Bullhorn CRM in AWS Lambda using the CData JDBC Driver.
-
Connect to Power BI XMLA Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Power BI XMLA using standard SQL.
-
ETL Slack in Oracle Data Integrator
This article shows how to transfer Slack into a data warehouse using Oracle Data Integrator.
-
Access Live Oracle Financials Cloud Data in Excel 365 Online (Excel for the web)
Connect to Oracle Financials Cloud from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated ConvertKit Data Replication to Teradata
Use CData Sync to Customize and automate ConvertKit replication to Teradata.
-
How to Visualize OData Services in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live OData in Python.
-
Query HubSpot Data as a MySQL Database in Node.js
Execute MySQL queries against HubSpot from Node.js.
-
Access SAP ByDesign Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP Business ByDesign from HeidiSQL.
-
LINQ to Beeminder 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 Beeminder Data Provider.
-
How to Work with MailerSend Data in ETL Validator JDBC
Connect to MailerSend from ETL Validator jobs using the CData Software JDBC Driver.
-
How to use SQLAlchemy ORM to access Reckon Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Reckon.
-
Access Mailgun Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Mailgun from HeidiSQL.
-
Visualize Live SharePoint Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft SharePoint and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Validate Amazon Athena Data with QuerySurge
Access and validate Amazon Athena in QuerySurge using the CData JDBC Driver.
-
Getting Started with the CData JDBC Driver for FormSite
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for FormSite.
-
Access Productboard Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Productboard from your Oracle system.
-
How to Seamlessly Import Scrapfly Data into IBM SPSS Modeler
Integrate Scrapfly data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Microsoft OneLake Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to IBM DB2.
-
Connect to Impala Data in RapidMiner
Integrate Apache Impala with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Cursor CLI with Copper 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.
-
Automated Continuous Kintone Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Kintone replication to delimited files (CSV/TSV).
-
Import Microsoft Planner Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft Planner. In this article, you will use the OData format to import Microsoft Planner into Microsoft Power Query.
-
Provide OData Services of SAP Business Warehouse Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP Business Warehouse by developing a WCF Service Application.
-
Access Live Cosmos DB Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Azure Cosmos DB from your Excel spreadsheets.
-
Integrate MarkLogic Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to MarkLogic and integrate live MarkLogic into your Power Automate tasks.
-
Integrate SFTP Data in the Pentaho Report Designer
Publish reports based on SFTP in the Pentaho BI tool.
-
Integrate with Sage Cloud Accounting Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Sage Business Cloud Accounting in SnapLogic.
-
Connect to Grafana Data in CloverDX (formerly CloverETL)
Transfer Grafana using the visual workflow in the CloverDX data integration tool.
-
Visualize Azure Analysis Services Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Azure Analysis Services into TIBCO Spotfire.
-
Automated Continuous MongoDB Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable MongoDB replication to OneLake in Microsoft Fabric.
-
How to import Paddle Data into Apache Solr
Use the CData Software JDBC Driver for Paddle in Data Import Handler and create an automated import of Paddle to Apache Solr Enterprise Search platform.