CData Software - Knowledge Base
Recent Articles
-
How to Visualize Active Directory Data in Python with pandas
Use pandas and other modules to analyze and visualize live Active Directory data in Python.
-
Query Dynamics 365 Data as a MySQL Database in Node.js
Execute MySQL queries against Dynamics 365 data from Node.js.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Square
Provide connectivity to Square data through an SAP BusinessObjects universe.
-
Build MVC Applications with Connectivity to Sage 300 Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Sage 300 from an ASP.NET MVC application.
-
Integrate SAS xpt Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SAS xpt data and integrate live SAS xpt data into your Power Automate tasks.
-
Use Dash to Build to Web Apps on Azure Table Data
Create Python applications that use pandas and Dash to build Azure Table-connected web apps.
-
Create Email Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Email data access from reports, embedded analytics, and more.
-
Integrating LangChain with Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Facebook Ads data within automated workflows.
-
Integrate with Pushbullet Data in JReport Designer
Create charts and reports based on Pushbullet data in JReport Designer.
-
How to Seamlessly Import ConvertAPI Data into IBM SPSS Modeler
Integrate ConvertAPI data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build a Singer.io Tap for CouchDB With the CData Python Connector
Learn how to easily build a Singer.io Tap for live CouchDB data using the CData Python Connector.
-
Automated Continuous Zoho Books Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Zoho Books replication to Google Cloud SQL.
-
How to Visualize ServiceNow Data in Python with pandas
Use pandas and other modules to analyze and visualize live ServiceNow data in Python.
-
Analyze SuiteCRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SuiteCRM from Power Pivot. You will use the Table Import Wizard to load SuiteCRM data. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData JDBC Driver for Samanage
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Samanage.
-
Integrate Acumatica Data in Pentaho Data Integration
Build ETL pipelines based on Acumatica data in the Pentaho Data Integration tool.
-
Build MVC Applications with Connectivity to Facebook Ads Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Facebook Ads from an ASP.NET MVC application.
-
How to Create Power BI Visual Reports with Real-Time Shippo Data
Use CData Power BI Connectors to visualize Shippo data in Power BI.
-
Automated Continuous Excel Replication to Oracle
Use CData Sync for automated, continuous, customizable Excel replication to Oracle.
-
How to Query OpenWeatherMap Data in MySQL Workbench
Execute MySQL queries against live OpenWeatherMap data from MySQL Workbench.
-
How to Build an ETL App for CapsuleCRM Data in Python with CData Connect AI
Extract and transform live CapsuleCRM data in Python with petl and the CData Connect AI Python SDK.
-
Automated Continuous Browserless Replication to SingleStore
Use CData Sync for automated, continuous, customizable Browserless replication to SingleStore.
-
Integrating Claude Code with Email Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Email data within assisted coding and automated development workflows.
-
Connect to Dynamics NAV Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Dynamics NAV to connect to Dynamics NAV data and execute queries in PowerBuilder.
-
Analyze Live Snowflake Data in SAS Viya
Use CData Connect AI to connect to Snowflake data from SAS Viya and deploy self-service analytics using live Snowflake data.
-
Natively Connect to Oracle Data in PHP
The CData ODBC driver for Oracle enables you to create PHP applications with connectivity to Oracle data. Leverage the native support for ODBC in PHP.
-
A PostgreSQL Interface for Suadeo Data using the CData ODBC Driver
Use the SQL Gateway and Suadeo ODBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Multiple Dynamics NAV Accounts
Replicate multiple Dynamics NAV accounts to one or many databases.
-
How to connect and process Azure Data Lake Storage data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Azure Data Lake Storage data.
-
Automated Continuous Amazon Athena Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Amazon Athena replication to delimited files (CSV/TSV).
-
Connect to Apollo from Asprova with CData Software ODBC Driver for Apollo
This article shows how to connect faster to Apollo data from Asprova.
-
Easily Integrate Perigon Data in Lazarus Pascal IDE
Learn how to easily integrate live Perigon data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Work with Live RSS Feeds in Power Query
Use CData Connect AI to connect to RSS feeds and work with live RSS feeds in Microsoft Power Query.
-
Integrate Devin with Live Avalara AvaTax Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Avalara AvaTax data.
-
Getting Started with the CData Excel Add-In for OpenWeatherMap
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for OpenWeatherMap.
-
Integrating Boomi Agentstudio with Dropbox Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Dropbox data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use the CData Software JDBC Driver for Azure Synapse in MicroStrategy
Connect to Azure Synapse data in MicroStrategy Developer using the CData Software JDBC Driver for Azure Synapse.
-
Integrate with Missive Data in JReport Designer
Create charts and reports based on Missive data in JReport Designer.
-
Build SAP Business One-Connected Apps in Choreo
Use CData Connect AI to connect to SAP Business One Data from Choreo and build custom apps using live SAP Business One data.
-
How to Connect to & Open Bullhorn CRM Data in Microsoft Excel
This article uses the CData ODBC driver for Bullhorn CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Create Power BI Visual Reports with Real-Time Opsgenie Data
Use CData Power BI Connectors to visualize Opsgenie data in Power BI.
-
How to Connect DBeaver to Jira via a JDBC Driver
Manage Jira data with visual tools in DBeaver like the query browser.
-
Validate ZohoSubscriptions Data with QuerySurge
Access and validate ZohoSubscriptions data in QuerySurge using the CData JDBC Driver.
-
Create SQL Server Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SQL Server data access from reports, embedded analytics, and more.
-
Build a Singer.io Tap for Marketo With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Marketo data using the CData Python Connector.
-
Access xBase Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access xBase data from your Oracle system.
-
Bridge CapsuleCRM Connectivity with Apache NiFi
Access and process CapsuleCRM data in Apache NiFi using the CData JDBC Driver.
-
Create Power BI Reports on Real-Time Google Spanner Data
Use the CData ODBC Driver for Google Spanner to visualize Google Spanner data in Power BI Desktop.
-
Getting Started with the CData Tableau Connector for Avalara AvaTax
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Avalara AvaTax.
-
Connect to HubDB Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for HubDB to connect to HubDB data and execute queries in PowerBuilder.
-
Bridge WordPress Connectivity with Apache NiFi
Access and process WordPress data in Apache NiFi using the CData JDBC Driver.
-
Moving Data from MariaDB to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live MariaDB data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Enable the Zoho Creator JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Zoho Creator data.
-
Query Live Apify Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Apify data through a conversational interface.
-
How to Connect to Live Raisers Edge NXT Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Raisers Edge NXT data for you.
-
Integrating Claude Code CLI with Azure Analysis Services 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 connect PolyBase to Excel
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Excel data.
-
Automated Continuous Aweber Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Aweber replication to PostgreSQL.
-
Use JayDeBeApi to access Sendwithus Data in Python
Use standard Python scripting and the development environment of your choice to access live Sendwithus data.
-
Integrating Antigravity CLI with Microsoft Ads data via CData CLI
Connect Microsoft Ads data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automate Teamgate Data Replication to Azure Data Lake
Use CData Sync to customize and automate Teamgate data replication to Azure Data Lake.
-
Import Real-Time Google Cloud Storage Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Cloud Storage data in ColdFusion.
-
Rapidly Develop SageHR-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 SageHR.
-
Automated Continuous Dynamics 365 Replication to Oracle
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Oracle.
-
Connect and Visualize Live AgileCRM Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live AgileCRM data into the Databricks platform and create visualization dashboards with real-time AgileCRM data.
-
Integrating Gumloop with Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Blackbaud FE NXT data within automated workflows.
-
Replicate Multiple HubDB Accounts via the CData Sync CLI
Replicate multiple HubDB accounts to one or many databases.
-
How to connect SharePoint with Cvent Data through external lists
Provide Cvent data to SharePoint users as an external list.
-
Connect to Demio Data in Jaspersoft Studio
Execute SQL to remote Demio data in Jaspersoft Studio.
-
Visualize Live CouchDB Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live CouchDB data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Dash to Build Web Apps on Adobe Experience Manager Data via CData Connect AI
Build interactive Dash web apps on live Adobe Experience Manager data using pandas and the CData Connect AI Python SDK.
-
Integrate Real-Time Access to QuickBooks Online in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to QuickBooks Online data in real time.
-
Connect and Visualize Live MarkLogic Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live MarkLogic data into the Databricks platform and create visualization dashboards with real-time MarkLogic data.
-
Model Cloudflare Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Cloudflare, enabling the direct import of real-time Cloudflare data.
-
How to connect to HCL Domino Data from Spring Boot
Connect to HCL Domino in a Spring Boot Application using the CData JDBC Driver for HCL Domino
-
Interact with Live SharePoint Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SharePoint data.
-
Connect to Google Directory Data in RapidMiner
Integrate Google Directory data with standard components and data source configuration wizards in RapidMiner Studio.
-
A PostgreSQL Interface for CloudConvert Data using the CData ODBC Driver
Use the SQL Gateway and CloudConvert ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Pipelines with Live Couchbase Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Couchbase from Google Cloud Data Fusion, enabling the integration of live Couchbase data into the building and management of effective data pipelines.
-
Create Dynamic Tally Grids Using the Infragistics XamDataGrid
Learn how you can connect Tally to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Google Analytics Data in Jaspersoft Studio
Execute SQL to remote Google Analytics data in Jaspersoft Studio.
-
Visualize Azure DevOps Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Azure DevOps data.
-
Replicate Multiple Bitly Accounts
Replicate multiple Bitly accounts to one or many databases.
-
Publish Reports with Copper Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Copper data.
-
Connect to Certinia Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Certinia as an External Source in Dremio.
-
Integrate Templated with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Templated with External Services.
-
Getting Started with the CData Power BI Connector for SuiteCRM
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SuiteCRM.
-
Use Microsoft Copilot Studio to talk to your Bright Data Data 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 Bright Data data for you.
-
Connect to SurveyMonkey Data from HeidiSQL
Use CData Connect AI to connect to and query live SurveyMonkey data from HeidiSQL.
-
DataBind Controls to Scrapfly Data in Delphi
DataBind to Scrapfly data in Delphi with standard data access components and controls.
-
Automated Continuous Oracle HCM Cloud Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to IBM DB2.
-
Connect to Discourse Data in RazorSQL
Connect to Discourse from wizards and query Discourse data from the GUI in the RazorSQL database management tool.
-
Access Live Epicor Kinetic Data in TIBCO Data Virtualization
Use the Epicor Kinetic Tibco DV Adapter to create a Epicor Kinetic data data source in TIBCO Data Virtualization Studio and gain access to live Epicor Kinetic data from your TDV Server.
-
Connect to ElevenLabs Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ElevenLabs data using standard SQL.
-
Getting Started with the CData JDBC Driver for Confluence
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Confluence.
-
Connect to Dynamics CRM Data from HeidiSQL
Use CData Connect AI to connect to and query live Dynamics CRM data from HeidiSQL.
-
Configure the CData JDBC Driver for Dynamics NAV in a Connection Pool in Tomcat
Connect to Dynamics NAV data from a connection pool in Tomcat.
-
Connect to Klipfolio Data from Crystal Reports
Use CData Connect AI to connect to and report on live Klipfolio data from Crystal Reports.
-
Access Live Tally 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 Tally data through MCP integration.
-
Enable the AfterShip JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with AfterShip data.