CData Software - Knowledge Base
Recent Articles
-
Publish Crystal Reports on FTP Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date FTP Servers.
-
Connect to JDBC-ODBC Bridge Data in Aqua Data Studio
Access JDBC-ODBC Bridge from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Import Data from DocuSign into Google Sheets
Import DocuSign into a Google spreadsheet that is automatically refreshed.
-
How to Build an ETL App for QuickBooks Data in Python with CData
Create ETL applications and real-time data pipelines for QuickBooks Desktop in Python with petl.
-
Automate RSS Integration Tasks from PowerShell
Are you in search of a quick and easy way to access RSS Feeds from PowerShell? This article demonstrates how to utilize the RSS Cmdlets for tasks like connecting to RSS Feeds, automating operations, downloading data, and more.
-
Connect to Google Cloud Storage Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Cloud Storage Data and connect to Google Cloud Storage in Akorbi Digital RunMyProcess.
-
Connect to TaxJar Data from PowerBuilder via ADO.NET
This article demonstrates how to access TaxJar from Appeon PowerBuilder using the CData ADO.NET Provider for TaxJar.
-
Connecting Agentforce with ServiceNow 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 ServiceNow for you.
-
Analyze Reckon Accounts Hosted Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Reckon Accounts Hosted in Microsoft R Open.
-
Build Act-On-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Act-On Data and create custom apps in Bubble.
-
Automated Continuous Toggl Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Toggl replication to OneLake in Microsoft Fabric.
-
Replicate Multiple Printify Accounts
Replicate multiple Printify accounts to one or many databases.
-
How to Connect Flowise AI Agents to Live Blackbaud FE NXT Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Blackbaud FE NXT without replication.
-
Integrating Codex CLI with Bright 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.
-
Query, Visualize, and Share live OneNote Data in Redash
Use CData Connect AI to connect to live Microsoft OneNote in Redash for querying, visualizing, and sharing.
-
Visualize Discourse 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 Discourse into TIBCO Spotfire.
-
Access SAP SuccessFactors LMS Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP SuccessFactors LMS from HeidiSQL.
-
Integrating Codex CLI with Yelp 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.
-
Use Databricks Agent Bricks to Talk to Your CockroachDB Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your CockroachDB for you.
-
Replicate Facebook Data from PowerShell
Write a quick PowerShell script to query Facebook. Use connectivity to the live data to replicate Facebook to SQL Server.
-
Integrate Live Eventbrite Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Eventbrite to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automated Continuous Slack Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Slack replication to IBM DB2.
-
Automated Continuous Perplexity Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Perplexity replication to Google BigQuery.
-
Contentful Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Contentful facts in real time.
-
Build MVC Applications with Connectivity to Mouseflow Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Mouseflow from an ASP.NET MVC application.
-
Connect ClickUp to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ClickUp with IBM WebSphere for seamless data integration and connectivity.
-
Publish GitHub-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live GitHub.
-
Seamlessly Bring WordPress Data into Retool Using CData Connect AI
Integrate WordPress data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Connect to Live Google Analytics Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Google Analytics for you.
-
How to Visualize Supabase Data in Python with pandas
Use pandas and other modules to analyze and visualize live Supabase in Python.
-
Connect to Vercel from a Connection Pool in WebLogic
Use the CData JDBC Driver for Vercel to connect to Vercel from Web applications running on WebLogic.
-
Integrate with Live Sugar CRM Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Sugar CRM from the MuleSoft Anypoint Platform to integrate live Sugar CRM into custom reports and dashboards.
-
How to Connect to Live Oracle Financials Cloud Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Oracle Financials Cloud through natural language.
-
Integrating Codex CLI with SAP Fieldglass 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.
-
Create SSAS Tabular Models from GitLab Data
How to build a SQL Server Analysis Service Tabular Model from GitLab using CData drivers.
-
Integrating Excel Data in Talend Cloud Data Management Platform
Connect Excel Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Microsoft Excel.
-
Connect to SAP Hybris C4C Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Connect DBeaver to Zoho Projects via a JDBC Driver
Manage Zoho Projects with visual tools in DBeaver like the query browser.
-
Use CData Connect AI to Access Oracle HCM Cloud Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Oracle HCM Cloud in the Power Pivot business intelligence tool.
-
Access Amazon Athena Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Amazon Athena from HeidiSQL.
-
Build Apps with Live Simplesat Data Using the Low-Code Development Platform of Mendix
Connect Simplesat with Mendix to build apps using the CData API Driver for JDBC.
-
Stream Calendly Data into Apache Kafka Topics
Access and stream Calendly in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Work with Humanity Data in ETL Validator JDBC
Connect to Humanity from ETL Validator jobs using the CData Software JDBC Driver.
-
DataBind Confluence Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Confluence with the DevExpress Windows Forms and Web controls to provide Atlassian Confluence to a chart.
-
DataBind Charts to Authorize.Net Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Authorize.Net 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.
-
Build a PostgreSQL Interface for Salesforce Data using the CData JDBC Driver
Use the Remoting features of the Salesforce JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live ShipStation Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to ShipStation from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Analyze Cohere Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Cohere with the CData JDBC Driver for Cohere.
-
How to work with ClickTime Data in Apache Spark using SQL
Access and process ClickTime Data in Apache Spark using the CData Software JDBC Driver.
-
Build Charts with Vimeo Data in Clear Analytics
Create dynamic charts and perform analytics based on Vimeo in Clear Analytics.
-
Query ActiveCampaign Data from Node.js
Use the OData endpoint of the CData API Server to connect to your ActiveCampaign and perform CRUD operations on ActiveCampaign from Node.js.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for RSS
Provide connectivity to RSS Feeds through an SAP BusinessObjects universe.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Snapchat Ads to Power BI dashboards. Simply drag and drop Snapchat Ads into data visuals on the Power BI canvas.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zoho Inventory
Provide connectivity to Zoho Inventory through an SAP BusinessObjects universe.
-
Build Azure Analysis Services-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Azure Analysis Services and build Azure Analysis Services-connected web apps with Axios.
-
Automated Continuous Zoho Inventory Replication to SQL Server
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to SQL Server.
-
How to Access Bright Data Data Using Entity Framework
This article shows how to access Bright Data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Publish Reports with SAP HANA XS Advanced Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP HANA XS Advanced.
-
Getting Started with the CData ADO.NET Provider for Short.io
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
ETL ZohoExpense in Oracle Data Integrator
This article shows how to transfer ZohoExpense into a data warehouse using Oracle Data Integrator.
-
Publish Reports with Bitly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bitly.
-
Replicate HCL Domino Data to Multiple Databases via the CData Sync CLI
Replicate HCL Domino to disparate databases with a single configuration.
-
Analyze SendPulse Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SendPulse in Microsoft R Open.
-
Analyze IBM Cloud Object Storage Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze IBM Cloud Object Storage in Microsoft R Open.
-
Integrating OpenCode Terminal with Oracle Eloqua 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.
-
Build Apps with Live SAP HANA Data Using the Low-Code Development Platform of Mendix
Connect SAP HANA with Mendix to build apps using the CData JDBC Driver for SAP HANA.
-
Getting Started with the CData ADO.NET Provider for NASA
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Easily Query SAP HANA XS Advanced Data in OpenOffice Base
Connect to SAP HANA XS Advanced data in OpenOffice Base using the CData ODBC Driver for SAP HANA XS Advanced and generate reports with live data insights.
-
Connect to Wistia Data in CloverDX (formerly CloverETL)
Transfer Wistia using the visual workflow in the CloverDX data integration tool.
-
How to Connect to Live Vault CRM 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 Veeva Vault & Vault CRM for you.
-
Work with ServiceNow Data in FoxPro
Load ServiceNow into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build AI/ML Models with Live SAP HANA XS Advanced Data using Dataiku
Connect SAP HANA XS Advanced Data with Dataiku using the CData JDBC Driver for SAP HANA XS Advanced.
-
Connect and Visualize Live Office 365 Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Microsoft Office 365 into the Databricks platform and create visualization dashboards with real-time Microsoft Office 365.
-
Replicate Calendly Data in Heroku for Use in Salesforce Connect
Replicate Calendly to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Visualize Live Hugging Face Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Hugging Face.
-
Getting Started with the CData Power BI Connector for Email
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Email.
-
Create SSAS Tabular Models from Campaigner Data
How to build a SQL Server Analysis Service Tabular Model from Campaigner using CData drivers.
-
Creating HBase-Connected Applications in Unqork
You can use CData Connect AI to feed Apache HBase to Unqork and build custom business apps.
-
Connect to Oracle SCM Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Oracle SCM from Filemaker Pro on Mac.
-
Create Data Visualizations in Cognos BI with Workable Data
Access Workable as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Query CloudConvert Data through ODBC in Node.js
Use node-odbc to execute SQL queries against CloudConvert from Node.js.
-
Automate Tasks in Power Automate Using the CData API Server
Automate CouchDB actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Automated Continuous Google Spanner Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Spanner replication to MySQL.
-
Visualize Live Yelp Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Yelp using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connecting GenSpark with Xero Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Xero Accounting without any replication or custom integration required.
-
Integrating LlamaIndex with Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Act-On in real time.
-
How to Connect to Live LinkedIn Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live LinkedIn without replication.
-
Analyze SAP Business One Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Business One in Microsoft R Open.
-
Connect to and Visualize Live Jira Assets Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Jira Assets.
-
Connect to BambooHR Data in Google Apps Script via Connect AI
Use CData Connect AI to access BambooHR in Google Apps Script.
-
Import Sage 200 Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Sage 200. In this article, you will use the OData format to import Sage 200 into Microsoft Power Query.
-
Analyze Workable Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Workable from Power Pivot. You will use the Table Import Wizard to load Workable. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Live Excel Online Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Microsoft Excel Online to Blue Prism using the CData ODBC Driver for Excel Online to create automated workflows for repetitive business tasks.
-
Visualize SingleStore Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SingleStore.
-
Integrating Cursor CLI with Postmark 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.
-
Design BIRT Reports on Reckon Data
Provide current Reckon to your embedded analytics.
-
Access Live Elasticsearch Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Elasticsearch in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Access Live Impala Data in Visual Studio Code via Cline
Run CData MCP Server for Impala on Windows Subsytem for Linux (WSL) and connect to live Apache Impala from the Cline extension in Visual Studio Code.
-
How to connect to TigerGraph Data in DBVisualizer
Integrate TigerGraph with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Oracle SCM Data in the Pentaho Report Designer
Publish reports based on Oracle SCM in the Pentaho BI tool.