CData Software - Knowledge Base
Recent Articles
-
Connect to Amazon Athena in RapidMiner
Integrate Amazon Athena with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Data Visualizations Based On Azure Table in Mode
Use CData Connect AI to connect to Azure Table from Mode and build visualizations using live
-
Build a Simple VCL Application for GitHub
How to build a simple VCL Application to view GitHub in RAD Studio using the CData ODBC Driver for GitHub.
-
Migrating data from Active Directory to Databricks using CData SSIS Components.
Easily push Active Directory to Databricks using the CData SSIS Tasks for Active Directory and Databricks.
-
Integrate with Google Directory in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Directory in SnapLogic.
-
Design BIRT Reports on Exact Online
Provide current Exact Online to your embedded analytics.
-
Create Elasticsearch-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Elasticsearch from OutSystems and build custom enterprise apps using live Elasticsearch.
-
Automated Continuous QuickBooks Online Replication to SQL Server
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to SQL Server.
-
Load Smartsheet to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Smartsheet to a database.
-
View Reports on Real-Time NetSuite in Power BI Report Server
Use the CData ODBC Driver for NetSuite to visualize NetSuite CRM & ERP in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to EnterpriseDB from Asprova with CData Software ODBC Driver for EnterpriseDB
This article shows how to connect faster to EnterpriseDB data from Asprova.
-
Query Cosmos DB as a SQL Server Database in Node.js
Execute SQL Server queries against Azure Cosmos DB from Node.js.
-
MySQL Reporting in OBIEE with the MySQL JDBC Driver
Deploy the MySQL JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to create an RPA flow for AlloyDB in UiPath Studio
Use the AlloyDB ODBC Driver to create workflows that access real-time Google AlloyDB without any coding.
-
Integrating LangChain with OneNote via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Microsoft OneNote within automated workflows.
-
Feed Amazon Marketplace into FineReport
How to set Amazon Marketplace as a JDBC data source in FineReport.
-
Query MongoDB through ODBC in Node.js
Use node-odbc to execute SQL queries against MongoDB from Node.js.
-
Integrate BigQuery into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google BigQuery and integrate live Google BigQuery into your Power Automate tasks.
-
Use Microsoft Copilot Studio to talk to your NetSuite 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 NetSuite CRM & ERP for you.
-
DataBind Charts to Bullhorn CRM
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Bullhorn CRM from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Access Live Stripe in AWS Lambda (with IntelliJ IDEA)
Connect to live Stripe in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Explore Geographical Relationships in Unbounce with Power Map
Create data visualizations with Unbounce in Power Map.
-
Import and Visualize Dropbox in Power View
Create data visualizations based on Dropbox in Excel.
-
Connect to Salesloft from a Connection Pool in WebLogic
Use the CData JDBC Driver for Salesloft to connect to Salesloft from Web applications running on WebLogic.
-
How to work with Splunk in Apache Spark using SQL
Access and process Splunk in Apache Spark using the CData Software JDBC Driver.
-
Edit and Search Elasticsearch External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Elasticsearch to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Elasticsearch objects that you can access from apps and the dashboard.
-
Access Bitbucket from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Bitbucket from HeidiSQL.
-
How to Connect to Gmail in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Gmail. Leverage the pyodbc module for ODBC in Python.
-
How to integrate SharePoint Excel Services with Apache Airflow
Access and process SharePoint Excel Services in Apache Airflow using the CData JDBC Driver.
-
Use Microsoft Copilot Studio to talk to your Paylocity 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 Paylocity for you.
-
Excel Spreadsheet Automation on Invoiced with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
How to pipe Paylocity to CSV in PowerShell
Use standard PowerShell cmdlets to access Paylocity tables.
-
Connect to Zuora in CloverDX (formerly CloverETL)
Transfer Zuora using the visual workflow in the CloverDX data integration tool.
-
View Reports on Real-Time Cosmos DB in Power BI Report Server
Use the CData ODBC Driver for Cosmos DB to visualize Azure Cosmos DB in Power BI Desktop and then publish them to Power BI Report Server.
-
Consume Zoom OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Zoom feeds that reflect any changes in SAP Lumira.
-
Facebook Ads Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Facebook Ads through CData Connect AI using different applications and tools.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Azure Data Catalog
Provide connectivity to Azure Data Catalog through an SAP BusinessObjects universe.
-
Use the CData ODBC Driver for Adobe Analytics in Microsoft Power Query
You can use the CData Adobe Analytics ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Adobe Analytics into Microsoft Power Query.
-
Connect to Avalara AvaTax from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Avalara AvaTax to connect to Avalara AvaTax and execute queries in PowerBuilder.
-
Query Phoenix as a MySQL Database in Node.js
Execute MySQL queries against Apache Phoenix from Node.js.
-
Natively Connect to Presto in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Presto. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for Xero in MicroStrategy Web
Connect to Xero Accounting in MicroStrategy Web using the CData Software JDBC Driver for Xero.
-
Query, Visualize, and Share live Oracle SCM in Redash
Use CData Connect AI to connect to live Oracle SCM in Redash for querying, visualizing, and sharing.
-
Build ADP-Powered Applications in Cursor with CData Code Assist MCP
-