CData Software - Knowledge Base
Recent Articles
-
Analyze SQL Server Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Microsoft SQL Server and visualize live Microsoft SQL Server in Infragistics Reveal.
-
Connect to BenchmarkEmail Data in DBeaver
Use the CData ODBC Driver to connect to BenchmarkEmail in DBeaver.
-
How to Work with Sage Intacct Data in ETL Validator JDBC
Connect to Sage Intacct from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Azure Table-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Azure Table Data from Klipfolio and build custom visualizations using live Azure Table Storage.
-
Use Claude to Talk to Your Zendesk 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 Zendesk for you.
-
Automated Continuous Lakebase Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Lakebase replication to Google Cloud SQL.
-
Connect to Twilio Data from Crystal Reports
Use CData Connect AI to connect to and report on live Twilio from Crystal Reports.
-
Analyze SQL Analysis Services Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SQL Analysis Services with the CData JDBC Driver for SQL Analysis Services.
-
How to connect to SAS Data Sets Data from Spring Boot
Connect to SAS Data Sets in a Spring Boot Application using the CData JDBC Driver for SAS Data Sets
-
How to Connect DBeaver to REST via a JDBC Driver
Manage REST with visual tools in DBeaver like the query browser.
-
Access Zoho Inventory 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 Inventory.
-
How to Access Live Teamwork Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Teamwork enables you to integrate Teamwork into workflows built using Microsoft Power Automate Desktop.
-
How to create an RPA flow for Procore Data in UiPath Studio
Use the Procore ODBC Driver to create workflows that access real-time Procore without any coding.
-
Building Dynamic Web Pages with Microsoft Teams Data Using AngularJS
Create single-page applications with live connectivity to Microsoft Teams using the CData API Server.
-
Automate MailChimp Integration Tasks from PowerShell
Are you in search of a quick and easy way to access MailChimp from PowerShell? This article demonstrates how to utilize the MailChimp Cmdlets for tasks like connecting to MailChimp, automating operations, downloading data, and more.
-
Create Power BI Reports on Real-Time Mistral AI Data
Use the CData ODBC Driver for Mistral AI to visualize Mistral AI in Power BI Desktop.
-
Connect to Coda Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Coda and work with Coda in your FileMaker applications.
-
Object-Relational Mapping (ORM) with Greenhouse Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Greenhouse into a Java-based ORM framework, Hibernate.
-
DataBind Controls to Pipeliner CRM Data in C++Builder
DataBind to Pipeliner CRM in C++Builder with standard components and controls.
-
Visualize ConstantContact Data in Sisense
Create an ElastiCube in Sisense app with access to ConstantContact.
-
Getting Started with the CData ADO.NET Provider for Salesforce
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Salesforce.
-
Build Notion-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Notion Data in GitHub Copilot to assist with building Notion-powered applications.
-
Use the CData ODBC Driver for Front from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Front to connect to Front from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Front in Excel.
-
Connect Quaderno Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Quaderno using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Consume Coda OData Feeds in PowerBuilder
This article demonstrates how to consume Coda as OData feeds from PowerBuilder using the API Server.
-
How to integrate Metabase with DocuSign Data
Use CData Connect AI to connect to live DocuSign and create an interactive dashboard in Metabase from DocuSign.
-
Analyze Oracle HCM Cloud Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Oracle HCM Cloud from Power Pivot. You will use the Table Import Wizard to load Oracle HCM Cloud. You can visually build the import query or use any SQL supported by the driver.
-
Import and Visualize Omnisend Data in Power View
Create data visualizations based on Omnisend in Excel.
-
Connect to Microsoft Ads Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Microsoft Ads.
-
Build MariaDB-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for MariaDB to explore live MariaDB Data in Cursor to assist with building MariaDB-powered applications.
-
Build MVC Applications with Connectivity to ClickUp Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ClickUp from an ASP.NET MVC application.
-
Excel Spreadsheet Automation on Beeminder Data with the QUERY Formula
Pull data from Beeminder, automate spreadsheets, and more with the QUERY formula.
-
Validate Hubstaff Data with QuerySurge
Access and validate Hubstaff in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Databricks Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Databricks replication to Amazon Redshift.
-
Integrate with Google Translate Data in JReport Designer
Create charts and reports based on Google Translate in JReport Designer.
-
Connect to SQL Server Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft SQL Server in the Denodo Virtual DataPort Administrator.
-
Integrating Claude Code CLI with Amazon Marketplace 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.
-
Build Visualizations of Aweber Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Aweber in Birst.
-
Integrating Dataiku with DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live DocuSign.
-
Visualize Live SFTP Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SFTP using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating OpenCode Terminal with Retently 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.
-
Use JayDeBeApi to access QuickBooks Online Data in Python
Use standard Python scripting and the development environment of your choice to access live QuickBooks Online.
-
Integrate Salesforce Pardot Data into Power Automate Desktop using CData Connect
CData Connect for Salesforce Pardot Data enables you to integrate Salesforce Pardot into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software JDBC Driver for Discord in MicroStrategy
Connect to Discord in MicroStrategy Developer using the CData Software JDBC Driver for Discord.
-
Connect to HubSpot Data in NetBeans
Connect to HubSpot in NetBeans with the data source configuration wizard.
-
Analyze JDBC-ODBC Bridge Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze JDBC-ODBC Bridge with the CData JDBC Driver for JDBC-ODBC Bridge.
-
Build Visualizations of Paylocity Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Paylocity in Birst.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Active Directory within intelligent workflows.
-
How to connect to Sybase Data from IntelliJ
Integrate connectivity to Sybase with wizards in IntelliJ.
-
Use the CData Software ODBC Driver for Oracle Sales in SAS for Real-Time Reporting and Analytics
Connect to real-time Oracle Sales in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Oracle Sales.
-
Connect to ADP Data from a Connection Pool in JBoss
Integrate ADP into Java servlets: Use the Management Console in JBoss to install the ADP JDBC Driver.
-
Build AI Agents with SAP SuccessFactors 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 SAP SuccessFactors through CData Connect AI.
-
Access Live Pingdom Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Pingdom data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Yelp Data from PowerBuilder via JDBC
This article demonstrates how to access Yelp from PowerBuilder using the Yelp JDBC Driver.
-
Connect to REST Data from PowerBuilder via ADO.NET
This article demonstrates how to access REST from Appeon PowerBuilder using the CData ADO.NET Provider for REST.
-
Access Dynamics 365 Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Dynamics 365 from HeidiSQL.
-
Build Dashboards with HubDB Data in DBxtra
Create dynamic dashboards and perform analytics based on HubDB in DBxtra.
-
Build MariaDB-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for MariaDB to explore live MariaDB Data in Claude Code to assist with building MariaDB-powered applications.
-
Connect to SharePoint Excel Services Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Oracle Service Cloud Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Oracle Service Cloud from HeidiSQL.
-
Integrating Kiro CLI with REST 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.
-
Access Vault CRM Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Veeva Vault & Vault CRM from your Oracle system.
-
DataBind Charts to Retently Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Retently 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.
-
Create Dynamics 365 Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Dynamics 365 data access from reports, embedded analytics, and more.
-
Work with Discord Data in FoxPro
Load Discord into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build a PostgreSQL Interface for MariaDB Data using the CData JDBC Driver
Use the Remoting features of the MariaDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze eBay Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of eBay and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Workable Data in JRuby
Create a simple JRuby app with access to live Workable.
-
How to connect to SendInBlue Data in DBVisualizer
Integrate SendInBlue with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating Kiro CLI with Mode 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.
-
Work with Greenhouse Data in FoxPro
Load Greenhouse into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect Hubstaff to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Hubstaff with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software JDBC Driver for eBay in MicroStrategy Web
Connect to eBay in MicroStrategy Web using the CData Software JDBC Driver for eBay.
-
How to Connect to Live SQL Server Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Microsoft SQL Server without replication.
-
Build Data Flows from Sentry to SQL Server using SSIS
Easily back up Sentry to SQL Server using the SSIS components for Sentry.
-
Connect to Vercel Data in NetBeans
Connect to Vercel in NetBeans with the data source configuration wizard.
-
Query Live SAP Netweaver Gateway 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 SAP Netweaver Gateway directly from the development environment.
-
Connect to Sugar CRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for Sugar CRM to connect to Sugar CRM from Web applications running on WebLogic.
-
Build SAP Concur Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Concur and build visualizations in Tableau Cloud.
-
Create Datasets from Copper in Domo Workbench and Build Visualizations of Copper Data in Domo
Use the CData Software ODBC Driver for Copper to create datasets from Copper in Domo Workbench and then build visualizations in the Domo service.
-
How to Connect to Live Vault CRM 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 Veeva Vault & Vault CRM for you.
-
Build Apps with Live Printful Data Using the Low-Code Development Platform of Mendix
Connect Printful with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate Short.io with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Short.io with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Short.io.
-
Rapidly Develop Humanity-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 Humanity.
-
Connect to Real-Time Quickbase Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Quickbase and Dataflow to import and use Quickbase in Power Apps.
-
Integrating Cursor CLI with Microsoft Dataverse 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 ScrapingBee Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ScrapingBee to connect to ScrapingBee and execute queries in PowerBuilder.
-
Use the CData Software ODBC Driver for Snowflake in MicroStrategy
Connect to Snowflake in MicroStrategy Developer using the CData Software ODBC Driver for Snowflake.
-
Deploy the ADO.NET Provider for Oracle SCM on an SSRS Report Server
Connect to Oracle SCM 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.
-
Access Live Salesforce CRM Analytics Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Salesforce CRM Analytics from your Google Sheets.
-
How to connect to Keap Data from Spring Boot
Connect to Keap in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate LibreChat with Live ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live ServiceNow from within the chat interface.
-
Connect to Webflow Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Webflow in the Denodo Virtual DataPort Administrator.
-
Integrate Oracle Sales with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Oracle Sales with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Oracle Sales.
-
Getting Started with the CData SSIS Components for eBay
Complete guide to installing, licensing, and connecting with the CData SSIS Components for eBay.
-
Excel Spreadsheet Automation on Teamwork Data with the QUERY Formula
Pull data from Teamwork, automate spreadsheets, and more with the QUERY formula.
-
Use the CData SSIS Components to Insert New or Update Existing Sugar CRM Records from SQL Server
Easily push SQL Server data to Sugar CRM using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Sugar CRM or update existing records with data from a SQL Server database.
-
DataBind Controls to CloudConvert Data in C++Builder
DataBind to CloudConvert in C++Builder with standard components and controls.
-
Integrating Cursor CLI with Klipfolio 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.
-
Bidirectional Access to ScrapingBee Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ScrapingBee in Filemaker Pro for Mac or Windows.