Read the blog
 

CData Software - Knowledge Base



Recent SQL Server ODBC Articles

Connect to Spark in DBeaver

Use the CData ODBC Driver to connect to Apache Spark SQL in DBeaver.

Query SuiteCRM as a MySQL Database in Node.js

Execute MySQL queries against SuiteCRM from Node.js.

Access SAP ByDesign from MySQL in PHP

Connect to SAP ByDesign through the standard MySQL libraries in PHP.

Analyze Salesforce Pardot in R

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

Connect to Excel Online as a Linked Server

Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Excel Online.

Use the CData ODBC Driver for Office 365 in SAS JMP

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

Connect to Kintone as an External Data Source using PolyBase

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

Query QuickBooks in MySQL Workbench

Execute MySQL queries against live QuickBooks Desktop from MySQL Workbench.

Connect to MySQL in DBeaver

Use the CData ODBC Driver to connect to MySQL in DBeaver.

Connect to SharePoint as a Federated Tables in MySQL

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

Access Oracle from MySQL in Amazon QuickSight

Connect to Oracle and build visualizations of Oracle Database using a MySQL Connection in Amazon QuickSight.