> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# application-mssql.yaml

## File purpose

This profile is used to run Atoti Market Risk in DirectQuery mode, connecting to a Microsoft SQL Server database.

## File location

The file is located in the folder **mr-application\src\main\resources**.

## File values

| Key                                                      | Value                                                             | Description                                                                                                                                                             |
| -------------------------------------------------------- | ----------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| configuration                                            |                                                                   |                                                                                                                                                                         |
| configuration.sign-off                                   |                                                                   |                                                                                                                                                                         |
| configuration.sign-off.enabled                           | `false`                                                           | Sign-off is not available to use with DirectQuery applications.                                                                                                         |
| mr                                                       |                                                                   |                                                                                                                                                                         |
| mr.enable                                                |                                                                   |                                                                                                                                                                         |
| mr.enable.cubes                                          |                                                                   |                                                                                                                                                                         |
| mr.enable.cubes.var-summary                              | `false`                                                           | Summary cubes are not available to use with DirectQuery applications.                                                                                                   |
| mr.enable.cubes.pnl-summary                              | `false`                                                           | Summary cubes are not available to use with DirectQuery applications.                                                                                                   |
| mr.enable.cubes.sensi-summary                            | `false`                                                           | Summary cubes are not available to use with DirectQuery applications.                                                                                                   |
| starter                                                  |                                                                   |                                                                                                                                                                         |
| starter.deployment                                       |                                                                   |                                                                                                                                                                         |
| starter.deployment.type                                  | `direct-query`                                                    | This causes Atoti Market Risk to run in DirectQuery mode with the appropriate components configured to enable this.                                                     |
| directquery                                              |                                                                   |                                                                                                                                                                         |
| directquery.with-adjustments                             | `false`                                                           | Whether the schema contains adjusted data.                                                                                                                              |
| directquery.clustering                                   |                                                                   |                                                                                                                                                                         |
| directquery.clustering.enabled                           | `true`                                                            | This enables DirectQuery to use [clustering fields](/products/atoti/server/latest/docs/directquery/directquery-clustering-fields/) to improve data loading performance. |
| directquery.clustering.clustering-per-table              | `PnL: AsOfDate; TradePnLs: AsOfDate; TradeSensitivties: AsOfDate` | This enables clustering on the `AsOfDate` field for all base tables.                                                                                                    |
| directquery.schema                                       |                                                                   |                                                                                                                                                                         |
| directquery.schema.validation                            |                                                                   |                                                                                                                                                                         |
| directquery.schema.validation.validate-on-startup        | `true`                                                            | This ensures the MS SQL Server schema will be validated against the internal Atoti schema at startup with results provided in the logs.                                 |
| directquery.schema.validation.fail-startup-on-bad-schema | `true`                                                            | This ensures the application fails to start if the MS SQL Server schema does not match the internal Atoti schema.                                                       |
| directquery.database                                     |                                                                   |                                                                                                                                                                         |
| directquery.database.type                                | `mssql`                                                           | This ensures the application configures the appropriate connection for a Databricks database.                                                                           |
| directquery.mssql                                        |                                                                   |                                                                                                                                                                         |
| directquery.mssql.username                               | `${MSSQL_USERNAME}`                                               | This is the username for the account that will be used to connect Atoti to MS SQL Server, provided as an environment variable.                                          |
| directquery.mssql.password                               | `${MSSQL_PASSWORD}`                                               | This is the password for the account that will be used to connect Atoti to MS SQL Server, provided as an environment variable.                                          |
| directquery.mssql.port                                   | `${MSSQL_PORT}`                                                   | This is the port that MS SQL Server is running on, provided as an environment variable.                                                                                 |
| directquery.mssql.hostname                               | `${MSSQL_HOSTNAME}`                                               | This is the hostname of the MS SQL Server instance, provided as an environment variable.                                                                                |
| directquery.mssql.database                               | `${MSSQL_DATABASE}`                                               | This is the MS SQL Server catalog containing your data, provided as an environment variable.                                                                            |
| directquery.mssql.schema                                 | `${MSSQL_SCHEMA}`                                                 | This is the MS SQL Server schema containing your data, provided as an environment variable.                                                                             |
| directquery.mssql.encrypt                                | `${MSSQL_ENCRYPT}`                                                | Set to true `true` if the Secure Sockets Layer (SSL) encryption is enabled between the client and the SQL Server, `false` otherwise.                                    |
| directquery.mssql.trust-server-certificate               | `${MSSQL_TRUST_SERVER_CERTIFICATE}`                               | Set to `true` if the SSL certificate should be automatically trusted when the communication layer is encrypted using SSL, `false` otherwise.                            |
| directquery.mssql.connect-retry-account                  | `${MSSQL_CONNECT_RETRY_COUNT}`                                    | The maximum number of attempts to re-establish a broken connection.                                                                                                     |