CData Software - Knowledge Base
Recent Articles
-
Using the CData Software ODBC Driver for Elasticsearch in PyCharm
Connect to Elasticsearch as an ODBC data source in PyCharm using the CData Software ODBC Driver for Elasticsearch.
-
Access Front Data from MySQL in PHP
Connect to Front through the standard MySQL libraries in PHP.
-
Automate QuickBooks Time Data Replication to SAP HANA
Use CData Sync to customize and automate QuickBooks Time replication to SAP HANA.
-
Automate Neo4J Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Neo4J from PowerShell? This article demonstrates how to utilize the Neo4J Cmdlets for tasks like connecting to Neo4J, automating operations, downloading data, and more.
-
Connect to and Visualize Live Neo4J Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Neo4J.
-
How to import Anaplan Data into Apache Solr
Use the CData Software JDBC Driver for Anaplan in Data Import Handler and create an automated import of Anaplan to Apache Solr Enterprise Search platform.
-
Build Semantic Layer Views for RSS Feeds in APOS Live Data Gateway
Use the CData Connector for RSS in APOS Live Data Gateway to build Semantic Layer Views for RSS Feeds.
-
Extend Google Sheets with Microsoft Entra ID Data
Make calls to Microsoft Entra ID from Google Apps Script via the API Server.
-
Connecting Mastra with Azure Table Data 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 Azure Table Storage, no replication required.
-
Use Azure AI Foundry to Talk to Your Monday.com 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 Monday.com for you.
-
Publish Reports with Bannerbear Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bannerbear.
-
Automated Continuous ZarMoney Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ZarMoney replication to IBM DB2.
-
Rapidly Develop Twilio-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Twilio.
-
Visualize eBay Analytics Data in Tableau
The CData ODBC driver for eBay Analytics enables you integrate eBay Analytics into Tableau dashboards.
-
Use Manus AI to Talk to Your Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Greenhouse.
-
Natively Connect to Google Spanner Data in PHP
The CData ODBC driver for Google Spanner enables you to create PHP applications with connectivity to Google Spanner. Leverage the native support for ODBC in PHP.
-
Building Dynamic Web Pages with Notion Data Using AngularJS
Create single-page applications with live connectivity to Notion using the CData API Server.
-
Configure the CData JDBC Driver for Billsby in a Connection Pool in Tomcat
Connect to Billsby from a connection pool in Tomcat.
-
Build Pipelines with Live SAP BusinessObjects BI Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP BusinessObjects BI from Google Cloud Data Fusion, enabling the integration of live SAP BusinessObjects BI into the building and management of effective data pipelines.
-
Build a Singer.io Tap for ZohoInvoice With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ZohoInvoice data using
-
Query Live Google Ad Manager Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Google Ad Manager directly from the development environment.
-
Connect to Sage Intacct Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Sage Intacct Data and connect to Sage Intacct in Akorbi Digital RunMyProcess.
-
Load Mailjet Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Mailjet to a database.
-
Integrating LangGraph with Sugar CRM Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Sugar CRM within automated workflows.
-
How to connect PolyBase to Mouseflow
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Mouseflow.
-
Migrating data from Lakebase to Databricks using CData SSIS Components.
Easily push Lakebase to Databricks using the CData SSIS Tasks for Lakebase and Databricks.
-
Connect Printify to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Printify using the CData Python MCP Server.
-
Integrating Claude Code CLI with Hive 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.
-
How to Work with Authorize.Net Data in ETL Validator JDBC
Connect to Authorize.Net from ETL Validator jobs using the CData Software JDBC Driver.
-
Create eBay Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time eBay data access from reports, embedded analytics, and more.
-
Connect to Kintone Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Kintone.
-
Integrate Cline with Live Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Trello from within your IDE.
-
Deploy the ADO.NET Provider for Recurly on an SSRS Report Server
Connect to Recurly 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.
-
Use the CData API Server to Access Avaza Data in Microsoft PowerPivot
Use the CData API Server to connect to live Avaza in the Power Pivot business intelligence tool.
-
How to Query Live Okta Data in Claude Desktop
Connect to and query live Okta Data in Claude Desktop using CData MCP Server.
-
Connect to Splunk Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Splunk from Filemaker Pro on Mac.
-
Integrate Discourse Data in Pentaho Data Integration
Build ETL pipelines based on Discourse in the Pentaho Data Integration tool.
-
Build Adobe Commerce-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Adobe Commerce Data and create custom apps in Bubble.
-
Connect to Salesforce Marketing in SpagoBI
Create reports featuring live Salesforce Marketing Cloud in SpagoBI Studio. Host Salesforce Marketing reports on SpagoBI Server.
-
Analyze Certinia Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Certinia from Power Pivot. You will use the Table Import Wizard to load Certinia. You can visually build the import query or use any SQL supported by the driver.
-
Work with Mocean Data in FoxPro
Load Mocean into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Access Live Todoist Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Todoist enables you to integrate Todoist into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData Excel Add-In for Wistia
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Wistia.
-
How to publish and share Mouseflow Data dashboards with Tableau Server
The CData ODBC driver for Mouseflow enables you integrate Mouseflow into Tableau dashboards.
-
Analyze Amazon Marketplace Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Amazon Marketplace in Microsoft R Open.
-
Access Live Office 365 Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft Office 365 from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Migrating data from Act-On to Google BigQuery using CData SSIS Components.
Easily push Act-On to Google BigQuery using the CData SSIS Tasks for Act-On and Google BigQuery.
-
Build Accelo-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Accelo Data in Cursor to assist with building Accelo-powered applications.
-
How to publish and share Zoho CRM Data dashboards with Tableau Server
The CData ODBC driver for Zoho CRM enables you integrate Zoho CRM into Tableau dashboards.
-
Analyze HubDB Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of HubDB and visualize live HubDB in Infragistics Reveal.
-
How to Connect to Live SAP Netweaver Gateway 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 SAP Netweaver Gateway for you.
-
Validate Moosend Data with QuerySurge
Access and validate Moosend in QuerySurge using the CData JDBC Driver.
-
Access Live MailChimp 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 MailChimp through MCP integration.
-
Connect to CircleCI Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to CircleCI and work with CircleCI in your FileMaker applications.
-
Query eBay Data as a SQL Server Database in Node.js
Execute SQL Server queries against eBay from Node.js.
-
A PostgreSQL Interface for Stack Exchange Data using the CData ODBC Driver
Use the SQL Gateway and Stack Exchange ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect and Visualize Live Act-On Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Act-On into the Databricks platform and create visualization dashboards with real-time Act-On.
-
Build Webflow-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Webflow Data in GitHub Copilot to assist with building Webflow-powered applications.
-
Getting Started with the CData ADO.NET Provider for Superchat
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrating Codex CLI with Apache Impala 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.
-
DataBind Greenplum Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Greenplum with the DevExpress Windows Forms and Web controls to provide Pivotal GreenPlum to a chart.
-
Analyze Hive Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Apache Hive and visualize live Apache Hive in Infragistics Reveal.
-
How to Easily Query Browserless Data in OpenOffice Base
Connect to Browserless data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Access Brex Data from MySQL in Amazon QuickSight
Connect to Brex and build visualizations of Brex using a MySQL Connection in Amazon QuickSight.
-
Access CockroachDB 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 CockroachDB.
-
Bridge Excel Online Connectivity with Apache NiFi
Access and process Microsoft Excel Online in Apache NiFi using the CData JDBC Driver.
-
How to Connect JSON Services to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live JSON data in real time using natural language.
-
Migrating data from Quaderno to Google BigQuery using CData SSIS Components.
Easily push Quaderno to Google BigQuery using the CData SSIS Tasks for Quaderno and Google BigQuery.
-
Visualize Workday Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Workday.
-
How to create an RPA flow for Drift Data in UiPath Studio
Use the Drift ODBC Driver to create workflows that access real-time Drift without any coding.
-
Write a Simple Go Application to work with Couchbase Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Couchbase.
-
Getting Started with the CData ADO.NET Provider for Certinia
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Certinia.
-
How to integrate Email with Apache Airflow
Access and process Email in Apache Airflow using the CData JDBC Driver.
-
Connect to eBay Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for eBay in Airbyte.
-
How to Connect to Live Authorize.Net Data 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 Authorize.Net without replication.
-
Design BIRT Reports on Highrise Data
Provide current Highrise CRM to your embedded analytics.
-
How to Access Live Paylocity Data in Visual Studio Code via Cline
Run CData MCP Server for Paylocity on Windows Subsytem for Linux (WSL) and connect to live Paylocity from the Cline extension in Visual Studio Code.
-
Build SurveyMonkey Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SurveyMonkey and build visualizations in Tableau.
-
Integrating Google Campaign Manager 360 Data in Talend Cloud Data Management Platform
Connect Google Campaign Manager 360 Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Google Campaign Manager 360.
-
Create Reports from NetSuite Data in Looker Studio
Use CData Connect AI to gain access to live NetSuite CRM & ERP and create custom reports in Looker Studio.
-
Getting Started with the CData Power BI Connector for Teamgate
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Access Tanda 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 Tanda.
-
Automate FHIR Data Replication to Azure Synapse
Use CData Sync to customize and automate FHIR replication to Azure Synapse.
-
Create a Data Access Object for Oracle HCM Cloud Data using JDBI
A brief overview of creating a SQL Object API for Oracle HCM Cloud in JDBI.
-
Back Up Oracle Service Cloud to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Oracle Service Cloud. In this article, we will employ an SSIS workflow to populate a database with Oracle Service Cloud data.
-
Explore Geographical Relationships in ZohoPeople Data with Power Map
Create data visualizations with ZohoPeople in Power Map.
-
Visualize Live Elasticsearch Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Elasticsearch using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Dashboards with SAP Business One Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP Business One in DBxtra.
-
Connect to and Visualize Live Avalara AvaTax Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Avalara AvaTax.
-
Connect to LaunchDarkly Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for LaunchDarkly and the SQL Gateway to access LaunchDarkly from Google Apps Script.
-
Connect to QuickBooks Time Data in NetBeans
Connect to QuickBooks Time in NetBeans with the data source configuration wizard.
-
Replicate ADP Data in Heroku for Use in Salesforce Connect
Replicate ADP to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Connect to & Open Highrise Data in Microsoft Excel
This article uses the CData ODBC driver for Highrise to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live Microsoft OneDrive Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft OneDrive in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Hacker News Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Hacker News in the Denodo Virtual DataPort Administrator.
-
Create Datasets from Insightly in Domo Workbench and Build Visualizations of Insightly Data in Domo
Use the CData Software ODBC Driver for Insightly to create datasets from Insightly in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Coinbase Data from PowerBuilder via ADO.NET
This article demonstrates how to access Coinbase from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Cloudant Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Cloudant to connect to IBM Cloudant and execute queries in PowerBuilder.
-
Create Dashboards and Visualize Live Salesforce Marketing Data in Geckoboard
Use CData Connect AI to connect to live Salesforce Marketing Cloud and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Visualize SAP Netweaver Gateway Data in TIBCO Spotfire through OData
Integrate SAP Netweaver Gateway into dashboards in TIBCO Spotfire.