ContextQMD
Back to Flyway

Microsoft Entra Interactive Resolver

documentation/Reference/Configuration/Environments Namespace/Environment Resolvers Namespace/Microsoft Entra Interactive Resolver.md

latest2.0 KB
Original Source

This is a property resolver which applies when trying to connect to Microsoft Azure SQL Server databases using interactive authentication. Connections made using this form of authentication without this resolver will have the default behavior of prompting for login on every database call. When using this resolver, with the appropriate Azure setup, documented here, you can connect once and your token will be cached and reused for a period of time.

Settings

SettingRequiredTypeDescription
tenantIdYesStringThe Microsoft Entra tenant id.
clientIdYesStringThe Microsoft Entra client id.

Usage

Flyway Desktop

This can be set from the connection dialog.

TOML Configuration File

toml
[environments.development]
url = "jdbc:sqlserver://mfa-testing.database.windows.net:1433;databaseName=MyDatabase"

[environments.development.jdbcProperties]
accessToken = "${entraId.token}"

[environments.development.resolvers.entraId]
tenantId = "{some GUID}"
clientId = "{some other GUID}"