CData Software - Knowledge Base
Recent Articles
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Microsoft Exchange using the Model Context Protocol.
-
Visualize Live Microsoft OneDrive of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft OneDrive using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to OData Services in Jaspersoft Studio
Execute SQL to remote OData in Jaspersoft Studio.
-
Stream HubSpot into Apache Kafka Topics
Access and stream HubSpot in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Avro Replication to MySQL
Use CData Sync for automated, continuous, customizable Avro replication to MySQL.
-
Import Real-Time Stripe via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Stripe in ColdFusion.
-
Connect to GitHub as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live GitHub.
-
How to Connect to & Open SingleStore in Microsoft Excel
This article uses the CData ODBC driver for SingleStore to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData Software JDBC Driver for Google Calendar in MicroStrategy
Connect to Google Calendar in MicroStrategy Developer using the CData Software JDBC Driver for Google Calendar.
-
Build Visualizations of LinkedIn Ads in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of LinkedIn Ads in Birst.
-
Connect to Azure Table from AWS Glue
Use CData Connect AI to gain access to live Azure Table Storage from your AWS Glue jobs.
-
How to Connect to Live Twitter Ads Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Twitter Ads securely in real time.
-
Create Dynamic Dynamics 365 Business Central Grids Using the Infragistics XamDataGrid
Learn how you can connect Dynamics 365 Business Central to Infragistics XamDataGrid to build dynamic grids.
-
Analyze Google Directory in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google Directory and visualize Google Directory in SAP Analytics Cloud.
-
Create Informatica Mappings From/To an ODBC Data Source for SAS xpt
Create an ODBC connection to SAS xpt in Informatica and browse and transfer SAS XPORT.
-
How to Query Live Shippo Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Shippo data in natural language using Python.
-
A PostgreSQL Interface for ClickUp (MySQL Remoting via JDBC)
Use the Remoting features of the ClickUp JDBC Driver to create a PostgreSQL entry-point for data access.
-
Model, Search, and Visualize Live AlloyDB in ThoughtSpot
Use CData Connect AI to connect to live Google AlloyDB for modeling, searching, and visualizing.
-
How to Work with Workday in AWS Glue Jobs Using JDBC
Connect to Workday from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Cursor with Live Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Stripe from within the editor.
-
Access Live Oracle in Excel 365 Online (Excel for the web)
Connect to Oracle Database from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to MariaDB in DBeaver
Use the CData ODBC Driver to connect to MariaDB in DBeaver.
-
Connect to CouchDB from a Connection Pool in Jetty
The CouchDB JDBC Driver supports connection pooling: This article shows how to connect faster to Apache CouchDB from Web apps in Jetty.
-
Edit and Search Avalara AvaTax External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Avalara AvaTax to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Avalara AvaTax objects that you can access from apps and the dashboard.
-
Create Google Directory-Connected Applications in Appsmith
Connect to Google Directory via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Directory.
-
How to Connect to Live Microsoft Exchange from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Microsoft Exchange through natural language.
-
Query Lakebase in DataGrip
Create a Data Source for Lakebase in DataGrip and use SQL to query live Lakebase.
-
Access Trello as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Trello from your Oracle system.
-
Use the CData Software ODBC Driver for SAP Ariba Source in MicroStrategy Web
Connect to SAP Ariba Source in MicroStrategy Web using the CData Software ODBC Driver for SAP Ariba Source.
-
Replicate Multiple Microsoft Project Accounts via the CData Sync CLI
Replicate multiple Microsoft Project accounts to one or many databases.
-
How to Connect to Live MYOB AccountRight in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live MYOB AccountRight without replication.
-
Using the CData Software ODBC Driver for Zoho Projects in PyCharm
Connect to Zoho Projects as an ODBC data source in PyCharm using the CData Software ODBC Driver for Zoho Projects.
-
Automate Salesforce Replication to Azure Synapse
Use CData Sync to customize and automate Salesforce & Force.com replication to Azure Synapse.
-
Connecting Mastra with SAP HANA 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 300+ enterprise sources no replication required.
-
Getting Started with the CData Excel Add-In for CSV
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for CSV.
-
Viewing Zoho Creator in RAD Studio Data Explorer
How to view Zoho Creator in RAD Studio Data Explorer using the CData ODBC Driver for Zoho Creator.
-
Visualize Live HarperDB of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live HarperDB using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
DataBind Databricks to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Databricks with the DevExpress Windows Forms and Web controls to provide Databricks to a chart.
-
Connect to SAP from a Connection Pool in Jetty
The SAP JDBC Driver supports connection pooling: This article shows how to connect faster to SAP ERP/NetWeaver from Web apps in Jetty.
-
Create BigQuery Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time BigQuery data access from reports, embedded analytics, and more.
-
How to use SQLAlchemy ORM to access Sybase IQ in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sybase IQ.
-
Connect and Visualize Live PayPal Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live PayPal into the Databricks platform and create visualization dashboards with real-time PayPal.
-
Automated Continuous Certinia Replication to Databricks
Use CData Sync for automated, continuous, customizable Certinia replication to Databricks.
-
Operational Reporting on Shopify from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Shopify.
-
Prepare, Blend, and Analyze ServiceNow in Alteryx Designer (Connect AI)
Build workflows to access live ServiceNow for self-service data analytics.
-
Automated Continuous Box Replication to Databricks
Use CData Sync for automated, continuous, customizable Box replication to Databricks.
-
Automated Continuous Slack Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Slack replication to Apache Cassandra.
-
Automated Continuous Oracle SCM Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Oracle SCM replication to Azure SQL Database.
-
How to Connect the Power BI Service to Azure Data Catalog: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Prepare, Blend, and Analyze Databricks in Alteryx Designer (Connect AI)
Build workflows to access live Databricks for self-service data analytics.
-
Publish Azure Active Directory-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Azure Active Directory.
-
Use CData Connect AI to Access SAP ByDesign in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP Business ByDesign in the Power Pivot business intelligence tool.
-
ETL Databricks in Oracle Data Integrator
This article shows how to transfer Databricks into a data warehouse using Oracle Data Integrator.
-
Edit and Search Dropbox External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Dropbox to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Dropbox objects that you can access from apps and the dashboard.
-
Build a Singer.io Tap for Couchbase With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Couchbase data using
-
How to create JotForm federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for JotForm in MySQL .
-
Connect to Google Search Results from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Google Search from Filemaker Pro on Mac.
-
Work with Odoo in FoxPro
Load Odoo ERP into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate with Shopify using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Shopify to a JSON file on disk.
-
Perform Batch Operations with Instagram in Apache NiFi
Connect to Instagram and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Choosing the Best Method to Connect Invoiced to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Invoiced from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Instagram-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Instagram from Klipfolio and build custom visualizations using live Instagram.
-
Connect to Gmail in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
DataBind Controls to Cloudant in C++Builder
DataBind to IBM Cloudant in C++Builder with standard components and controls.
-
Edit and Search eBay Analytics External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of eBay Analytics to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create eBay Analytics objects that you can access from apps and the dashboard.
-
Analyze Harvest with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Harvest from Power Pivot. You will use the Table Import Wizard to load Harvest. You can visually build the import query or use any SQL supported by the driver.
-
Feed Google Ad Manager into FineReport
How to set Google Ad Manager as a JDBC data source in FineReport.
-
Integrate SAS xpt in the Pentaho Report Designer
Publish reports based on SAS XPORT in the Pentaho BI tool.
-
How to Connect Flowise AI Agents to Live PostgreSQL via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
Build Visualizations of Oracle Eloqua in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Oracle Eloqua in Birst.
-
Validate Google Analytics with QuerySurge
Access and validate Google Analytics in QuerySurge using the CData JDBC Driver.
-
Build Voice Agents in ElevenLabs with access to Live MariaDB
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live MariaDB.
-
How to import JDBC-ODBC Bridge into Apache Solr
Use the CData Software JDBC Driver for JDBC-ODBC Bridge in Data Import Handler and create an automated import of JDBC-ODBC Bridge to Apache Solr Enterprise Search platform.
-
Connect to Sage Intacct in RapidMiner
Integrate Sage Intacct with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Certinia-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Certinia and build web apps with connectivity to live Certinia.
-
How to create an RPA flow for Teradata in UiPath Studio
Use the Teradata ODBC Driver to create workflows that access real-time Teradata without any coding.
-
Visualize Gmail in TIBCO Spotfire through OData
Integrate Gmail into dashboards in TIBCO Spotfire.
-
Analyze Google Ads in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google Ads and visualize Google Ads in SAP Analytics Cloud.
-
Integrate with live WooCommerce in Jitterbit
Use CData Connect AI to connect to and integrate live WooCommerce in Jitterbit.
-
Operational Reporting on SharePoint Excel Services from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SharePoint Excel Services.
-
How to Connect to Couchbase in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Couchbase. Leverage the pyodbc module for ODBC in Python.
-
Integrate Real-Time Access to Microsoft OneDrive in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft OneDrive in real time.
-
How to Work with WordPress in AWS Glue Jobs Using JDBC
Connect to WordPress from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to use SQLAlchemy ORM to access ShipStation in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ShipStation.
-
Validate SAP HANA XS Advanced with QuerySurge
Access and validate SAP HANA XS Advanced in QuerySurge using the CData JDBC Driver.
-
Viewing Cassandra in RAD Studio Data Explorer
How to view Apache Cassandra in RAD Studio Data Explorer using the CData ODBC Driver for Cassandra.
-
Build a PostgreSQL Interface for xBase using the CData JDBC Driver
Use the Remoting features of the xBase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Provide OData Services of eBay Analytics from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for eBay Analytics by developing a WCF Service Application.
-
Import and Visualize Microsoft OneDrive in Power View
Create data visualizations based on Microsoft OneDrive in Excel.
-
Connecting Mastra with Google Contacts 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 300+ enterprise sources no replication required.
-
Build ActiveCampaign-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to ActiveCampaign from Zoho Analytics and import live ActiveCampaign.
-
Access Live Google Search Results in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Search from your Excel spreadsheets.
-
Access Live Monday.com in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Monday.com from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Load Google Sheets to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Sheets to a database.
-
Automated Continuous CSV Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable CSV replication to Apache Cassandra.
-
Use Microsoft Copilot Studio to talk to your LinkedIn 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 LinkedIn for you.
-
Box Reporting in OBIEE with the Box JDBC Driver
Deploy the Box JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Excel Spreadsheet Automation on ActiveCampaign with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Build Charts with Adobe Target in Clear Analytics
Create dynamic charts and perform analytics based on Adobe Target in Clear Analytics.
-
Connect to Real-Time Klaviyo Data in Power Apps Using Dataflows to Build Custom Applications
-