The configuration parameters for the SQL Server connector are:
| Parameter | Required | Description |
|---|---|---|
| DB_USERNAME | Required | The database user to execute the statement as, for example: connector-user |
| DB_PASSWORD | Required | The password for the database user executing the statement |
| SQLSERVER_HOST | Optional | The host address of the database, for example: sqlserver.example.com |
| SQLSERVER_PORT | Optional | The port of the hosted database, for example: 421 |
| DB_NAME | Optional | The name of the database to execute the statement against, for example: inventory |
| DB_DATASOURCE | Required | The database datasource, the default value is a concatenation of SQLSERVER_HOST, SQLSERVER_PORT and DB_NAME: jdbc:sqlserver://${SQLSERVER_HOST}:${SQLSERVER_PORT}/${DB_NAME} |
| DB_DRIVER_CLASS_NAME | Optional | The database driver to use. The default value is com.microsoft.sqlserver.jdbc.SQLServerDriver |