CData Software - Knowledge Base
Recent Articles
-
DataBind Charts to Yelp Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Yelp data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Analyze TaxJar Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of TaxJar data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Access Pinecone Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Pinecone data from your Oracle system.
-
Visualize Live MYOB AccountRight Data in the Power BI Service
Use CData Connect AI to connect to live MYOB AccountRight data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous CSV Replication to MySQL
Use CData Sync for automated, continuous, customizable CSV replication to MySQL.
-
Publish Crystal Reports on Dotmailer Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Dotmailer data.
-
How to Connect to Live PingOne Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your PingOne data for you.
-
Connect to Google Search Results in Ruby
Connect to Google Search results in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate with Sentry Data in JReport Designer
Create charts and reports based on Sentry data in JReport Designer.
-
Connect to Vault CRM Data in RazorSQL
Connect to Vault CRM from wizards and query Vault CRM data from the GUI in the RazorSQL database management tool.
-
Query ChargeOver Data in DataGrip
Create a Data Source for ChargeOver in DataGrip and use SQL to query live ChargeOver data.
-
Build an OLAP Cube in SSAS from Sentry Data
Establish a connection to Sentry data data from SQL Server Analysis Services, and use the Sentry Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Data Visualizations Based On xBase Data in Mode
Use CData Connect AI to connect to xBase Data from Mode and build visualizations using live xBase data.
-
Integrate Trae with Live Tally Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Tally data from within the AI-powered IDE.
-
How to Connect DBeaver to Calendly via a JDBC Driver
Manage Calendly data with visual tools in DBeaver like the query browser.
-
Connect to FTP Data from HeidiSQL
Use CData Connect AI to connect to and query live FTP data from HeidiSQL.
-
Getting Started with the CData Python Connector for Nethunt
Learn to install and license the CData Python Connector and configure a connection to live Nethunt data.
-
How to connect to Twilio Data from Spring Boot
Connect to Twilio in a Spring Boot Application using the CData JDBC Driver for Twilio
-
Visualize Asana Data in TIBCO Spotfire through ADO.NET
Integrate Asana data into dashboards in TIBCO Spotfire.
-
Access Live Azure Table 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 Azure Table data through MCP integration.
-
Bridge Cosmos DB Connectivity with Apache NiFi
Access and process Cosmos DB data in Apache NiFi using the CData JDBC Driver.
-
Create Power BI Reports on Real-Time Apollo Data
Use the CData ODBC Driver for Apollo to visualize Apollo data in Power BI Desktop.
-
Use Claude to Talk to Your Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Greenplum data for you.
-
Connecting Mastra with Microsoft Planner Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Microsoft Planner data, no replication required.
-
Build Office 365-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Office 365 data.
-
Design BIRT Reports on Act-On Data
Provide current Act-On data to your embedded analytics.
-
Build Apps with Live Amazon Athena data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Amazon Athena data into the Adalo platform and build custom mobile and web applications with real-time Amazon Athena data.
-
DataBind Controls to Shippo Data in Delphi
DataBind to Shippo data in Delphi with standard data access components and controls.
-
Integrating LangChain with SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SQL Server data within automated workflows.
-
How to load Confluence data into Elasticsearch via Logstash
Introducing a simple method to load Confluence data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Dynamic Mailjet Grids Using the Infragistics XamDataGrid
Learn how you can connect Mailjet to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Shopify Data in Pentaho Data Integration
Build ETL pipelines based on Shopify data in the Pentaho Data Integration tool.
-
Migrating data from Dropbox to Snowflake using CData SSIS Components.
Easily push Dropbox data to Snowflake using the CData SSIS Tasks for Dropbox and Snowflake.
-
Automate Clockify Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Clockify data from PowerShell? This article demonstrates how to utilize the Clockify Cmdlets for tasks like connecting to Clockify data, automating operations, downloading data, and more.
-
Automate Vimeo Data Replication to SAP HANA
Use CData Sync to customize and automate Vimeo data replication to SAP HANA.
-
Using the CData Software ODBC Driver for Salesforce Marketing in PyCharm
Connect to Salesforce Marketing as an ODBC data source in PyCharm using the CData Software ODBC Driver for Salesforce Marketing.
-
Connect to Simplesat in SpagoBI
Create reports featuring live Simplesat data in SpagoBI Studio. Host Simplesat reports on SpagoBI Server.
-
Viewing Pinecone Data in RAD Studio Data Explorer
How to view Pinecone data in RAD Studio Data Explorer using the CData ODBC Driver for Pinecone.
-
Build Agents in Relevance AI with Access to Live ShipEngine Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on ShipEngine data within intelligent agent workflows.
-
Consume SAP Ariba Procurement OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP Ariba Procurement feeds that reflect any changes in SAP Lumira.
-
Getting Started with the CData SSIS Components for Salesforce CRM Analytics
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Salesforce CRM Analytics.
-
Access Live YouTube Analytics Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live YouTube Analytics data from your Excel spreadsheets.
-
Query Stack Exchange Data in ColdFusion
Write standard ColdFusion data access code to connect to Stack Exchange data.
-
Analyze EnterpriseDB Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for EnterpriseDB from Power Pivot. You will use the Table Import Wizard to load EnterpriseDB data. You can visually build the import query or use any SQL supported by the driver.
-
Excel Spreadsheet Automation on Microsoft Ads Data with the QUERY Formula
Pull data from Microsoft Ads, automate spreadsheets, and more with the QUERY formula.
-
Create Datasets from Tickspot in Domo Workbench and Build Visualizations of Tickspot Data in Domo
Use the CData Software ODBC Driver for Tickspot to create datasets from Tickspot data in Domo Workbench and then build visualizations in the Domo service.
-
View Reports on Real-Time Bright Data Data in Power BI Report Server
Use the CData ODBC Driver for Bright Data to visualize Bright Data data in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData Excel Add-In for Active Directory
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Active Directory.
-
Use the CData ODBC Driver for Samanage from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Samanage to connect to Samanage data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Samanage data in Excel.
-
Enable the Adobe Commerce JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Adobe Commerce data.
-
How to Access Live HubSpot Data in Power Automate Desktop via ODBC
The CData ODBC Driver for HubSpot enables you to integrate HubSpot data into workflows built using Microsoft Power Automate Desktop.
-
Build AI/ML Models with Live YouTube Analytics Data using Dataiku
Connect YouTube Analytics Data with Dataiku using the CData JDBC Driver for YouTube Analytics.
-
Use Agno to Talk to Your SendPulse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your SendPulse data for you.
-
Build Spark-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Spark data and build web apps with connectivity to live Spark data.
-
How to Access Hubstaff Data Using Entity Framework
This article shows how to access Hubstaff data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Consume SAP ByDesign OData Feeds in PowerBuilder
This article demonstrates how to consume SAP ByDesign data as OData feeds from PowerBuilder using the API Server.
-
DataBind OData Services to the DevExpress Data Grid
Use the CData ADO.NET Provider for OData with the DevExpress Windows Forms and Web controls to provide OData services to a chart.
-
Integrating Dataiku with Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Zoho Books data.
-
Use the CData Software JDBC Driver for CouchDB in MicroStrategy
Connect to CouchDB data in MicroStrategy Developer using the CData Software JDBC Driver for CouchDB.
-
Getting Started with the CData ODBC Driver for Grafana
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Grafana.
-
Replicate Sybase Data to Multiple Databases
Replicate Sybase data to disparate databases with a point-and-click configuration.
-
Integrating Claude Code CLI with Databricks 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.
-
Integrating LangChain with Shortcut Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Shortcut data within automated workflows.
-
Back Up SAP Ariba Procurement data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP Ariba Procurement. In this article, we will employ an SSIS workflow to populate a database with SAP Ariba Procurement data data.
-
Analyze Amazon DynamoDB Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Amazon DynamoDB data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to WooCommerce Data from a Connection Pool in JBoss
Integrate WooCommerce data into Java servlets: Use the Management Console in JBoss to install the WooCommerce JDBC Driver.
-
Integrate with Quickbase Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Quickbase data to a JSON file on disk.
-
Automate Codat Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Codat data from PowerShell? This article demonstrates how to utilize the Codat Cmdlets for tasks like connecting to Codat data, automating operations, downloading data, and more.
-
Build Apps with Live Aha! Data Using the Low-Code Development Platform of Mendix
Connect Aha! data with Mendix to build apps using the CData API Driver for JDBC.
-
Rapidly Develop Sybase-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 Sybase.
-
Integrating Codex with Hugging Face 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 Data Visualizations Based On SageHR Data in Mode
Use CData Connect AI to connect to SageHR Data from Mode and build visualizations using live SageHR data.
-
Build Visualizations of Neo4J Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Neo4J data in Birst.
-
Access Supabase Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Supabase data from HeidiSQL.
-
Working with Amazon DynamoDB Data in LINQPad
Execute LINQ queries to Amazon DynamoDB data in LINQPad.
-
Connect to Confluence Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Confluence and the SQL Gateway to access Confluence data from Google Apps Script.
-
Build an OLAP Cube in SSAS from Elorus Data
Establish a connection to Elorus data data from SQL Server Analysis Services, and use the Elorus Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Live Toggl Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Toggl data from your Excel spreadsheets.
-
Publish Crystal Reports on Omnisend Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Omnisend data.
-
Import Real-Time Wistia Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Wistia data in ColdFusion.
-
Create Reports from Avalara AvaTax Data in Looker Studio
Use CData Connect AI to gain access to live Avalara AvaTax data and create custom reports in Looker Studio.
-
Integrating Claude Code CLI with Wave Financial 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.
-
How to Connect to Live ZohoMarketingHub Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live ZohoMarketingHub data securely in real time.
-
Integrating Dataiku with Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Neo4J data.
-
Use Azure AI Foundry to Talk to Your HDFS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your HDFS data for you.
-
Integrate Open WebUI with Live LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live LinkedIn data from within the chat interface.
-
Visualize Live Procore Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Procore data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access FTP Data from MySQL in PHP
Connect to FTP through the standard MySQL libraries in PHP.
-
Automated Continuous Microsoft Planner Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to IBM DB2.
-
Access Live Google Sheets Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Sheets data from your Excel spreadsheets.
-
Integrate Real-Time Access to Zoho CRM in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Zoho CRM data in real time.
-
Import Act-On Data Using Azure Data Factory
Use CData Connect AI to connect to Act-On Data from Azure Data Factory and import live Act-On data.
-
How to Seamlessly Import Aweber Data into IBM SPSS Modeler
Integrate Aweber data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Replicate Gong Data to Multiple Databases via the CData Sync CLI
Replicate Gong data to disparate databases with a single configuration.
-
Connect to SQL Server Data in Ruby
Connect to SQL Server data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect Superchat to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Superchat data using the CData Python MCP Server.
-
Import Real-Time MariaDB Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use MariaDB data in ColdFusion.
-
Build AI/ML Models with Live FTP Data using Dataiku
Connect FTP Data with Dataiku using the CData JDBC Driver for FTP.
-
Prepare, Blend, and Analyze Google Cloud Storage Data in Alteryx Designer (ODBC)
Build workflows to access live Google Cloud Storage data for self-service data analytics.
-
Bridge Deel Connectivity with Apache NiFi
Access and process Deel data in Apache NiFi using the CData JDBC Driver.