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