The following settings can be defined for the Microsoft SQL database connection.

MSSql-Destination-Details

Host Name
Defines the name of the SQL server.

Integrated Security
Defines if the Windows Integrated Security should be used. Alternatively use:

User ID
The user id and

Password
The password.

Database Name
Defines the name of the SQL database.

Test Connection
Checks the database connection.

Database Schema
By default the user’s default schema dbo will be used. To use another schema, you should set it as the default schema for your user on the SQL Server database.