CData Software - Knowledge Base
Recent Articles
-
A PostgreSQL Interface for Amazon Marketplace Data using the CData ODBC Driver
Use the SQL Gateway and Amazon Marketplace ODBC Driver to create a PostgreSQL entry-point for data access.
-
Deploy the ADO.NET Provider for Clari on an SSRS Report Server
Connect to Clari 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.
-
Access LionDesk Data from MySQL in PHP
Connect to LionDesk through the standard MySQL libraries in PHP.
-
Access Live CSV 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 CSV/TSV Files through MCP integration.
-
Build Facebook-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Facebook to explore live Facebook Data in Cursor to assist with building Facebook-powered applications.
-
Choosing the Best Method to Connect Redshift to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Amazon Redshift from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Data Visualizations in Cognos BI with SQL Server Data
Access Microsoft SQL Server as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
DataBind Controls to Oracle Service Cloud Data in Delphi
DataBind to Oracle Service Cloud in Delphi with standard data access components and controls.
-
Connect to SAP Business One Data in RapidMiner
Integrate SAP Business One with standard components and data source configuration wizards in RapidMiner Studio.
-
Establish a Live Connection with Amazon Athena Data using Tableau Bridge
The CData ODBC Driver for Amazon Athena enables you to integrate live Amazon Athena into Tableau Cloud dashboards using the Tableau Bridge.
-
Working with ActiveCampaign Data in LINQPad
Execute LINQ queries to ActiveCampaign in LINQPad.
-
CouchDB Reporting in OBIEE with the CouchDB JDBC Driver
Deploy the CouchDB JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use CData Connect AI to Access Zoho Creator Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Zoho Creator in the Power Pivot business intelligence tool.
-
Build Dashboards with Tanda Data in DBxtra
Create dynamic dashboards and perform analytics based on Tanda in DBxtra.
-
Use Dash to Build to Web Apps on Google Campaign Manager 360 Data
Create Python applications that use pandas and Dash to build Google Campaign Manager 360-connected web apps.
-
Analyze SurveyMonkey Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SurveyMonkey with the CData JDBC Driver for SurveyMonkey.
-
Integrate Live Google Calendar Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Google Calendar from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Calendar.
-
Integrating Claude Code CLI with EnterpriseDB 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 Elasticsearch-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Elasticsearch and build Elasticsearch-connected web apps with Axios.
-
Automated Continuous Timely Replication to Databricks
Use CData Sync for automated, continuous, customizable Timely replication to Databricks.
-
Integrating Gumloop with Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Act CRM within automated workflows.
-
How to Work with Sage Cloud Accounting Data in AWS Glue Jobs Using JDBC
Connect to Sage Cloud Accounting from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Dash to Build to Web Apps on CircleCI Data
Create Python applications that use pandas and Dash to build CircleCI-connected web apps.
-
Connect to Brex Data from PowerBuilder via ADO.NET
This article demonstrates how to access Brex from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Replicate Figshare Data to Multiple Databases via the CData Sync CLI
Replicate Figshare to disparate databases with a single configuration.
-
Visualize QuickBooks Online 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 QuickBooks Online into TIBCO Spotfire.
-
How to publish and share Figshare Data dashboards with Tableau Server
The CData ODBC driver for Figshare enables you integrate Figshare into Tableau dashboards.
-
Use Microsoft Copilot Studio to talk to your Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Sybase IQ for you.
-
Getting Started with the CData SSIS Components for Oracle Eloqua Reporting
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Oracle Eloqua Reporting.
-
Connect to Real-Time Google Campaign Manager 360 Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Google Campaign Manager 360 and Dataflow to import and use Google Campaign Manager 360 in Power Apps.
-
Integrating Gumroad Data in Talend Cloud Data Management Platform
Connect Gumroad Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Query Amazon Athena Data as a MySQL Database in Node.js
Execute MySQL queries against Amazon Athena from Node.js.
-
Build Dashboards with Qualaroo Data in Dundas BI
Create dynamic dashboards and perform analytics based on Qualaroo in Dundas BI.
-
Publish Crystal Reports on WordPress Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date WordPress.
-
Establish a Live Connection with Sendwithus Data using Tableau Bridge
The CData ODBC Driver for Sendwithus enables you to integrate live Sendwithus into Tableau Cloud dashboards using the Tableau Bridge.
-
Establish a Live Connection with Dropbox Data using Tableau Bridge
The CData ODBC Driver for Dropbox enables you to integrate live Dropbox into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Connect DBeaver to MYOB AccountRight via a JDBC Driver
Manage MYOB AccountRight with visual tools in DBeaver like the query browser.
-
Integrating OpenCode Terminal with Elorus 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.
-
Create SSAS Tabular Models from Access Data
How to build a SQL Server Analysis Service Tabular Model from Microsoft Access using CData drivers.
-
Visualize Live SAP SuccessFactors Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP SuccessFactors.
-
Build Visualizations of Auth0 Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Auth0 in Birst.
-
How to integrate Metabase with eBay Data
Use CData Connect AI to connect to live eBay and create an interactive dashboard in Metabase from eBay.
-
Integrating Codex CLI with Coda 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 Billsby Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Billsby using standard SQL.
-
Integrate Cursor with Live Google Calendar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Calendar from within the editor.
-
Connect to SAP Ariba Procurement Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAP Ariba Procurement in FileMaker Pro to connect to SAP Ariba Procurement and work with SAP Ariba Procurement in your FileMaker applications.
-
Access Bitly Data from MySQL in PHP
Connect to Bitly through the standard MySQL libraries in PHP.
-
Connect to Shortcut Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Shortcut and the SQL Gateway to access Shortcut from Google Apps Script.
-
Automated Continuous Delighted Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Delighted replication to Apache Cassandra.
-
Vercel Reporting in OBIEE with the Vercel JDBC Driver
Deploy the Vercel JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Easily Integrate Eventbrite Data in Lazarus Pascal IDE
Learn how to easily integrate live Eventbrite in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Query QuickBooks Data in MySQL Workbench
Execute MySQL queries against live QuickBooks Desktop from MySQL Workbench.
-
How to create Visio diagrams from Jira Assets Data
Automatically update Jira Assets with the changes you make to Visio master shapes.
-
Process & Analyze Avaza Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Avaza Data.
-
How to create an RPA flow for MongoDB Data in UiPath Studio
Use the MongoDB ODBC Driver to create workflows that access real-time MongoDB without any coding.
-
Getting Started with the CData Python Connector for Supabase
Learn to install and license the CData Python Connector
-
Import Real-Time HCL Domino Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use HCL Domino in ColdFusion.
-
Create ZarMoney Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ZarMoney data access from reports, embedded analytics, and more.
-
Visualize QuickBooks Online Data in Sisense
Create an ElastiCube in Sisense app with access to QuickBooks Online.
-
Getting Started with the CData Connect AI Python SDK for NetSuite SuiteAnalytics
Install the CData Connect AI Python SDK to read and write live NetSuite SuiteAnalytics with standard DB-API 2.0 Python code.
-
Connect to Procore in SpagoBI
Create reports featuring live Procore in SpagoBI Studio. Host Procore reports on SpagoBI Server.
-
Query PhantomBuster Data in ColdFusion
Write standard ColdFusion data access code to connect to PhantomBuster.
-
Connect to Delighted Data from PowerBuilder via ADO.NET
This article demonstrates how to access Delighted from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Access Live ZohoInvoice Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ZohoInvoice in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Avalara AvaTax Data in Pentaho Data Integration
Build ETL pipelines based on Avalara AvaTax in the Pentaho Data Integration tool.
-
FreeAgent Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on FreeAgent facts in real time.
-
Visualize Live xBase Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live xBase.
-
Use JayDeBeApi to access Grafana Data in Python
Use standard Python scripting and the development environment of your choice to access live Grafana.
-
How to connect PolyBase to Azure Data Lake Storage
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Azure Data Lake Storage.
-
Integrate Open WebUI with Live Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Greenhouse from within the chat interface.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Cloudflare
Provide connectivity to Cloudflare through an SAP BusinessObjects universe.
-
Create Active Directory-Connected Dashboards in Grafana
Connect to Active Directory Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Active Directory.
-
Visualize Live BigQuery Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Google BigQuery into custom reports in Power BI.
-
Connect to Stack Exchange Data in Ruby
Connect to Stack Exchange in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build AI Agents with Gmail Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Gmail through CData Connect AI.
-
Use the CData ODBC Driver for Slack in Microsoft Power Query
You can use the CData Slack ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Slack into Microsoft Power Query.
-
Build Dynamics NAV-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Dynamics NAV to explore live Dynamics NAV Data in Claude Code to assist with building Dynamics NAV-powered applications.
-
Access Live SAP Ariba Procurement Data in AWS Lambda
Connect to live SAP Ariba Procurement in AWS Lambda using the CData JDBC Driver.
-
Import and Visualize Reckon Accounts Hosted Data in Power View
Create data visualizations based on Reckon Accounts Hosted in Excel.
-
How to Create Power BI Visual Reports with Real-Time Google Search Results
Use CData Power BI Connectors to visualize Google Search in Power BI.
-
How to Access Live Google Campaign Manager 360 Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Campaign Manager 360 enables you to integrate Google Campaign Manager 360 into workflows built using Microsoft Power Automate Desktop.
-
Connect to Stack Exchange Data in Jaspersoft Studio
Execute SQL to remote Stack Exchange in Jaspersoft Studio.
-
Build Automated Workflows with Live Act-On Data in Workato
Use CData Connect AI to connect to live Act-On and build automated workflows in Workato.
-
Prepare, Blend, and Analyze LDAP Objects in Alteryx Designer (ODBC)
Build workflows to access live LDAP for self-service data analytics.
-
Getting Started with the CData ADO.NET Provider for Autopilot
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create Attio Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Attio data access from reports, embedded analytics, and more.
-
Connect to SAP BusinessObjects BI Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SAP BusinessObjects BI and the Script function in FileMaker Pro to connect to SAP BusinessObjects BI and work with SAP BusinessObjects BI in your FileMaker application.
-
Build Data Flows from Adobe Experience Manager to SQL Server using SSIS
Easily back up Adobe Experience Manager to SQL Server using the SSIS components for Adobe Experience Manager.
-
Create Neo4J-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Neo4J Data from OutSystems and build custom enterprise apps using live Neo4J.
-
Getting Started with the CData Excel Add-In for Facebook
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Facebook.
-
View Reports on Real-Time Google Search Results in Power BI Report Server
Use the CData ODBC Driver for Google Search to visualize Google Search in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to SQL Analysis Services Data from PowerBuilder via JDBC
This article demonstrates how to access SQL Analysis Services from PowerBuilder using the SQL Analysis Services JDBC Driver.
-
Integrating GitHub Copilot CLI with Paylocity 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.
-
Automate SAP BusinessObjects BI Data Replication to Couchbase
Use CData Sync to Customize and automate SAP BusinessObjects BI replication to Couchbase.
-
Edit and Search FHIR External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of FHIR to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create FHIR objects that you can access from apps and the dashboard.
-
How to Connect to Live SAP Concur 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 SAP Concur for you.
-
Connect to and Query BigQuery Data in QlikView over ODBC
Create data visualizations with Google BigQuery in QlikView.
-
Load Bright Data Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Bright Data to a database.
-
Connect to ActiveCampaign Data in Google Apps Script via Connect AI
Use CData Connect AI to access ActiveCampaign in Google Apps Script.
-
Edit and Search Sage Cloud Accounting External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Sage Business Cloud Accounting to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Sage Cloud Accounting objects that you can access from apps and the dashboard.