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.
-
Bind Live MarkLogic Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live MarkLogic data
-
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.
-
Integrating Claude Code CLI with Qualaroo 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 Raisers Edge NXT Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Raisers Edge NXT as an External Source in Dremio.
-
Load Deel Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Deel to a database.
-
Use CData Connect AI to Access Avro Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Apache Avro in the Power Pivot business intelligence tool.
-
Connect to Oracle SCM Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Oracle SCM using standard SQL.
-
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.
-
Create SSAS Tabular Models from CampaignMonitor Data
How to build a SQL Server Analysis Service Tabular Model from CampaignMonitor using CData drivers.
-
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.
-
How to Query Live Qualaroo Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Qualaroo data in natural language using Python.
-
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.
-
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 to Live MariaDB Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your MariaDB 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.
-
Query Reply.io Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Reply.io from Node.js.
-
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.
-
Automate Shortcut Data Replication to SAP HANA
Use CData Sync to customize and automate Shortcut replication to SAP HANA.
-
Integrate ElevenLabs Data in Pentaho Data Integration
Build ETL pipelines based on ElevenLabs in the Pentaho Data Integration tool.
-
Automated Continuous FreeAgent Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable FreeAgent replication to OneLake in Microsoft Fabric.
-
Enable the PolarTeamPro JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with PolarTeamPro.
-
Build Dashboards with Close Data in DBxtra
Create dynamic dashboards and perform analytics based on Close in DBxtra.
-
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.
-
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.
-
Replicate Avalara AvaTax Data from PowerShell
Write a quick PowerShell script to query Avalara AvaTax. Use connectivity to the live data to replicate Avalara AvaTax to SQL 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.
-
Integrate Cline with Live Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Sybase IQ from within your IDE.
-
How to connect to SAS xpt Data from IntelliJ
Integrate connectivity to SAS XPORT with wizards in IntelliJ.
-
Validate Excel Online Data with QuerySurge
Access and validate Microsoft Excel Online in QuerySurge using the CData JDBC Driver.
-
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.
-
Build Confluence-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Confluence to explore live Confluence Data in Gemini Code Assist to assist with building Confluence-powered applications.
-
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.
-
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.
-
Connect to SAP Data in NetBeans
Connect to SAP ERP/NetWeaver in NetBeans with the data source configuration wizard.
-
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.
-
Integrating Codex CLI with Acumatica ERP 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.
-
Connecting Agentforce with LinkedIn 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 LinkedIn for you.
-
Automated Continuous AlloyDB Replication to SingleStore
Use CData Sync for automated, continuous, customizable AlloyDB replication to SingleStore.
-
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.
-
How to connect to ZohoSubscriptions Data in DBVisualizer
Integrate ZohoSubscriptions with visual data analysis tools and data connection wizards in DBVisualizer
-
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.
-
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.
-
Use Biml to Build SSIS Tasks to Replicate Opsgenie Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Opsgenie to SQL Server.
-
Integrate NASA with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate NASA with External Services.
-
Query Live Salesforce 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 Salesforce & Force.com directly from the development environment.
-
Automated Continuous Snapchat Ads Replication to SQLite
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to SQLite.
-
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.
-
Create Dynamic Humanity Grids Using the Infragistics XamDataGrid
Learn how you can connect Humanity to Infragistics XamDataGrid to build dynamic grids.
-
How to Work with PDFMonkey Data in AWS Glue Jobs Using JDBC
Connect to PDFMonkey from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
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.
-
Build Charts with Mailgun Data in Clear Analytics
Create dynamic charts and perform analytics based on Mailgun in Clear Analytics.
-
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.
-
Consume Spotify OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Spotify feeds that reflect any changes in SAP Lumira.
-
How to connect Amazon QuickSight to Azure Synapse Data
Create a connection to Azure Synapse in CData Connect AI and insert Azure Synapse into Amazon QuickSight SPICE to build interactive dashboards.
-
Enable the Calendly JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Calendly.
-
Visualize Sybase Data in TIBCO Spotfire through ADO.NET
Integrate Sybase into dashboards in TIBCO Spotfire.
-
How to connect to PingOne Data in DBVisualizer
Integrate PingOne with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Data Visualizations in Cognos BI with REST Data
Access REST as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Working with MongoDB Data in LINQPad
Execute LINQ queries to MongoDB in LINQPad.
-
Access Mistral AI Data from MySQL in Amazon QuickSight
Connect to Mistral AI and build visualizations of Mistral AI using a MySQL Connection in Amazon QuickSight.
-
Trello Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Trello through CData Connect AI using different applications and tools.
-
Build AI Agents with Airtable 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 Airtable through CData Connect AI.
-
How to Connect to & Open ConvertKit Data in Microsoft Excel
This article uses the CData ODBC driver for ConvertKit to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Provide OData Services of Customer.io Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Customer.io by developing a WCF Service Application.
-
Connect to Rebilly Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Rebilly and work with Rebilly in your FileMaker applications.
-
Connect to Outreach.io Data in CloverDX (formerly CloverETL)
Transfer Outreach.io using the visual workflow in the CloverDX data integration tool.
-
Connect and Query Live Email Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Email into Databricks
-
Connect to ServiceDesk Plus Data in CloverDX (formerly CloverETL)
Transfer ServiceDesk Plus using the visual workflow in the CloverDX data integration tool.
-
Publish Avro-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Apache Avro.
-
Use the CData Software JDBC Driver for PhantomBuster in MicroStrategy Web
Connect to PhantomBuster in MicroStrategy Web using the CData Software JDBC Driver for PhantomBuster.
-
Build Dashboards with Wave Financial Data in Dundas BI
Create dynamic dashboards and perform analytics based on Wave Financial in Dundas BI.
-
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.
-
Stream Dynamics CRM Data into Apache Kafka Topics
Access and stream Microsoft Dynamics CRM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Visualize REST Data in Python with pandas
Use pandas and other modules to analyze and visualize live REST in Python.
-
Visualize Coinbase Data in TIBCO Spotfire through OData
Integrate Coinbase into dashboards in TIBCO Spotfire.
-
Use the CData ODBC Driver for Quaderno in Microsoft Power Query
You can use the CData Quaderno ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Quaderno into Microsoft Power Query.
-
Edit and Search Keap External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Keap to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Keap objects that you can access from apps and the dashboard.
-
Build Charts with Unbounce Data in Clear Analytics
Create dynamic charts and perform analytics based on Unbounce in Clear Analytics.
-
Import and Visualize Dynamics CRM Data in Power View
Create data visualizations based on Microsoft Dynamics CRM in Excel.
-
Integrate Live Reply.io Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Reply.io to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Publish Reports with Webex Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Webex.
-
Build Tally-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Tally ERP and build web apps with connectivity to live Tally ERP.
-
Enable the Microsoft Planner JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft Planner.
-
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.
-
Automated Continuous Hubstaff Replication to SQL Server
Use CData Sync for automated, continuous, customizable Hubstaff replication to SQL Server.
-
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.
-
Query Highrise Data in DataGrip
Create a Data Source for Highrise in DataGrip and use SQL to query live Highrise CRM.
-
Model, Search, and Visualize Live Dropbox Data in ThoughtSpot
Use CData Connect AI to connect to live Dropbox for modeling, searching, and visualizing.
-
Integrate Google Analytics Data in Pentaho Data Integration
Build ETL pipelines based on Google Analytics in the Pentaho Data Integration tool.
-
Query Snapchat Ads Data as a SQL Server Database in Node.js
Execute SQL Server queries against Snapchat Ads from Node.js.