Supported Databases

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/).
• Reference data in a format compatible with the specific database (again provided in frtb-directquery/src/test/resources/databases/).
• 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:

• Clickhouse
• Databricks
• Microsoft SQL
• Snowflake

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 we do not document the implementation steps required.

If your chosen Database is not natively supported, you can contact us for implementation support or refer to the Atoti Server DirectQuery documentation to customize with a different database.