CData Software - Knowledge Base
Recent Articles
-
Create SAP Ariba Procurement-Connected Dashboards in Grafana
Connect to SAP Ariba Procurement Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP Ariba Procurement.
-
How to Visualize Drift Data in Python with pandas
Use pandas and other modules to analyze and visualize live Drift in Python.
-
Replicate Google Ad Manager Data to Multiple Databases via the CData Sync CLI
Replicate Google Ad Manager to disparate databases with a single configuration.
-
How to Easily Query Oracle Service Cloud Data in OpenOffice Base
Connect to Oracle Service Cloud data in OpenOffice Base using the CData ODBC Driver for Oracle Service Cloud and generate reports with live data insights.
-
Build xBase-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for xBase to explore live xBase Data in GitHub Copilot to assist with building xBase-powered applications.
-
Connect to Bitbucket Data in DBeaver
Use the CData ODBC Driver to connect to Bitbucket in DBeaver.
-
Create BigCommerce-Connected Dashboards in Grafana
Connect to BigCommerce Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to BigCommerce.
-
Import QuickBooks Time Data Using Azure Data Factory
Use CData Connect AI to connect to QuickBooks Time Data from Azure Data Factory and import live QuickBooks Time.
-
Create Dynamic Epicor Kinetic Grids Using the Infragistics XamDataGrid
Learn how you can connect Epicor Kinetic to Infragistics XamDataGrid to build dynamic grids.
-
Import Real-Time Cloudflare Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Cloudflare in ColdFusion.
-
Create SSAS Tabular Models from PingOne Data
How to build a SQL Server Analysis Service Tabular Model from PingOne using CData drivers.
-
Use the CData Software JDBC Driver for ClickUp in MicroStrategy Web
Connect to ClickUp in MicroStrategy Web using the CData Software JDBC Driver for ClickUp.
-
Analyze Google Calendar Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google Calendar and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
View Reports on Real-Time Tally Data in Power BI Report Server
Use the CData ODBC Driver for Tally to visualize Tally ERP in Power BI Desktop and then publish them to Power BI Report Server.
-
Using the CData Software ODBC Driver for Nuclia in PyCharm
Connect to Nuclia as an ODBC data source in PyCharm using the CData Software ODBC Driver for Nuclia.
-
Visualize Live Airtable Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Airtable.
-
Getting Started with the CData Connect AI Python SDK for Oracle HCM Cloud
Install the CData Connect AI Python SDK to read and write live Oracle HCM Cloud with standard DB-API 2.0 Python code.
-
Build MariaDB-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to MariaDB Data from Zoho Analytics and import live MariaDB.
-
DataBind Controls to Shortcut Data in Delphi
DataBind to Shortcut in Delphi with standard data access components and controls.
-
Integrating Deel Data in Talend Cloud Data Management Platform
Connect Deel Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create Informatica Mappings From/To a JDBC Data Source for ConvertAPI
Create ConvertAPI data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Natively Connect to MYOB AccountRight Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to MYOB AccountRight. Leverage the native support for ODBC in PHP.
-
Build Dashboards with Dropbox Data in Dundas BI
Create dynamic dashboards and perform analytics based on Dropbox in Dundas BI.
-
Connect to and Query Testmonitor Data in QlikView over ODBC
Create data visualizations with Testmonitor in QlikView.
-
Consume SuiteCRM OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SuiteCRM feeds that reflect any changes in SAP Lumira.
-
Connect to Elorus Data in NetBeans
Connect to Elorus in NetBeans with the data source configuration wizard.
-
Analyze Snapchat Ads Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Snapchat Ads with the CData JDBC Driver for Snapchat Ads.
-
Connect to Nethunt Data in Jaspersoft Studio
Execute SQL to remote Nethunt in Jaspersoft Studio.
-
Integrating GitHub Copilot CLI with ZendeskSell 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.
-
Query NetSuite SuiteAnalytics Data as a SQL Server Database in Node.js
Execute SQL Server queries against NetSuite SuiteAnalytics from Node.js.
-
Getting Started with the CData Connect AI Python SDK for Microsoft Ads
Install the CData Connect AI Python SDK to read and write live Microsoft Ads with standard DB-API 2.0 Python code.
-
Visualize HubSpot Data in Sisense
Create an ElastiCube in Sisense app with access to HubSpot.
-
Zoom Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Zoom through CData Connect AI using different applications and tools.
-
Build AI/ML Models with Live Keap Data using Dataiku
Connect Keap Data with Dataiku using the CData API Driver for JDBC.
-
Query Float Data in ColdFusion
Write standard ColdFusion data access code to connect to Float.
-
Use Azure AI Foundry to Talk to Your Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Jira Assets for you.
-
How to Easily Query PagerDuty Data in OpenOffice Base
Connect to PagerDuty data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Query Datadog Data as a MySQL Database in Node.js
Execute MySQL queries against Datadog from Node.js.
-
Working with Drip Data in LINQPad
Execute LINQ queries to Drip in LINQPad.
-
How to work with Okta Data in Apache Spark using SQL
Access and process Okta Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Drift Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Drift.
-
How to integrate ZeroBounce with Apache Airflow
Access and process ZeroBounce in Apache Airflow using the CData JDBC Driver.
-
Replicate Greenhouse Data to Multiple Databases via the CData Sync CLI
Replicate Greenhouse to disparate databases with a single configuration.
-
Visualize Live Dynamics CRM Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft Dynamics CRM using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build an OLAP Cube in SSAS from Microsoft Entra ID Data
Establish a connection to Microsoft Entra ID data from SQL Server Analysis Services, and use the Microsoft Entra ID Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect Zoom to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Zoom with IBM WebSphere for seamless data integration and connectivity.
-
Connect Cloudflare to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Cloudflare using the CData Python MCP Server.
-
How to Access Live Suadeo Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Suadeo enables you to integrate Suadeo into workflows built using Microsoft Power Automate Desktop.
-
How to Connect the Power BI Service to Exa: Complete Guide
Connect to the CData Software Power BI Connector for Exa from PowerBI.com to provide real-time Exa across the organization.
-
Migrating data from Tavily to Snowflake using CData SSIS Components.
Easily push Tavily to Snowflake using the CData SSIS Tasks for Tavily and Snowflake.
-
How to Connect SAP Fieldglass 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 SAP Fieldglass data in real time using natural language.
-
Build AI Agents with Google Cloud Storage 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 Google Cloud Storage through CData Connect AI.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live EnterpriseDB using the Model Context Protocol.
-
Query Salesloft Data as a MySQL Database in Node.js
Execute MySQL queries against Salesloft from Node.js.
-
Use the CData API Server to Access Active Directory Data in Microsoft PowerPivot
Use the CData API Server to connect to live Active Directory in the Power Pivot business intelligence tool.
-
Query Tally Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Tally entities in PHP by modeling them as objects.
-
How to integrate Azure Data Lake Storage with Apache Airflow
Access and process Azure Data Lake Storage in Apache Airflow using the CData JDBC Driver.
-
Build MVC Applications with Connectivity to Snowflake Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Snowflake from an ASP.NET MVC application.
-
Create Reports with PabblySubscriptions Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PabblySubscriptions.
-
Automated Continuous Google Cloud Storage Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to OneLake in Microsoft Fabric.
-
Query SAP Ariba Procurement Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAP Ariba Procurement entities in PHP by modeling them as objects.
-
Integrate Theia IDE with Live Twilio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Build a Simple VCL Application for Strava Data
How to build a simple VCL Application to view Strava in RAD Studio using the CData ODBC Driver for Strava.
-
How to Access Live Egnyte Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Egnyte enables you to integrate Egnyte into workflows built using Microsoft Power Automate Desktop.
-
Connect to FreeAgent Data from PowerBuilder via JDBC
This article demonstrates how to access FreeAgent from PowerBuilder using the FreeAgent JDBC Driver.
-
Integrating Cursor CLI with OData Services 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.
-
Import Real-Time Azure Analysis Services Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Azure Analysis Services in ColdFusion.
-
Automated Continuous Exact Online Replication to Oracle
Use CData Sync for automated, continuous, customizable Exact Online replication to Oracle.
-
Query SharePoint Data in ColdFusion
Write standard ColdFusion data access code to connect to Microsoft SharePoint.
-
Getting Started with the CData Python Connector for Teamwork
Learn to install and license the CData Python Connector
-
Natively Connect to REST Data in PHP
The CData ODBC driver for REST enables you to create PHP applications with connectivity to REST. Leverage the native support for ODBC in PHP.
-
Migrating data from Dotmailer to Databricks using CData SSIS Components.
Easily push Dotmailer to Databricks using the CData SSIS Tasks for Dotmailer and Databricks.
-
Automated Trello Data Replication to Teradata
Use CData Sync to Customize and automate Trello replication to Teradata.
-
How to Access Live Retently Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Retently enables you to integrate Retently into workflows built using Microsoft Power Automate Desktop.
-
Create Oracle HCM Cloud-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Oracle HCM Cloud Data from OutSystems and build custom enterprise apps using live Oracle HCM Cloud.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Shopify
Provide connectivity to Shopify through an SAP BusinessObjects universe.
-
Edit and Search External Neo4J Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Neo4J to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Neo4J Data objects that you can access from apps and the dashboard.
-
Build SAS xpt-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAS XPORT.
-
How to Work with Intercom Data in ETL Validator JDBC
Connect to Intercom from ETL Validator jobs using the CData Software JDBC Driver.
-
Replicate Airtable Data to Multiple Databases via the CData Sync CLI
Replicate Airtable to disparate databases with a single configuration.
-
Object-Relational Mapping (ORM) with ZohoInvoice 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 ZohoInvoice into a Java-based ORM framework, Hibernate.
-
Import Real-Time SAP SuccessFactors Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP SuccessFactors in ColdFusion.
-
Access ScrapingBee Data from MySQL in Amazon QuickSight
Connect to ScrapingBee and build visualizations of ScrapingBee using a MySQL Connection in Amazon QuickSight.
-
Access Spark 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 Apache Spark SQL.
-
View Reports on Real-Time Zuora Data in Power BI Report Server
Use the CData ODBC Driver for Zuora to visualize Zuora in Power BI Desktop and then publish them to Power BI Report Server.
-
Working with Presto Data in LINQPad
Execute LINQ queries to Presto in LINQPad.
-
Getting Started with the CData SSIS Components for Mouseflow
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Mouseflow.
-
Integrate Live IBM Informix Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Query Twilio Data as a MySQL Database in Node.js
Execute MySQL queries against Twilio from Node.js.
-
Automated Continuous Adobe Analytics Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to OneLake in Microsoft Fabric.
-
Automate Tasks in Power Automate Using the CData API Server
Automate SFTP actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Use JayDeBeApi to access eBay Data in Python
Use standard Python scripting and the development environment of your choice to access live eBay.
-
DataBind Controls to Google Contacts Data in C++Builder
DataBind to Google Contacts in C++Builder with standard components and controls.
-
Create Adobe Commerce Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Adobe Commerce from PowerBI.com to create Power BI Dataflows with real-time data.
-
Import Raisers Edge NXT Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Raisers Edge NXT Data and provide access to live Raisers Edge NXT for custom reports in the Power BI Service.
-
Migrating data from Avaza to Google BigQuery using CData SSIS Components.
Easily push Avaza to Google BigQuery using the CData SSIS Tasks for Avaza and Google BigQuery.
-
Connect to Salesforce Pardot from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Salesforce Pardot, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Migrating data from Strava to Google BigQuery using CData SSIS Components.
Easily push Strava to Google BigQuery using the CData SSIS Tasks for Strava and Google BigQuery.
-
Object-Relational Mapping (ORM) with Hugging Face 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 Hugging Face into a Java-based ORM framework, Hibernate.
-
Migrating data from Azure Analysis Services to Google BigQuery using CData SSIS Components.
Easily push Azure Analysis Services to Google BigQuery using the CData SSIS Tasks for Azure Analysis Services and Google BigQuery.