CData Software - Knowledge Base



Recent SQL Server ODBC Articles

Connect to JSON as an External Data Source using PolyBase

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

Connect to Raisers Edge NXT as a Linked Server

Use the SQL Gateway and the ODBC Driver to set up a linked server for Raisers Edge NXT.

Access SharePoint Excel Services from MySQL in Amazon QuickSight

Connect to SharePoint Excel Services and build visualizations of SharePoint Excel Services using a MySQL Connection in Amazon QuickSight.

Access Google Sheets from MySQL in PHP

Connect to Google Sheets through the standard MySQL libraries in PHP.

Query Parquet as a MySQL Database in Node.js

Execute MySQL queries against Apache Parquet from Node.js.

Use the CData ODBC Driver for Trello in SAS JMP

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

Connect to FTP as an External Data Source using PolyBase

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

Connect to Redis as a Federated Tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Redis in MySQL .

Connect to Kintone as a Federated Tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Kintone in MySQL .

Connect to Workday as an External Data Source using PolyBase

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

Connect to LinkedIn Ads as a Linked Server

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

Connect to Greenplum as a Linked Server

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

Access Sage 200 from MySQL in Amazon QuickSight

Connect to Sage 200 and build visualizations of Sage 200 using a MySQL Connection in Amazon QuickSight.

Query Azure Synapse in MySQL Workbench

Execute MySQL queries against live Azure Synapse from MySQL Workbench.

Access GraphQL from MySQL in PHP

Connect to GraphQL through the standard MySQL libraries in PHP.