CData Software - Knowledge Base
Recent Articles
-
Connect to Google Ads from HeidiSQL
Use CData Connect AI to connect to and query live Google Ads from HeidiSQL.
-
How to Query Google Calendar in MySQL Workbench
Execute MySQL queries against live Google Calendar from MySQL Workbench.
-
Query Oracle HCM Cloud from Node.js
Use the OData endpoint of the CData API Server to connect to your Oracle HCM Cloud and perform CRUD operations on Oracle HCM Cloud from Node.js.
-
Use ChatGPT to Talk to Your Snowflake via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Snowflake for you.
-
Automate Dynamics 365 Business Central Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Dynamics 365 Business Central from PowerShell? This article demonstrates how to utilize the Dynamics 365 Business Central Cmdlets for tasks like connecting to Dynamics 365 Business Central, automating operations, downloading data, and more.
-
How to Connect Flowise AI Agents to Live LinkedIn via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
Create BigQuery-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to BigQuery from OutSystems and build custom enterprise apps using live Google BigQuery.
-
How to Build an ETL App for CouchDB in Python with CData
Create ETL applications and real-time data pipelines for Apache CouchDB in Python with petl.
-
Query xBase through ODBC in Node.js
Use node-odbc to execute SQL queries against xBase from Node.js.
-
Replicate ADP from PowerShell
Write a quick PowerShell script to query ADP. Use connectivity to the live data to replicate ADP to SQL Server.
-
Automate Typeform Replication to SAP HANA
Use CData Sync to customize and automate Typeform replication to SAP HANA.
-
Write a Simple Go Application to work with SAP HANA on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP HANA.
-
Prepare, Blend, and Analyze Google Spanner in Alteryx Designer (Connect AI)
Build workflows to access live Google Spanner for self-service data analytics.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SAP Business One to Power BI dashboards. Simply drag and drop SAP Business One into data visuals on the Power BI canvas.
-
Connect to Trello from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Trello to connect to Trello and execute queries in PowerBuilder.
-
Create Power BI Reports on Real-Time HarperDB
Use the CData ODBC Driver for HarperDB to visualize HarperDB in Power BI Desktop.
-
Automated Continuous Square Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Square replication to OneLake in Microsoft Fabric.
-
Back Up Microsoft Dataverse (CDS) to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Microsoft Dataverse. In this article, we will employ an SSIS workflow to populate a database with Microsoft Dataverse (CDS) data.
-
Create SAP BusinessObjects BI Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Analyze Sage Cloud Accounting in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Sage Business Cloud Accounting and visualize Sage Business Cloud Accounting in SAP Analytics Cloud.
-
Create Data Visualizations in Cognos BI with ServiceNow
Access ServiceNow as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build a Simple VCL Application for Azure Table
How to build a simple VCL Application to view Azure Table Storage in RAD Studio using the CData ODBC Driver for Azure Table.
-
How to Connect Flowise AI Agents to Live Microsoft Dataverse via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
Automate SAP ByDesign Replication to Couchbase
Use CData Sync to Customize and automate SAP Business ByDesign replication to Couchbase.
-
Working with CouchDB in LINQPad
Execute LINQ queries to Apache CouchDB in LINQPad.
-
DataBind Charts to Cassandra
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache Cassandra 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 an SAP BusinessObjects Universe on the CData ODBC Driver for Calendly
Provide connectivity to Calendly through an SAP BusinessObjects universe.
-
How to Build an ETL App for Cosmos DB in Python with CData
Create ETL applications and real-time data pipelines for Azure Cosmos DB in Python with petl.
-
Working with SAP Business One in LINQPad
Execute LINQ queries to SAP Business One in LINQPad.
-
How to publish and share Zuora dashboards with Tableau Server
The CData ODBC driver for Zuora enables you integrate Zuora into Tableau dashboards.
-
How to Query Live Google Data Catalog Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Data Catalog data in natural language using Python.
-
Automated Continuous Hive Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Hive replication to Microsoft Access.
-
Visualize FHIR in TIBCO Spotfire through OData
Integrate FHIR into dashboards in TIBCO Spotfire.
-
Access Live Google Campaign Manager 360 in Coginiti Pro
Connect to and query live Google Campaign Manager 360 from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Square-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Square from OutSystems and build custom enterprise apps using live Square.
-
Publish Reports with Azure DevOps in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Azure DevOps.
-
Integrate SQL Server into Power Automate Desktop using CData Connect
CData Connect for SQL Server enables you to integrate Microsoft SQL Server into workflows built using Microsoft Power Automate Desktop.
-
Build Bullhorn CRM-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Bullhorn CRM.
-
Viewing Airtable in RAD Studio Data Explorer
How to view Airtable in RAD Studio Data Explorer using the CData ODBC Driver for Airtable.
-
Automated Continuous Coinbase Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Coinbase replication to Microsoft Access.
-
Analyze Splunk in Infragistics Reveal
Use the CData API Server to create an OData API on top of Splunk and visualize live Splunk in Infragistics Reveal.
-
Query WooCommerce in ColdFusion
Write standard ColdFusion data access code to connect to WooCommerce.
-
How to connect to JDBC-ODBC Bridge from Spring Boot
Connect to JDBC-ODBC Bridge in a Spring Boot Application using CData JDBC JDBC-ODBC Bridge Driver
-
Easily Integrate Zoho Creator in Lazarus Pascal IDE
Learn how to easily integrate live Zoho Creator in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Amazon Athena Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Microsoft Access.
-
Extend Google Sheets with MariaDB
Make calls to the API Server from Google Apps Script.
-
Access Act-On as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Act-On from your Oracle system.
-
Bridge Square Connectivity with Apache NiFi
Access and process Square in Apache NiFi using the CData JDBC Driver.
-
How to load SQL Analysis Services data into Elasticsearch via Logstash
Introducing a simple method to load SQL Analysis Services data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Import Zuora into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Zuora. In this article, you will use the OData format to import Zuora into Microsoft Power Query.
-
Automated Continuous Sage 300 Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Sage 300 replication to Apache Cassandra.
-
Connect to OneNote as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft OneNote.
-
How to connect to Active Directory with Squirrel SQL client
Connect to Active Directory and execute queries in the Squirrel SQL Client.
-
How to Easily Query Zendesk in OpenOffice Base
-