CData Software - Knowledge Base
Recent Articles
-
Connect to Google Contacts Data in Aqua Data Studio
Access Google Contacts data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Cvent from a Connection Pool in WebLogic
Use the CData JDBC Driver for Cvent to connect to Cvent data from Web applications running on WebLogic.
-
Automate Salesforce Data Replication to SAP HANA
Use CData Sync to customize and automate Salesforce data replication to SAP HANA.
-
Import Real-Time Zoho Books Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Zoho Books data in ColdFusion.
-
Model, Search, and Visualize Live Dynamics 365 Business Central Data in ThoughtSpot
Use CData Connect AI to connect to live Dynamics 365 Business Central data for modeling, searching, and visualizing.
-
Publish Paddle-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Paddle data.
-
Integrate Live Reckon Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Reckon data from within the IDE.
-
Automate Zoho Books Data Replication to Azure Data Lake
Use CData Sync to customize and automate Zoho Books data replication to Azure Data Lake.
-
How to Query Live VWO Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live VWO data data in natural language using Python.
-
Build Tally-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Tally data without replication.
-
Enable the Cosmos DB JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Cosmos DB data.
-
Automated Continuous EmailOctopus Replication to SQL Server
Use CData Sync for automated, continuous, customizable EmailOctopus replication to SQL Server.
-
Use the CData Software JDBC Driver for Presto in MicroStrategy Desktop
Connect to Presto data in MicroStrategy Desktop using the CData Software JDBC Driver for Presto.
-
Import Real-Time SAP SuccessFactors Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP SuccessFactors data in ColdFusion.
-
Replicate Oracle Financials Cloud Data from PowerShell
Write a quick PowerShell script to query Oracle Financials Cloud data. Use connectivity to the live data to replicate Oracle Financials Cloud data to SQL Server.
-
Connect to Coda Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Coda and the SQL Gateway to access Coda data from Google Apps Script.
-
Integrate Goose with Live SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP Concur data from within the local AI agent.
-
Connect to Beeminder Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Beeminder to connect to Beeminder data and execute queries in PowerBuilder.
-
Integrate Eventbrite Data in the Pentaho Report Designer
Publish reports based on Eventbrite data in the Pentaho BI tool.
-
Use the CData SSIS Components to Insert New or Update Existing Zendesk Records from SQL Server
Easily push SQL Server data to Zendesk using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Zendesk or update existing records with data from a SQL Server database.
-
Integrate Devin with Live SFTP Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live SFTP data.
-
Automated Continuous Billsby Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Billsby replication to PostgreSQL.
-
Build MVC Applications with Connectivity to ADP Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ADP from an ASP.NET MVC application.
-
Visualize Hugging Face Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Hugging Face data.
-
Object-Relational Mapping (ORM) with Microsoft OneDrive 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 Microsoft OneDrive data into a Java-based ORM framework, Hibernate.
-
Build Visualizations of JSON Services in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of JSON services in Birst.
-
Use the CData Software JDBC Driver for ConvertKit in MicroStrategy Desktop
Connect to ConvertKit data in MicroStrategy Desktop using the CData Software JDBC Driver for ConvertKit.
-
Automate Clari Data Replication to SAP HANA
Use CData Sync to customize and automate Clari data replication to SAP HANA.
-
Automated Continuous Elorus Replication to MySQL
Use CData Sync for automated, continuous, customizable Elorus replication to MySQL.
-
Use JayDeBeApi to access ZohoInvoice Data in Python
Use standard Python scripting and the development environment of your choice to access live ZohoInvoice data.
-
Create a Data Access Object for Spark Data using JDBI
A brief overview of creating a SQL Object API for Spark data in JDBI.
-
Use CData Connect AI to Access Coda Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Coda data in the Power Pivot business intelligence tool.
-
Rapidly Develop Retently-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 Retently.
-
How to integrate Metabase with Coda Data
Use CData Connect AI to connect to live Coda data and create an interactive dashboard in Metabase from Coda data.
-
How to Connect to Live Egnyte Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Egnyte data through natural language.
-
Connect to and Visualize Live Bullhorn CRM Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Bullhorn CRM data.
-
How to integrate Qualaroo with Apache Airflow
Access and process Qualaroo data in Apache Airflow using the CData JDBC Driver.
-
DataBind Controls to JobNimbus Data in C++Builder
DataBind to JobNimbus data in C++Builder with standard components and controls.
-
Integrate Live Teradata Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Teradata data from within the IDE.
-
Access Dynamics 365 Business Central 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 Dynamics 365 Business Central data.
-
Publish Crystal Reports on Reckon Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Reckon data.
-
Integrate with AgileCRM Data in SnapLogic
Use CData Connect AI to connect to and integrate with live AgileCRM data in SnapLogic.
-
Connect to SFTP Data in RazorSQL
Connect to SFTP from wizards and query SFTP data from the GUI in the RazorSQL database management tool.
-
Create Dashboards and Visualize Live BigQuery Data in Geckoboard
Use CData Connect AI to connect to live BigQuery data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Extract, Transform, and Load Microsoft Entra ID Data in Informatica PowerCenter
Create a simple Workflow for Microsoft Entra ID data in Informatica PowerCenter.
-
Write a Simple Go Application to work with Mixpanel Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Mixpanel data.
-
How to Connect to Live Jira Assets Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Jira Assets data securely in real time.
-
Manage JobNimbus Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for JobNimbus.
-
Visualize Epicor Kinetic Data in TIBCO Spotfire through OData
Integrate Epicor Kinetic data into dashboards in TIBCO Spotfire.
-
Publish Reports with Elasticsearch Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Elasticsearch data.
-
Publish Crystal Reports on Cohere Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Cohere data.
-
Build a Singer.io Tap for Recurly With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Recurly data using the CData Python Connector.
-
Connect to SAS xpt Data in JRuby
Create a simple JRuby app with access to live SAS xpt data.
-
How to Query Sugar CRM Data in MySQL Workbench
Execute MySQL queries against live Sugar CRM data from MySQL Workbench.
-
Connect to NASA Data from PowerBuilder via ADO.NET
This article demonstrates how to access NASA data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build a PostgreSQL Interface for Supabase Data using the CData JDBC Driver
Use the Remoting features of the Supabase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query ZohoExpense Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ZohoExpense data from Node.js.
-
Connect to Coinbase Data in RazorSQL
Connect to Coinbase from wizards and query Coinbase data from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData ADO.NET Provider for Exa
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connecting Pipedream with ConstantContact Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on ConstantContact data in real time.
-
Automated Continuous Parquet Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Parquet replication to Apache Cassandra.
-
Explore Geographical Relationships in SAP Ariba Procurement Data with Power Map
Create data visualizations with SAP Ariba Procurement data in Power Map.
-
Connect to GraphQL Data in Aqua Data Studio
Access GraphQL data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
DataBind Charts to Hugging Face Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Hugging Face 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.
-
Connect to HubSpot Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live HubSpot data from Filemaker Pro on Mac.
-
Build Automated Workflows with Live Azure Synapse Data in Workato
Use CData Connect AI to connect to live Azure Synapse data and build automated workflows in Workato.
-
Access Live Yelp Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Yelp data through MCP integration.
-
How to connect to Miro Data with Squirrel SQL client
Connect to Miro data and execute queries in the Squirrel SQL Client.
-
Connect to Webex Data from PowerBuilder via ADO.NET
This article demonstrates how to access Webex data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Connect to Live Exact Online 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 Exact Online data for you.
-
Build SAP HANA-Connected Apps in Choreo
Use CData Connect AI to connect to SAP HANA Data from Choreo and build custom apps using live SAP HANA data.
-
Integrate LibreChat with Live Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Jira data from within the chat interface.
-
Integrating LangChain with Azure Table Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Azure Table data within automated workflows.
-
Build DocuSign-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live DocuSign data without replication.
-
How to create an RPA flow for Stripe Data in UiPath Studio
Use the Stripe ODBC Driver to create workflows that access real-time Stripe data without any coding.
-
View Reports on Real-Time SharePoint Excel Services Data in Power BI Report Server
Use the CData ODBC Driver for SharePoint Excel Services to visualize SharePoint Excel Services data in Power BI Desktop and then publish them to Power BI Report Server.
-
Configure the CData JDBC Driver for Snowflake in a Connection Pool in Tomcat
Connect to Snowflake data from a connection pool in Tomcat.
-
Integrate Theia IDE with Live Twilio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Twilio data from within the development environment.
-
Visualize Acumatica Data in Sisense
Create an ElastiCube in Sisense app with access to Acumatica data.
-
Access Live Wave Financial Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Wave Financial data from your Excel spreadsheets.
-
Automated Continuous ServiceNow Replication to MySQL
Use CData Sync for automated, continuous, customizable ServiceNow replication to MySQL.
-
Connect to Zoho Creator Data from HeidiSQL
Use CData Connect AI to connect to and query live Zoho Creator data from HeidiSQL.
-
Connect to and Visualize Live Exact Online Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Exact Online data.
-
How to Connect Google Directory 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 Google Directory data in real time using natural language.
-
Enable the BigQuery JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with BigQuery data.
-
Create SSAS Tabular Models from SurveyMonkey Data
How to build a SQL Server Analysis Service Tabular Model from SurveyMonkey data using CData drivers.
-
Bridge HBase Connectivity with Apache NiFi
Access and process HBase data in Apache NiFi using the CData JDBC Driver.
-
Integrating Cursor with Bugsnag 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.
-
Import and Visualize CouchDB Data in Power View
Create data visualizations based on CouchDB data in Excel.
-
Connect to Cvent Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Cvent and the SQL Gateway to access Cvent data from Google Apps Script.
-
Connect to Excel Online from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Excel Online data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate Jira with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Jira with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Jira data.
-
Connect to QuickBooks Time Data from PowerBuilder via JDBC
This article demonstrates how to access QuickBooks Time data from PowerBuilder using the QuickBooks Time JDBC Driver.
-
How to Visualize Browserless Data in Python with pandas
Use pandas and other modules to analyze and visualize live Browserless data in Python.
-
Automated Continuous Microsoft Ads Replication to Databricks
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to Databricks.
-
Greenplum Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Greenplum facts in real time.
-
Back Up DocuSign data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for DocuSign. In this article, we will employ an SSIS workflow to populate a database with DocuSign data data.
-
Automated Continuous Sage 200 Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Sage 200 replication to Azure SQL Database.
-
Access Live Procore Data in Coginiti Pro
Connect to and query live Procore data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Import Kintone Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Kintone Data and provide access to live Kintone data for custom reports in the Power BI Service.