CData Software - Knowledge Base
Recent Articles
-
Connect to Elorus Data in Aqua Data Studio
Access Elorus from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect to Live Google Sheets 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 Google Sheets without replication.
-
Integrate Redshift Data in Pentaho Data Integration
Build ETL pipelines based on Amazon Redshift in the Pentaho Data Integration tool.
-
How to Seamlessly Import Paylocity Data into IBM SPSS Modeler
Integrate Paylocity data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to PayPal from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from PayPal, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Dropbox using the Model Context Protocol.
-
Operational Reporting on Teradata Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Teradata.
-
Access Live Printify Data in AWS Lambda
Connect to live Printify in AWS Lambda using the CData JDBC Driver.
-
Use the CData ODBC Driver for Vimeo in Microsoft Power Query
You can use the CData Vimeo ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Vimeo into Microsoft Power Query.
-
Build AI Agents with SQL Analysis Services 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 SQL Analysis Services through CData Connect AI.
-
Query Adobe Commerce Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Adobe Commerce entities in PHP by modeling them as objects.
-
Build Smartsheet-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Smartsheet and build Smartsheet-connected web apps with Axios.
-
Use the CData Software ODBC Driver for Gong in SAS for Real-Time Reporting and Analytics
Connect to real-time Gong in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Gong.
-
Getting Started with the CData Tableau Connector for Zoho CRM
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Zoho CRM.
-
How to Connect to & Open Clockify Data in Microsoft Excel
This article uses the CData ODBC driver for Clockify to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to ServiceDesk Plus Data in DBArtisan
Use wizards in DBArtisan to configure ServiceDesk Plus as a data source.
-
How to connect to SAP HANA XS Advanced Data in DBVisualizer
Integrate SAP HANA XS Advanced with visual data analysis tools and data connection wizards in DBVisualizer
-
Build CouchDB-Connected Apps in Choreo
Use CData Connect AI to connect to CouchDB Data from Choreo and build custom apps using live Apache CouchDB.
-
Working with Marketo Data in LINQPad
Execute LINQ queries to Marketo in LINQPad.
-
Connect to Reply.io Data in NetBeans
Connect to Reply.io in NetBeans with the data source configuration wizard.
-
Viewing xBase Data in RAD Studio Data Explorer
How to view xBase in RAD Studio Data Explorer using the CData ODBC Driver for xBase.
-
Connect to ZohoMarketingHub Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ZohoMarketingHub and the SQL Gateway to access ZohoMarketingHub from Google Apps Script.
-
A PostgreSQL Interface for Google Ad Manager Data (MySQL Remoting via JDBC)
Use the Remoting features of the Google Ad Manager JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to use SQLAlchemy ORM to access Miro Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Miro.
-
How to connect to Productboard Data from Spring Boot
Connect to Productboard in a Spring Boot Application using the CData API Driver for JDBC
-
Connecting Moonlit Workflow with GitLab Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your GitLab in real time.
-
Integrate Live Adobe Analytics Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Adobe Analytics from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Adobe Analytics.
-
Publish Nethunt-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Nethunt.
-
How to Query Gmail Data in MySQL Workbench
Execute MySQL queries against live Gmail from MySQL Workbench.
-
Oracle Sales Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Oracle Sales facts in real time.
-
Integrate Theia IDE with Live HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Create Informatica Mappings From/To an ODBC Data Source for Splunk
Create an ODBC connection to Splunk in Informatica and browse and transfer Splunk.
-
Connect to Oracle Eloqua Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Oracle Eloqua from Filemaker Pro on Mac.
-
Build SendGrid-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SendGrid to explore live SendGrid Data in Claude Code to assist with building SendGrid-powered applications.
-
Bind Live Airtable Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Airtable data
-
Visualize Gmail 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 Gmail into TIBCO Spotfire.
-
Choosing the Best Method to Connect SurveyMonkey to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SurveyMonkey from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Excel Spreadsheet Automation on SAP Business One Data with the QUERY Formula
Pull data from SAP Business One, automate spreadsheets, and more with the QUERY formula.
-
Integrating OAuth Authorization Code Grant with CData Connectors
A comprehensive guide to implementing OAuth Authorization Code Grant flows with CData embedded connectors for desktop and web applications.
-
Query Salesforce CRM Analytics Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Salesforce CRM Analytics entities in PHP by modeling them as objects.
-
DataBind Controls to Sybase IQ Data in C++Builder
DataBind to Sybase IQ in C++Builder with standard components and controls.
-
Integrating Boomi Agentstudio with Google Ad Manager Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Ad Manager, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Rapidly Develop Deel-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 Deel.
-
Extract, Transform, and Load Aircall Data in Informatica PowerCenter
Create a simple Workflow for Aircall in Informatica PowerCenter.
-
Creating Azure Synapse-Connected Applications in Unqork
You can use CData Connect AI to feed Azure Synapse to Unqork and build custom business apps.
-
Integrate Open WebUI with Live Zoho Creator Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Zoho Creator from within the chat interface.
-
Integrating Cursor CLI with Mixpanel 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.
-
Connect to Instantly in SpagoBI
Create reports featuring live Instantly in SpagoBI Studio. Host Instantly reports on SpagoBI Server.
-
Operational Reporting on Vimeo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Vimeo.
-
Getting Started with the CData Tableau Connector for Sage 300
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Sage 300.
-
Object-Relational Mapping (ORM) with Amazon Athena Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Amazon Athena into a Java-based ORM framework, Hibernate.
-
Create Spark-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Spark Data from Klipfolio and build custom visualizations using live Apache Spark SQL.
-
Build a Simple VCL Application for Notion Data
How to build a simple VCL Application to view Notion in RAD Studio using the CData ODBC Driver for Notion.
-
How to Query Live Office 365 Data in Claude Desktop
Connect to and query live Office 365 Data in Claude Desktop using CData MCP Server.
-
Use the CData Software ODBC Driver for Cloudflare in SAS for Real-Time Reporting and Analytics
Connect to real-time Cloudflare in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Cloudflare.
-
How to Connect to Live Dropbox 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 Dropbox for you.
-
How to connect PolyBase to Zoho Projects
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Zoho Projects.
-
Integrating Kiro CLI with Telegram 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.
-
DataBind Controls to Xero Data in Delphi
DataBind to Xero Accounting in Delphi with standard data access components and controls.
-
Automated Continuous Chargebee Replication to MongoDB
Use CData Sync for automated, continuous, customizable Chargebee replication to MongoDB.
-
Create Google Campaign Manager 360-Connected Dashboards in Grafana
Connect to Google Campaign Manager 360 Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Campaign Manager 360.
-
Use the CData ODBC Driver for Freshservice in Microsoft Power Query
You can use the CData Freshservice ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Freshservice into Microsoft Power Query.
-
Connect to Splunk Data from HeidiSQL
Use CData Connect AI to connect to and query live Splunk from HeidiSQL.
-
Use the CData Software JDBC Driver for Aircall in MicroStrategy
Connect to Aircall in MicroStrategy Developer using the CData Software JDBC Driver for Aircall.
-
Connect to Phoenix Data in NetBeans
Connect to Apache Phoenix in NetBeans with the data source configuration wizard.
-
How to Create Power BI Visual Reports with Real-Time HCL Domino Data
Use CData Power BI Connectors to visualize HCL Domino in Power BI.
-
Connect to HDFS Data from PowerBuilder via ADO.NET
This article demonstrates how to access Apache HDFS from Appeon PowerBuilder using the CData ADO.NET Provider for HDFS.
-
Integrate with LDAP Objects using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy LDAP to a JSON file on disk.
-
Integrating OpenCode Terminal with XML 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.
-
Import Real-Time ADP Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ADP in ColdFusion.
-
Automated Continuous Notion Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Notion replication to IBM DB2.
-
Build AI/ML Models with Live Odoo Data using Dataiku
Connect Odoo Data with Dataiku using the CData JDBC Driver for Odoo.
-
Access Live Gong Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Gong from your Excel spreadsheets.
-
Integrate Theia IDE with Live WordPress Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Build an OLAP Cube in SSAS from Klaviyo Data
Establish a connection to Klaviyo data from SQL Server Analysis Services, and use the Klaviyo Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData Software ODBC Driver for Snapchat Ads in SAS for Real-Time Reporting and Analytics
Connect to real-time Snapchat Ads in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Snapchat Ads.
-
Automate Active Directory Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Active Directory and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Create HelloSign Dataflows on PowerBI.com
Connect to the CData Power BI Connector for HelloSign from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live Couchbase Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Couchbase through MCP integration.
-
Connecting Pipedream with Google Spanner 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 Google Spanner data in real time.
-
How to connect and process Smartsheet from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Smartsheet.
-
Getting Started with the CData Python Connector for QuickBooks Time
Learn to install and license the CData Python Connector
-
Connect to Klipfolio Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Klipfolio.
-
Connect to Highrise Data from a Connection Pool in JBoss
Integrate Highrise CRM into Java servlets: Use the Management Console in JBoss to install the Highrise JDBC Driver.
-
How to connect SharePoint with Bullhorn CRM Data through external lists
Provide Bullhorn CRM to SharePoint users as an external list.
-
How to load Miro data into Elasticsearch via Logstash
Introducing a simple method to load Miro data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect to SuiteCRM Data from IntelliJ
Integrate connectivity to SuiteCRM with wizards in IntelliJ.
-
Natively Connect to Reckon Accounts Hosted Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Reckon Accounts Hosted. Leverage the native support for ODBC in PHP.
-
Replicate Multiple Humanity Accounts
Replicate multiple Humanity accounts to one or many databases.
-
How to Create Power BI Visual Reports with Real-Time QuickBooks Online Data
Use CData Power BI Connectors to visualize QuickBooks Online in Power BI.
-
Connect to Landbot Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Stream Jodoo Data into Apache Kafka Topics
Access and stream Jodoo in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Query Live Discourse Data in Claude Desktop
Connect to and query live Discourse Data in Claude Desktop using CData MCP Server.
-
Create NetSuite-Connected Dashboards in Grafana
Connect to NetSuite Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to NetSuite CRM & ERP.
-
Use the CData API Server to Access Salesforce CRM Analytics Data in Microsoft PowerPivot
Use the CData API Server to connect to live Salesforce CRM Analytics in the Power Pivot business intelligence tool.
-
How to Build an ETL App for Outlook Data in Python with CData
Create ETL applications and real-time data pipelines for Outlook in Python with petl.
-
Design BIRT Reports on Bullhorn CRM Data
Provide current Bullhorn CRM to your embedded analytics.
-
Connect to Odoo Data in HULFT Integrate
Connect to Odoo as a JDBC data source in HULFT Integrate
-
Getting Started with the CData Excel Add-In for GitLab
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for GitLab.
-
How to Connect Flowise AI Agents to Live Vault CRM 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 Veeva Vault & Vault CRM without replication.