CData Software - Knowledge Base
Recent Articles
-
Analyze Qualaroo Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Qualaroo with the CData JDBC Driver for Qualaroo.
-
Operational Reporting on Kintone Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Kintone.
-
How to load Auth0 data into Elasticsearch via Logstash
Introducing a simple method to load Auth0 data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Reply.io Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Reply.io from your Oracle system.
-
Build an OLAP Cube in SSAS from Dynamics CRM Data
Establish a connection to Microsoft Dynamics CRM data from SQL Server Analysis Services, and use the Dynamics CRM Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to connect SharePoint with YouTube Analytics Data through external lists
Provide YouTube Analytics to SharePoint users as an external list.
-
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.
-
Use the CData ODBC Driver for FreeAgent from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for FreeAgent to connect to FreeAgent from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring FreeAgent in Excel.
-
Connect to Oracle SCM Data from PowerBuilder via JDBC
This article demonstrates how to access Oracle SCM from PowerBuilder using the Oracle SCM JDBC Driver.
-
How to Work with LightSpeedRetail Data in ETL Validator JDBC
Connect to LightSpeedRetail from ETL Validator jobs using the CData Software JDBC Driver.
-
Build MVC Applications with Connectivity to MongoDB Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access MongoDB from an ASP.NET MVC application.
-
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.
-
Integrating GitHub Copilot CLI with Amazon DynamoDB 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.
-
Model Zoho Books Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Zoho Books, enabling the direct import of real-time Zoho Books.
-
Create SSAS Tabular Models from Factorial Data
How to build a SQL Server Analysis Service Tabular Model from Factorial using CData drivers.
-
Analyze VWO Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze VWO with the CData JDBC Driver for VWO.
-
How to Query Live Act-On Data in Perplexity MacOS Desktop
Connect to and query live Act-On Data in Perplexity Desktop using CData MCP Server.
-
Use ChatGPT to Talk to Your Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Redis for you.
-
How to work with Stack Exchange Data in Apache Spark using SQL
Access and process Stack Exchange Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous SparkPost Replication to SQL Server
Use CData Sync for automated, continuous, customizable SparkPost replication to SQL Server.
-
Analyze Live Amazon DynamoDB Data in SAS Viya
Use CData Connect AI to connect to Amazon DynamoDB from SAS Viya and deploy self-service analytics using live Amazon DynamoDB.
-
Build a Simple VCL Application for IBM Cloud Object Storage Data
How to build a simple VCL Application to view IBM Cloud Object Storage in RAD Studio using the CData ODBC Driver for IBM Cloud Object Storage.
-
Visualize Live Active Directory Data in the Power BI Service
Use CData Connect AI to connect to live Active Directory and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate SAS xpt Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAS XPORT from Informatica Cloud.
-
Bridge HDFS Connectivity with Apache NiFi
Access and process Apache HDFS in Apache NiFi using the CData JDBC Driver.
-
Provide OData Services of ZohoPeople Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ZohoPeople by developing a WCF Service Application.
-
Automated Continuous PabblySubscriptions Replication to AlloyDB
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to AlloyDB.
-
Automate SendInBlue Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SendInBlue and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
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 without any coding.
-
Build ScrapingBee-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live ScrapingBee Data in GitHub Copilot to assist with building ScrapingBee-powered applications.
-
Back Up BambooHR to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with BambooHR data.
-
Publish Reports with OpenWeatherMap Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date OpenWeatherMap.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Avalara AvaTax actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Visualize Pingdom Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pingdom.
-
Bridge Discourse Connectivity with Apache NiFi
Access and process Discourse in Apache NiFi using the CData JDBC Driver.
-
Getting Started with the CData JDBC Driver for MariaDB
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for MariaDB.
-
How to Work with Splunk Data in ETL Validator JDBC
Connect to Splunk from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect to ShipEngine Data from IntelliJ
Integrate connectivity to ShipEngine with wizards in IntelliJ.
-
Connect ZohoExpense to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ZohoExpense using the CData Python MCP Server.
-
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.
-
Use the CData Software JDBC Driver for Azure Synapse in MicroStrategy Web
Connect to Azure Synapse in MicroStrategy Web using the CData Software JDBC Driver for Azure Synapse.
-
Import and Visualize Smartsheet Data in Power View
Create data visualizations based on Smartsheet in Excel.
-
Build BigCommerce-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live BigCommerce and build BigCommerce-connected web apps with Axios.
-
Access Live Salesforce Pardot Data in AWS Lambda
Connect to live Salesforce Pardot in AWS Lambda using the CData JDBC Driver.
-
Build Semantic Layer Views for Power BI XMLA Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Power BI XMLA.
-
Create Reports with ZohoDesk Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZohoDesk.
-
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.
-
How to Connect to Live Microsoft Dataverse 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 Microsoft Dataverse (CDS) for you.
-
Visualize Oracle Financials Cloud 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 Oracle Financials Cloud into TIBCO Spotfire.
-
Integrate Microsoft Dataverse Data in Pentaho Data Integration
Build ETL pipelines based on Microsoft Dataverse (CDS) in the Pentaho Data Integration tool.
-
Automated Databricks Data Replication to Teradata
Use CData Sync to Customize and automate Databricks replication to Teradata.
-
Rapidly Develop Coda-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 Coda.
-
Automated Continuous Oracle Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Oracle replication to IBM DB2.
-
Build MVC Applications with Connectivity to Shippo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Shippo from an ASP.NET MVC application.
-
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 in Domo Workbench and then build visualizations in the Domo service.
-
Build Semantic Layer Views for Freshsales Data in APOS Live Data Gateway
Use the CData Connector for Freshsales in APOS Live Data Gateway to build Semantic Layer Views for Freshsales.
-
Analyze ZendeskSell Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ZendeskSell with the CData JDBC Driver for ZendeskSell.
-
Replicate Timely Data from PowerShell
Write a quick PowerShell script to query Timely. Use connectivity to the live data to replicate Timely to SQL Server.
-
Use Manus AI to Talk to Your SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on SAP BusinessObjects BI.
-
Access Live Google Search Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Google Search data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Moving Data from ScrapingBee to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ScrapingBee data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Greenplum Replication to Vertica
Use CData Sync for automated, continuous, customizable Greenplum replication to Vertica.
-
Visualize Live Paddle Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Paddle.
-
Build Paylocity-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Paylocity Data from Zoho Analytics and import live Paylocity.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Amazon S3 within intelligent workflows.
-
Bidirectional Access to BigCommerce Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate BigCommerce in Filemaker Pro for Mac or Windows.
-
Automated Continuous Float Replication to Oracle
Use CData Sync for automated, continuous, customizable Float replication to Oracle.
-
Create Data Visualizations in Cognos BI with Apollo Data
Access Apollo as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Write a Simple Go Application to work with Drift Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Drift.
-
Build an OLAP Cube in SSAS from Oracle HCM Cloud Data
Establish a connection to Oracle HCM Cloud data from SQL Server Analysis Services, and use the Oracle HCM Cloud Data Provider to build OLAP cubes for use in analytics and reporting.
-
Migrating data from PDFMonkey to Google BigQuery using CData SSIS Components.
Easily push PDFMonkey to Google BigQuery using the CData SSIS Tasks for PDFMonkey and Google BigQuery.
-
Operational Reporting on Snowflake Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Snowflake.
-
Connect to Sage Intacct in SpagoBI
Create reports featuring live Sage Intacct in SpagoBI Studio. Host Sage Intacct reports on SpagoBI Server.
-
Validate Shortcut Data with QuerySurge
Access and validate Shortcut in QuerySurge using the CData JDBC Driver.
-
How to connect PolyBase to Splunk
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Splunk.
-
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.
-
Integrating Claude Code CLI with Planio 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 to Live Sage 200 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 Sage 200 for you.
-
Connect to Pushbullet Data from a Connection Pool in Jetty
The Pushbullet JDBC Driver supports connection pooling: This article shows how to connect faster to Pushbullet from Web apps in Jetty.
-
Build Agents in Relevance AI with Access to Live SingleStore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SingleStore within intelligent agent workflows.
-
Operational Reporting on Insightly Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Insightly.
-
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.
-
Visualize Access Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft Access.
-
Integrate Live API Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to API from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live API.
-
Automated Continuous Pipedrive Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Pipedrive replication to IBM DB2.
-
Publish Front-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Front.
-
Consume BigQuery OData Feeds in SAP Lumira
Use the API Server to create data visualizations on BigQuery feeds that reflect any changes in SAP Lumira.
-
Integrating Antigravity CLI with MariaDB via CData CLI
Connect MariaDB to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Data Visualizations in Cognos BI with DB2 Data
Access IBM DB2 as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
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.
-
Access Anaplan Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Anaplan from your Oracle system.
-
Connect to Quickbase Data from PowerBuilder via ADO.NET
This article demonstrates how to access Quickbase from Appeon PowerBuilder using the CData ADO.NET Provider for Quickbase.
-
Analyze Live Sage Intacct Data in SAS Viya
Use CData Connect AI to connect to Sage Intacct from SAS Viya and deploy self-service analytics using live Sage Intacct.
-
Prepare, Blend, and Analyze Retently Data in Alteryx Designer (ODBC)
Build workflows to access live Retently for self-service data analytics.
-
Create Data Visualizations Based On Tally Data in Mode
Use CData Connect AI to connect to Tally Data from Mode and build visualizations using live
-
Work with Live Xero Data in Power Query
Use CData Connect AI to connect to Xero Accounting and work with live Xero Accounting in Microsoft Power Query.
-
Analyze Mocean Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Mocean and visualize live Mocean in Infragistics Reveal.
-
Visualize Live Presto Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Presto using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Cvent Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Cvent and visualize live Cvent in Infragistics Reveal.
-
Use the CData Software JDBC Driver for QuickBooks Online in MicroStrategy Web
Connect to QuickBooks Online in MicroStrategy Web using the CData Software JDBC Driver for QuickBooks Online.