CData Software - Knowledge Base
Recent Articles
-
A PostgreSQL Interface for Monday.com Data using the CData ODBC Driver
Use the SQL Gateway and Monday.com ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Claude Code with Zoom Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Zoom within assisted coding and automated development workflows.
-
Access Google Drive Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Drive from your Oracle system.
-
Connect to SAP HANA XS Advanced Data in DBeaver
Use the CData ODBC Driver to connect to SAP HANA XS Advanced in DBeaver.
-
Work with Live Elasticsearch Data in Power Query
Use CData Connect AI to connect to Elasticsearch and work with live Elasticsearch in Microsoft Power Query.
-
Create Google Sheets Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Sheets from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAP Business One within intelligent workflows.
-
Query FHIR Data from Node.js
Use the OData endpoint of the CData API Server to connect to your FHIR and perform CRUD operations on FHIR from Node.js.
-
Work with Live Microsoft Exchange Data in Power Query
Use CData Connect AI to connect to Microsoft Exchange and work with live Microsoft Exchange in Microsoft Power Query.
-
Working with Teamgate Data in LINQPad
Execute LINQ queries to Teamgate in LINQPad.
-
Connect to Templated Data in HULFT Integrate
Connect to Templated as a JDBC data source in HULFT Integrate
-
Build Klaviyo-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Klaviyo to explore live Klaviyo Data in Cursor to assist with building Klaviyo-powered applications.
-
Automated Continuous CampaignMonitor Replication to MongoDB
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to MongoDB.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Amazon DynamoDB within intelligent workflows.
-
Query Box Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Box entities in PHP by modeling them as objects.
-
Import Real-Time Dynamics 365 Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Dynamics 365 in ColdFusion.
-
Use Databricks Agent Bricks to Talk to Your SAS xpt Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAS XPORT for you.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for GitHub
Provide connectivity to GitHub through an SAP BusinessObjects universe.
-
Build Dashboards with Humanity Data in Dundas BI
Create dynamic dashboards and perform analytics based on Humanity in Dundas BI.
-
Write a Simple Go Application to work with SAS Data Sets Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAS Data Sets.
-
Add ConstantContact Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ConstantContact with the Informatica Enterprise Data Catalog to classify and organize data.
-
Trigger SAP Netweaver Gateway IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SAP Netweaver Gateway with standard wizards in Logic Apps.
-
Create SSAS Tabular Models from Teradata Data
How to build a SQL Server Analysis Service Tabular Model from Teradata using CData drivers.
-
Enable the Raisers Edge NXT JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Raisers Edge NXT.
-
Migrating data from Eventbrite to Databricks using CData SSIS Components.
Easily push Eventbrite to Databricks using the CData SSIS Tasks for Eventbrite and Databricks.
-
Building Dynamic Web Pages with Google Drive Data Using AngularJS
Create single-page applications with live connectivity to Google Drive using the CData API Server.
-
Use Biml to Build SSIS Tasks to Replicate SAS xpt Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAS XPORT to SQL Server.
-
Connect to and Query Procore Data in QlikView over ODBC
Create data visualizations with Procore in QlikView.
-
Use Biml to Build SSIS Tasks to Replicate Office 365 Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Office 365 to SQL Server.
-
How to Connect Flowise AI Agents to Live Zoho Projects 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 Zoho Projects without replication.
-
How to connect and process Microsoft Dataverse (CDS) from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft Dataverse (CDS).
-
Integrate Live Microsoft Dataverse Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Build AI/ML Models with Live SAS Data Sets Data using Dataiku
Connect SAS Data Sets Data with Dataiku using the CData JDBC Driver for SAS Data Sets.
-
Connect to SAP Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP ERP/NetWeaver from Appeon PowerBuilder using the CData ADO.NET Provider for SAP.
-
Create Dynamics 365 Business Central-Connected Dashboards in Grafana
Connect to Dynamics 365 Business Central Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Dynamics 365 Business Central.
-
Faster Reporting using the QuickBooks Provider
The CData ADO.NET Provider for QuickBooks features advanced caching capabilities. The Auto Cache feature of the Data Provider can be used to execute expensive queries against a local, automatically updated cache.
-
How to Connect to Onfleet Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Onfleet. Leverage the pyodbc module for ODBC in Python.
-
How to connect to HubDB Data in DBVisualizer
Integrate HubDB with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Mixpanel Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Mixpanel using standard SQL.
-
Consume Neo4J OData Feeds in PowerBuilder
This article demonstrates how to consume Neo4J as OData feeds from PowerBuilder using the API Server.
-
Automated Continuous Google Cloud Storage Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to IBM DB2.
-
Integrate SAP SuccessFactors Data into Power Automate Desktop using CData Connect
CData Connect for SAP SuccessFactors Data enables you to integrate SAP SuccessFactors into workflows built using Microsoft Power Automate Desktop.
-
Integrate Cline with Live CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Apache CouchDB from within your IDE.
-
Use the CData Software ODBC Driver for Mocean in MicroStrategy Desktop
Connect to Mocean in MicroStrategy Desktop using the CData Software ODBC Driver for Mocean.
-
How to connect to Google Directory Data in DBVisualizer
Integrate Google Directory with visual data analysis tools and data connection wizards in DBVisualizer
-
Publish Zoho Books-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Zoho Books.
-
How to Connect to Live ShipStation 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 ShipStation without replication.
-
Migrating data from VWO to Databricks using CData SSIS Components.
Easily push VWO to Databricks using the CData SSIS Tasks for VWO and Databricks.
-
Import Snowflake Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Snowflake Data and provide access to live Snowflake for custom reports in the Power BI Service.
-
Connect to ConvertAPI Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ConvertAPI using standard SQL.
-
Access Tickspot Data from MySQL in PHP
Connect to Tickspot through the standard MySQL libraries in PHP.
-
How to connect to Epicor Kinetic Data with Squirrel SQL client
Connect to Epicor Kinetic and execute queries in the Squirrel SQL Client.
-
Connect to and Visualize Live Coda Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Coda.
-
Creating Oracle Sales-Connected Applications in Unqork
You can use CData Connect AI to feed Oracle Sales to Unqork and build custom business apps.
-
Create SSAS Tabular Models from SuiteCRM Data
How to build a SQL Server Analysis Service Tabular Model from SuiteCRM using CData drivers.
-
Automate SAP ByDesign Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP Business ByDesign from PowerShell? This article demonstrates how to utilize the SAP ByDesign Cmdlets for tasks like connecting to SAP Business ByDesign, automating operations, downloading data, and more.
-
Connect to Sage Cloud Accounting Data in DBArtisan
Use wizards in DBArtisan to configure Sage Business Cloud Accounting as a data source.
-
Import QuickBooks Time Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access QuickBooks Time. In this article, you will use the OData format to import QuickBooks Time into Microsoft Power Query.
-
Getting Started with the CData Power BI Connector for Zoho CRM
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Zoho CRM.
-
Connect to Vercel Data in Ruby
Connect to Vercel in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrating Kiro CLI with Splunk 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 SendGrid Data in Python
Use standard Python scripting and the development environment of your choice to access live SendGrid.
-
Build Dashboards with EmailOctopus Data in Dundas BI
Create dynamic dashboards and perform analytics based on EmailOctopus in Dundas BI.
-
How to connect to WooCommerce Data with Squirrel SQL client
Connect to WooCommerce and execute queries in the Squirrel SQL Client.
-
Access Live Instantly Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Instantly in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Reckon Accounts Hosted Data in TIBCO Spotfire through ADO.NET
Integrate Reckon Accounts Hosted into dashboards in TIBCO Spotfire.
-
Add Simplesat Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Simplesat with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Sugar CRM Data in ACL Analytics
Connect to Sugar CRM via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Sugar CRM.
-
Access Live Google Ads Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google Ads from your Excel spreadsheets.
-
Automated Continuous Opsgenie Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Opsgenie replication to Google BigQuery.
-
Use the CData Software ODBC Driver for HDFS in MicroStrategy
Connect to Apache HDFS in MicroStrategy Developer using the CData Software ODBC Driver for HDFS.
-
Migrating data from Jira Assets to Snowflake using CData SSIS Components.
Easily push Jira Assets to Snowflake using the CData SSIS Tasks for Jira Assets and Snowflake.
-
Use the CData ODBC Driver for Quaderno from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Quaderno to connect to Quaderno from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Quaderno in Excel.
-
How to connect to ZohoExpense Data from IntelliJ
Integrate connectivity to ZohoExpense with wizards in IntelliJ.
-
How to Seamlessly Import Webex Data into IBM SPSS Modeler
Integrate Webex data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Import Google Directory Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Google Directory Data and provide access to live Google Directory for custom reports in the Power BI Service.
-
Connect to GitHub Data in Jaspersoft Studio
Execute SQL to remote GitHub in Jaspersoft Studio.
-
Connect to SAP Concur Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAP Concur in FileMaker Pro to connect to SAP Concur and work with SAP Concur in your FileMaker applications.
-
Connect to Dynamics NAV Data in CloverDX (formerly CloverETL)
Transfer Microsoft Dynamics NAV using the visual workflow in the CloverDX data integration tool.
-
Use CData Connect AI to Access ShipStation Data in Microsoft Power Pivot
Use CData Connect AI to connect to live ShipStation in the Power Pivot business intelligence tool.
-
Create Datasets from Mode in Domo Workbench and Build Visualizations of Mode Data in Domo
Use the CData Software ODBC Driver for Mode to create datasets from Mode in Domo Workbench and then build visualizations in the Domo service.
-
Use the CData API Server to Access Bitbucket Data in Microsoft PowerPivot
Use the CData API Server to connect to live Bitbucket in the Power Pivot business intelligence tool.
-
Connect to Real-Time SAP Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SAP and Dataflow to import and use SAP ERP/NetWeaver in Power Apps.
-
Access Excel Files within Sub-Folders Using CData Excel Drivers
A step-by-step guide on retrieving data from Excel files within sub-folders of a root folder using CData Excel Drivers for seamless data access and integration.
-
Build a Simple VCL Application for CSV Data
How to build a simple VCL Application to view CSV/TSV Files in RAD Studio using the CData ODBC Driver for CSV.
-
Integrate LibreChat with Live Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google Directory from within the chat interface.
-
Build Voice Agents in ElevenLabs with access to Live Oracle Eloqua Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Oracle Eloqua.
-
Create Dynamic Sybase Grids Using the Infragistics XamDataGrid
Learn how you can connect Sybase to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Bugsnag Replication to SQLite
Use CData Sync for automated, continuous, customizable Bugsnag replication to SQLite.
-
Connect to Spark in SpagoBI
Create reports featuring live Apache Spark SQL in SpagoBI Studio. Host Spark reports on SpagoBI Server.
-
Integrate Microsoft Entra ID with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Microsoft Entra ID with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Microsoft Entra ID.
-
How to create Salesforce Pardot federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Salesforce Pardot in MySQL .
-
Build MVC Applications with Connectivity to SQL Analysis Services Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SQL Analysis Services from an ASP.NET MVC application.
-
Connecting Pipedream with Oracle SCM 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 Oracle SCM data in real time.
-
Connect to PayPal Data from PowerBuilder via JDBC
This article demonstrates how to access PayPal from PowerBuilder using the PayPal JDBC Driver.
-
Connect to Codat Data in HULFT Integrate
Connect to Codat as a JDBC data source in HULFT Integrate
-
Query SuiteCRM Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SuiteCRM from Node.js.
-
Replicate Flowlu Data to Multiple Databases
Replicate Flowlu to disparate databases with a point-and-click configuration.
-
Automated Continuous ChargeOver Replication to Databricks
Use CData Sync for automated, continuous, customizable ChargeOver replication to Databricks.
-
SQL Gateway Overview
A detailed overview of the SQL Gateway, its function, and its features.