CData Software - Knowledge Base



Recent SQL Server ODBC Articles

Connect to Zoho Creator as a Federated Tables in MySQL

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

Connect to TaxJar as an External Data Source using PolyBase

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

Natively Connect to PostgreSQL in PHP

The CData ODBC driver for PostgreSQL enables you to create PHP applications with connectivity to PostgreSQL. Leverage the native support for ODBC in PHP.

Use the CData ODBC Driver for Sugar CRM in SAS JMP

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

Access Salesforce Pardot from MySQL in Amazon QuickSight

Connect to Salesforce Pardot and build visualizations of Salesforce Pardot using a MySQL Connection in Amazon QuickSight.

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.

Connect to IBM Cloud SQL Query from Asprova with CData Software ODBC Driver for IBM Cloud SQL Query

This article shows how to connect faster to IBM Cloud SQL Query data from Asprova.

Query SAS xpt as a MySQL Database in Node.js

Execute MySQL queries against SAS XPORT from Node.js.

Use the CData ODBC Driver for Microsoft Planner in SAS JMP

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

Connect to FreshBooks as an External Data Source using PolyBase

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

Using Microsoft Query in Excel to Connect to SQL Server

This article uses the CData ODBC driver for SQL Server to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

Use the CData ODBC Driver for Google Sheets in SAS JMP

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

Connect to Btrieve as an External Data Source using PolyBase

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

Connect to SAP as an External Data Source using PolyBase

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

Connect to Stripe as a Linked Server

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