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

Usage

Flyway Desktop

This can be set from the connection dialog.

TOML Configuration File

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

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

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