Does Data Get Stored or Cached on the Bold BI Server?
When using Bold BI, understanding where the user data is stored and cached is crucial for data security. This article provides insights into how data is managed in Bold BI, specifically addressing whether the data is stored or cached on the Bold BI server when a dashboard is created and viewed.
Data Processing Modes
Bold BI offers two primary modes for managing data from Web APIs: Extract Mode and Live Mode.
In Extract Mode, data is periodically fetched from the data source and stored in the Bold BI data store database. For On-premise Bold BI, your database will serve as the data store database.
In Live Mode, data is retrieved from the Web API each time the dashboard is accessed. No intermediate storage of data occurs, except for Web API data which is temporarily processed in the data store database and subsequently deleted according to an internal schedule.
More detailed information on Difference between live and extract mode data sources
Dashboard Caching
Bold BI provides options to enable or disable data caching on the dashboard, to optimize dashboard performance. This feature can significantly improve loading times and overall user experience. Data cache can be achieved through two modes: In-Memory and Redis.
For more detailed information on how to manage data cache, please refer to the Bold BI Data Cache Documentation.