CData Software - Knowledge Base
Recent Articles
-
How to Connect DBeaver to ZendeskSell via a JDBC Driver
Manage ZendeskSell data with visual tools in DBeaver like the query browser.
-
Query Live Outreach.io Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Outreach.io data through a conversational interface.
-
Build LeadDesk-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live LeadDesk data.
-
How to connect PolyBase to CircleCI
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live CircleCI data.
-
Integrating Claude Code CLI with LinkedIn Ads 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.
-
Getting Started with the CData Excel Add-In for ZendeskSell
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ZendeskSell.
-
Integrate SpaceX Data in Pentaho Data Integration
Build ETL pipelines based on SpaceX data in the Pentaho Data Integration tool.
-
Natively Connect to Amazon DynamoDB Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Amazon DynamoDB data. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData ADO.NET Provider for Eventbrite
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Visualize Helpscout 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 Helpscout data into TIBCO Spotfire.
-
Natively Connect to Oracle Service Cloud Data in PHP
The CData ODBC driver for Oracle Service Cloud enables you to create PHP applications with connectivity to Oracle Service Cloud data. Leverage the native support for ODBC in PHP.
-
Integrating GitHub Copilot with Grafana 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 a Data Access Object for Gmail Data using JDBI
A brief overview of creating a SQL Object API for Gmail data in JDBI.
-
Connect to Real-Time Reckon Accounts Hosted Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Reckon Accounts Hosted and Dataflow to import and use Reckon Accounts Hosted data in Power Apps.
-
Create Dynamic Databricks Grids Using the Infragistics XamDataGrid
Learn how you can connect Databricks to Infragistics XamDataGrid to build dynamic grids.
-
Rapidly Develop PolarTeamPro-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 PolarTeamPro.
-
Connect to BigQuery Data in RapidMiner
Integrate BigQuery data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Customer.io Data in DBArtisan
Use wizards in DBArtisan to configure Customer.io data as a data source.
-
Automate CloudConvert Data Replication to Azure Synapse
Use CData Sync to customize and automate CloudConvert data replication to Azure Synapse.
-
Create Dynamic SAS Data Sets Grids Using the Infragistics XamDataGrid
Learn how you can connect SAS Data Sets to Infragistics XamDataGrid to build dynamic grids.
-
A PostgreSQL Interface for Gong Data using the CData ODBC Driver
Use the SQL Gateway and Gong ODBC Driver to create a PostgreSQL entry-point for data access.
-
View Reports on Real-Time Mistral AI Data in Power BI Report Server
Use the CData ODBC Driver for Mistral AI to visualize Mistral AI data in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Jumpseller Data from MySQL in PHP
Connect to Jumpseller through the standard MySQL libraries in PHP.
-
Build Semantic Layer Views for Highrise Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Highrise data.
-
Query Live XML Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live XML data through a conversational interface.
-
Integrate Live Insightly Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Insightly data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build Data Flows from Greenplum to SQL Server using SSIS
Easily back up Greenplum data to SQL Server using the SSIS components for Greenplum.
-
Create a Data Access Object for Cosmos DB Data using JDBI
A brief overview of creating a SQL Object API for Cosmos DB data in JDBI.
-
Create Exact Online-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Exact Online Data from OutSystems and build custom enterprise apps using live Exact Online data.
-
How to create Azure Analysis Services federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure Analysis Services data in MySQL .
-
Prepare, Blend, and Analyze Onfleet Data in Alteryx Designer (ODBC)
Build workflows to access live Onfleet data for self-service data analytics.
-
Visualize SAP Business One 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 SAP Business One data into TIBCO Spotfire.
-
Query Live SAS Data Sets Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live SAS Data Sets data directly from the development environment.
-
Automated Continuous LaunchDarkly Replication to MySQL
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to MySQL.
-
How to import Mouseflow Data into Apache Solr
Use the CData Software JDBC Driver for Mouseflow in Data Import Handler and create an automated import of Mouseflow data to Apache Solr Enterprise Search platform.
-
Automated CapsuleCRM Data Replication to Teradata
Use CData Sync to Customize and automate CapsuleCRM data replication to Teradata.
-
Deploy the ADO.NET Provider for Hubstaff on an SSRS Report Server
Connect to Hubstaff data 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.
-
Build a Singer.io Tap for Google Forms With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Forms data using the CData Python Connector.
-
Build Dashboards with Hive Data in Dundas BI
Create dynamic dashboards and perform analytics based on Hive data in Dundas BI.
-
How to Work with Customer.io Data in AWS Glue Jobs Using JDBC
Connect to Customer.io from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to connect to Box Data with Squirrel SQL client
Connect to Box data and execute queries in the Squirrel SQL Client.
-
Integrate Cursor with Live Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Vertica data from within the editor.
-
Use Biml to Build SSIS Tasks to Replicate Facebook Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Facebook data to SQL Server.
-
How to Access Live Quaderno Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Quaderno enables you to integrate Quaderno data into workflows built using Microsoft Power Automate Desktop.
-
Viewing Hugging Face Data in RAD Studio Data Explorer
How to view Hugging Face data in RAD Studio Data Explorer using the CData ODBC Driver for Hugging Face.
-
How to create Visio diagrams from Gmail Data
Automatically update Gmail data with the changes you make to Visio master shapes.
-
How to Visualize IBM Cloud Object Storage Data in Python with pandas
Use pandas and other modules to analyze and visualize live IBM Cloud Object Storage data in Python.
-
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.
-
Connect to Live Coda Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Coda in CData Connect AI and connect to your Coda data from PostgreSQL.
-
Access SAP BusinessObjects BI Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP BusinessObjects BI data from your Oracle system.
-
How to integrate Mistral AI with Apache Airflow
Access and process Mistral AI data in Apache Airflow using the CData JDBC Driver.
-
Create Reports with Kintone Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Kintone data.
-
Query SingleStore Data in ColdFusion
Write standard ColdFusion data access code to connect to SingleStore data.
-
Configure the CData JDBC Driver for REST in a Connection Pool in Tomcat
Connect to REST data from a connection pool in Tomcat.
-
How to Connect to Live Google Campaign Manager 360 Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google Campaign Manager 360 data securely in real time.
-
Analyze Salesloft Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Salesloft data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Creating Vault CRM-Connected Applications in Unqork
You can use CData Connect AI to feed Vault CRM data to Unqork and build custom business apps.
-
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 data from PostgreSQL.
-
How to Create Power BI Visual Reports with Real-Time CampaignMonitor Data
Use CData Power BI Connectors to visualize CampaignMonitor data in Power BI.
-
Automate SQL Analysis Services Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SQL Analysis Services data from PowerShell? This article demonstrates how to utilize the SQL Analysis Services Cmdlets for tasks like connecting to SQL Analysis Services data, automating operations, downloading data, and more.
-
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 data in Akorbi Digital RunMyProcess.
-
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 Access data in Power Apps.
-
Build Apps with Live Teradata Data Using the Low-Code Development Platform of Mendix
Connect Teradata data with Mendix to build apps using the CData JDBC Driver for Teradata.
-
Integrate LibreChat with Live Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Greenplum data from within the chat interface.
-
Connect to Insightly from a Connection Pool in WebLogic
Use the CData JDBC Driver for Insightly to connect to Insightly data from Web applications running on WebLogic.
-
Automate Azure Analysis Services Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Azure Analysis Services data from PowerShell? This article demonstrates how to utilize the Azure Analysis Services Cmdlets for tasks like connecting to Azure Analysis Services data, automating operations, downloading data, and more.
-
Connect to AfterShip Data from AWS Glue
Use CData Connect AI to gain access to live AfterShip data from your AWS Glue jobs.
-
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 data for you.
-
How to connect PolyBase to Jumpseller
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Jumpseller data.
-
Connect to ShipStation Data in DBeaver
Use the CData ODBC Driver to connect to ShipStation data in DBeaver.
-
Integrating Antigravity CLI with MailerSend data via CData CLI
Connect MailerSend data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Analyze Live Kintone Data in SAS Viya
Use CData Connect AI to connect to Kintone data from SAS Viya and deploy self-service analytics using live Kintone data.
-
How to load SuiteCRM data into Elasticsearch via Logstash
Introducing a simple method to load SuiteCRM data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
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.
-
Query JotForm Data in DataGrip
Create a Data Source for JotForm in DataGrip and use SQL to query live JotForm data.
-
Connect Greenplum to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Greenplum data using the CData Python MCP Server.
-
Use the CData Software ODBC Driver for Teradata in MicroStrategy Web
Connect to Teradata data in MicroStrategy Web using the CData Software ODBC Driver for Teradata.
-
Automated Continuous Shippo Replication to Vertica
Use CData Sync for automated, continuous, customizable Shippo replication to Vertica.
-
Automated Lakebase Data Replication to Teradata
Use CData Sync to Customize and automate Lakebase data replication to Teradata.
-
Connect MarkLogic to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect MarkLogic with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous SAP Hybris C4C Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Oracle.
-
Automate Microsoft Dataverse Data Replication to SAP HANA
Use CData Sync to customize and automate Microsoft Dataverse data replication to SAP HANA.
-
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 data.
-
Work with Odoo Data in FoxPro
Load Odoo data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData Python Connector for Copper
Learn to install and license the CData Python Connector and configure a connection to live Copper data.
-
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 data from within your IDE.
-
Connect to Amazon Marketplace Data from Crystal Reports
Use CData Connect AI to connect to and report on live Amazon Marketplace data from Crystal Reports.
-
Visualize Live AlloyDB Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live AlloyDB data.
-
Access Live SAP ByDesign Data in AWS Lambda
Connect to live SAP ByDesign data in AWS Lambda using the CData JDBC Driver.
-
How to Connect to Live Odoo 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 Odoo data through natural language.
-
Connect to Oracle Eloqua from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Oracle Eloqua data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate Goose with Live Azure Data Catalog Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Azure Data Catalog data from within the local AI agent.
-
Viewing Customer.io Data in RAD Studio Data Explorer
How to view Customer.io data in RAD Studio Data Explorer using the CData ODBC Driver for Customer.io.
-
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 data for you.
-
Access Live Coda Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Coda data from your Excel spreadsheets.
-
Visualize Live Retently Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Retently data.
-
Automated Continuous Clockify Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Clockify replication to Amazon Redshift.
-
Integrate OpenCode with Live Oracle Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Oracle data from within your AI coding agent.
-
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 data into TIBCO Spotfire.