Search results

Purpose of Configuration and Extract Databases in Bold BI

Bold ID database Bold BI database Bold BI Data store database
Purpose This database stores the Bold BI sites, which you have created and the users you are adding in the Bold BI sites. This database needs to be setup only once during the application startup. This is BI application database and it will store the below information.
  • Users and groups information.
  • Resource like dashboard, data source, schedules etc.
  • Users and groups permission to access the resources.
  • Authentication details, Email configuration, dashboard settings.
Note: Each Bold BI site requires separate database.
This database needs to be set up only when you are targeting the data source, which is extract type like file data source, web API data source, etc.
Need Mandatory Mandatory Optional
Database Load Less load, since it is only used for site management and user login. Load based on traffic in the Bold BI site. The database will get loaded, if you use the extract type data source. The load to the database depends on data and traffic to the dashboard, which uses the extract type data source.

Can we use same database for both configuration and extract data storage?

Yes, you can use a single database for low traffic sites, which will be cost-effective. But you may face difficulties in scalability. So, it is recommended to use the single database for both Bold ID, site, and a separate database for data store.