CData Software - Knowledge Base
Recent Articles
-
Build Microsoft Planner-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft Planner and build Microsoft Planner-connected web apps with Axios.
-
Operational Reporting on Microsoft Teams Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Teams.
-
How to connect to Rootly Data from Spring Boot
Connect to Rootly in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Testmonitor Data in NetBeans
Connect to Testmonitor in NetBeans with the data source configuration wizard.
-
Configure a One-Way Send Port for the CData BizTalk Adapter for Salesforce
Use the CData BizTalk Adapter for Salesforce with a one-way send port to execute updategrams and data manipulation SQL in BizTalk.
-
Connect to Freshservice Data in Jaspersoft Studio
Execute SQL to remote Freshservice in Jaspersoft Studio.
-
Migrating data from Zendesk to Databricks using CData SSIS Components.
Easily push Zendesk to Databricks using the CData SSIS Tasks for Zendesk and Databricks.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Salesforce & Force.com within intelligent workflows.
-
How to connect to ShipStation Data from Spring Boot
Connect to ShipStation in a Spring Boot Application using the CData JDBC Driver for ShipStation
-
Access Live Microsoft Exchange Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Exchange data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Redis Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Redis Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to CapsuleCRM Data in HULFT Integrate
Connect to CapsuleCRM as a JDBC data source in HULFT Integrate
-
Visualize Egnyte Data in TIBCO Spotfire through ADO.NET
Integrate Egnyte into dashboards in TIBCO Spotfire.
-
Use the CData API Server to Access Azure Table Data in Microsoft PowerPivot
Use the CData API Server to connect to live Azure Table Storage in the Power Pivot business intelligence tool.
-
Build Visualizations of LDAP Objects in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of LDAP in Birst.
-
Create CockroachDB-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to CockroachDB Data from OutSystems and build custom enterprise apps using live CockroachDB.
-
Consume Google Calendar OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Calendar feeds that reflect any changes in SAP Lumira.
-
How to connect to Miro Data in DBVisualizer
Integrate Miro with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Datasets from PDFMonkey in Domo Workbench and Build Visualizations of PDFMonkey Data in Domo
Use the CData Software ODBC Driver for PDFMonkey to create datasets from PDFMonkey in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Spotify in SpagoBI
Create reports featuring live Spotify in SpagoBI Studio. Host Spotify reports on SpagoBI Server.
-
Integrating Codex CLI with Tanda 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.
-
Integrate Real-Time Access to Power BI XMLA in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Power BI XMLA in real time.
-
How to connect PolyBase to SharePoint
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft SharePoint.
-
Process & Analyze Printful Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Printful Data.
-
Use Dash to Build to Web Apps on Avaza Data
Create Python applications that use pandas and Dash to build Avaza-connected web apps.
-
Deploy the ADO.NET Provider for XML on an SSRS Report Server
Connect to XML Files 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.
-
Automate NetSuite Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live NetSuite CRM & ERP and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
DataBind Controls to SAP HANA XS Advanced Data in Delphi
DataBind to SAP HANA XS Advanced in Delphi with standard data access components and controls.
-
Create Dashboards and Visualize Live eBay Data in Geckoboard
Use CData Connect AI to connect to live eBay and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Connect DBeaver to Figshare via a JDBC Driver
Manage Figshare with visual tools in DBeaver like the query browser.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live GitLab within intelligent workflows.
-
Connect RSS to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live RSS Feeds using the CData Python MCP Server.
-
How to connect to Testmonitor Data with Squirrel SQL client
Connect to Testmonitor and execute queries in the Squirrel SQL Client.
-
Create Datasets from ZohoMarketingHub in Domo Workbench and Build Visualizations of ZohoMarketingHub Data in Domo
Use the CData Software ODBC Driver for ZohoMarketingHub to create datasets from ZohoMarketingHub in Domo Workbench and then build visualizations in the Domo service.
-
Build Charts with SAP SuccessFactors Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP SuccessFactors in Clear Analytics.
-
Connect to API Data from Crystal Reports
Use CData Connect AI to connect to and report on live API from Crystal Reports.
-
Build Data Flows from Simplesat to SQL Server using SSIS
Easily back up Simplesat to SQL Server using the SSIS components for Simplesat.
-
Natively Connect to Sage Cloud Accounting Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Sage Business Cloud Accounting. Leverage the native support for ODBC in PHP.
-
Integrate with HDFS Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Apache HDFS to a JSON file on disk.
-
Deploy the ADO.NET Provider for AdRoll on an SSRS Report Server
Connect to AdRoll 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.
-
Build Microsoft OneDrive-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Microsoft OneDrive to explore live Microsoft OneDrive Data in Claude Code to assist with building Microsoft OneDrive-powered applications.
-
Connect to Flowlu Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Flowlu as an External Source in Dremio.
-
Replicate SQL Server Data from PowerShell
Write a quick PowerShell script to query Microsoft SQL Server. Use connectivity to the live data to replicate Microsoft SQL Server to SQL Server.
-
Visualize ZohoPeople Data in Tableau
The CData ODBC driver for ZohoPeople enables you integrate ZohoPeople into Tableau dashboards.
-
Build Microsoft Exchange-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Microsoft Exchange Data and create custom apps in Bubble.
-
Visualize Live Sage Cloud Accounting Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Sage Business Cloud Accounting.
-
Connect to Adobe Experience Manager Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Adobe Experience Manager to connect to Adobe Experience Manager and execute queries in PowerBuilder.
-
Working with Webex Data in LINQPad
Execute LINQ queries to Webex in LINQPad.
-
Automated Continuous ADP Replication to SQL Server
Use CData Sync for automated, continuous, customizable ADP replication to SQL Server.
-
DataBind Controls to OData Services in C++Builder
DataBind to OData in C++Builder with standard components and controls.
-
Getting Started with the CData Python Connector for MailerLite
Learn to install and license the CData Python Connector
-
Query Pipeliner CRM Data as a MySQL Database in Node.js
Execute MySQL queries against Pipeliner CRM from Node.js.
-
How to Work with SAS xpt Data in ETL Validator JDBC
Connect to SAS xpt from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate LibreChat with Live YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live YouTube Analytics from within the chat interface.
-
Integrate Productboard with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Productboard with External Services.
-
Create Informatica Mappings From/To a JDBC Data Source for Dotmailer
Create Dotmailer data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Analyze Delighted Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Delighted in Microsoft R Open.
-
Replicate Hubstaff Data from PowerShell
Write a quick PowerShell script to query Hubstaff. Use connectivity to the live data to replicate Hubstaff to SQL Server.
-
Create FreshBooks Dataflows on PowerBI.com
Connect to the CData Power BI Connector for FreshBooks from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect MailerSend to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live MailerSend using the CData Python MCP Server.
-
Create Apps from SAP Business One Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP Business One Data and build apps from live SAP Business One in Qlik Sense Cloud.
-
How to Connect to Live Blackbaud FE NXT Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Blackbaud FE NXT for you.
-
Connect to AdRoll in SpagoBI
Create reports featuring live AdRoll in SpagoBI Studio. Host AdRoll reports on SpagoBI Server.
-
Integrate Live Bugsnag Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Bugsnag to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to connect and process Rootly from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Rootly.
-
Connect to Real-Time Certinia Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Certinia and Dataflow to import and use Certinia in Power Apps.
-
Integrating LlamaIndex with Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Pipedrive in real time.
-
Use the CData Software JDBC Driver for Zoom in MicroStrategy Desktop
Connect to Zoom in MicroStrategy Desktop using the CData Software JDBC Driver for Zoom.
-
Connect to Testmonitor Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Testmonitor.
-
How to connect to Kafka Data with Squirrel SQL client
Connect to Apache Kafka and execute queries in the Squirrel SQL Client.
-
How to Visualize Landbot Data in Python with pandas
Use pandas and other modules to analyze and visualize live Landbot in Python.
-
Build a Singer.io Tap for Procore With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Procore data using
-
Connect to ClickUp Data in JRuby
Create a simple JRuby app with access to live ClickUp.
-
Build Visualizations of SQL Analysis Services Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SQL Analysis Services in Birst.
-
Visualize TaxJar Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to TaxJar.
-
Publish Everhour-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Everhour.
-
Automated Continuous SparkPost Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SparkPost replication to PostgreSQL.
-
Connect to and Visualize Live Insightly Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Insightly.
-
Connect and Query Live Spark Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Apache Spark SQL into Databricks
-
Consume HubDB OData Feeds in SAP Lumira
Use the API Server to create data visualizations on HubDB feeds that reflect any changes in SAP Lumira.
-
Access Live Zoho Projects Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Zoho Projects in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Data Visualizations in Cognos BI with Sentry Data
Access Sentry as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Enable the Cohere JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Cohere.
-
Getting Started with the CData Excel Add-In for Oracle Sales
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Oracle Sales.
-
Query GitLab Data as a MySQL Database in Node.js
Execute MySQL queries against GitLab from Node.js.
-
Use the CData ODBC Driver for Neo4J from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Neo4J to connect to Neo4J from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Neo4J in Excel.
-
Connect to Ontraport from Asprova with CData Software ODBC Driver for Ontraport
This article shows how to connect faster to Ontraport data from Asprova.
-
Use Agno to Talk to Your GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your GitHub for you.
-
Build Apps with Live HCL Domino in Adalo using CData Connect AI
Use CData Connect AI to integrate live HCL Domino into the Adalo platform and build custom mobile and web applications with real-time HCL Domino.
-
Replicate Salesforce Marketing Data in Heroku for Use in Salesforce Connect
Replicate Salesforce Marketing Cloud to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect to Humanity Data in DBVisualizer
Integrate Humanity with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Adobe Experience Manager Data in Jaspersoft Studio
Execute SQL to remote Adobe Experience Manager in Jaspersoft Studio.
-
Getting Started with the CData Power BI Connector for Azure Analysis Services
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Azure Analysis Services.
-
Visualize Reply.io Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Reply.io into TIBCO Spotfire.
-
Build Semantic Layer Views for Acumatica Data in APOS Live Data Gateway
Use the CData Connector for Acumatica in APOS Live Data Gateway to build Semantic Layer Views for Acumatica ERP.
-
Use the CData Software JDBC Driver for Recurly in MicroStrategy Web
Connect to Recurly in MicroStrategy Web using the CData Software JDBC Driver for Recurly.
-
Access Live Google Cloud Storage Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Google Cloud Storage data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Query, Visualize, and Share live Sage Intacct Data in Redash
Use CData Connect AI to connect to live Sage Intacct in Redash for querying, visualizing, and sharing.
-
Oracle Service Cloud Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Oracle Service Cloud through CData Connect AI using different applications and tools.
-
Automated Continuous PayPal Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable PayPal replication to Google Cloud SQL.