CData Software - Knowledge Base



Recent SQL Server ODBC Articles

Access RSS Feeds from MySQL in Amazon QuickSight

Connect to RSS and build visualizations of RSS Feeds using a MySQL Connection in Amazon QuickSight.

Query Google Search Results as a MySQL Database in Node.js

Execute MySQL queries against Google Search from Node.js.

Access Google Cloud Storage from MySQL in PHP

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

Connect to SAP HANA XS Advanced as a Linked Server

Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP HANA XS Advanced.

Connect to PostgreSQL as an External Data Source using PolyBase

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

Connect to Office 365 as an External Data Source using PolyBase

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

Query FHIR in MySQL Workbench

Execute MySQL queries against live FHIR from MySQL Workbench.

Analyze SQL Server in R

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

Use the CData ODBC Driver for MySQL from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for MySQL to connect to MySQL from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring MySQL in Excel.

Access Odoo from MySQL in PHP

Connect to Odoo through the standard MySQL libraries in PHP.

Connect to Access as an External Data Source using PolyBase

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

Access Power BI XMLA from MySQL in PHP

Connect to Power BI XMLA through the standard MySQL libraries in PHP.

Access Google Sheets from MySQL in PHP

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

Analyze Xero in R

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

Analyze ADP in R

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