CData Software - Knowledge Base



Recent Azure Analysis Services ODBC Articles

Using Microsoft Query in Excel to Connect to Azure Analysis Services

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

Connect to Azure Analysis Services in DBArtisan

Use wizards in DBArtisan to configure Azure Analysis Services as a data source.

Import and Visualize Azure Analysis Services in Power View

Create data visualizations based on Azure Analysis Services in Excel.

Connect to Azure Analysis Services as an External Data Source using PolyBase

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

Access Azure Analysis Services as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Azure Analysis Services from your Oracle system.

Link Visio Shapes to Azure Analysis Services

Automatically update Azure Analysis Services with the changes you make to Visio master shapes.

Connect to and Query Azure Analysis Services in QlikView over ODBC

Create data visualizations with Azure Analysis Services in QlikView.

Natively Connect to Azure Analysis Services in PHP

The CData ODBC Driver for Azure Analysis Services enables you to create PHP applications on Linux/UNIX machines with connectivity to Azure Analysis Services. Leverage the native support for ODBC in PHP.

Connect to Azure Analysis Services as a Linked Server

Use the SQL Gateway and the ODBC Driver to set up a linked server for Azure Analysis Services.

Replicate Azure Analysis Services from PowerShell

Write a quick PowerShell script to query Azure Analysis Services. Use connectivity to the live data to replicate Azure Analysis Services to SQL Server.

Visualize Azure Analysis Services in Tableau

The CData ODBC driver for Azure Analysis Services enables you integrate Azure Analysis Services into Tableau dashboards.