How to Identify the Meta Database and Intermediate Database Details in Bold BI

This article provides guidance on locating the Intermediate Database and Meta Database details in Bold BI.

Meta DB (Metadata Database)

The Meta DB is the primary database that stores metadata and settings related to Bold BI sites. It contains:

• Users and groups information
• Resources such as dashboards, data sources, and schedules
• User and group permissions to access resources
• Authentication details, email configurations, and other application settings.

Intermediate DB (Data Store Database)

The Intermediate DB is a data store used to import and store data from:

• Web API data sources
• Extract mode connection data sources (e.g., SQL)
• Data imported from file-based data sources (e.g., Excel, CSV)

In certain scenarios, you may need to access the Intermediate Database or update records in the Meta Database. If you do not remember the database details configured during application startup, you can use the following methods to identify them.

Option 1: Find the Intermediate Database from Data Process Settings

You can find the Intermediate Database details from the Data process Settings page.

Navigation Path: {{:domain}}/bi/site/site1/administration/data-process

Option 2: Find the Meta Database from the config.json File

You can find the Meta Database details in the config.json file located in the Bold BI deployment directory.

Refer to the following article to locate the configuration folder for your deployment environment:
How to Locate the Configuration Folder in Different Environments

Once you have located the configuration folder, open the config.json file. You can find the Meta Database details as highlighted in the example below.

Option 3: Find the Meta Database from UMS Site Settings

If you are an administrator and have access to the UMS Site Settings, you can view the Meta Database details directly from the configuration settings page.

Navigation Path: {{domain}}/ums/administration/config-editor

The Meta Database details are available in the config.json under the configuration settings.

Conclusion

These methods can help you quickly locate the Intermediate and Meta Database details whenever they are required for troubleshooting, maintenance, or configuration updates.