CData Software - Knowledge Base
Recent Articles
-
Automated Continuous PhantomBuster Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable PhantomBuster data replication to OneLake in Microsoft Fabric.
-
How to connect Amazon QuickSight to Klipfolio Data
Create a connection to Klipfolio data in CData Connect AI and insert Klipfolio data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect xBase to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect xBase with IBM WebSphere for seamless data integration and connectivity.
-
Deploy the ADO.NET Provider for Reckon Accounts Hosted on an SSRS Report Server
Connect to Reckon Accounts Hosted data 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.
-
Visualize Live MongoDB Data in the Power BI Service
Use CData Connect AI to connect to live MongoDB data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate with Sentry Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Sentry data to a JSON file on disk.
-
Connect to Couchbase in SpagoBI
Create reports featuring live Couchbase data in SpagoBI Studio. Host Couchbase reports on SpagoBI Server.
-
Integrate ZohoDesk Data in the Pentaho Report Designer
Publish reports based on ZohoDesk data in the Pentaho BI tool.
-
Build Charts with eBay Analytics Data in Clear Analytics
Create dynamic charts and perform analytics based on eBay Analytics data in Clear Analytics.
-
Build Semantic Layer Views for Google Campaign Manager 360 Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Campaign Manager 360 data.
-
Creating Microsoft Planner-Connected Applications in Unqork
You can use CData Connect AI to feed Microsoft Planner data to Unqork and build custom business apps.
-
Use the CData Software ODBC Driver for Acumatica in SAS for Real-Time Reporting and Analytics
Connect to real-time Acumatica data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Acumatica.
-
Getting Started with the CData Excel Add-In for Google Directory
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Directory.
-
Consume Microsoft Planner OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft Planner data as OData feeds from PowerBuilder using the API Server.
-
Integrate Live Exact Online Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Exact Online data to Blue Prism using the CData ODBC Driver for Exact Online to create automated workflows for repetitive business tasks.
-
Connecting Agentforce with Shippo Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Shippo data for you.
-
Access Live GetResponse Data in AWS Lambda (with IntelliJ IDEA)
Connect to live GetResponse data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Azure Data Catalog Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Azure Data Catalog.
-
Perform Batch Operations with Lakebase Data in Apache NiFi
Connect to Lakebase data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automated Continuous SAP HANA Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP HANA data replication to OneLake in Microsoft Fabric.
-
Access Exa Data from MySQL in Amazon QuickSight
Connect to Exa and build visualizations of Exa data using a MySQL Connection in Amazon QuickSight.
-
Query, Visualize, and Share live JSON Services in Redash
Use CData Connect AI to connect to live JSON services in Redash for querying, visualizing, and sharing.
-
Use the CData ODBC Driver for Amazon S3 in Microsoft Power Query
You can use the CData Amazon S3 ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Amazon S3 data into Microsoft Power Query.
-
Extract, Transform, and Load BigQuery Data in Informatica PowerCenter
Create a simple Workflow for BigQuery data in Informatica PowerCenter.
-
How to Visualize Cvent Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Cvent data in Python.
-
How to Connect to Live Paymo Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Paymo data without replication.
-
How to connect PolyBase to WooCommerce
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live WooCommerce data.
-
Query Google Ad Manager Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Ad Manager data from Node.js.
-
How to integrate Planio with Apache Airflow
Access and process Planio data in Apache Airflow using the CData JDBC Driver.
-
Integrating FTP Data in Talend Cloud Data Management Platform
Connect FTP Data with Talend Cloud Data Management Platform using the CData JDBC Driver for FTP.
-
Integrate LibreChat with Live ZohoMarketingHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live ZohoMarketingHub data from within the chat interface.
-
Operational Reporting on Landbot Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Landbot data.
-
How to connect to ConvertKit Data in DBVisualizer
Integrate ConvertKit data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect Apollo Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Apollo data in real time using natural language.
-
How to Seamlessly Import Printify Data into IBM SPSS Modeler
Integrate Printify data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrating Cursor with EnterpriseDB 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.
-
Connecting Moonlit Workflow with Cosmos DB Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Cosmos DB data in real time.
-
How to Use a Microsoft Access Database to Update EnterpriseDB Data in Real Time
Update EnterpriseDB data by creating a linked table in Microsoft Access with the CData EnterpriseDB ODBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Mailjet Data
Use CData Power BI Connectors to visualize Mailjet data in Power BI.
-
Automated Continuous Odoo Replication to SQLite
Use CData Sync for automated, continuous, customizable Odoo replication to SQLite.
-
Build Semantic Layer Views for Raisers Edge NXT Data in APOS Live Data Gateway
Use the CData Connector for Raisers Edge NXT in APOS Live Data Gateway to build Semantic Layer Views for Raisers Edge NXT data.
-
Rapidly Develop Microsoft OneDrive-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 Microsoft OneDrive.
-
Connect to Oracle Eloqua Reporting Data from a Connection Pool in JBoss
Integrate Oracle Eloqua Reporting data into Java servlets: Use the Management Console in JBoss to install the Oracle Eloqua Reporting JDBC Driver.
-
Build Dashboards with Clari Data in Dundas BI
Create dynamic dashboards and perform analytics based on Clari data in Dundas BI.
-
Automate Sage 300 Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Sage 300 data from PowerShell? This article demonstrates how to utilize the Sage 300 Cmdlets for tasks like connecting to Sage 300 data, automating operations, downloading data, and more.
-
Connect to SparkPost Data in Google Apps Script via Connect AI
Use CData Connect AI to access SparkPost data in Google Apps Script.
-
Use the CData Software ODBC Driver for Suadeo in MicroStrategy Desktop
Connect to Suadeo data in MicroStrategy Desktop using the CData Software ODBC Driver for Suadeo.
-
Create Teamgate Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Teamgate data access from reports, embedded analytics, and more.
-
Use the CData ODBC Driver for ZohoMarketingHub in Microsoft Power Query
You can use the CData ZohoMarketingHub ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ZohoMarketingHub data into Microsoft Power Query.
-
Integrate Live Jira Assets Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Jira Assets data and integrate live Jira Assets data into apps built in Microsoft Power Apps.
-
Getting Started with the CData ODBC Driver for Cassandra
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Cassandra.
-
Use the CData Software JDBC Driver for SQL Analysis Services in MicroStrategy Web
Connect to SQL Analysis Services data in MicroStrategy Web using the CData Software JDBC Driver for SQL Analysis Services.
-
Automated Continuous Egnyte Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Egnyte replication to AlloyDB.
-
Use JayDeBeApi to access ADP Data in Python
Use standard Python scripting and the development environment of your choice to access live ADP data.
-
Create AlloyDB Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time AlloyDB data access from reports, embedded analytics, and more.
-
Automated Continuous HubSpot Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable HubSpot replication to Azure SQL Database.
-
Process & Analyze LeadDesk Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live LeadDesk Data.
-
Seamlessly Bring Google Sheets Data into Retool Using CData Connect AI
Integrate Google Sheets data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Data Flows from Vault CRM to SQL Server using SSIS
Easily back up Vault CRM data to SQL Server using the SSIS components for Vault CRM.
-
Access Live SAP Hybris C4C Data in AWS Lambda
Connect to live SAP Hybris C4C data in AWS Lambda using the CData JDBC Driver.
-
Integrating LangGraph with Dynamics NAV Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Dynamics NAV data within automated workflows.
-
Integrate Live Jira Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Jira data to Blue Prism using the CData ODBC Driver for Jira to create automated workflows for repetitive business tasks.
-
Integrate Live ZohoSubscriptions Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live ZohoSubscriptions data from within the IDE.
-
Build AI/ML Models with Live Shippo Data using Dataiku
Connect Shippo Data with Dataiku using the CData API Driver for JDBC.
-
Connect to Apollo Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Apollo and the SQL Gateway to access Apollo data from Google Apps Script.
-
Query Moosend Data as a MySQL Database in Node.js
Execute MySQL queries against Moosend data from Node.js.
-
Process & Analyze Ontraport Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Ontraport Data.
-
Build Raisers Edge NXT-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Raisers Edge NXT data without replication.
-
Connect to BenchmarkEmail Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for BenchmarkEmail and the SQL Gateway to access BenchmarkEmail data from Google Apps Script.
-
Use ChatGPT to Talk to Your Omnisend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Omnisend data for you.
-
A PostgreSQL Interface for TaxJar Data (MySQL Remoting via JDBC)
Use the Remoting features of the TaxJar JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Zoho Inventory Data in ColdFusion
Write standard ColdFusion data access code to connect to Zoho Inventory data.
-
Query ScrapingBee Data in ColdFusion
Write standard ColdFusion data access code to connect to ScrapingBee data.
-
Create Auth0 Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Auth0 from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ConvertKit
Provide connectivity to ConvertKit data through an SAP BusinessObjects universe.
-
Connect to Quaderno from a Connection Pool in WebLogic
Use the CData JDBC Driver for Quaderno to connect to Quaderno data from Web applications running on WebLogic.
-
Connect to ZohoDesk Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ZohoDesk and the SQL Gateway to access ZohoDesk data from Google Apps Script.
-
Integrate Oracle Service Cloud with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Oracle Service Cloud with External Services.
-
Migrating data from Brex to Google BigQuery using CData SSIS Components.
Easily push Brex data to Google BigQuery using the CData SSIS Tasks for Brex and Google BigQuery.
-
How to create an RPA flow for FTP Data in UiPath Studio
Use the FTP ODBC Driver to create workflows that access real-time FTP data without any coding.
-
Connect to Facebook Ads Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Facebook Ads Data and connect to Facebook Ads data in Akorbi Digital RunMyProcess.
-
Operational Reporting on Snapchat Ads Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Snapchat Ads data.
-
Feed Hive Data into FineReport
How to set Hive data as a JDBC data source in FineReport.
-
Moving Data from Adobe Analytics to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Adobe Analytics data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build a PostgreSQL Interface for Zoom Data using the CData JDBC Driver
Use the Remoting features of the Zoom JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to CSV Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for CSV Data and connect to CSV data in Akorbi Digital RunMyProcess.
-
Replicate HDFS Data from PowerShell
Write a quick PowerShell script to query HDFS data. Use connectivity to the live data to replicate HDFS data to SQL Server.
-
DataBind Adobe Analytics Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Adobe Analytics with the DevExpress Windows Forms and Web controls to provide Adobe Analytics data to a chart.
-
Import Real-Time Grafana Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Grafana data in ColdFusion.
-
DataBind Controls to Couchbase Data in C++Builder
DataBind to Couchbase data in C++Builder with standard components and controls.
-
Getting Started with the CData Excel Add-In for MongoDB
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for MongoDB.
-
Access Couchbase Data from MySQL in PHP
Connect to Couchbase through the standard MySQL libraries in PHP.
-
Create SAP Netweaver Gateway-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SAP Netweaver Gateway Data from Klipfolio and build custom visualizations using live SAP Netweaver Gateway data.
-
Replicate Multiple ZohoSubscriptions Accounts
Replicate multiple ZohoSubscriptions accounts to one or many databases.
-
Build an OLAP Cube in SSAS from Google Campaign Manager 360 Data
Establish a connection to Google Campaign Manager 360 data data from SQL Server Analysis Services, and use the Google Campaign Manager 360 Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Email Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Email data.
-
Integrate Google's Antigravity Agent with Live Shippo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Shippo data using the Model Context Protocol.
-
Using the CData Software ODBC Driver for Brex in PyCharm
Connect to Brex as an ODBC data source in PyCharm using the CData Software ODBC Driver for Brex.
-
How to Connect to Cosmos DB Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Cosmos DB data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Egnyte Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Egnyte data in the Denodo Virtual DataPort Administrator.