CData Software - Knowledge Base
Recent Articles
-
Analyze Presto Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Presto from Power Pivot. You will use the Table Import Wizard to load Presto. You can visually build the import query or use any SQL supported by the driver.
-
Build AI Agents with Microsoft Entra ID 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 Microsoft Entra ID through CData Connect AI.
-
Manage BambooHR Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for BambooHR.
-
DataBind SAP BusinessObjects BI Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAP BusinessObjects BI with the DevExpress Windows Forms and Web controls to provide SAP BusinessObjects BI to a chart.
-
How to load Blackbaud FE NXT data into Elasticsearch via Logstash
Introducing a simple method to load Blackbaud FE NXT data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Back Up Neo4J to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Neo4J. In this article, we will employ an SSIS workflow to populate a database with Neo4J data.
-
How to Import Data from SAP HANA XS Advanced into Google Sheets
Import SAP HANA XS Advanced into a Google spreadsheet that is automatically refreshed.
-
Add ElevenLabs Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ElevenLabs with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect Lakebase to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Lakebase using the CData Python MCP Server.
-
Visualize MailerSend Data in Tableau
The CData ODBC driver for MailerSend enables you integrate MailerSend into Tableau dashboards.
-
Access Live Gmail 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 Gmail through MCP integration.
-
How to Access Live Copper Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Copper from the Cline extension in Visual Studio Code.
-
Integrating Claude Code with Zendesk Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Zendesk within assisted coding and automated development workflows.
-
Query Google Directory Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Directory entities in PHP by modeling them as objects.
-
Use Claude to Talk to Your Outreach.io 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 Outreach.io for you.
-
Consume Xero OData Feeds in PowerBuilder
This article demonstrates how to consume Xero Accounting as OData feeds from PowerBuilder using the API Server.
-
Prepare, Blend, and Analyze Webflow Data in Alteryx Designer (ODBC)
Build workflows to access live Webflow for self-service data analytics.
-
Creating SurveyMonkey-Connected Applications in Unqork
You can use CData Connect AI to feed SurveyMonkey to Unqork and build custom business apps.
-
Consume Close OData Feeds in PowerBuilder
This article demonstrates how to consume Close as OData feeds from PowerBuilder using the API Server.
-
Connect to Gumroad Data in Ruby
Connect to Gumroad in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Visualizations of Clockify Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Clockify in Birst.
-
Connect to TaxJar Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time TaxJar using standard SQL.
-
Connect to Zoho Books Data from AWS Glue
Use CData Connect AI to gain access to live Zoho Books from your AWS Glue jobs.
-
Connect to Dynamics NAV Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft Dynamics NAV in DBeaver.
-
How to connect SharePoint with SAP Ariba Procurement Data through external lists
Provide SAP Ariba Procurement to SharePoint users as an external list.
-
DataBind Controls to FormSite Data in C++Builder
DataBind to FormSite in C++Builder with standard components and controls.
-
Build Adobe Target-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Adobe Target to explore live Adobe Target Data in Gemini Code Assist to assist with building Adobe Target-powered applications.
-
Prepare, Blend, and Analyze Todoist Data in Alteryx Designer (ODBC)
Build workflows to access live Todoist for self-service data analytics.
-
How to Easily Query Short.io Data in OpenOffice Base
Connect to Short.io data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Hubstaff from a Connection Pool in WebLogic
Use the CData JDBC Driver for Hubstaff to connect to Hubstaff from Web applications running on WebLogic.
-
Build Reply.io-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Reply.io Data in Gemini Code Assist to assist with building Reply.io-powered applications.
-
How to connect SharePoint with MailerLite Data through external lists
Provide MailerLite to SharePoint users as an external list.
-
Feed Spotify Data into FineReport
How to set Spotify as a JDBC data source in FineReport.
-
How to create an RPA flow for xBase Data in UiPath Studio
Use the xBase ODBC Driver to create workflows that access real-time xBase without any coding.
-
How to Seamlessly Import HubSpot Data into IBM SPSS Modeler
Integrate HubSpot data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrating LangGraph with Microsoft Dataverse Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Microsoft Dataverse (CDS) within automated workflows.
-
Configure the CData JDBC Driver for Google Calendar in a Connection Pool in Tomcat
Connect to Google Calendar from a connection pool in Tomcat.
-
Use Claude to Talk to Your SAP Concur 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 SAP Concur for you.
-
How to Work with Dropbox Data in AWS Glue Jobs Using JDBC
Connect to Dropbox from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to ShipStation Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ShipStation as an External Source in Dremio.
-
Build Apps with Live Toggl Data Using the Low-Code Development Platform of Mendix
Connect Toggl with Mendix to build apps using the CData API Driver for JDBC.
-
Access Live ScrapingBee Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ScrapingBee into the statistical analysis tools available in SAS JMP. This article shows how to use ScrapingBee in the Graph Builder and Query Builder.
-
How to Easily Query Gumroad Data in OpenOffice Base
Connect to Gumroad data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Basecamp Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Basecamp using standard SQL.
-
Connect to Oracle Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Oracle to connect to Oracle Database and execute queries in PowerBuilder.
-
Connect and Query Live ADP Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live ADP into Databricks
-
Connect to Miro Data in Aqua Data Studio
Access Miro from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Outreach.io-Connected Apps in Choreo
Use CData Connect AI to connect to Outreach.io Data from Choreo and build custom apps using live Outreach.io.
-
Explore Geographical Relationships in Marketo Data with Power Map
Create data visualizations with Marketo in Power Map.
-
Automate Google Ad Manager Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Google Ad Manager and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Create SSAS Tabular Models from Amplitude Data
How to build a SQL Server Analysis Service Tabular Model from Amplitude using CData drivers.
-
Integrating OpenCode Terminal with Box 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 and Visualize Live MySQL Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MySQL.
-
How to Query Live Access Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft Access data in natural language using Python.
-
Deploy the ADO.NET Provider for iContact on an SSRS Report Server
Connect to iContact 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 Apps with Live Certinia in Adalo using CData Connect AI
Use CData Connect AI to integrate live Certinia into the Adalo platform and build custom mobile and web applications with real-time Certinia.
-
Connect to and Query Splunk Data in QlikView over ODBC
Create data visualizations with Splunk in QlikView.
-
Connect to Factorial Data in RapidMiner
Integrate Factorial with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Webflow Data from MySQL in Amazon QuickSight
Connect to Webflow and build visualizations of Webflow using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous ActiveCampaign Replication to SQLite
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to SQLite.
-
Import Real-Time CockroachDB Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use CockroachDB in ColdFusion.
-
How to Connect to Live Salesforce Marketing 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 Salesforce Marketing Cloud for you.
-
Integrate Open WebUI with Live OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft OneNote from within the chat interface.
-
Build Apps with Live Retently Data Using the Low-Code Development Platform of Mendix
Connect Retently with Mendix to build apps using the CData API Driver for JDBC.
-
Visualize Aircall Data in TIBCO Spotfire through OData
Integrate Aircall into dashboards in TIBCO Spotfire.
-
Back Up Placid to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Placid data.
-
Connect to Close Data in CloverDX (formerly CloverETL)
Transfer Close using the visual workflow in the CloverDX data integration tool.
-
Enable the DocuSign JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with DocuSign.
-
Automated Continuous Dynamics 365 Business Central Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to IBM DB2.
-
Access Zoho Books Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Zoho Books.
-
Automate HelloSign Data Replication to SAP HANA
Use CData Sync to customize and automate HelloSign replication to SAP HANA.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Acumatica
Provide connectivity to Acumatica ERP through an SAP BusinessObjects universe.
-
Integrating Claude Code CLI with Adobe Analytics 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.
-
Write a Simple Go Application to work with EmailOctopus Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to EmailOctopus.
-
How to Import Data from Dynamics CRM into Google Sheets
Import Microsoft Dynamics CRM into a Google spreadsheet that is automatically refreshed.
-
Automate Factorial Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Factorial from PowerShell? This article demonstrates how to utilize the Factorial Cmdlets for tasks like connecting to Factorial, automating operations, downloading data, and more.
-
Migrating data from Recurly to Databricks using CData SSIS Components.
Easily push Recurly to Databricks using the CData SSIS Tasks for Recurly and Databricks.
-
Create Informatica Mappings From/To an ODBC Data Source for Databricks
Create an ODBC connection to Databricks in Informatica and browse and transfer Databricks.
-
Create Splunk-Connected Applications in Appsmith
Connect to Splunk Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Splunk.
-
Use the CData Software ODBC Driver for TigerGraph in MicroStrategy Desktop
Connect to TigerGraph in MicroStrategy Desktop using the CData Software ODBC Driver for TigerGraph.
-
Getting Started with the CData Power BI Connector for Sage Cloud Accounting
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Sage Cloud Accounting.
-
Viewing Microsoft Exchange Data in RAD Studio Data Explorer
How to view Microsoft Exchange in RAD Studio Data Explorer using the CData ODBC Driver for Microsoft Exchange.
-
How to Work with Microsoft Dataverse Data in ETL Validator JDBC
Connect to Microsoft Dataverse from ETL Validator jobs using the CData Software JDBC Driver.
-
How to integrate Metabase with Act-On Data
Use CData Connect AI to connect to live Act-On and create an interactive dashboard in Metabase from Act-On.
-
Connect to and Query Dynamics 365 Data in QlikView over ODBC
Create data visualizations with Microsoft Dynamics 365 in QlikView.
-
Build Dashboards with Deel Data in Dundas BI
Create dynamic dashboards and perform analytics based on Deel in Dundas BI.
-
Access Live Sage 200 Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Sage 200 from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Connect to Live Microsoft Exchange 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 Microsoft Exchange for you.
-
How to create Helpscout federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Helpscout in MySQL .
-
Use the CData Software ODBC Driver for WooCommerce in MicroStrategy
Connect to WooCommerce in MicroStrategy Developer using the CData Software ODBC Driver for WooCommerce.
-
Replicate Wrike Data from PowerShell
Write a quick PowerShell script to query Wrike. Use connectivity to the live data to replicate Wrike to SQL Server.
-
Add Float Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Float with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect Office 365 Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Office 365 data in real time using natural language.
-
Automated Continuous Excel Online Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Excel Online replication to Google Cloud SQL.
-
Use the CData Software JDBC Driver for Salesforce Pardot in MicroStrategy
Connect to Salesforce Pardot in MicroStrategy Developer using the CData Software JDBC Driver for Salesforce Pardot.
-
Extend Google Sheets with Keap Data
Make calls to Keap from Google Apps Script via the API Server.
-
Getting Started with the CData Excel Add-In for Clari
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Clari.
-
How to Connect DBeaver to Dynamics NAV via a JDBC Driver
Manage Microsoft Dynamics NAV with visual tools in DBeaver like the query browser.
-
Getting Started with the CData JDBC Driver for Mode
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Mode.
-
Integrate with SurveyMonkey Data in JReport Designer
Create charts and reports based on SurveyMonkey in JReport Designer.