CData Software - Knowledge Base
Recent Articles
-
Connect to SAP BusinessObjects BI Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAP BusinessObjects BI and the SQL Gateway to access SAP BusinessObjects BI data from Google Apps Script.
-
Query, Visualize, and Share live SAP Netweaver Gateway Data in Redash
Use CData Connect AI to connect to live SAP Netweaver Gateway data in Redash for querying, visualizing, and sharing.
-
Access FTP Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for FTP data.
-
Integrating Codex with ZarMoney 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.
-
Connect to PagerDuty Data in Jaspersoft Studio
Execute SQL to remote PagerDuty data in Jaspersoft Studio.
-
Connect to Apify Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Apify data.
-
Build Dashboards with Superchat Data in Dundas BI
Create dynamic dashboards and perform analytics based on Superchat data in Dundas BI.
-
Integrate Live GitHub 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 GitHub data from within the IDE.
-
DataBind Google Ad Manager Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Google Ad Manager with the DevExpress Windows Forms and Web controls to provide Google Ad Manager data to a chart.
-
Connect to Figshare Data in Google Apps Script via Connect AI
Use CData Connect AI to access Figshare data in Google Apps Script.
-
Connect to Rebilly Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Rebilly and work with Rebilly data in your FileMaker application.
-
Use the CData Software JDBC Driver for Amazon Marketplace in MicroStrategy Desktop
Connect to Amazon Marketplace data in MicroStrategy Desktop using the CData Software JDBC Driver for Amazon Marketplace.
-
Automated Continuous Mixpanel Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Mixpanel data replication to OneLake in Microsoft Fabric.
-
Access Live LinkedIn 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 LinkedIn data through MCP integration.
-
Publish Crystal Reports on Jumpseller Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Jumpseller data.
-
How to Visualize Access Data in Python with pandas
Use pandas and other modules to analyze and visualize live Access data in Python.
-
Connect to Egnyte from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Egnyte data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Operational Reporting on Kintone Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Kintone data.
-
How to create an RPA flow for Highrise Data in UiPath Studio
Use the Highrise ODBC Driver to create workflows that access real-time Highrise data without any coding.
-
Connect to EnterpriseDB Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live EnterpriseDB data.
-
Getting Started with the CData Excel Add-In for MailChimp
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for MailChimp.
-
Integrate Devin with Live Sybase IQ 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 Sybase IQ data.
-
Integrate WooCommerce with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate WooCommerce with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to WooCommerce data.
-
How to connect and process Front data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Front data.
-
Create OData-Connected Applications in Appsmith
Connect to OData Services via CData Connect AI in Appsmith and create custom business applications with real-time access to OData services.
-
Integrate with GitHub Data in JReport Designer
Create charts and reports based on GitHub data in JReport Designer.
-
Build MVC Applications with Connectivity to JotForm Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access JotForm from an ASP.NET MVC application.
-
Seamlessly Bring HCL Domino Data into Retool Using CData Connect AI
Integrate HCL Domino data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect Quickbase to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Quickbase data using the CData Python MCP Server.
-
Visualize Live EmailOctopus Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live EmailOctopus data.
-
Analyze Live Amazon DynamoDB Data in SAS Viya
Use CData Connect AI to connect to Amazon DynamoDB data from SAS Viya and deploy self-service analytics using live Amazon DynamoDB data.
-
Integrate SAS xpt Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAS xpt data from Informatica Cloud.
-
Model Cosmos DB Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Cosmos DB, enabling the direct import of real-time Cosmos DB data.
-
How to Visualize ZohoDesk Data in Python with pandas
Use pandas and other modules to analyze and visualize live ZohoDesk data in Python.
-
Building Dynamic Web Pages with Dropbox Data Using AngularJS
Create single-page applications with live connectivity to Dropbox using the CData API Server.
-
Access Live Impala Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Impala data through MCP integration.
-
How to create an RPA flow for Missive Data in UiPath Studio
Use the Missive ODBC Driver to create workflows that access real-time Missive data without any coding.
-
How to Connect to Live Testmonitor Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Testmonitor data securely in real time.
-
Visualize Pingdom Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pingdom data.
-
How to work with Zoom Data in Apache Spark using SQL
Access and process Zoom Data in Apache Spark using the CData Software JDBC Driver.
-
Query SharePoint Excel Services Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SharePoint Excel Services entities in PHP by modeling them as objects.
-
How to Access Live Telegram Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Telegram enables you to integrate Telegram data into workflows built using Microsoft Power Automate Desktop.
-
Integrating Dataiku with Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Authorize.Net data.
-
Use Dash to Build to Web Apps on Clari Data
Create Python applications that use pandas and Dash to build Clari-connected web apps.
-
Bridge Certinia Connectivity with Apache NiFi
Access and process Certinia data in Apache NiFi using the CData JDBC Driver.
-
Create Reports with Ontraport Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Ontraport data.
-
A PostgreSQL Interface for Paymo Data using the CData ODBC Driver
Use the SQL Gateway and Paymo ODBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Python Connector for Placid
Learn to install and license the CData Python Connector and configure a connection to live Placid data.
-
How to publish and share Zoho Projects Data dashboards with Tableau Server
The CData ODBC driver for Zoho Projects enables you integrate Zoho Projects data into Tableau dashboards.
-
Bridge PolarTeamPro Connectivity with Apache NiFi
Access and process PolarTeamPro data in Apache NiFi using the CData JDBC Driver.
-
Integrating ShipEngine Data in Talend Cloud Data Management Platform
Connect ShipEngine Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Access Live Salesforce Pardot Data in AWS Lambda
Connect to live Salesforce Pardot data in AWS Lambda using the CData JDBC Driver.
-
Building Dynamic Web Pages with SAP SuccessFactors LMS Data Using AngularJS
Create single-page applications with live connectivity to SAP SuccessFactors LMS using the CData API Server.
-
Connect to Aircall in SpagoBI
Create reports featuring live Aircall data in SpagoBI Studio. Host Aircall reports on SpagoBI Server.
-
Build Apps with Live Google Directory Data Using the Low-Code Development Platform of Mendix
Connect Google Directory data with Mendix to build apps using the CData JDBC Driver for Google Directory.
-
Moving Data from Bitbucket to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Bitbucket data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate Microsoft Exchange Data into Power Automate Desktop using CData Connect
CData Connect for Microsoft Exchange Data enables you to integrate Microsoft Exchange data into workflows built using Microsoft Power Automate Desktop.
-
How to integrate Metabase with eBay Analytics Data
Use CData Connect AI to connect to live eBay Analytics data and create an interactive dashboard in Metabase from eBay Analytics data.
-
How to Seamlessly Import Instantly Data into IBM SPSS Modeler
Integrate Instantly data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to load Trello data into Elasticsearch via Logstash
Introducing a simple method to load Trello data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Oracle Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Oracle replication to IBM DB2.
-
Build Dashboards with SharePoint Excel Services Data in Dundas BI
Create dynamic dashboards and perform analytics based on SharePoint Excel Services data in Dundas BI.
-
Create Datasets from Splunk in Domo Workbench and Build Visualizations of Splunk Data in Domo
Use the CData Software ODBC Driver for Splunk to create datasets from Splunk data in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData Excel Add-In for Slack
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Slack.
-
Getting Started with the CData Connect AI Python SDK for Toggl
Install the CData Connect AI Python SDK to read live Toggl data with standard DB-API 2.0 Python code.
-
Integrate with SAP Fieldglass Data in JReport Designer
Create charts and reports based on SAP Fieldglass data in JReport Designer.
-
Analyze ZendeskSell Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ZendeskSell data with the CData JDBC Driver for ZendeskSell.
-
Integrate Live Gorgias Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Gorgias data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Replicate Optimizely Data to Multiple Databases
Replicate Optimizely data to disparate databases with a point-and-click configuration.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Accelo
Provide connectivity to Accelo data through an SAP BusinessObjects universe.
-
Replicate Timely Data from PowerShell
Write a quick PowerShell script to query Timely data. Use connectivity to the live data to replicate Timely data to SQL Server.
-
Integrating LangGraph with ClickUp Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on ClickUp data within automated workflows.
-
Operational Reporting on CampaignMonitor Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote CampaignMonitor data.
-
Automated Continuous Foursquare Replication to Oracle
Use CData Sync for automated, continuous, customizable Foursquare replication to Oracle.
-
Integrating LangGraph with Guru Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Guru data within automated workflows.
-
Build Marketo Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Marketo data and build visualizations in Tableau Cloud.
-
Connect to Apollo Data from AWS Glue
Use CData Connect AI to gain access to live Apollo data from your AWS Glue jobs.
-
Build Paylocity-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Paylocity Data from Zoho Analytics and import live Paylocity data.
-
Getting Started with the CData ADO.NET Provider for Zoho Projects
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Zoho Projects.
-
Use the CData ODBC Driver for Lakebase from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Lakebase to connect to Lakebase data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Lakebase data in Excel.
-
Replicate Samanage Data in Heroku for Use in Salesforce Connect
Replicate Samanage data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Data Visualizations in Cognos BI with Apollo Data
Access Apollo data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Codex with Unbounce 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.
-
Migrating data from PDFMonkey to Google BigQuery using CData SSIS Components.
Easily push PDFMonkey data to Google BigQuery using the CData SSIS Tasks for PDFMonkey and Google BigQuery.
-
Connect to Sage Intacct in SpagoBI
Create reports featuring live Sage Intacct data in SpagoBI Studio. Host Sage Intacct reports on SpagoBI Server.
-
Excel Spreadsheet Automation on Avaza Data with the QUERY Formula
Pull data from Avaza, automate spreadsheets, and more with the QUERY formula.
-
Build a Simple VCL Application for Xero Data
How to build a simple VCL Application to view Xero data in RAD Studio using the CData ODBC Driver for Xero.
-
Connect to ServiceDesk Plus Data in RazorSQL
Connect to ServiceDesk Plus from wizards and query ServiceDesk Plus data from the GUI in the RazorSQL database management tool.
-
Viewing Jira Assets Data in RAD Studio Data Explorer
How to view Jira Assets data in RAD Studio Data Explorer using the CData ODBC Driver for Jira Assets.
-
Create Power BI Reports on Real-Time Discord Data
Use the CData ODBC Driver for Discord to visualize Discord data in Power BI Desktop.
-
Visualize Live Omnisend Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Omnisend data.
-
A PostgreSQL Interface for REST Data (MySQL Remoting via JDBC)
Use the Remoting features of the REST JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create a Data Access Object for Excel Data using JDBI
A brief overview of creating a SQL Object API for Excel data in JDBI.
-
Using the CData Software ODBC Driver for SAP in PyCharm
Connect to SAP as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP.
-
Automated Continuous Pipedrive Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Pipedrive replication to IBM DB2.
-
Getting Started with the CData SSIS Components for Hubstaff
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Hubstaff.
-
Connect to Spotify Data in Aqua Data Studio
Access Spotify data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Add Google Cloud Storage Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Cloud Storage with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating Gumloop with Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Spark data within automated workflows.
-
Use Dash to Build to Web Apps on AdRoll Data
Create Python applications that use pandas and Dash to build AdRoll-connected web apps.