CData Software - Knowledge Base



Recent SQL Server ODBC Articles

Analyze GraphQL in R

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

Access IBM Cloud Object Storage from MySQL in PHP

Connect to IBM Cloud Object Storage through the standard MySQL libraries in PHP.

Query Google Directory in MySQL Workbench

Execute MySQL queries against live Google Directory from MySQL Workbench.

Analyze Azure Analysis Services in R

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

Access SAP HANA XS Advanced from MySQL in PHP

Connect to SAP HANA XS Advanced through the standard MySQL libraries in PHP.

Connect to TSheets as a Linked Server

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

Use the CData ODBC Driver for Slack in SAS JMP

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

Connect to PostgreSQL in DBArtisan

Use wizards in DBArtisan to configure PostgreSQL as a data source.

Access Email from MySQL in PHP

Connect to Email through the standard MySQL libraries in PHP.

Use the CData ODBC Driver for Sybase in SAS JMP

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

Analyze SQL Server with Power Pivot

This article walks you through the process of using the CData ODBC Driver for SQL Server from Power Pivot. You will use the Table Import Wizard to load Microsoft SQL Server. You can visually build the import query or use any SQL supported by the driver.

Access PostgreSQL from MySQL in PHP

Connect to PostgreSQL through the standard MySQL libraries in PHP.

Analyze FTP in R

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

Connect to Microsoft OneDrive as an External Data Source using PolyBase

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

Connect to FreshBooks as a Linked Server

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