CData Software - Knowledge Base
Recent Articles
-
Validate Apify Data with QuerySurge
Access and validate Apify in QuerySurge using the CData JDBC Driver.
-
How to connect to Deel Data in DBVisualizer
Integrate Deel with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Live Paylocity Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Paylocity from your Google Sheets.
-
Create Oracle Financials Cloud-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Oracle Financials Cloud Data from Klipfolio and build custom visualizations using live Oracle Financials Cloud.
-
How to Connect Flowise AI Agents to Live Odoo Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Odoo ERP without replication.
-
Build MVC Applications with Connectivity to QuickBooks Online Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access QuickBooks Online from an ASP.NET MVC application.
-
Add SageHR Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SageHR with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating LangChain with Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Salesforce Pardot within automated workflows.
-
Build Dashboards with Avaza Data in Dundas BI
Create dynamic dashboards and perform analytics based on Avaza in Dundas BI.
-
Build Delighted-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Delighted Data in Claude Code to assist with building Delighted-powered applications.
-
Automated Continuous Facebook Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Facebook replication to delimited files (CSV/TSV).
-
Build an OLAP Cube in SSAS from LaunchDarkly Data
Establish a connection to LaunchDarkly data from SQL Server Analysis Services, and use the LaunchDarkly Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrating Cursor CLI with FormSite 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 Browserless Data from MySQL in PHP
Connect to Browserless through the standard MySQL libraries in PHP.
-
How to Visualize Productboard Data in Python with pandas
Use pandas and other modules to analyze and visualize live Productboard in Python.
-
How to Connect Dropbox 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 Dropbox data in real time using natural language.
-
Connect to and Visualize Live AgileCRM Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live AgileCRM.
-
Migrating data from Splunk to Snowflake using CData SSIS Components.
Easily push Splunk to Snowflake using the CData SSIS Tasks for Splunk and Snowflake.
-
How to Query Live Oracle Service Cloud Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Oracle Service Cloud data in natural language using Python.
-
Connect to Exact Online Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Exact Online in the Denodo Virtual DataPort Administrator.
-
Integrate Live Anaplan Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Anaplan to Blue Prism using the CData ODBC Driver for Anaplan to create automated workflows for repetitive business tasks.
-
Back Up Teamgate 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 Teamgate data.
-
Operational Reporting on Ontraport Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Ontraport.
-
Integrate Vimeo Data in the Pentaho Report Designer
Publish reports based on Vimeo in the Pentaho BI tool.
-
Use the CData Software JDBC Driver for Brex in MicroStrategy
Connect to Brex in MicroStrategy Developer using the CData Software JDBC Driver for Brex.
-
How to Easily Query Adobe Commerce Data in OpenOffice Base
Connect to Adobe Commerce data in OpenOffice Base using the CData ODBC Driver for Adobe Commerce and generate reports with live data insights.
-
Rapidly Develop Tanda-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 Tanda.
-
Connect to Elasticsearch Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Elasticsearch Data and connect to Elasticsearch in Akorbi Digital RunMyProcess.
-
Migrating data from Google Spanner to Snowflake using CData SSIS Components.
Easily push Google Spanner to Snowflake using the CData SSIS Tasks for Google Spanner and Snowflake.
-
Create Informatica Mappings From/To an ODBC Data Source for Tanda
Create an ODBC connection to Tanda in Informatica and browse and transfer Tanda.
-
Build AI/ML Models with Live Google Translate Data using Dataiku
Connect Google Translate Data with Dataiku using the CData API Driver for JDBC.
-
How to integrate Bitbucket with Apache Airflow
Access and process Bitbucket in Apache Airflow using the CData JDBC Driver.
-
Connect Presto to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Presto using the CData Python MCP Server.
-
Build Automated Workflows with Live SAS xpt Data in Workato
Use CData Connect AI to connect to live SAS XPORT and build automated workflows in Workato.
-
Build Facebook-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Facebook Data and create custom apps in Mendix.
-
Connect to OpenWeatherMap in SpagoBI
Create reports featuring live OpenWeatherMap in SpagoBI Studio. Host OpenWeatherMap reports on SpagoBI Server.
-
Analyze Brex Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Brex with the CData JDBC Driver for Brex.
-
Integrate Live JotForm Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live JotForm to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect Greenhouse Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Greenhouse using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
ETL Workday in Oracle Data Integrator
This article shows how to transfer Workday into a data warehouse using Oracle Data Integrator.
-
Automated Continuous SuiteCRM Replication to Databricks
Use CData Sync for automated, continuous, customizable SuiteCRM replication to Databricks.
-
Create Reports from Zoho Projects Data in Looker Studio
Use CData Connect AI to gain access to live Zoho Projects and create custom reports in Looker Studio.
-
Consume ConvertAPI OData Feeds in PowerBuilder
This article demonstrates how to consume ConvertAPI as OData feeds from PowerBuilder using the API Server.
-
Perform Batch Operations with IBM Informix Data in Apache NiFi
Connect to IBM Informix and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automated Continuous BambooHR Replication to Vertica
Use CData Sync for automated, continuous, customizable BambooHR replication to Vertica.
-
Connect to Copper Data in HULFT Integrate
Connect to Copper as a JDBC data source in HULFT Integrate
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Apache Hive to Power BI dashboards. Simply drag and drop Apache Hive into data visuals on the Power BI canvas.
-
Build Shortcut-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Shortcut Data in Claude Code to assist with building Shortcut-powered applications.
-
Connect to Gumroad Data from PowerBuilder via JDBC
This article demonstrates how to access Gumroad from PowerBuilder using the Gumroad JDBC Driver.
-
How to Easily Query SAP Concur Data in OpenOffice Base
Connect to SAP Concur data in OpenOffice Base using the CData ODBC Driver for SAP Concur and generate reports with live data insights.
-
Connect Shortcut Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Shortcut using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use ChatGPT to Talk to Your MarkLogic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your MarkLogic for you.
-
Automated Continuous Mouseflow Replication to MongoDB
Use CData Sync for automated, continuous, customizable Mouseflow replication to MongoDB.
-
Access Live Xero Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Xero Accounting from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate Live Azure Data Lake Storage Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Azure Data Lake Storage from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Azure Data Lake Storage.
-
Integrate Microsoft Ads with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Microsoft Ads with External Services.
-
A PostgreSQL Interface for LinkedIn Data using the CData ODBC Driver
Use the SQL Gateway and LinkedIn ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use Manus AI to Talk to Your Lakebase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Lakebase.
-
How to import JotForm Data into Apache Solr
Use the CData Software JDBC Driver for JotForm in Data Import Handler and create an automated import of JotForm to Apache Solr Enterprise Search platform.
-
Import JobNimbus Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access JobNimbus. In this article, you will use the OData format to import JobNimbus into Microsoft Power Query.
-
Extract, Transform, and Load Google Calendar Data in Informatica PowerCenter
Create a simple Workflow for Google Calendar in Informatica PowerCenter.
-
How to connect to Adobe Commerce Data from IntelliJ
Integrate connectivity to Adobe Commerce with wizards in IntelliJ.
-
How to Connect DBeaver to Mailgun via a JDBC Driver
Manage Mailgun with visual tools in DBeaver like the query browser.
-
Integrating SAP ByDesign Data in Talend Cloud Data Management Platform
Connect SAP ByDesign Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP ByDesign.
-
Back Up Microsoft Dynamics NAV to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Dynamics NAV. In this article, we will employ an SSIS workflow to populate a database with Microsoft Dynamics NAV data.
-
Use Azure AI Foundry to Talk to Your Zoho CRM 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 Zoho CRM for you.
-
Visualize Google Tasks Data in Tableau
The CData ODBC driver for Google Tasks enables you integrate Google Tasks into Tableau dashboards.
-
Integrate Klipfolio with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Klipfolio with External Services.
-
Create SpaceX Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SpaceX data access from reports, embedded analytics, and more.
-
Connect to Oracle HCM Cloud Data in Aqua Data Studio
Access Oracle HCM Cloud from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Presto Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Presto from Filemaker Pro on Mac.
-
Build Insightly-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Insightly Data in Claude Code to assist with building Insightly-powered applications.
-
Access Live OData Services 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 OData through MCP integration.
-
How to integrate SAP Concur with Apache Airflow
Access and process SAP Concur in Apache Airflow using the CData JDBC Driver.
-
Validate Float Data with QuerySurge
Access and validate Float in QuerySurge using the CData JDBC Driver.
-
Analyze ZohoDesk Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ZohoDesk with the CData JDBC Driver for ZohoDesk.
-
Integrating Boomi Agentstudio with Power BI XMLA Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Power BI XMLA, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Analyze Retently Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Retently and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous Todoist Replication to Vertica
Use CData Sync for automated, continuous, customizable Todoist replication to Vertica.
-
Automated Ontraport Data Replication to Teradata
Use CData Sync to Customize and automate Ontraport replication to Teradata.
-
Create SSAS Tabular Models from Unbounce Data
How to build a SQL Server Analysis Service Tabular Model from Unbounce using CData drivers.
-
Create Dynamic Aweber Grids Using the Infragistics XamDataGrid
Learn how you can connect Aweber to Infragistics XamDataGrid to build dynamic grids.
-
Build Apps with Live Accelo Data Using the Low-Code Development Platform of Mendix
Connect Accelo with Mendix to build apps using the CData API Driver for JDBC.
-
Work with Google Translate Data in FoxPro
Load Google Translate into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Access Live Snapchat Ads Data in Visual Studio Code via Cline
Run CData MCP Server for Snapchat Ads on Windows Subsytem for Linux (WSL) and connect to live Snapchat Ads from the Cline extension in Visual Studio Code.
-
How to Connect the Power BI Service to SAP BusinessObjects BI: Complete Guide
Connect to the CData Software Power BI Connector for SAP BusinessObjects BI from PowerBI.com to provide real-time SAP BusinessObjects BI across the organization.
-
Create Datasets from Demio in Domo Workbench and Build Visualizations of Demio Data in Domo
Use the CData Software ODBC Driver for Demio to create datasets from Demio in Domo Workbench and then build visualizations in the Domo service.
-
How to Work with Hubstaff Data in ETL Validator JDBC
Connect to Hubstaff from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to PDFMonkey 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 PDFMonkey and work with PDFMonkey in your FileMaker application.
-
Migrating data from SAP SuccessFactors LMS to Google BigQuery using CData SSIS Components.
Easily push SAP SuccessFactors LMS to Google BigQuery using the CData SSIS Tasks for SAP SuccessFactors LMS and Google BigQuery.
-
Visualize Mouseflow Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Mouseflow.
-
Access Sugar CRM Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sugar CRM from your Oracle system.
-
Automated Continuous EnterpriseDB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to IBM DB2.
-
Build Dashboards with Gorgias Data in Dundas BI
Create dynamic dashboards and perform analytics based on Gorgias in Dundas BI.
-
Access Amazon Marketplace Data from MySQL in Amazon QuickSight
Connect to Amazon Marketplace and build visualizations of Amazon Marketplace using a MySQL Connection in Amazon QuickSight.
-
Use the CData API Server to Access CockroachDB Data in Microsoft PowerPivot
Use the CData API Server to connect to live CockroachDB in the Power Pivot business intelligence tool.
-
Integrate Zoho Creator Data into Power Automate Desktop using CData Connect
CData Connect for Zoho Creator Data enables you to integrate Zoho Creator into workflows built using Microsoft Power Automate Desktop.
-
Integrate Lakebase with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Lakebase with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Lakebase.
-
How to Connect Salesforce Marketing 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 Salesforce Marketing data in real time using natural language.
-
How to connect to PingOne Data with Squirrel SQL client
Connect to PingOne and execute queries in the Squirrel SQL Client.