CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Google Tasks Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Tasks replication to Google Cloud SQL.
-
Query Workable Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Workable from Node.js.
-
How to connect SharePoint with Redis Data through external lists
Provide Redis to SharePoint users as an external list.
-
Use the CData Software ODBC Driver for Epicor Kinetic in MicroStrategy
Connect to Epicor Kinetic in MicroStrategy Developer using the CData Software ODBC Driver for Epicor Kinetic.
-
How to Connect DBeaver to Facebook via a JDBC Driver
Manage Facebook with visual tools in DBeaver like the query browser.
-
Integrate with ZendeskSell Data in JReport Designer
Create charts and reports based on ZendeskSell in JReport Designer.
-
How to create Adobe Analytics federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Adobe Analytics in MySQL .
-
Connect to HBase Data in Aqua Data Studio
Access Apache HBase from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Natively Connect to Greenplum Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Pivotal GreenPlum. Leverage the native support for ODBC in PHP.
-
Model EnterpriseDB Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and EnterpriseDB, enabling the direct import of real-time EnterpriseDB.
-
Bridge Okta Connectivity with Apache NiFi
Access and process Okta in Apache NiFi using the CData JDBC Driver.
-
Visualize Live PostgreSQL Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live PostgreSQL using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live Confluence Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Atlassian Confluence from your Excel spreadsheets.
-
Getting Started with the CData JDBC Driver for Zoho Books
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Zoho Books.
-
Import Real-Time ConvertKit Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ConvertKit in ColdFusion.
-
How to integrate Vercel with Apache Airflow
Access and process Vercel in Apache Airflow using the CData JDBC Driver.
-
SingleStore Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SingleStore through CData Connect AI using different applications and tools.
-
How to connect PolyBase to AlloyDB
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google AlloyDB.
-
Build Microsoft Planner-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Microsoft Planner to explore live Microsoft Planner Data in GitHub Copilot to assist with building Microsoft Planner-powered applications.
-
View Reports on Real-Time Toggl Data in Power BI Report Server
Use the CData ODBC Driver for Toggl to visualize Toggl in Power BI Desktop and then publish them to Power BI Report Server.
-
Query Sage 300 Data as a MySQL Database in Node.js
Execute MySQL queries against Sage 300 from Node.js.
-
Use the CData SSIS Components to Insert New or Update Existing Microsoft Entra ID Records from SQL Server
Easily push SQL Server data to Microsoft Entra ID using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Microsoft Entra ID or update existing records with data from a SQL Server database.
-
Create Reports with RSS Feeds in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date RSS Feeds.
-
Automated Continuous Avalara AvaTax Replication to MySQL
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to MySQL.
-
Moving Data from MailerSend to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live MailerSend data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build a Simple VCL Application for Unbounce Data
How to build a simple VCL Application to view Unbounce in RAD Studio using the CData ODBC Driver for Unbounce.
-
Access Live Twilio Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Twilio from your Google Sheets.
-
Build Odoo-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Odoo ERP and build Odoo-connected web apps with Axios.
-
Connect to PagerDuty Data in Jaspersoft Studio
Execute SQL to remote PagerDuty in Jaspersoft Studio.
-
Build Dashboards with Superchat Data in Dundas BI
Create dynamic dashboards and perform analytics based on Superchat in Dundas BI.
-
Edit and Search External Trello Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Trello to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Trello Data objects that you can access from apps and the dashboard.
-
Use the CData ODBC Driver for Vercel in Microsoft Power Query
You can use the CData Vercel ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Vercel into Microsoft Power Query.
-
Query SAP BusinessObjects BI Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAP BusinessObjects BI entities in PHP by modeling them as objects.
-
Connect to Kintone Data from AWS Glue
Use CData Connect AI to gain access to live Kintone from your AWS Glue jobs.
-
How to connect to Adobe Target Data from Spring Boot
Connect to Adobe Target in a Spring Boot Application using the CData JDBC Driver for Adobe Target
-
Choosing the Best Method to Connect RabbitMQ to SQL Server: 5 Options Explained
Discover multiple ways to connect and use RabbitMQ from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Biml to Build SSIS Tasks to Replicate MariaDB Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate MariaDB to SQL Server.
-
Getting Started with the CData ODBC Driver for Short.io
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Short.io.
-
Visualize SAP BusinessObjects BI Data in TIBCO Spotfire through ADO.NET
Integrate SAP BusinessObjects BI into dashboards in TIBCO Spotfire.
-
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.
-
How to Query Live SAS Data Sets Data in Claude Desktop
Connect to and query live SAS Data Sets Data in Claude Desktop using CData MCP Server.
-
Integrate MySQL Data in the Pentaho Report Designer
Publish reports based on MySQL in the Pentaho BI tool.
-
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.
-
How to Visualize Oracle Sales Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Oracle Sales in Python.
-
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.
-
Deploying CData API Server V25 on AWS with High Availability Using an Application Load Balancer
Learn how to deploy CData API Server V25 on AWS with high availability using EC2, RDS, and an Application Load Balancer.
-
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.
-
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.
-
Visualize Klaviyo 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 Klaviyo into TIBCO Spotfire.
-
Integrate with Templated Data in JReport Designer
Create charts and reports based on Templated in JReport Designer.
-
Work with Live Basecamp Data in Power Query
Use CData Connect AI to connect to Basecamp and work with live Basecamp in Microsoft Power Query.
-
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.
-
Use the CData Software ODBC Driver for QuickBooks in MicroStrategy Web
Connect to QuickBooks Desktop in MicroStrategy Web using the CData Software ODBC Driver for QuickBooks.
-
Connect to Zoho Books Data in Jaspersoft Studio
Execute SQL to remote Zoho Books in Jaspersoft Studio.
-
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.
-
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.
-
Connect to and Visualize Live Coinbase Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Coinbase.
-
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.
-
Process & Analyze Pinterest Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Pinterest Data.
-
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.
-
Migrating data from Drip to Databricks using CData SSIS Components.
Easily push Drip to Databricks using the CData SSIS Tasks for Drip and Databricks.
-
Import Real-Time SAP HANA XS Advanced Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP HANA XS Advanced in ColdFusion.
-
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.
-
Use the CData Software ODBC Driver for Facebook in MicroStrategy
Connect to Facebook in MicroStrategy Developer using the CData Software ODBC Driver for Facebook.
-
Build Apps with Live Shippo Data Using the Low-Code Development Platform of Mendix
Connect Shippo with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous PabblySubscriptions Replication to AlloyDB
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to AlloyDB.
-
Consume SAS xpt OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAS xpt feeds that reflect any changes in SAP Lumira.
-
Create Instagram Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Instagram data access from reports, embedded analytics, and more.
-
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.
-
Getting Started with the CData JDBC Driver for MariaDB
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for MariaDB.
-
Integrating Claude Code CLI with Paymo 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 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.
-
Connecting Agentforce with Cosmos DB 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 Azure Cosmos DB for you.
-
How to Query Live PostgreSQL Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live PostgreSQL data in natural language using Python.
-
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.
-
Connect XML Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your XML Files using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Replicate Multiple SingleStore Accounts via the CData Sync CLI
Replicate multiple SingleStore accounts to one or many databases.
-
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.
-
Visualize Pinecone Data in Tableau
The CData ODBC driver for Pinecone enables you integrate Pinecone into Tableau dashboards.
-
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.
-
Edit and Search External Zoho Books Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Zoho Books to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Zoho Books Data objects that you can access from apps and the dashboard.
-
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.
-
Connect to Azure Analysis Services Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Azure Analysis Services.
-
Access Live Nethunt Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Nethunt into the statistical analysis tools available in SAS JMP. This article shows how to use Nethunt in the Graph Builder and Query Builder.
-
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.
-
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.
-
Build an OLAP Cube in SSAS from Accelo Data
Establish a connection to Accelo data from SQL Server Analysis Services, and use the Accelo Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize MarkLogic Data in TIBCO Spotfire through ADO.NET
Integrate MarkLogic into dashboards in TIBCO Spotfire.
-
How to Connect to Live Oracle SCM 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 Oracle SCM for you.
-
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.