Connecting to Analysis Services Tabular

Szymon Karpęcki - Dataedo Team Szymon Karpęcki 26th October, 2021

This article explains how to connect Dataedo to Azure Analysis Services and SQL Server Analysis, Tabular Model and import metadata - tables & columns.

If you'd like to connect to Power BI Premium dataset/workspace, check this article.

Add new connection

To connect to Analysis Services Tabular model create new documentation by clicking Add and choosing Database connection.

Connection to SSAS Tabular

On the add connection screen choose Analysis Servies (SSAS/Azure) Tabular

Add docs Tabular

Connection details

Provide connection details:

  • Server name - address of a server or Azure:
    • e.g. 10.10.10.10 for SSAS (server)
    • e.g. asazure://westus.asazure.windows.net/adventure for Azure
  • Authentication - choose one of the autethication options:
    • Windows Authentication
    • Azure Active Directory - Password
    • Azure Active Directory - Integrated - this one uses Mirosoft online authentication.
  • User - for Azure Active Directory - Password authentication.
  • Passowrd - for Azure Active Directory - Password authentication.
  • Database - if server hosts multiple models, database allows you to select one of them by clicking [...] button.
  • Perspective - if model has multiple perspectives here you can select one of them by clicking [...] or leave default one.

SSAS Tabular connection form

How to get connection details with SSMS

You can get connection details from Connect to server SSMS form:

SSMS Connection Form

How to get server name from Azure

You can get server name in Essentials section in Azure Portal:

Azure portal essentials

Saving password

You can save Azure Active Directory password for later connections by checking Save password option. Password are saved in the repository database.

Importing schema

When connection was successful Dataedo will read objects and show a list of objects found. You can choose which objects to import. You can also use advanced filter to narrow down list of objects.

SSAS Tabular objects list

Confirm list of objects to import by clicking Next.

Next screen allow you to change default name of the documentation under which it will be visible in Dataedo repository.

SSAS Tabular Documentation Title

Click Import to start the import.

SSAS Tabular Import Progress

When done close import window with Finish button.

Outcome

Your database schema has been imported to new documentation in the repository.

SSAS Sample Documentation

Analysis Services support

Analysis Services Tabular support details

Found issue with this article? Comment below
0
There are no comments. Click here to write the first comment.