CData Software - Knowledge Base
Recent Articles
-
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.
-
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.
-
Access Live PostgreSQL Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to PostgreSQL from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
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.
-
Build PolarTeamPro-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live PolarTeamPro Data in Claude Code to assist with building PolarTeamPro-powered applications.
-
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.
-
Connect to Oracle Service Cloud Data in Aqua Data Studio
Access Oracle Service Cloud from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Visualize Live Airtable Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Airtable.
-
A PostgreSQL Interface for Oracle Eloqua Reporting Data using the CData ODBC Driver
Use the SQL Gateway and Oracle Eloqua Reporting ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous CouchDB Replication to Vertica
Use CData Sync for automated, continuous, customizable CouchDB replication to Vertica.
-
Build BenchmarkEmail-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live BenchmarkEmail.
-
Connect to Copper in SpagoBI
Create reports featuring live Copper in SpagoBI Studio. Host Copper reports on SpagoBI Server.
-
Excel Spreadsheet Automation on SAP ByDesign Data with the QUERY Formula
Pull data from SAP ByDesign, automate spreadsheets, and more with the QUERY formula.
-
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.
-
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 Nuclia to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Nuclia with IBM WebSphere for seamless data integration and connectivity.
-
Connect to iContact Data in DBArtisan
Use wizards in DBArtisan to configure iContact as a data source.
-
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.
-
Use the CData ODBC Driver for Google Search in Microsoft Power Query
You can use the CData Google Search ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Search into Microsoft Power Query.
-
Visualize HubSpot Data in Sisense
Create an ElastiCube in Sisense app with access to HubSpot.
-
Build Agents in Relevance AI with Access to Live Quickbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Quickbase within intelligent agent workflows.
-
DataBind Controls to Brex Data in C++Builder
DataBind to Brex in C++Builder with standard components and controls.
-
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.
-
Building Dynamic Web Pages with LDAP Objects Using AngularJS
Create single-page applications with live connectivity to LDAP using the CData API Server.
-
Query Float Data in ColdFusion
Write standard ColdFusion data access code to connect to Float.
-
Automated Continuous Dynamics CRM Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Google Cloud SQL.
-
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.
-
Connect to LinkedIn Data in CloverDX (formerly CloverETL)
Transfer LinkedIn using the visual workflow in the CloverDX data integration tool.
-
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.
-
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.
-
Build Okta-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Okta.
-
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.
-
Create Data Visualizations in Cognos BI with SAP HANA Data
Access SAP HANA as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Real-Time Chargebee Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Chargebee in Power Apps.
-
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.
-
Integrating GitHub Copilot CLI with SAP Hybris C4C 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.
-
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.
-
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.
-
Replicate Tanda Data to Multiple Databases
Replicate Tanda to disparate databases with a point-and-click configuration.
-
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.
-
How to connect SharePoint with Harvest Data through external lists
Provide Harvest to SharePoint users as an external list.
-
Import Real-Time Avaza Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Avaza in ColdFusion.
-
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.
-
Connect to Google Campaign Manager 360 Data from a Connection Pool in JBoss
Integrate Google Campaign Manager 360 into Java servlets: Use the Management Console in JBoss to install the Google Campaign Manager 360 JDBC Driver.
-
Automated Continuous Exact Online Replication to Oracle
Use CData Sync for automated, continuous, customizable Exact Online replication to Oracle.
-
Query Campaigner Data in ColdFusion
Write standard ColdFusion data access code to connect to Campaigner.
-
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.
-
How to Access Dynamics CRM Data Using Entity Framework
This article shows how to access Microsoft Dynamics CRM using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Enable the Avalara AvaTax JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Avalara AvaTax.
-
Query Retently Data in ColdFusion
Write standard ColdFusion data access code to connect to Retently.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Shopify
Provide connectivity to Shopify through an SAP BusinessObjects universe.
-
Build SAS xpt-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAS XPORT.
-
Connect to Rootly Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Rootly and work with Rootly in your FileMaker applications.
-
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.
-
Connect to and Visualize Live Demio Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Demio.
-
Connect FreeAgent to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live FreeAgent using the CData Python MCP Server.
-
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.
-
Access Live Instagram Data in Excel 365 Online (Excel for the web)
Connect to Instagram from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Getting Started with the CData Power BI Connector for Snowflake
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Snowflake.
-
Connect to Vimeo Data from PowerBuilder via JDBC
This article demonstrates how to access Vimeo from PowerBuilder using the Vimeo JDBC Driver.
-
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.
-
Automated Continuous Helpscout Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Helpscout replication to Azure SQL Database.
-
Import FHIR Data Using Azure Data Factory
Use CData Connect AI to connect to FHIR Data from Azure Data Factory and import live FHIR.
-
Query Twilio Data as a MySQL Database in Node.js
Execute MySQL queries against Twilio from Node.js.
-
Visualize Pinterest Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pinterest.
-
Connect to Oracle SCM Data in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle SCM in FileMaker Pro to connect to Oracle SCM and work with Oracle SCM in your FileMaker applications.
-
Connect to Deel Data in CloverDX (formerly CloverETL)
Transfer Deel using the visual workflow in the CloverDX data integration tool.
-
DataBind Controls to Google Contacts Data in C++Builder
DataBind to Google Contacts in C++Builder with standard components and controls.
-
Automate Figshare Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Figshare and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Visualize Live SparkPost Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SparkPost.
-
Integrate with Adobe Commerce Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Adobe Commerce to a JSON file on disk.
-
Connect to Codat Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Codat and the SQL Gateway to access Codat from Google Apps Script.
-
Process & Analyze SendPulse Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SendPulse Data.
-
Connect to LinkedIn Ads Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with LinkedIn Ads Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to create Sendwithus federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Sendwithus in MySQL .
-
Establish a Live Connection with Google Analytics Data using Tableau Bridge
The CData ODBC Driver for Google Analytics enables you to integrate live Google Analytics into Tableau Cloud dashboards using the Tableau Bridge.