Category / Section
Purpose of Configuration and Extract Databases in Bold BI
Published:
| Bold ID database | Bold BI database | Bold BI Data store database | |
| Purpose | This database stores the Bold BI sites that you have created and the users you are adding to the Bold BI sites. It needs to be set up only once during the application startup. | This is a BI application database, and it will store the following information.
Note: Each Bold BI site requires a separate database. | This database needs to be set up only when you are targeting a data source, such as a file data source, web API data source, etc. |
| Need | Mandatory | Mandatory | Optional |
| Database Load | There is less load, as it is only used for site management and user login. | The load on the Bold BI site is based on traffic. | The database will be loaded if you use the extract type data source. The loading of data into the database depends on the data and traffic to the dashboard, which utilizes 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. However, you may face difficulties in scalability. Therefore, it is recommended to use a single database for both Bold ID and the site, and a separate database for data store.
NG
