Tableau Connector for Azure Analysis Services

Build 21.0.7930

Configuring a Connection

The connector comes with a connection builder which allows you to build and test your connection settings outside of Tableau. It also allows you to create a connection string, which can be used to provide options not listed in the connection dialog in Tableau.

Configuring a Connection Builder

There are two ways to access the connection builder:

  • On Windows, there will be a shortcut called Connection Builder in the start menu, under the CData Azure Analysis Services Tableau Data Connector folder.
  • The connection builder can also be started by going to the driver install directory and running the .jar file in the lib directory.

In the connection builder, you can set values for connection properties and click the Test Connection button to validate that they work. You can also use the Copy to Clipboard button to save the connection string for use with Tableau.

Connecting to Azure Analysis Services

To connect, set the Url property to a valid Azure Analysis Services server, for instance, asazure://, in addition to authenticating.

Optionally, set Database to distinguish which Azure database on the server to connect to.

Authenticating to Azure Analysis Services

Authenticating using Azure AD

Azure AD is a connection type that goes through OAuth. Set your AuthScheme to AzureAD and see Using OAuth Authentication for an authentication guide.

Authenticating using Azure Service Principal

Azure Service Principal is a connection type that goes through OAuth. Set your AuthScheme to AzureServicePrincipal and see Using Azure Service Principal Authentication for an authentication guide.

Authenticating using MSI Authentication

If you are running Azure Analysis Services on an Azure VM, you can leverage Managed Service Identity (MSI) credentials to connect:

  • AuthScheme: Set this to AzureMSI.

The MSI credentials will then be automatically obtained for authentication.

Authenticating using Azure Password

To connect using your Azure credentials directly, specify the following connection properties:

  • AuthScheme: Set this to AzurePassword.
  • User: Set this to your user account you use to connect to Azure.
  • Password: Set this to the password you use to connect to Azure.

Next Step

See Getting Data for the next step, which includes authenticating to the Azure Analysis Services APIs.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930