CData Software - Knowledge Base
Recent Articles
-
Connect to Hubstaff Data in NetBeans
Connect to Hubstaff in NetBeans with the data source configuration wizard.
-
Publish Crystal Reports on Mistral AI Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Mistral AI.
-
Query Testmonitor Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Testmonitor from Node.js.
-
How to create Hive federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Apache Hive in MySQL .
-
How to Access Live Coinbase Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Coinbase enables you to integrate Coinbase into workflows built using Microsoft Power Automate Desktop.
-
Connect to Adobe Analytics Data in ACL Analytics
Connect to Adobe Analytics via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Adobe Analytics.
-
Build SAP SuccessFactors LMS-Connected Apps in Choreo
Use CData Connect AI to connect to SAP SuccessFactors LMS Data from Choreo and build custom apps using live SAP SuccessFactors LMS.
-
Integrate Open WebUI with Live LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live LinkedIn Ads from within the chat interface.
-
Building Dynamic Web Pages with Salesforce Pardot Data Using AngularJS
Create single-page applications with live connectivity to Salesforce Pardot using the CData API Server.
-
Access Live Email Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Email data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Prepare, Blend, and Analyze Dynamics 365 Data in Alteryx Designer (ODBC)
Build workflows to access live Microsoft Dynamics 365 for self-service data analytics.
-
Visualize Webex Data in Sisense
Create an ElastiCube in Sisense app with access to Webex.
-
Build Zoom-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Zoom Data and create custom apps in Bubble.
-
How to Connect to Live MYOB AccountRight Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your MYOB AccountRight for you.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Microsoft Entra ID
Provide connectivity to Microsoft Entra ID through an SAP BusinessObjects universe.
-
Access Google Directory Data from MySQL in Amazon QuickSight
Connect to Google Directory and build visualizations of Google Directory using a MySQL Connection in Amazon QuickSight.
-
DataBind Charts to SharePoint Excel Services Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SharePoint Excel Services 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.
-
How to Query Live Avro Data in Claude Desktop
Connect to and query live Avro Data in Claude Desktop using CData MCP Server.
-
Build Dashboards with ZeroBounce Data in DBxtra
Create dynamic dashboards and perform analytics based on ZeroBounce in DBxtra.
-
Analyze GitHub Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of GitHub and visualize GitHub in SAP Analytics Cloud.
-
Use Biml to Build SSIS Tasks to Replicate ZohoMarketingHub Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ZohoMarketingHub to SQL Server.
-
Integrate NetSuite SuiteAnalytics Data into Power Automate Desktop using CData Connect
CData Connect for NetSuite SuiteAnalytics Data enables you to integrate NetSuite SuiteAnalytics into workflows built using Microsoft Power Automate Desktop.
-
Easily Integrate Zoho CRM Data in Lazarus Pascal IDE
Learn how to easily integrate live Zoho CRM in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Feed PolarTeamPro Data into FineReport
How to set PolarTeamPro as a JDBC data source in FineReport.
-
Connect Outreach.io to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Outreach.io using the CData Python MCP Server.
-
Connect to BigCommerce in SpagoBI
Create reports featuring live BigCommerce in SpagoBI Studio. Host BigCommerce reports on SpagoBI Server.
-
Bidirectional Access to SuiteCRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SuiteCRM in Filemaker Pro for Mac or Windows.
-
Natively Connect to Helpscout Data in PHP
The CData ODBC driver for Helpscout enables you to create PHP applications with connectivity to Helpscout. Leverage the native support for ODBC in PHP.
-
How to import SendPulse Data into Apache Solr
Use the CData Software JDBC Driver for SendPulse in Data Import Handler and create an automated import of SendPulse to Apache Solr Enterprise Search platform.
-
Build Automated Workflows with Live Slack Data in Workato
Use CData Connect AI to connect to live Slack and build automated workflows in Workato.
-
Seamlessly Bring SendGrid Data into Retool Using CData Connect AI
Integrate SendGrid data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to connect to ZohoPeople Data from IntelliJ
Integrate connectivity to ZohoPeople with wizards in IntelliJ.
-
Build Visualizations of RabbitMQ Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of RabbitMQ in Birst.
-
Visualize Google Ad Manager Data in TIBCO Spotfire through OData
Integrate Google Ad Manager into dashboards in TIBCO Spotfire.
-
Build Apps with Live LinkedIn Ads in Adalo using CData Connect AI
Use CData Connect AI to integrate live LinkedIn Ads into the Adalo platform and build custom mobile and web applications with real-time LinkedIn Ads.
-
Automated Continuous Pipedrive Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Pipedrive replication to OneLake in Microsoft Fabric.
-
Connect to Zoho Projects Data in HULFT Integrate
Connect to Zoho Projects as a JDBC data source in HULFT Integrate
-
Easily Integrate LDAP Objects in Lazarus Pascal IDE
Learn how to easily integrate live LDAP in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to ServiceNow Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with ServiceNow Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Choosing the Best Method to Connect Hugging Face to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Hugging Face from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Apps with Live Pivotal GreenPlum in Adalo using CData Connect AI
Use CData Connect AI to integrate live Pivotal GreenPlum into the Adalo platform and build custom mobile and web applications with real-time Pivotal GreenPlum.
-
How to create Miro federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Miro in MySQL .
-
Create SSAS Tabular Models from SAP BusinessObjects BI Data
How to build a SQL Server Analysis Service Tabular Model from SAP BusinessObjects BI using CData drivers.
-
DataBind Charts to BenchmarkEmail Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to BenchmarkEmail 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.
-
Visualize Live Google Calendar Data in the Power BI Service
Use CData Connect AI to connect to live Google Calendar and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Invoiced Data from MySQL in Amazon QuickSight
Connect to Invoiced and build visualizations of Invoiced using a MySQL Connection in Amazon QuickSight.
-
Visualize ZarMoney Data in TIBCO Spotfire through ADO.NET
Integrate ZarMoney into dashboards in TIBCO Spotfire.
-
How to connect and process Accelo from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Accelo.
-
Analyze Live Zoho Creator Data in SAS Viya
Use CData Connect AI to connect to Zoho Creator from SAS Viya and deploy self-service analytics using live Zoho Creator.
-
How to Query Live Avalara AvaTax Data in Claude Desktop
Connect to and query live Avalara AvaTax Data in Claude Desktop using CData MCP Server.
-
Configure the CData JDBC Driver for RabbitMQ in a Connection Pool in Tomcat
Connect to RabbitMQ from a connection pool in Tomcat.
-
Automated Continuous Zoho Creator Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Amazon Redshift.
-
Visualize Hacker News Data in Sisense
Create an ElastiCube in Sisense app with access to Hacker News.
-
Integrating MailerSend Data in Talend Cloud Data Management Platform
Connect MailerSend Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous Shippo Replication to MongoDB
Use CData Sync for automated, continuous, customizable Shippo replication to MongoDB.
-
Import Redshift Data Using Azure Data Factory
Use CData Connect AI to connect to Redshift Data from Azure Data Factory and import live Amazon Redshift.
-
Use the CData ODBC Driver for ConstantContact from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ConstantContact to connect to ConstantContact from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ConstantContact in Excel.
-
Access Landbot Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Landbot from your Oracle system.
-
Access Live Sugar CRM Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sugar CRM from your Excel spreadsheets.
-
Getting Started with the CData SSIS Components for Pipeline CRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Pipeline CRM.
-
Integrate Live Sage 300 Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Sage 300 to Blue Prism using the CData ODBC Driver for Sage 300 to create automated workflows for repetitive business tasks.
-
How to Connect to & Open Intercom Data in Microsoft Excel
This article uses the CData ODBC driver for Intercom to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Oracle Eloqua Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Oracle Eloqua and build visualizations in Tableau.
-
Automated Continuous ShipStation Replication to Oracle
Use CData Sync for automated, continuous, customizable ShipStation replication to Oracle.
-
Connect to Freshteam Data in RapidMiner
Integrate Freshteam with standard components and data source configuration wizards in RapidMiner Studio.
-
Visualize Google Contacts Data in Sisense
Create an ElastiCube in Sisense app with access to Google Contacts.
-
Build Azure DevOps-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Azure DevOps to explore live Azure DevOps Data in Claude Code to assist with building Azure DevOps-powered applications.
-
Integrating LangChain with Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Oracle Database within automated workflows.
-
Integrate Cline with Live EnterpriseDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live EnterpriseDB from within your IDE.
-
Natively Connect to ZeroBounce Data in PHP
The CData ODBC driver for ZeroBounce enables you to create PHP applications with connectivity to ZeroBounce. Leverage the native support for ODBC in PHP.
-
Connect to Planio Data in Aqua Data Studio
Access Planio from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Data Visualizations in Cognos BI with Google Search Results
Access Google Search as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Migrating data from Dynamics NAV to Google BigQuery using CData SSIS Components.
Easily push Microsoft Dynamics NAV to Google BigQuery using the CData SSIS Tasks for Dynamics NAV and Google BigQuery.
-
How to connect and process Authorize.Net from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Authorize.Net.
-
Connect to SAP Ariba Procurement Data in HULFT Integrate
Connect to SAP Ariba Procurement as a JDBC data source in HULFT Integrate
-
Visualize Acumatica Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Acumatica ERP.
-
Automated Continuous Power BI XMLA Replication to MongoDB
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to MongoDB.
-
A PostgreSQL Interface for Klaviyo Data using the CData ODBC Driver
Use the SQL Gateway and Klaviyo ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Snowflake Data in Google Apps Script via Connect AI
Use CData Connect AI to access Snowflake in Google Apps Script.
-
How to Access Live Azure Analysis Services Data in Visual Studio Code via Cline
Run CData MCP Server for Azure Analysis Services on Windows Subsytem for Linux (WSL) and connect to live Azure Analysis Services from the Cline extension in Visual Studio Code.
-
Getting Started with the CData Tableau Connector for PDFMonkey
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Migrating data from DB2 to Snowflake using CData SSIS Components.
Easily push IBM DB2 to Snowflake using the CData SSIS Tasks for DB2 and Snowflake.
-
Create PostgreSQL-Connected Applications in Appsmith
Connect to PostgreSQL Data via CData Connect AI in Appsmith and create custom business applications with real-time access to PostgreSQL.
-
Create Data Visualizations in Cognos BI with Deel Data
Access Deel as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous FreshBooks Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable FreshBooks replication to Amazon Redshift.
-
Integrate with Microsoft Ads Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Microsoft Ads in SnapLogic.
-
Integrate with Marketo Data in JReport Designer
Create charts and reports based on Marketo in JReport Designer.
-
Viewing Raisers Edge NXT Data in RAD Studio Data Explorer
How to view Raisers Edge NXT in RAD Studio Data Explorer using the CData ODBC Driver for Raisers Edge NXT.
-
Use Dash to Build to Web Apps on xBase Data
Create Python applications that use pandas and Dash to build xBase-connected web apps.
-
How to connect to Templated Data from IntelliJ
Integrate connectivity to Templated with wizards in IntelliJ.
-
Integrating Dataiku with Azure Table Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Azure Table Storage.
-
Query BigQuery Data as a MySQL Database in Node.js
Execute MySQL queries against Google BigQuery from Node.js.
-
Connect to Redis Data from HeidiSQL
Use CData Connect AI to connect to and query live Redis from HeidiSQL.
-
Publish CloudConvert-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live CloudConvert.
-
Automated Continuous Hubstaff Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Hubstaff replication to OneLake in Microsoft Fabric.
-
Connect to CockroachDB Data in CloverDX (formerly CloverETL)
Transfer CockroachDB using the visual workflow in the CloverDX data integration tool.
-
Visualize Recurly Data in TIBCO Spotfire through ADO.NET
Integrate Recurly into dashboards in TIBCO Spotfire.
-
Analyze EmailOctopus Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze EmailOctopus in Microsoft R Open.
-
Manage Greenhouse Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Greenhouse.
-
Replicate Acumatica Data to Multiple Databases
Replicate Acumatica ERP to disparate databases with a point-and-click configuration.