Skip to main content
Atoti FRTB offers two levels of support for databases to work with DirectQuery.

​
Native support

These databases are natively supported by Atoti FRTB. The solution provides a fully tested standard implementation, with reference data and documentation for connecting to these databases. With a natively supported database, the solution provides:
  • Documentation on required configuration properties to connect to the remote database.
  • Reference queries to create the Database Tables. (These are included in frtb-directquery/src/test/resources/databases/ for Snowflake and Databricks, and in frtb-application-tests/src/test/resources/db/liquibase/ for ClickHouse and MSSQL).
  • Reference data in a format compatible with the specific database (provided in the same directories).
  • Migration REST service to extract in-memory data into a format compatible with the specific database.
  • Databases tested for computational accuracy and performance.

​
Natively supported databases

The solution 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 Connecting to a Database.

​
Non-native support

Atoti Server supports connecting to other compatible databases, but Atoti FRTB currently does not. Clients can manage these databases themselves, but the implementation steps required are not documented. If your chosen database is not natively supported, you can contact ActiveViam for implementation support or refer to the Atoti Server DirectQuery documentation to customize with a different database.
Your chosen database must be supported by Atoti Server. Check that it is listed among Atoti Server’s compatible databases.