Before you create a catalog source, ensure that you have the information required to connect to the source system.
Perform the following tasks:
•Ensure that you use one of the following authentication types to authenticate your organization to access the source system:
- Admin User. Required when Microsoft Azure Analysis Services allows user names and passwords for authentication.
- Service Principal. Required when Microsoft Azure Analysis Services uses the Microsoft Entra ID service principal, formerly known as Azure Active Directory, for authentication.
•If you plan to authenticate your organization to the service with a user with administrator privileges, create the user account.
•If you plan to authenticate your organization to the service using service principal authentication, register a Microsoft Entra application and create the service principal.
•To perform Azure Analysis Services server management operations, add the service principal to the server administrators role.
Note: Add the service principal directly to the server administrators role. You can't add a service principal to a security group and then add the security group to the server administrators role.
•Create a connection.
•Create endpoint catalog sources for connection assignment.
Verify permissions
To extract metadata and to configure other capabilities that a catalog source might include, you need account access and permissions on the source system. The permissions required might vary depending on the capability.
Permissions for metadata extraction
To extract metadata, you need account access and permissions to the Microsoft Azure Analysis Services source system.
Verify that the administrator performs the following tasks:
•Grants read permission to the user account to access the source system for admin user authentication.
•Enables read-only access to the registered application for service principal authentication.
Create a connection
Create a Microsoft Azure Analysis Services connection object in Administrator with the connection details of the Microsoft Azure Analysis Services source system.
1In Administrator, select Connections.
2Click Add Connection and select Microsoft Azure Analysis Services.
3Enter the connection properties.
The following table describes the connection properties:
Property
Description
Use Secret Vault
Stores sensitive credentials for this connection in the secrets manager that is configured for your organization.
This property appears only if secrets manager is set up for your organization.
When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
Description
Description of the connection. Maximum length is 4000 characters.
Runtime Environment
The name of the runtime environment where you want to run tasks. Select a Secure Agent or serverless runtime environment.
Authentication Type
The authentication type to use for the connection. Choose to connect using the Admin User option or the Service Principal option.
Server Name
The unique identifier for your Microsoft Azure Analysis Services instance.
4Based on the authentication type you selected, enter the following connection properties:
Admin User option
Specify the following properties:
Property
Description
User Name
The fully qualified user name to connect to Microsoft Azure Analysis Services instances.
Password
The password associated with the user name.
Service Principal option
Specify the following properties:
Property
Description
Client ID
The client or application ID of the registered application to complete the service principal authentication.
Tenant ID
The tenant ID of the registered application to complete the service principal authentication.
Client Secret
The client secret key to connect to complete the service principal authentication.
5Click Test.
6Click Save.
Create endpoint catalog sources for connection assignment
An endpoint catalog source represents a source system that the catalog source references. Before you perform connection assignment, create endpoint catalog sources and run the catalog source jobs.
You can then perform connection assignment to reference source systems and run connection-aware scans to view complete lineage with source system objects.