Skip to main content
Skip table of contents

How to use a separate database for report execution

In cases of slow report execution speed due to large amounts of data it might be beneficial to use a separate database with a snowflake architecture for report execution. Supported database by right now is Vertica.

To enable separate database for report execution:

  1. Install the additional database on your server

  2. Add database connector to /flexbi_private/lib

  3. Configure OLAP DWH database connection parameters in Admin Settings page or /flexbi_private/config/database.toml file

4. Select the olap_dwh option for “OLAP DWH connection” on the Update Account page

Emptying and deleting data cubes right now is not fully supported with Vertica. In order to do this, the “OLAP DWH connection” parameter has to be disabled and re-enabled after the re-import is finished.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.