CData Software - Knowledge Base



Recent SQL Server ODBC Articles

Query SAP as a MySQL Database in Node.js

Execute MySQL queries against SAP NetWeaver from Node.js.

Access Microsoft Planner from MySQL in Amazon QuickSight

Connect to Microsoft Planner and build visualizations of Microsoft Planner using a MySQL Connection in Amazon QuickSight.

Connect to Amazon Athena as an External Data Source using PolyBase

Use the CData ODBC Driver for Amazon Athena and PolyBase to create an external data source in SQL Server 2019 with access to live Amazon Athena.

Analyze Act CRM in R

Create data visualizations and use high-performance statistical functions to analyze Act CRM in Microsoft R Open.

Connect to GraphQL as a Linked Server

Use the SQL Gateway and the ODBC Driver to set up a linked server for GraphQL.

Connect to CSV as a Federated Tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for CSV/TSV Files in MySQL .

Connect to Hive as a Linked Server

Use the SQL Gateway and the ODBC Driver to set up a linked server for Apache Hive.

Use the CData ODBC Driver for ServiceNow in SAS JMP

You can use the CData ODBC Driver to integrate ServiceNow into the statistical analysis tools available in SAS JMP. This article shows how to use ServiceNow in the Graph Builder and Query Builder.

Analyze Airtable in R

Create data visualizations and use high-performance statistical functions to analyze Airtable in Microsoft R Open.

Query Office 365 as a MySQL Database in Node.js

Execute MySQL queries against Microsoft Office 365 from Node.js.

Query Active Directory as a MySQL Database in Node.js

Execute MySQL queries against Active Directory from Node.js.

Analyze XML in R

Create data visualizations and use high-performance statistical functions to analyze XML Files in Microsoft R Open.

Query SAP Concur in MySQL Workbench

Execute MySQL queries against live SAP Concur from MySQL Workbench.

Use the CData ODBC Driver for XML in SAS JMP

You can use the CData ODBC Driver to integrate XML Files into the statistical analysis tools available in SAS JMP. This article shows how to use XML Files in the Graph Builder and Query Builder.

Connect to Gmail as an External Data Source using PolyBase

Use the CData ODBC Driver for Gmail and PolyBase to create an external data source in SQL Server 2019 with access to live Gmail.