Read the blog
 

CData Software - Knowledge Base



Recent SQL Server ODBC Articles

Connect to Shopify as an External Data Source using PolyBase

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

Use the CData ODBC Driver for Couchbase in SAS JMP

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

Access Sage Cloud Accounting from MySQL in PHP

Connect to Sage Cloud Accounting through the standard MySQL libraries in PHP.

Access Avro from MySQL in Amazon QuickSight

Connect to Avro and build visualizations of Apache Avro using a MySQL Connection in Amazon QuickSight.

Connect to Databricks as an External Data Source using PolyBase

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

Query ShipStation as a MySQL Database in Node.js

Execute MySQL queries against ShipStation from Node.js.

Video: Connecting with MongoDB Data from Microsoft Excel

This video shows how to use the CData ODBC Driver for MongoDB to connect to MongoDB. You will create a DSN and then use the Data Connection Wizard in Excel to retrieve MongoDB data.

Connect to Outreach.io as a Linked Server

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

Query Adobe Analytics as a MySQL Database in Node.js

Execute MySQL queries against Adobe Analytics from Node.js.

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.

Analyze Zoho Inventory in R

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

Connect to Oracle SCM as a Federated Tables in MySQL

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

Connect to ShipStation as an External Data Source using PolyBase

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

Use the CData ODBC Driver for TaxJar in SAS JMP

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

Connect to Authorize.Net as an External Data Source using PolyBase

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