CData Software - Knowledge Base
Recent Articles
-
Connect to Google Analytics from Asprova with CData Software ODBC Driver for Google Analytics
This article shows how to connect faster to Google Analytics data from Asprova.
-
Build Voice Agents in ElevenLabs with access to Live Snapchat Ads Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Snapchat Ads.
-
Automated Continuous SpaceX Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SpaceX replication to Amazon Redshift.
-
How to create an RPA flow for Placid Data in UiPath Studio
Use the Placid ODBC Driver to create workflows that access real-time Placid without any coding.
-
Access SAP BusinessObjects BI Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP BusinessObjects BI from your Oracle system.
-
Create Reports with Kintone Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Kintone.
-
Query SingleStore Data in ColdFusion
Write standard ColdFusion data access code to connect to SingleStore.
-
Integrating GitHub Copilot CLI with MessageBird 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.
-
Configure the CData JDBC Driver for REST in a Connection Pool in Tomcat
Connect to REST from a connection pool in Tomcat.
-
Integrate Tanda Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Tanda from Informatica Cloud.
-
Automate Delighted Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Delighted and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to connect to Avaza Data from Spring Boot
Connect to Avaza in a Spring Boot Application using the CData API Driver for JDBC
-
Integrating GitHub Copilot CLI with Landbot 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.
-
Using the CData Software ODBC Driver for Basecamp in PyCharm
Connect to Basecamp as an ODBC data source in PyCharm using the CData Software ODBC Driver for Basecamp.
-
Connect to Live SurveyMonkey Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SurveyMonkey in CData Connect AI and connect to your SurveyMonkey from PostgreSQL.
-
Automate SQL Analysis Services Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SQL Analysis Services from PowerShell? This article demonstrates how to utilize the SQL Analysis Services Cmdlets for tasks like connecting to SQL Analysis Services, automating operations, downloading data, and more.
-
Build OData-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for OData to explore live OData Services in Cursor to assist with building OData-powered applications.
-
Visualize PingOne 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 PingOne into TIBCO Spotfire.
-
Connect to Google Translate Data in Jaspersoft Studio
Execute SQL to remote Google Translate in Jaspersoft Studio.
-
Connect to NetSuite SuiteAnalytics Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for NetSuite SuiteAnalytics Data and connect to NetSuite SuiteAnalytics in Akorbi Digital RunMyProcess.
-
Automated Continuous Microsoft Dataverse Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Amazon S3.
-
Connect to Real-Time Access Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Access and Dataflow to import and use Microsoft Access in Power Apps.
-
How to Access Live SendGrid Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SendGrid enables you to integrate SendGrid into workflows built using Microsoft Power Automate Desktop.
-
Connect to Azure DevOps Data in Ruby
Connect to Azure DevOps in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use Microsoft Copilot Studio to talk to your Oracle 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 Oracle Database for you.
-
How to Work with Teradata Data in AWS Glue Jobs Using JDBC
Connect to Teradata from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Query Everhour Data in ColdFusion
Write standard ColdFusion data access code to connect to Everhour.
-
Connect to Odoo Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Odoo and the SQL Gateway to access Odoo ERP from Google Apps Script.
-
Build Dashboards with Jodoo Data in Dundas BI
Create dynamic dashboards and perform analytics based on Jodoo in Dundas BI.
-
Connect to ShipStation Data in DBeaver
Use the CData ODBC Driver to connect to ShipStation in DBeaver.
-
Integrate Live YouTube Analytics Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live YouTube Analytics to Blue Prism using the CData ODBC Driver for YouTube Analytics to create automated workflows for repetitive business tasks.
-
How to Connect to & Open Oracle Eloqua Data in Microsoft Excel
This article uses the CData ODBC driver for Oracle Eloqua to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect Greenplum to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Pivotal GreenPlum using the CData Python MCP Server.
-
Create Reports with Elasticsearch Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Elasticsearch.
-
Access Live Amazon Athena Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Amazon Athena from your Excel spreadsheets.
-
Automated Lakebase Data Replication to Teradata
Use CData Sync to Customize and automate Lakebase replication to Teradata.
-
Build Freshdesk Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Freshdesk and build visualizations in Tableau Cloud.
-
Getting Started with the CData ADO.NET Provider for Mistral AI
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Power BI XMLA Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Power BI XMLA.
-
Connect to Exact Online Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Exact Online.
-
Work with Odoo Data in FoxPro
Load Odoo ERP into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Cline with Live Google Cloud Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Cloud Storage from within your IDE.
-
Connecting Agentforce with Azure Table 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 Table Storage for you.
-
Visualize Live AlloyDB Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google AlloyDB.
-
Access Live SAP ByDesign Data in AWS Lambda
Connect to live SAP Business ByDesign in AWS Lambda using the CData JDBC Driver.
-
How to Connect to Live Quickbase 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 Quickbase for you.
-
Access Live Everhour Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Everhour in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connecting Pipedream with PostgreSQL Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on PostgreSQL data in real time.
-
Work with Live Klaviyo Data in Power Query
Use CData Connect AI to connect to Klaviyo and work with live Klaviyo in Microsoft Power Query.
-
Access Live Bitly Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Bitly data source in TIBCO Data Virtualization Studio and gain access to live Bitly from your TDV Server.
-
Visualize Live Google Ads Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Ads using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Live Retently Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Retently.
-
Visualize Odoo 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 Odoo ERP into TIBCO Spotfire.
-
Integrate with Live Google Ads Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Google Ads from the MuleSoft Anypoint Platform to integrate live Google Ads into custom reports and dashboards.
-
Automated Continuous Azure Data Lake Storage Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Azure SQL Database.
-
Integrating Dataiku with MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live MongoDB.
-
Connect to LionDesk Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for LionDesk in the Denodo Virtual DataPort Administrator.
-
How to Import Data from Supabase into Google Sheets
Import Supabase into a Google spreadsheet that is automatically refreshed.
-
Create EnterpriseDB-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to EnterpriseDB Data from Klipfolio and build custom visualizations using live EnterpriseDB.
-
How to create an RPA flow for Sugar CRM Data in UiPath Studio
Use the Sugar CRM ODBC Driver to create workflows that access real-time Sugar CRM without any coding.
-
How to Query Azure Table Data in MySQL Workbench
Execute MySQL queries against live Azure Table Storage from MySQL Workbench.
-
Build a PostgreSQL Interface for Jodoo Data using the CData JDBC Driver
Use the Remoting features of the Jodoo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Codex CLI with Power BI XMLA 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 PDFMonkey Data through ODBC in Node.js
Use node-odbc to execute SQL queries against PDFMonkey from Node.js.
-
Bidirectional Access to Stripe Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Stripe in Filemaker Pro for Mac or Windows.
-
How to create an RPA flow for Recurly Data in UiPath Studio
Use the Recurly ODBC Driver to create workflows that access real-time Recurly without any coding.
-
Build AI Agents with ShipStation 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 ShipStation through CData Connect AI.
-
Connect Demio Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Demio using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Bidirectional Access to Pipeliner CRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Pipeliner CRM in Filemaker Pro for Mac or Windows.
-
Bind Live SAP Hybris C4C Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP Hybris C4C data
-
Validate Qualaroo Data with QuerySurge
Access and validate Qualaroo in QuerySurge using the CData JDBC Driver.
-
Feed Jodoo Data into FineReport
How to set Jodoo as a JDBC data source in FineReport.
-
Getting Started with the CData JDBC Driver for Google Drive
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Google Drive.
-
Visualize Kafka Data in TIBCO Spotfire through ADO.NET
Integrate Apache Kafka into dashboards in TIBCO Spotfire.
-
How to Connect to Live MySQL 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 MySQL through natural language.
-
Automated Continuous Mailjet Replication to Databricks
Use CData Sync for automated, continuous, customizable Mailjet replication to Databricks.
-
Create Apps from Phoenix Data in Qlik Sense Cloud
Use CData Connect AI to connect to Phoenix Data and build apps from live Apache Phoenix in Qlik Sense Cloud.
-
Use the CData ODBC Driver for Bitbucket from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Bitbucket to connect to Bitbucket from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Bitbucket in Excel.
-
Create Informatica Mappings From/To an ODBC Data Source for Cosmos DB
Create an ODBC connection to Cosmos DB in Informatica and browse and transfer Azure Cosmos DB.
-
Visualize GraphQL Data in Sisense
Create an ElastiCube in Sisense app with access to GraphQL.
-
Automated Continuous HBase Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable HBase replication to Apache Kafka.
-
How to connect to SendInBlue Data from Spring Boot
Connect to SendInBlue in a Spring Boot Application using the CData API Driver for JDBC
-
Query Vault CRM Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Veeva Vault & Vault CRM and perform CRUD operations on Vault CRM from Node.js.
-
Access Live Bitbucket Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Bitbucket in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Keap Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Keap replication to Google Cloud SQL.
-
Build a Simple VCL Application for Cosmos DB Data
How to build a simple VCL Application to view Azure Cosmos DB in RAD Studio using the CData ODBC Driver for Cosmos DB.
-
Connect to Bugsnag Data in Aqua Data Studio
Access Bugsnag from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Work with Live CockroachDB Data in Power Query
Use CData Connect AI to connect to CockroachDB and work with live CockroachDB in Microsoft Power Query.
-
Analyze Gmail Data in Looker
Use CData Connect AI to connect to Gmail Data from Looker and build custom apps using live Gmail.
-
Build SAP HANA-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP HANA Data and create custom apps in Mendix.
-
Building Dynamic Web Pages with Google Search Results Using AngularJS
Create single-page applications with live connectivity to Google Search using the CData API Server.
-
Analyze Databricks Data in Looker
Use CData Connect AI to connect to Databricks Data from Looker and build custom apps using live Databricks.
-
Connect to HBase from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Apache HBase, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Visualize Basecamp 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 Basecamp into TIBCO Spotfire.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Couchbase to Power BI dashboards. Simply drag and drop Couchbase into data visuals on the Power BI canvas.
-
Getting Started with the CData Tableau Connector for Delighted
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create Reports with Teamwork Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Teamwork.
-
DataBind Zoho Books Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Zoho Books with the DevExpress Windows Forms and Web controls to provide Zoho Books to a chart.
-
Connect to Reckon Accounts Hosted Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Reckon Accounts Hosted Data and connect to Reckon Accounts Hosted in Akorbi Digital RunMyProcess.
-
Operational Reporting on FTP Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote FTP Servers.