CData Software - Knowledge Base



Recent SQL Server ODBC Articles

Connect to Sage Cloud Accounting as a Linked Server

Use the SQL Gateway and the ODBC Driver to set up a linked server for Sage Business Cloud Accounting.

Connect to FHIR as a Linked Server

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

Query Microsoft OneDrive in MySQL Workbench

Execute MySQL queries against live Microsoft OneDrive from MySQL Workbench.

Publish Reports with SQL Analysis Services in Crystal Reports

Use the Report Wizard to design a report based on up-to-date SQL Analysis Services.

Analyze Facebook Ads in R

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

Connect to FreshBooks as a Federated Tables in MySQL

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

Access Google Search Results from MySQL in PHP

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

Connect to Avalara AvaTax as a Federated Tables in MySQL

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

Query Acumatica as a MySQL Database in Node.js

Execute MySQL queries against Acumatica ERP from Node.js.

Update IBM Cloud SQL Query with a Microsoft Access Linked Table

Update IBM Cloud SQL Query data by creating a linked table in Microsoft Access with the CData IBM Cloud SQL Query ODBC Driver.

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.

Analyze Kintone in R

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

Query Sugar CRM in MySQL Workbench

Execute MySQL queries against live Sugar CRM from MySQL Workbench.

Query Access in MySQL Workbench

Execute MySQL queries against live Microsoft Access from MySQL Workbench.

Access SendGrid from MySQL in PHP

Connect to SendGrid through the standard MySQL libraries in PHP.