Show articles by: Integration Technology | Driver Technology | Recent Articles

CData Software - Knowledge Base

Recent Articles

Connect WordPress to AI Assistants With the CData Python MCP Server

Learn how to give AI assistants like Claude direct access to live WordPress using the CData Python MCP Server.
LDAP Reporting in OBIEE with the LDAP JDBC Driver

Deploy the LDAP JDBC driver on OBIEE to provide real-time reporting across the enterprise.
Bridge SharePoint Excel Services Connectivity with Apache NiFi

Access and process SharePoint Excel Services in Apache NiFi using the CData JDBC Driver.
NetSuite Reporting and Star Schemas in OBIEE

Create a star schema that shows perspectives on NetSuite facts in real time.
Automated Continuous IBM Cloud Object Storage Replication to AlloyDB

Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to AlloyDB.
Create Epicor Kinetic-Connected Business Apps in AppSheet

Connect to Epicor Kinetic via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Epicor Kinetic.
ETL Lakebase in Oracle Data Integrator

This article shows how to transfer Lakebase into a data warehouse using Oracle Data Integrator.
Connect to Clio in JRuby

Create a simple JRuby app with access to live Clio.
Easily Integrate Paylocity in Lazarus Pascal IDE

Learn how to easily integrate live Paylocity in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
Add Zoho Creator to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for Zoho Creator with the Informatica Enterprise Data Catalog to classify and organize data.
How to pipe HDFS to CSV in PowerShell

Use standard PowerShell cmdlets to access HDFS tables.
How to Connect to Live Amazon S3 Data from Sourcegraph Amp (via CData Connect AI)

Integrate Sourcegraph Amp with CData Connect AI to query and manage live Amazon S3 securely in real time.
Analyze MongoDB with Power Pivot

This article walks you through the process of using the CData ODBC Driver for MongoDB from Power Pivot. You will use the Table Import Wizard to load MongoDB. You can visually build the import query or use any SQL supported by the driver.
Connect to Drip in DBeaver

Use the CData ODBC Driver to connect to Drip in DBeaver.
How to connect and process QuickBooks Online from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live QuickBooks Online.
Analyze Square in Looker

Use CData Connect AI to connect to Square from Looker and build custom apps using live Square.
Access Live Dropbox in AWS Lambda (with IntelliJ IDEA)

Connect to live Dropbox in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
Integrating Claude Code with Google Campaign Manager 360 via CData Connect AI

Leverage CData Connect AI to enable Claude Code to securely access and act on Google Campaign Manager 360 within assisted coding and automated development workflows.
Access Live Bullhorn CRM in Excel (Desktop) via Connect AI

Use CData Connect AI to gain access to live Bullhorn CRM from your Excel spreadsheets.
Use JayDeBeApi to access SAP HANA XS Advanced in Python

Use standard Python scripting and the development environment of your choice to access live SAP HANA XS Advanced.
Automated Continuous Adobe Commerce Replication to Microsoft Access

Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Microsoft Access.
Connect to Stripe from a Connection Pool in JBoss

Integrate Stripe into Java servlets: Use the Management Console in JBoss to install the Stripe JDBC Driver.
Create Datasets from SAP HANA in Domo Workbench and Build Visualizations of SAP HANA in Domo

Use the CData Software ODBC Driver for SAP HANA to create datasets from SAP HANA in Domo Workbench and then build visualizations in the Domo service.
How to Build an ETL App for Office 365 in Python with CData

Create ETL applications and real-time data pipelines for Microsoft Office 365 in Python with petl.
Integrate with Live Presto in MuleSoft (via CData Connect AI)

Use CData Connect AI to connect to Presto from the MuleSoft Anypoint Platform to integrate live Presto into custom reports and dashboards.
Build a PostgreSQL Interface for Zoho Projects using the CData JDBC Driver

Use the Remoting features of the Zoho Projects JDBC Driver to create a PostgreSQL entry-point for data access.
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Square

Provide connectivity to Square through an SAP BusinessObjects universe.
How to Build an ETL App for Printful in Python with CData

