CData Software - Knowledge Base
Recent Articles
-
Natively Connect to SAP BusinessObjects BI Data in PHP
The CData ODBC driver for SAP BusinessObjects BI enables you to create PHP applications with connectivity to SAP BusinessObjects BI. Leverage the native support for ODBC in PHP.
-
Integrating Codex CLI with Scrapfly 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.
-
Access Bullhorn CRM Data from MySQL in Amazon QuickSight
Connect to Bullhorn CRM and build visualizations of Bullhorn CRM using a MySQL Connection in Amazon QuickSight.
-
Using the CData Software ODBC Driver for OneNote in PyCharm
Connect to OneNote as an ODBC data source in PyCharm using the CData Software ODBC Driver for OneNote.
-
Build Dashboards with Parquet Data in DBxtra
Create dynamic dashboards and perform analytics based on Apache Parquet in DBxtra.
-
Load Google Analytics Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Analytics to a database.
-
Load Typeform Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Typeform to a database.
-
Connect to LinkedIn from a Connection Pool in WebLogic
Use the CData JDBC Driver for LinkedIn to connect to LinkedIn from Web applications running on WebLogic.
-
How to connect and process Google Cloud Storage from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Cloud Storage.
-
Build AI/ML Models with Live AlloyDB Data using Dataiku
Connect AlloyDB Data with Dataiku using the CData JDBC Driver for AlloyDB.
-
Visualize Placid Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Placid.
-
Use the CData Software JDBC Driver for BigQuery in MicroStrategy Web
Connect to Google BigQuery in MicroStrategy Web using the CData Software JDBC Driver for BigQuery.
-
Integrating LangChain with Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Pivotal GreenPlum within automated workflows.
-
Connect to Microsoft Dataverse Data from HeidiSQL
Use CData Connect AI to connect to and query live Microsoft Dataverse (CDS) from HeidiSQL.
-
How to Access Live JobNimbus Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live JobNimbus from the Cline extension in Visual Studio Code.
-
Bind Live Avaza Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Avaza data
-
Connect to SAP Ariba Source Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP Ariba Source.
-
Back Up Beeminder to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Beeminder data.
-
Create IBM Cloud Object Storage-Connected Dashboards in Grafana
Connect to IBM Cloud Object Storage Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to IBM Cloud Object Storage.
-
Analyze DocuSign Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of DocuSign and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrating OpenCode Terminal with Google Ad Manager 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 MarkLogic from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from MarkLogic, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Zuora-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Zuora to explore live Zuora Data in Claude Code to assist with building Zuora-powered applications.
-
Using the CData Software ODBC Driver for Campaigner in PyCharm
Connect to Campaigner as an ODBC data source in PyCharm using the CData Software ODBC Driver for Campaigner.
-
Integrating LangGraph with Couchbase Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Couchbase within automated workflows.
-
Use the CData Software JDBC Driver for Couchbase in MicroStrategy Web
Connect to Couchbase in MicroStrategy Web using the CData Software JDBC Driver for Couchbase.
-
Analyze LaunchDarkly Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for LaunchDarkly from Power Pivot. You will use the Table Import Wizard to load LaunchDarkly. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Gumloop with Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Elasticsearch within automated workflows.
-
Seamlessly Bring Odoo Data into Retool Using CData Connect AI
Integrate Odoo data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Choosing the Best Method to Connect Yelp to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Yelp from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to FreshBooks Data from HeidiSQL
Use CData Connect AI to connect to and query live FreshBooks from HeidiSQL.
-
Integrate Intercom Data in Pentaho Data Integration
Build ETL pipelines based on Intercom in the Pentaho Data Integration tool.
-
Extend Google Sheets with Vault CRM Data
Make calls to Vault CRM from Google Apps Script via the API Server.
-
Back Up PabblySubscriptions to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with PabblySubscriptions data.
-
Build PayPal-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for PayPal to explore live PayPal Data in GitHub Copilot to assist with building PayPal-powered applications.
-
Access Gumroad Data from MySQL in Amazon QuickSight
Connect to Gumroad and build visualizations of Gumroad using a MySQL Connection in Amazon QuickSight.
-
Connect JobNimbus Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your JobNimbus using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Lakebase within intelligent workflows.
-
Connect to Jira Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Jira Data and connect to Atlassian Jira in Akorbi Digital RunMyProcess.
-
A PostgreSQL Interface for CapsuleCRM Data (MySQL Remoting via JDBC)
Use the Remoting features of the CapsuleCRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Zoom-Connected Dashboards in Grafana
Connect to Zoom Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zoom.
-
Create SSAS Tabular Models from Wrike Data
How to build a SQL Server Analysis Service Tabular Model from Wrike using CData drivers.
-
A PostgreSQL Interface for Bullhorn CRM Data using the CData ODBC Driver
Use the SQL Gateway and Bullhorn CRM ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access TaxJar Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live TaxJar from HeidiSQL.
-
Use the CData API Server to Access Excel Online Data in Microsoft PowerPivot
Use the CData API Server to connect to live Microsoft Excel Online in the Power Pivot business intelligence tool.
-
Analyze OData Services in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of OData and visualize OData in SAP Analytics Cloud.
-
Connect to Jira Data in ACL Analytics
Connect to Atlassian Jira via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Atlassian Jira.
-
Create Datasets from SQL Analysis Services in Domo Workbench and Build Visualizations of SQL Analysis Services Data in Domo
Use the CData Software ODBC Driver for SQL Analysis Services to create datasets from SQL Analysis Services in Domo Workbench and then build visualizations in the Domo service.
-
Build Visualizations of Salesforce Marketing Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Salesforce Marketing Cloud in Birst.
-
Create Reports with Oracle Service Cloud Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle Service Cloud.
-
Visualize Intercom Data in Tableau
The CData ODBC driver for Intercom enables you integrate Intercom into Tableau dashboards.
-
Analyze OneNote Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft OneNote in Microsoft R Open.
-
How to publish and share Certinia Data dashboards with Tableau Server
The CData ODBC driver for Certinia enables you integrate Certinia into Tableau dashboards.
-
How to Connect to Live Zoho Inventory Data 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 Zoho Inventory through natural language.
-
Validate MariaDB Data with QuerySurge
Access and validate MariaDB in QuerySurge using the CData JDBC Driver.
-
Integrate Open WebUI with Live Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Act-On from within the chat interface.
-
Integrating GitHub Copilot CLI with Pivotal GreenPlum 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 Clio Data from a Connection Pool in Jetty
The Clio JDBC Driver supports connection pooling: This article shows how to connect faster to Clio from Web apps in Jetty.
-
Connect to GetResponse Data in Jaspersoft Studio
Execute SQL to remote GetResponse in Jaspersoft Studio.
-
SQL Server Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SQL Server facts in real time.
-
Bidirectional Access to Demio Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Demio in Filemaker Pro for Mac or Windows.
-
Connecting Pipedream with Authorize.Net Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Authorize.Net data in real time.
-
Query ShipStation Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume ShipStation entities in PHP by modeling them as objects.
-
Create Email-Connected Business Apps in AppSheet
Connect to Email Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Email.
-
Build Klipfolio-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Klipfolio Data in GitHub Copilot to assist with building Klipfolio-powered applications.
-
A PostgreSQL Interface for Workable Data using the CData ODBC Driver
Use the SQL Gateway and Workable ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Azure Synapse Replication to SingleStore
Use CData Sync for automated, continuous, customizable Azure Synapse replication to SingleStore.
-
How to Connect to Live MySQL Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your MySQL for you.
-
Work with RSS Feeds in FoxPro
Load RSS Feeds into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate Multiple CSV Accounts
Replicate multiple CSV accounts to one or many databases.
-
Connect to Live Zuora Data in MicroStrategy through CData Connect AI
Create a live connection to Zuora Data in CData Connect AI and connect to your Zuora from MicroStrategy.
-
How to Easily Query Apollo Data in OpenOffice Base
Connect to Apollo data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Migrating data from SAP HANA to Google BigQuery using CData SSIS Components.
Easily push SAP HANA to Google BigQuery using the CData SSIS Tasks for SAP HANA and Google BigQuery.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Basecamp using the Model Context Protocol.
-
Migrating data from NASA to Snowflake using CData SSIS Components.
Easily push NASA to Snowflake using the CData SSIS Tasks for NASA and Snowflake.
-
Visualize Live Apollo Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Apollo using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live Basecamp 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 Basecamp through MCP integration.
-
How to publish and share Sugar CRM Data dashboards with Tableau Server
The CData ODBC driver for Sugar CRM enables you integrate Sugar CRM into Tableau dashboards.
-
Automated Continuous ZendeskSell Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ZendeskSell replication to Apache Kafka.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live IBM Cloud Object Storage within intelligent workflows.
-
Natively Connect to Amazon Marketplace Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Amazon Marketplace. Leverage the native support for ODBC in PHP.
-
Connect to Active Directory Data in DBeaver
Use the CData ODBC Driver to connect to Active Directory in DBeaver.
-
Getting Started with the CData Excel Add-In for QuickBooks Time
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for QuickBooks Time.
-
Integrating Codex CLI with Paddle 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 use SQLAlchemy ORM to access QuickBooks Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of QuickBooks Desktop.
-
Enable the Bannerbear JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Bannerbear.
-
Integrate Flowlu with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Flowlu with External Services.
-
Excel Spreadsheet Automation on Splunk Data with the QUERY Formula
Pull data from Splunk, automate spreadsheets, and more with the QUERY formula.
-
Integrating GitHub Copilot CLI with CircleCI 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.
-
Use the CData Software JDBC Driver for Codat in MicroStrategy Web
Connect to Codat in MicroStrategy Web using the CData Software JDBC Driver for Codat.
-
Build Tally-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Tally ERP and build Tally-connected web apps with Axios.
-
Replicate Autopilot Data from PowerShell
Write a quick PowerShell script to query Autopilot. Use connectivity to the live data to replicate Autopilot to SQL Server.
-
Back Up ZohoInvoice to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with ZohoInvoice data.
-
Replicate Multiple Helpscout Accounts
Replicate multiple Helpscout accounts to one or many databases.
-
How to Work with MongoDB Data in AWS Glue Jobs Using JDBC
Connect to MongoDB from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access ConstantContact Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ConstantContact from your Oracle system.
-
Automated Continuous Pipedrive Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Pipedrive replication to Google Cloud SQL.
-
Connect to and Query Oracle SCM Data in QlikView over ODBC
Create data visualizations with Oracle SCM in QlikView.
-
Automated Continuous Google Calendar Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Calendar replication to Google BigQuery.
-
Integrating OpenCode Terminal with CapsuleCRM 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.