CData Software - Knowledge Base
Recent Articles
-
Import MySQL Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to MySQL Data and provide access to live MySQL for custom reports in the Power BI Service.
-
Bidirectional Access to Sendwithus Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Sendwithus in Filemaker Pro for Mac or Windows.
-
Automate Airtable Data Replication to Azure Data Lake
Use CData Sync to customize and automate Airtable replication to Azure Data Lake.
-
How to connect SharePoint with Acumatica Data through external lists
Provide Acumatica ERP to SharePoint users as an external list.
-
Visualize Live SAP Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP ERP/NetWeaver using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Dashboards with SendGrid Data in DBxtra
Create dynamic dashboards and perform analytics based on SendGrid in DBxtra.
-
Access Live SAP Ariba Source Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP Ariba Source from your Excel spreadsheets.
-
Consume Smartsheet OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Smartsheet feeds that reflect any changes in SAP Lumira.
-
Moving Data from Deel to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Deel data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use the CData ODBC Driver for SAP SuccessFactors LMS in Microsoft Power Query
You can use the CData SAP SuccessFactors LMS ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP SuccessFactors LMS into Microsoft Power Query.
-
Build Automated Workflows with Live AlloyDB Data in Workato
Use CData Connect AI to connect to live Google AlloyDB and build automated workflows in Workato.
-
Query Quickbase Data as a MySQL Database in Node.js
Execute MySQL queries against Quickbase from Node.js.
-
Integrate ZeroBounce with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ZeroBounce with External Services.
-
Connect to Odoo Data from a Connection Pool in Jetty
The Odoo JDBC Driver supports connection pooling: This article shows how to connect faster to Odoo ERP from Web apps in Jetty.
-
Bridge MariaDB Connectivity with Apache NiFi
Access and process MariaDB in Apache NiFi using the CData JDBC Driver.
-
Use JayDeBeApi to access Beeminder Data in Python
Use standard Python scripting and the development environment of your choice to access live Beeminder.
-
Build a PostgreSQL Interface for Wave Financial Data using the CData JDBC Driver
Use the Remoting features of the Wave Financial JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Cursor CLI with PostgreSQL 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 Real-Time SAP BusinessObjects BI Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SAP BusinessObjects BI and Dataflow to import and use SAP BusinessObjects BI in Power Apps.
-
Automated Continuous Grafana Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Grafana replication to PostgreSQL.
-
Build an OLAP Cube in SSAS from Mode Data
Establish a connection to Mode data from SQL Server Analysis Services, and use the Mode Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Adobe Analytics Data into Power Automate Desktop using CData Connect
CData Connect for Adobe Analytics Data enables you to integrate Adobe Analytics into workflows built using Microsoft Power Automate Desktop.
-
Create Datasets from Autopilot in Domo Workbench and Build Visualizations of Autopilot Data in Domo
Use the CData Software ODBC Driver for Autopilot to create datasets from Autopilot in Domo Workbench and then build visualizations in the Domo service.
-
Add CSV Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for CSV with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build an OLAP Cube in SSAS from DB2 Data
Establish a connection to IBM DB2 data from SQL Server Analysis Services, and use the DB2 Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Quickbase-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Quickbase Data from OutSystems and build custom enterprise apps using live Quickbase.
-
Connect Mistral AI Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Mistral AI using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Jira Data from a Connection Pool in JBoss
Integrate Atlassian Jira into Java servlets: Use the Management Console in JBoss to install the Jira JDBC Driver.
-
ETL Oracle Eloqua Reporting in Oracle Data Integrator
This article shows how to transfer Oracle Eloqua Reporting into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Drip Replication to Snowflake
Use CData Sync for automated, continuous, customizable Drip replication to Snowflake.
-
Connect to MariaDB Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for MariaDB and the SQL Gateway to access MariaDB from Google Apps Script.
-
Access Live Oracle Sales Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Oracle Sales through MCP integration.
-
Connect to LinkedIn Ads from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from LinkedIn Ads, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Replicate Azure Data Catalog Data in Heroku for Use in Salesforce Connect
Replicate Azure Data Catalog to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Access Live Reckon Accounts Hosted Data in Visual Studio Code via Cline
Run CData MCP Server for Reckon Accounts Hosted on Windows Subsytem for Linux (WSL) and connect to live Reckon Accounts Hosted from the Cline extension in Visual Studio Code.
-
Use the CData Software JDBC Driver for NetSuite in MicroStrategy
Connect to NetSuite CRM & ERP in MicroStrategy Developer using the CData Software JDBC Driver for NetSuite.
-
Connect to PingOne Data from a Connection Pool in JBoss
Integrate PingOne into Java servlets: Use the Management Console in JBoss to install the PingOne JDBC Driver.
-
Create SSAS Tabular Models from Freshsales Data
How to build a SQL Server Analysis Service Tabular Model from Freshsales using CData drivers.
-
Access Live Insightly Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Insightly in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Lakebase-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Lakebase Data from Klipfolio and build custom visualizations using live Lakebase.
-
Integrate with live Neo4J Data in Jitterbit
Use CData Connect AI to connect to and integrate live Neo4J in Jitterbit.
-
Connect Billsby to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Billsby with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect to Live Salesforce Marketing Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Salesforce Marketing Cloud securely in real time.
-
Use Azure AI Foundry to Talk to Your Google Cloud Storage 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 Google Cloud Storage for you.
-
Integrate Open WebUI with Live eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live eBay from within the chat interface.
-
Query Authorize.Net Data as a SQL Server Database in Node.js
Execute SQL Server queries against Authorize.Net from Node.js.
-
How to Visualize Bannerbear Data in Python with pandas
Use pandas and other modules to analyze and visualize live Bannerbear in Python.
-
Use the CData Software ODBC Driver for Timely in MicroStrategy
Connect to Timely in MicroStrategy Developer using the CData Software ODBC Driver for Timely.
-
Automated Continuous Gorgias Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Gorgias replication to Google Cloud SQL.
-
Access Google Drive 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 Google Drive.
-
Connect to Pinterest Data in JRuby
Create a simple JRuby app with access to live Pinterest.
-
Connect to SQL Analysis Services Data in Ruby
Connect to SQL Analysis Services in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Consume Dropbox OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Dropbox feeds that reflect any changes in SAP Lumira.
-
Access Live IBM Informix Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live IBM Informix through MCP integration.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Adobe Experience Manager
Provide connectivity to Adobe Experience Manager through an SAP BusinessObjects universe.
-
Getting Started with the CData Excel Add-In for Azure DevOps
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Azure DevOps.
-
A PostgreSQL Interface for Dynamics 365 Data using the CData ODBC Driver
Use the SQL Gateway and Dynamics 365 ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to Oracle Eloqua Data from IntelliJ
Integrate connectivity to Oracle Eloqua with wizards in IntelliJ.
-
How to Query Live Presto Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Presto data in natural language using Python.
-
Integrating Claude Code CLI with Oracle Financials Cloud 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.
-
Visualize Accelo Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Accelo.
-
Access Access Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Access from HeidiSQL.
-
Viewing Coda Data in RAD Studio Data Explorer
How to view Coda in RAD Studio Data Explorer using the CData ODBC Driver for Coda.
-
Integrating Cursor CLI with Oracle Financials Cloud 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.
-
Replicate Data from Multiple Files in an Amazon S3 Bucket Using CData Sync
Use CData Sync to replicate multiple files from an Amazon S3 bucket to a data warehouse
-
Integrating Cursor CLI with Moosend 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.
-
Deploy the ADO.NET Provider for Xero on an SSRS Report Server
Connect to Xero Accounting 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.
-
Connect SAP Netweaver Gateway to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP Netweaver Gateway with IBM WebSphere for seamless data integration and connectivity.
-
Create Google Ads-Connected Business Apps in AppSheet
Connect to Google Ads Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Google Ads.
-
Automated Continuous ZohoDesk Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ZohoDesk replication to Google BigQuery.
-
Access Live Access Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Access data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Object-Relational Mapping (ORM) with Asana 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 Asana into a Java-based ORM framework, Hibernate.
-
Bridge Avalara AvaTax Connectivity with Apache NiFi
Access and process Avalara AvaTax in Apache NiFi using the CData JDBC Driver.
-
Model, Search, and Visualize Live Zoho CRM Data in ThoughtSpot
Use CData Connect AI to connect to live Zoho CRM for modeling, searching, and visualizing.
-
Automated Continuous Spark Replication to SingleStore
Use CData Sync for automated, continuous, customizable Spark replication to SingleStore.
-
Migrating data from Azure DevOps to Google BigQuery using CData SSIS Components.
Easily push Azure DevOps to Google BigQuery using the CData SSIS Tasks for Azure DevOps and Google BigQuery.
-
How to create Dotmailer federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Dotmailer in MySQL .
-
How to connect and process Highrise CRM from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Highrise CRM.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Marketo using the Model Context Protocol.
-
Getting Started with the CData SSIS Components for Authorize.Net
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Authorize.Net.
-
Automated Continuous Google Cloud Storage Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to MongoDB.
-
Integrate Jumpseller with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Jumpseller with External Services.
-
Connect to Gumroad Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Gumroad as an External Source in Dremio.
-
Automated Continuous SuiteCRM Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SuiteCRM replication to AlloyDB.
-
Replicate Multiple Shopify Accounts
Replicate multiple Shopify accounts to one or many databases.
-
Query Outreach.io Data in ColdFusion
Write standard ColdFusion data access code to connect to Outreach.io.
-
Automated Continuous Salesforce Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Salesforce replication to delimited files (CSV/TSV).
-
Model Dynamics 365 Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Dynamics 365, enabling the direct import of real-time Microsoft Dynamics 365.
-
Publish Crystal Reports on Exact Online Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Exact Online.
-
Automate Harvest Data Replication to Azure Data Lake
Use CData Sync to customize and automate Harvest replication to Azure Data Lake.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SurveyMonkey using the Model Context Protocol.
-
Access Live Authorize.Net Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Authorize.Net from your Google Sheets.
-
Build Dashboards with HBase Data in DBxtra
Create dynamic dashboards and perform analytics based on Apache HBase in DBxtra.
-
How to import ServiceDesk Plus Data into Apache Solr
Use the CData Software JDBC Driver for ServiceDesk Plus in Data Import Handler and create an automated import of ServiceDesk Plus to Apache Solr Enterprise Search platform.
-
Automated Continuous Vault CRM Replication to MongoDB
Use CData Sync for automated, continuous, customizable Vault CRM replication to MongoDB.
-
Integrating Gumloop with Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Pivotal GreenPlum within automated workflows.
-
How to Query Odoo Data in MySQL Workbench
Execute MySQL queries against live Odoo ERP from MySQL Workbench.
-
How to import SendInBlue Data into Apache Solr
Use the CData Software JDBC Driver for SendInBlue in Data Import Handler and create an automated import of SendInBlue to Apache Solr Enterprise Search platform.
-
Getting Started with the CData Tableau Connector for Rebilly
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrating Cursor CLI with Teamgate 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.