Create ETL applications and real-time data pipelines for Printful in Python with petl.
Edit and Search HCL Domino External Objects in Salesforce Connect (API Server)

Use the API Server to securely provide OData feeds of HCL Domino to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create HCL Domino objects that you can access from apps and the dashboard.
Access Microsoft Teams from MySQL in PHP

Connect to Microsoft Teams through the standard MySQL libraries in PHP.
Access HBase 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 HBase.
Configure the CData JDBC Driver for Facebook in a Connection Pool in Tomcat

Connect to Facebook from a connection pool in Tomcat.
Use the CData API Server to Access Unbounce in Microsoft PowerPivot

Use the CData API Server to connect to live Unbounce in the Power Pivot business intelligence tool.
Migrating data from Dynamics NAV to Google BigQuery using CData SSIS Components.

Easily push Microsoft Dynamics NAV to Google BigQuery using the CData SSIS Tasks for Dynamics NAV and Google BigQuery.
Connect DB2 to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

Connect to your IBM DB2 using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
Integrate Cursor with Live Zoho CRM Data via CData Connect AI

Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Zoho CRM from within the editor.
Integrate TaxJar in Pentaho Data Integration

Build ETL pipelines based on TaxJar in the Pentaho Data Integration tool.
How to Import Data from SAP ByDesign into Google Sheets

Import SAP Business ByDesign into a Google spreadsheet that is automatically refreshed.
Connect to Dynamics 365 from AWS Glue

Use CData Connect AI to gain access to live Microsoft Dynamics 365 from your AWS Glue jobs.
Design BIRT Reports on Google Sheets

Provide current Google Sheets to your embedded analytics.
Visualize Live ADP in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live ADP.
How to Create Power BI Visual Reports with Real-Time Jira Assets

Use CData Power BI Connectors to visualize Jira Assets in Power BI.
Create Klipfolio Reports on JasperReports Server

Deploy the CData JDBC Driver on JasperReports Server to provide real-time Klipfolio data access from reports, embedded analytics, and more.
Automated Continuous Shippo Replication to OneLake in Microsoft Fabric

Use CData Sync for automated, continuous, customizable Shippo replication to OneLake in Microsoft Fabric.
Design BIRT Reports on Eventbrite

Provide current Eventbrite to your embedded analytics.
Use Azure AI Foundry to Talk to Your Databricks 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 Databricks for you.
Visualize Oracle Eloqua Reporting in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Oracle Eloqua Reporting into TIBCO Spotfire.
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Analytics

Provide connectivity to Google Analytics through an SAP BusinessObjects universe.
Connecting Mastra with SendGrid via CData Connect AI MCP Server

Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across hundreds of enterprise sources no replication required.
Analyze HubSpot in Cognos Analytics

Use CData Connect AI to connect to HubSpot from Cognos Analytics and analyze live HubSpot.
Publish Crystal Reports on Adobe Experience Manager

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Adobe Experience Manager.
How to import Snowflake into Apache Solr

Use the CData Software JDBC Driver for Snowflake in Data Import Handler and create an automated import of Snowflake to Apache Solr Enterprise Search platform.
Migrating data from Facebook to Snowflake using CData SSIS Components.

Easily push Facebook to Snowflake using the CData SSIS Tasks for Facebook and Snowflake.
How to create Visio diagrams from Google Drive

Automatically update Google Drive with the changes you make to Visio master shapes.
How to Connect the Power BI Service to Presto: Complete Guide

Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
How to Query Office 365 in MySQL Workbench

Execute MySQL queries against live Microsoft Office 365 from MySQL Workbench.
Connect to Facebook in RazorSQL

Connect to Facebook from wizards and query Facebook from the GUI in the RazorSQL database management tool.
Visualize GitHub in TIBCO Spotfire through ADO.NET

Integrate GitHub into dashboards in TIBCO Spotfire.
Getting Started with the CData ADO.NET Provider for Monday.com

CData is the data layer that makes AI work in production—live connectivity and replication across hundreds of the most critical enterprise sources, semantic context, and built-in governance. Powering AI for Databricks, Microsoft, Google, Palantir, and 10,000+ customers worldwide.