Atoti Market Risk offers two levels of support for databases to work with DirectQuery.
Native support
These databases are natively supported by Atoti Market Risk. The Solution provides a fully tested standard implementation, with reference data and documentation for connecting to these databases.
With a natively supported database, Atoti Market Risk provides:
Documentation on required configuration properties to connect to the remote database.
Reference SQL queries to create the database tables (these are available in mr-directquery/src/test/resources/databases).
Reference data in a format compatible with the specific database (for Databricks this is available in mr-directquery/src/test/resources/databases/databricks/data. For Microsoft SQL Server and Snowflake you can use the primary dataset in mr-application/src/main/resources/data).
Databases tested for computational accuracy.
Natively supported databases
Atoti Market Risk provides a fully tested standard implementation, with reference data and documentation for the following databases:
For detailed steps on how to connect to one of these databases, see Getting started.
Non-native support
Atoti Server supports connecting to other compatible databases, but Atoti Market Risk currently does not. You can manage these databases yourself, but we do not document the implementation steps required.
If your chosen Database isn’t natively supported, you can contact us for implementation support or refer to the Atoti Server DirectQuery documentation to customize with a different database.