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