• Technical documentation
• User documentation
• Trust Center
• Contact us

Guide to connecting an Azure SQL data source to Convier

Contents of this page

Connecting an Azure SQL database

• Click “SQL database”
• Enter JDBC connection string (found at “SQL database” -> “Settings” -> “Connection strings” in Azure portal)
• Click save (you may need to refresh the page)

Managed Identity (App Service):

• Assign App Service a system managed identity
• Give managed identity access to database
• In connection string, add authentication=ActiveDirectoryManagedIdentity

Token based:

• In the SQL database, make sure the Enterprise Application used to authenticate Convier users is added

• CREATE USER [<name of enterprise app registration>] FROM EXTERNAL PROVIDER

• In Convier, click “Authentication”
• Select “App token”
  • Enter scope “https://database.windows.net/.default”

Basic credentials

• Select “Basic credentials”
• Enter username and password

Save