CData Software - Knowledge Base
Recent Articles
-
Integrating OpenCode Terminal with Stack Exchange 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.
-
Edit and Search External CockroachDB Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of CockroachDB to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create CockroachDB Data objects that you can access from apps and the dashboard.
-
Build AI/ML Models with Live WooCommerce Data using Dataiku
Connect WooCommerce Data with Dataiku using the CData JDBC Driver for WooCommerce.
-
Query Spotify Data in DataGrip
Create a Data Source for Spotify in DataGrip and use SQL to query live Spotify.
-
Excel Spreadsheet Automation on Hubstaff Data with the QUERY Formula
Pull data from Hubstaff, automate spreadsheets, and more with the QUERY formula.
-
How to Create Power BI Visual Reports with Real-Time Xero Data
Use CData Power BI Connectors to visualize Xero Accounting in Power BI.
-
Build Databricks-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Databricks to explore live Databricks Data in GitHub Copilot to assist with building Databricks-powered applications.
-
Use the CData Software JDBC Driver for Invoiced in MicroStrategy
Connect to Invoiced in MicroStrategy Developer using the CData Software JDBC Driver for Invoiced.
-
Automated Continuous MarkLogic Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable MarkLogic replication to OneLake in Microsoft Fabric.
-
Access Live API Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to API from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create SSAS Tabular Models from CampaignMonitor Data
How to build a SQL Server Analysis Service Tabular Model from CampaignMonitor using CData drivers.
-
Publish Sage Intacct-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Sage Intacct.
-
Connect to Redshift from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Amazon Redshift, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use Databricks Agent Bricks to Talk to Your Amazon Marketplace Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Amazon Marketplace for you.
-
Create a Data Access Object for Workday Data using JDBI
A brief overview of creating a SQL Object API for Workday in JDBI.
-
Use the CData Software ODBC Driver for DocuSign in SAS for Real-Time Reporting and Analytics
Connect to real-time DocuSign in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for DocuSign.
-
Use the CData Software ODBC Driver for Cohere in MicroStrategy Web
Connect to Cohere in MicroStrategy Web using the CData Software ODBC Driver for Cohere.
-
Connect to Tavily from a Connection Pool in WebLogic
Use the CData JDBC Driver for Tavily to connect to Tavily from Web applications running on WebLogic.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Instagram
Provide connectivity to Instagram through an SAP BusinessObjects universe.
-
Use Grok to Talk to Your WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your WooCommerce for you.
-
How to connect and process OData from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live OData.
-
Create Power BI Reports on Real-Time Clari Data
Use the CData ODBC Driver for Clari to visualize Clari in Power BI Desktop.
-
Access Pipeline CRM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Pipeline CRM from HeidiSQL.
-
How to Connect to Live Oracle Eloqua Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Oracle Eloqua securely in real time.
-
Access Live Airtable Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Airtable from your Google Sheets.
-
Getting Started with the CData Excel Add-In for Gmail
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Gmail.
-
Use CData Connect AI to Access Microsoft Entra ID Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Microsoft Entra ID in the Power Pivot business intelligence tool.
-
Add Tickspot Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Tickspot with the Informatica Enterprise Data Catalog to classify and organize data.
-
View Reports on Real-Time Webex Data in Power BI Report Server
Use the CData ODBC Driver for Webex to visualize Webex in Power BI Desktop and then publish them to Power BI Report Server.
-
Migrating data from Freshsales to Databricks using CData SSIS Components.
Easily push Freshsales to Databricks using the CData SSIS Tasks for Freshsales and Databricks.
-
Connect to Landbot Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Landbot.
-
Connect to Superchat Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Superchat and the SQL Gateway to access Superchat from Google Apps Script.
-
Stream Moosend Data into Apache Kafka Topics
Access and stream Moosend in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating LangGraph with Paylocity Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Paylocity within automated workflows.
-
Migrating data from Foursquare to Snowflake using CData SSIS Components.
Easily push Foursquare to Snowflake using the CData SSIS Tasks for Foursquare and Snowflake.
-
Analyze Jodoo Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Jodoo with the CData JDBC Driver for Jodoo.
-
Automated Continuous Clari Replication to Snowflake
Use CData Sync for automated, continuous, customizable Clari replication to Snowflake.
-
Integrate Epicor Kinetic Data into Power Automate Desktop using CData Connect
CData Connect for Epicor Kinetic Data enables you to integrate Epicor Kinetic into workflows built using Microsoft Power Automate Desktop.
-
Analyze Microsoft OneDrive Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Microsoft OneDrive and visualize live Microsoft OneDrive in Infragistics Reveal.
-
Getting Started with the CData Power BI Connector for Attio
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build AI/ML Models with Live Google Cloud Storage Data using Dataiku
Connect Google Cloud Storage Data with Dataiku using the CData JDBC Driver for Google Cloud Storage.
-
Access Microsoft Planner Data from MySQL in PHP
Connect to Microsoft Planner through the standard MySQL libraries in PHP.
-
Connect to Teamwork Data in CloverDX (formerly CloverETL)
Transfer Teamwork using the visual workflow in the CloverDX data integration tool.
-
How to connect to QuickBooks Time Data from Spring Boot
Connect to QuickBooks Time in a Spring Boot Application using the CData JDBC Driver for QuickBooks Time
-
Access Live Mailgun Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Mailgun into the statistical analysis tools available in SAS JMP. This article shows how to use Mailgun in the Graph Builder and Query Builder.
-
DataBind Controls to Avaza Data in Delphi
DataBind to Avaza in Delphi with standard data access components and controls.
-
Connect to Azure Analysis Services Data in Aqua Data Studio
Access Azure Analysis Services from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Prepare, Blend, and Analyze eBay Data in Alteryx Designer (ODBC)
Build workflows to access live eBay for self-service data analytics.
-
Access Live Azure DevOps Data in TIBCO Data Virtualization
Use the Azure DevOps Tibco DV Adapter to create a Azure DevOps data source in TIBCO Data Virtualization Studio and gain access to live Azure DevOps from your TDV Server.
-
Integrating GitHub Copilot CLI with Insightly 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 SSIS Components for Hacker News
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Hacker News.
-
Access Live Odoo 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 Odoo ERP through MCP integration.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Microsoft SQL Server within intelligent workflows.
-
Integrating GitHub Copilot CLI with Google Cloud Storage 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.
-
Integrate NASA with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate NASA with External Services.
-
Moving Data from Hubstaff to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Hubstaff data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use Microsoft Copilot Studio to talk to your MariaDB 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 MariaDB for you.
-
Connect to Quickbase Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Quickbase in the Denodo Virtual DataPort Administrator.
-
How to use SQLAlchemy ORM to access Sage Cloud Accounting Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sage Business Cloud Accounting.
-
How to Connect to Live SendGrid 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 SendGrid for you.
-
Integrating Boomi Agentstudio with SAP Concur Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SAP Concur, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Create Dynamic Humanity Grids Using the Infragistics XamDataGrid
Learn how you can connect Humanity to Infragistics XamDataGrid to build dynamic grids.
-
Access Google Sheets Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Sheets from your Oracle system.
-
Analyze WooCommerce Data in Cognos Analytics
Use CData Connect AI to connect to WooCommerce Data from Cognos Analytics and analyze live WooCommerce.
-
Connect to ZeroBounce Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ZeroBounce and work with ZeroBounce in your FileMaker applications.
-
How to Design Wave Financial Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Wave Financial from mobile and tablet Power Apps.
-
Integrating LangChain with Salesforce CRM Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Salesforce CRM Analytics within automated workflows.
-
Build Charts with PagerDuty Data in Clear Analytics
Create dynamic charts and perform analytics based on PagerDuty in Clear Analytics.
-
A PostgreSQL Interface for Couchbase Data (MySQL Remoting via JDBC)
Use the Remoting features of the Couchbase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Apify Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Apify and work with Apify in your FileMaker application.
-
Connect to Wistia Data from PowerBuilder via ADO.NET
This article demonstrates how to access Wistia from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to LionDesk Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to LionDesk and work with LionDesk in your FileMaker application.
-
Integrate Live AdRoll Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live AdRoll to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Connect to Live EnterpriseDB Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your EnterpriseDB for you.
-
How to Connect DBeaver to Reply.io via a JDBC Driver
Manage Reply.io with visual tools in DBeaver like the query browser.
-
Working with PabblySubscriptions Data in LINQPad
Execute LINQ queries to PabblySubscriptions in LINQPad.
-
Create Power BI Reports on Real-Time Excel Online Data
Use the CData ODBC Driver for Excel Online to visualize Microsoft Excel Online in Power BI Desktop.
-
Connect to Outreach.io Data in CloverDX (formerly CloverETL)
Transfer Outreach.io using the visual workflow in the CloverDX data integration tool.
-
Replicate Adobe Commerce Data from PowerShell
Write a quick PowerShell script to query Adobe Commerce. Use connectivity to the live data to replicate Adobe Commerce to SQL Server.
-
How to Build an ETL App for Azure Analysis Services Data in Python with CData Connect AI
Build ETL pipelines that read and write live Azure Analysis Services in Python with petl and the CData Connect AI Python SDK.
-
Access Live Zoho Projects Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Zoho Projects from your Excel spreadsheets.
-
How to Seamlessly Import Sybase Data into IBM SPSS Modeler
Integrate Sybase data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Build an ETL App for SAP SuccessFactors Data in Python with CData
Create ETL applications and real-time data pipelines for SAP SuccessFactors in Python with petl.
-
Connect to and Visualize Live RSS Feeds in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live RSS Feeds.
-
Create Gong-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Gong Data from Klipfolio and build custom visualizations using live Gong.
-
Connect to SAS xpt Data from a Connection Pool in Jetty
The SAS xpt JDBC Driver supports connection pooling: This article shows how to connect faster to SAS XPORT from Web apps in Jetty.
-
Import BigQuery Data Using Azure Data Factory
Use CData Connect AI to connect to BigQuery Data from Azure Data Factory and import live Google BigQuery.
-
Create Datasets from Adobe Analytics in Domo Workbench and Build Visualizations of Adobe Analytics Data in Domo
Use the CData Software ODBC Driver for Adobe Analytics to create datasets from Adobe Analytics in Domo Workbench and then build visualizations in the Domo service.
-
Consume Slack OData Feeds in PowerBuilder
This article demonstrates how to consume Slack as OData feeds from PowerBuilder using the API Server.
-
Automated Continuous Stripe Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Stripe replication to Amazon Redshift.
-
Access SAP Fieldglass Data from MySQL in Amazon QuickSight
Connect to SAP Fieldglass and build visualizations of SAP Fieldglass using a MySQL Connection in Amazon QuickSight.
-
Query Highrise Data in DataGrip
Create a Data Source for Highrise in DataGrip and use SQL to query live Highrise CRM.
-
Getting Started with the CData Python Connector for OneNote
Learn to install and license the CData Python Connector
-
Model, Search, and Visualize Live Dropbox Data in ThoughtSpot
Use CData Connect AI to connect to live Dropbox for modeling, searching, and visualizing.
-
Automated Continuous Sugar CRM Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Sugar CRM replication to Google BigQuery.
-
Query Snapchat Ads Data as a SQL Server Database in Node.js
Execute SQL Server queries against Snapchat Ads from Node.js.
-
How to Query Live Azure Analysis Services Data in Perplexity MacOS Desktop
Connect to and query live Azure Analysis Services Data in Perplexity Desktop using CData MCP Server.
-
Model, Search, and Visualize Live Power BI XMLA Data in ThoughtSpot
Use CData Connect AI to connect to live Power BI XMLA for modeling, searching, and visualizing.
-
How to connect Amazon QuickSight to MariaDB Data
Create a connection to MariaDB in CData Connect AI and insert MariaDB into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous Flowlu Replication to SQLite
Use CData Sync for automated, continuous, customizable Flowlu replication to SQLite.