Purpose

Microsoft Azure SQL Database or Azure SQL Managed Instance in the cloud. The connection is always encrypted with certificate validation.

Connection fields

FieldRule and default valueExplanation
Server
host		RequiredSet the value according to your service configuration.
Port
port		As configured
Default: 1433
Range: 1–65535		Set the value according to your service configuration.
Database
database		RequiredSet the value according to your service configuration.
Authentication
auth		As configured
Default: sql		sql — SQL username and password
service_principal — Microsoft Entra ID application (service principal)
SQL user or application Client ID
username		RequiredSet the value according to your service configuration.
Password or client secret
secret		Separate protected fieldThe secret is not displayed after saving. An empty field in an existing connection preserves its current secret.

Setup and validation

  1. Create a connection and give it a clear name.
  2. Complete required fields and the separate secret field.
  3. Run “Test” and read the diagnostics.
  4. Save the connection and select it in the appropriate flow block.

A successful test does not replace checking access to the required object and specific write mode.

Use in a flow

Server and account settings are stored in the connection. The specific object, fields and flow behavior are defined in the block. Go to data-handling rules →