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 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. |