CData Software - Knowledge Base
Recent Articles
-
Build a Simple VCL Application for Microsoft Teams Data
How to build a simple VCL Application to view Microsoft Teams in RAD Studio using the CData ODBC Driver for Microsoft Teams.
-
Integrate Square with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Square with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Square.
-
ETL Amazon Athena in Oracle Data Integrator
This article shows how to transfer Amazon Athena into a data warehouse using Oracle Data Integrator.
-
Consume Dynamics 365 OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Dynamics 365 feeds that reflect any changes in SAP Lumira.
-
Build Automated SurveyMonkey-Connected Workflows in Zapier
Use CData Connect AI to connect to live SurveyMonkey and build automated workflows in Zapier.
-
How to Connect to Mistral AI Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Mistral AI. Leverage the pyodbc module for ODBC in Python.
-
Integrating Claude Code CLI with Microsoft OneDrive 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 to Office 365 from a Connection Pool in WebLogic
Use the CData JDBC Driver for Office 365 to connect to Microsoft Office 365 from Web applications running on WebLogic.
-
Consume Google Ads OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Ads feeds that reflect any changes in SAP Lumira.
-
Automated Continuous Phoenix Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Phoenix replication to Apache Kafka.
-
Build Automated Workflows with Live Dynamics 365 Business Central Data in Workato
Use CData Connect AI to connect to live Dynamics 365 Business Central and build automated workflows in Workato.
-
How to Connect the Power BI Service to SAP Ariba Procurement: Complete Guide
Connect to the CData Software Power BI Connector for SAP Ariba Procurement from PowerBI.com to provide real-time SAP Ariba Procurement across the organization.
-
How to publish and share Drip Data dashboards with Tableau Server
The CData ODBC driver for Drip enables you integrate Drip into Tableau dashboards.
-
Deploy the ADO.NET Provider for Oracle Service Cloud on an SSRS Report Server
Connect to Oracle Service Cloud 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.
-
How to Build an ETL App for Exact Online Data in Python with CData
Create ETL applications and real-time data pipelines for Exact Online in Python with petl.
-
Connect to SAP HANA Data in CloverDX (formerly CloverETL)
Transfer SAP HANA using the visual workflow in the CloverDX data integration tool.
-
Integrating GitHub Copilot CLI with Microsoft OneDrive 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.
-
Viewing Wistia Data in RAD Studio Data Explorer
How to view Wistia in RAD Studio Data Explorer using the CData ODBC Driver for Wistia.
-
Analyze MessageBird Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze MessageBird with the CData JDBC Driver for MessageBird.
-
Automate SAP Ariba Source Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP Ariba Source replication to Azure Data Lake.
-
Work with Live Cvent Data in Power Query
Use CData Connect AI to connect to Cvent and work with live Cvent in Microsoft Power Query.
-
Integrating Codex CLI with Perigon 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.
-
Publish Zendesk-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Zendesk.
-
Analyze Billsby Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Billsby from Power Pivot. You will use the Table Import Wizard to load Billsby. You can visually build the import query or use any SQL supported by the driver.
-
Migrating data from ZohoSubscriptions to Snowflake using CData SSIS Components.
Easily push ZohoSubscriptions to Snowflake using the CData SSIS Tasks for ZohoSubscriptions and Snowflake.
-
Build an OLAP Cube in SSAS from Front Data
Establish a connection to Front data from SQL Server Analysis Services, and use the Front Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous TaxJar Replication to Oracle
Use CData Sync for automated, continuous, customizable TaxJar replication to Oracle.
-
Build Visualizations of Snowflake Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Snowflake in Birst.
-
Connect to Cosmos DB Data from PowerBuilder via JDBC
This article demonstrates how to access Azure Cosmos DB from PowerBuilder using the Cosmos DB JDBC Driver.
-
Getting Started with the CData ODBC Driver for HDFS
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for HDFS.
-
Integrate Aircall Data in the Pentaho Report Designer
Publish reports based on Aircall in the Pentaho BI tool.
-
Integrate with SAP Hybris C4C Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP Hybris C4C in SnapLogic.
-
Replicate Multiple OData Accounts
Replicate multiple OData accounts to one or many databases.
-
Configure the CData JDBC Driver for Google Search in a Connection Pool in Tomcat
Connect to Google Search from a connection pool in Tomcat.
-
How to Query Live ShipStation Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ShipStation data in natural language using Python.
-
Create Microsoft Teams-Connected Business Apps in AppSheet
Connect to Microsoft Teams Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft Teams.
-
Consume Outreach.io OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Outreach.io feeds that reflect any changes in SAP Lumira.
-
Connect to SAP SuccessFactors LMS from Asprova with CData Software ODBC Driver for SAP SuccessFactors LMS
This article shows how to connect faster to SAP SuccessFactors LMS data from Asprova.
-
A PostgreSQL Interface for ChargeOver Data using the CData ODBC Driver
Use the SQL Gateway and ChargeOver ODBC Driver to create a PostgreSQL entry-point for data access.
-
Enable the Email JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Email.
-
A PostgreSQL Interface for Google Analytics Data (MySQL Remoting via JDBC)
Use the Remoting features of the Google Analytics JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Pipedrive in MicroStrategy
Connect to Pipedrive in MicroStrategy Developer using the CData Software JDBC Driver for Pipedrive.
-
Automated Continuous Samanage Replication to MongoDB
Use CData Sync for automated, continuous, customizable Samanage replication to MongoDB.
-
Access Live Suadeo Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Suadeo in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect the Power BI Service to Apollo: Complete Guide
Connect to the CData Software Power BI Connector for Apollo from PowerBI.com to provide real-time Apollo across the organization.
-
Build Voice Agents in ElevenLabs with access to Live Microsoft Teams Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Microsoft Teams.
-
Getting Started with the CData ADO.NET Provider for Azure Analysis Services
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Azure Analysis Services.
-
Connect to Facebook Data from PowerBuilder via JDBC
This article demonstrates how to access Facebook from PowerBuilder using the Facebook JDBC Driver.
-
Analyze Cvent Data in Looker
Use CData Connect AI to connect to Cvent Data from Looker and build custom apps using live Cvent.
-
Configure the CData JDBC Driver for Printful in a Connection Pool in Tomcat
Connect to Printful from a connection pool in Tomcat.
-
Automated Continuous Cvent Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Cvent replication to delimited files (CSV/TSV).
-
Use CData Connect AI to Access Raisers Edge NXT Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Raisers Edge NXT in the Power Pivot business intelligence tool.
-
Edit and Search External Oracle Sales Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Oracle Sales to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Oracle Sales Data objects that you can access from apps and the dashboard.
-
How to connect SharePoint with Google Directory Data through external lists
Provide Google Directory to SharePoint users as an external list.
-
Use the CData Software ODBC Driver for Beeminder in MicroStrategy Desktop
Connect to Beeminder in MicroStrategy Desktop using the CData Software ODBC Driver for Beeminder.
-
Build an OLAP Cube in SSAS from Spotify Data
Establish a connection to Spotify data from SQL Server Analysis Services, and use the Spotify Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Bugsnag Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Bugsnag from your Oracle system.
-
Integrate NetSuite with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate NetSuite with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to NetSuite CRM & ERP.
-
Connect to Notion Data from a Connection Pool in JBoss
Integrate Notion into Java servlets: Use the Management Console in JBoss to install the Notion JDBC Driver.
-
Create Data Visualizations Based On Pipedrive Data in Mode
Use CData Connect AI to connect to Pipedrive Data from Mode and build visualizations using live
-
How to use SQLAlchemy ORM to access ServiceNow Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ServiceNow.
-
Connect to MYOB AccountRight Data from PowerBuilder via ADO.NET
This article demonstrates how to access MYOB AccountRight from Appeon PowerBuilder using the CData ADO.NET Provider for MYOB AccountRight.
-
Connect to Microsoft OneDrive Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft OneDrive using standard SQL.
-
How to load Mouseflow data into Elasticsearch via Logstash
Introducing a simple method to load Mouseflow data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Analyze MailerSend Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for MailerSend from Power Pivot. You will use the Table Import Wizard to load MailerSend. You can visually build the import query or use any SQL supported by the driver.
-
Build Gong-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Gong and build web apps with connectivity to live Gong.
-
Connect to Zoho Creator Data in CloverDX (formerly CloverETL)
Transfer Zoho Creator using the visual workflow in the CloverDX data integration tool.
-
Connect to Accelo Data from a Connection Pool in Jetty
The Accelo JDBC Driver supports connection pooling: This article shows how to connect faster to Accelo from Web apps in Jetty.
-
Import Real-Time Zoom Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zoom in ColdFusion.
-
How to Connect to Live Box Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Box securely in real time.
-
Build Automated API-Connected Workflows in Zapier
Use CData Connect AI to connect to live API and build automated workflows in Zapier.
-
Visualize Live Superchat Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Superchat.
-
Connect to MailChimp Data from AWS Glue
Use CData Connect AI to gain access to live MailChimp from your AWS Glue jobs.
-
Prepare, Blend, and Analyze SFTP Data in Alteryx Designer (ODBC)
Build workflows to access live SFTP for self-service data analytics.
-
Query Square Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Square from Node.js.
-
Work with Email Data in FoxPro
Load Email into a FoxPro database. This article includes full code and a walk-through of the process.
-
DataBind Controls to Power BI XMLA Data in Delphi
DataBind to Power BI XMLA in Delphi with standard data access components and controls.
-
How to Query Live Pipedrive Data in Claude Desktop
Connect to and query live Pipedrive Data in Claude Desktop using CData MCP Server.
-
Use the CData Software JDBC Driver for SAS xpt in MicroStrategy
Connect to SAS XPORT in MicroStrategy Developer using the CData Software JDBC Driver for SAS xpt.
-
How to Create Power BI Visual Reports with Real-Time ZohoSubscriptions Data
Use CData Power BI Connectors to visualize ZohoSubscriptions in Power BI.
-
Create Dynamic Brex Grids Using the Infragistics XamDataGrid
Learn how you can connect Brex to Infragistics XamDataGrid to build dynamic grids.
-
Moving Data from Demio to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Demio data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate ShipStation Data into Power Automate Desktop using CData Connect
CData Connect for ShipStation Data enables you to integrate ShipStation into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData Power BI Connector for eBay Analytics
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for eBay Analytics.
-
Integrate Paymo Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Paymo from Informatica Cloud.
-
Connect to ServiceNow Data in CloverDX (formerly CloverETL)
Transfer ServiceNow using the visual workflow in the CloverDX data integration tool.
-
Connect to ActiveCampaign Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for ActiveCampaign in Airbyte.
-
Using the CData Software ODBC Driver for Pinterest in PyCharm
Connect to Pinterest as an ODBC data source in PyCharm using the CData Software ODBC Driver for Pinterest.
-
Connect to EnterpriseDB Data in Google Apps Script via Connect AI
Use CData Connect AI to access EnterpriseDB in Google Apps Script.
-
Build a Simple VCL Application for Blackbaud FE NXT Data
How to build a simple VCL Application to view Blackbaud FE NXT in RAD Studio using the CData ODBC Driver for Blackbaud FE NXT.
-
Access Live HCL Domino Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live HCL Domino from your Excel spreadsheets.
-
Access Oracle Data from MySQL in PHP
Connect to Oracle through the standard MySQL libraries in PHP.
-
Build AI/ML Models with Live Microsoft Teams Data using Dataiku
Connect Microsoft Teams Data with Dataiku using the CData JDBC Driver for Microsoft Teams.
-
Build AI Agents with SAP Ariba Source 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 SAP Ariba Source through CData Connect AI.
-
Viewing Azure Synapse Data in RAD Studio Data Explorer
How to view Azure Synapse in RAD Studio Data Explorer using the CData ODBC Driver for Azure Synapse.
-
Build MVC Applications with Connectivity to YouTube Analytics Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access YouTube Analytics from an ASP.NET MVC application.
-
Build AI/ML Models with Live ZeroBounce Data using Dataiku
Connect ZeroBounce Data with Dataiku using the CData API Driver for JDBC.
-
Deploy the ADO.NET Provider for Mouseflow on an SSRS Report Server
Connect to Mouseflow 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.
-
Use the CData Software ODBC Driver for Coinbase in MicroStrategy
Connect to Coinbase in MicroStrategy Developer using the CData Software ODBC Driver for Coinbase.
-
Publish Reports with Adobe Analytics Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Adobe Analytics.