CData Software - Knowledge Base
Recent Articles
-
Visualize Live Slack in the Power BI Service
Use CData Connect AI to connect to live Slack and create custom reports in the Power BI Service through the On-Premises Gateway.
-
A PostgreSQL Interface for Acumatica using the CData ODBC Driver
Use the SQL Gateway and Acumatica ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Kintone Replication to Snowflake
Use CData Sync for automated, continuous, customizable Kintone replication to Snowflake.
-
How to load Azure Data Lake Storage data into Elasticsearch via Logstash
Introducing a simple method to load Azure Data Lake Storage data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData API Server to Access Printful in Microsoft PowerPivot
Use the CData API Server to connect to live Printful in the Power Pivot business intelligence tool.
-
Build Visualizations of Adobe Commerce in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Adobe Commerce in Birst.
-
Access Live MongoDB in AWS Lambda
Connect to live MongoDB in AWS Lambda using the CData JDBC Driver.
-
How to Query Live HubDB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live HubDB data in natural language using Python.
-
Natively Connect to FHIR in PHP
The CData ODBC driver for FHIR enables you to create PHP applications with connectivity to FHIR. Leverage the native support for ODBC in PHP.
-
Connect to Active Directory as an External Source in Dremio
Use the CData JDBC Driver to connect to Active Directory as an External Source in Dremio.
-
Publish BambooHR-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live BambooHR.
-
Using the CData Software ODBC Driver for MySQL in PyCharm
Connect to MySQL as an ODBC data source in PyCharm using the CData Software ODBC Driver for MySQL.
-
LINQ to Hive
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Hive Data Provider.
-
Analyze Freshdesk in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Freshdesk in Microsoft R Open.
-
Build Charts with Greenplum in Clear Analytics
Create dynamic charts and perform analytics based on Pivotal GreenPlum in Clear Analytics.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
Use ChatGPT to Talk to Your Google Drive via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Google Drive for you.
-
How to Query Live QuickBooks Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live QuickBooks Desktop data in natural language using Python.
-
Automate AlloyDB Replication to Azure Data Lake
Use CData Sync to customize and automate Google AlloyDB replication to Azure Data Lake.
-
Use Azure AI Foundry to Talk to Your Zendesk 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 Zendesk for you.
-
Query SAP Ariba Source as a SQL Server Database in Node.js
Execute SQL Server queries against SAP Ariba Source from Node.js.
-
Work with Live CockroachDB in Power Query
Use CData Connect AI to connect to CockroachDB and work with live CockroachDB in Microsoft Power Query.
-
Extend Google Sheets with Zoho Inventory
Make calls to the API Server from Google Apps Script.
-
Build Oracle HCM Cloud-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Oracle HCM Cloud.
-
Connect to Azure DevOps in Ruby
Connect to Azure DevOps in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Agents in Relevance AI with Access to Live Office 365 via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft Office 365 within intelligent agent workflows.
-
Connect Zendesk to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zendesk using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Consume Amazon S3 OData Feeds in PowerBuilder
This article demonstrates how to consume Amazon S3 as OData feeds from PowerBuilder using the API Server.
-
A PostgreSQL Interface for Box (MySQL Remoting via JDBC)
Use the Remoting features of the Box JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Instagram in Looker
Use CData Connect AI to connect to Instagram from Looker and build custom apps using live Instagram.
-
LINQ to LinkedIn Ads
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the LinkedIn Ads Data Provider.
-
Stream Amazon S3 into Apache Kafka Topics
Access and stream Amazon S3 in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Access Live Sugar CRM in Visual Studio Code via Cline
-