MSSQL - Alumio Documentation

Use this to connect Alumio to a Microsoft SQL Server (MSSQL) database. Once it is set up, the connection can be reused by other features that read from or write to your SQL Server database. You can sign in with a username and password, or with a Microsoft Entra service principal (client secret) for Azure-hosted databases. The Advanced tab holds connection tuning and encryption options that you usually do not need to touch.

Fields

Advanced

Sample data

A typical MSSQL connection using a username and password:

Field	Value
Server host	`your-db-host.example.com`
Server port	`1433`
Database name	`warehouse`
Authentication type	`SqlPassword`
Username	`integration_user`
Password	`your-password`

{
    "host": "your-db-host.example.com",
    "port": "1433",
    "database": "warehouse",
    "authenticationType": "SqlPassword",
    "username": "integration_user",
    "password": "your-password"
}

Connection credentials are shown here as placeholders. For the password you can reference an environment variable instead of typing the secret directly; see Placeholders for the full syntax.

⌘I

​Fields

​Advanced

​Sample data

Fields

Advanced

Sample data