Metadata extraction supports Azure Active Directory (Azure AD) token authentication to connect to Azure SQL Database. Two methods are available depending on your environment automatic and manual.
- Automatic method
Available when metadata extraction runs from a data catalog instance, which uses the assigned Azure cloud identity to generate a temporary access token.
The token is automatically passed using the hidden parameter:
__$Secret_Azure_AccessToken_Sql_Database- Leave the
UserandPasswordparameters empty.User= Password=
- Manual method
Authenticate directly with an Azure AD access token.
- Enter the token in the
Passwordfield and leave theUserfield empty.User= Password=<Azure Active Directory Token>
The Azure Cloud Identity (for the automatic method) or the Azure AD token (for the manual method) must have sufficient permissions to connect and read metadata from the target Azure SQL Database. The automatic method is recommended for environments running under Data Catalog, as it simplifies token management.