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

# Supported databases

export const productName = "Atoti FRTB";

export const coreProductName = "Atoti Server";

{productName} offers two levels of support for databases to work with DirectQuery.

## Native Support

These databases are natively supported by {productName}. 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](../customization-and-internals/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](https://clickhouse.com/)
* [Databricks](https://www.databricks.com/)
* [Microsoft SQL](https://www.microsoft.com/en-us/sql-server/)
* [Snowflake](https://www.snowflake.com/)

For detailed steps on how to connect to one of these databases, see [Connecting to a Database](./connect-to-database).

### Non-Native Support

{coreProductName} supports connecting to other compatible databases, but {productName} 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 {coreProductName} [DirectQuery documentation](/engine/java-sdk/6.1/directquery/getting_started/) to customize with a different database.

<Note>
  Your chosen Database **must** be supported by {coreProductName}. Check that it is listed among [Atoti Server's compatible Databases](/engine/java-sdk/6.1/directquery/compatibility/).
</Note>