How to update the database credentials used in the Bold BI application?
Step 1: Updating the main application's connection string
The main application's connection string is a crucial configuration that establishes the connection between the Bold BI application and the database server. To update the main application's connection string, follow these steps:
Run the Admin Utility to update the connection string in the main application (i.e., the UMS module of the application).
Restart the application by following the documentation.
Step 2: Changing the connection string for individual sites
Each site within the Bold BI application has its connection string that needs to be updated after updating the main application's connection string. To change the connection string for individual sites, follow these steps:
- Navigate to the sites listing page - https://<your-domain>/ums/sites
- Refer to this documentation for detailed instructions on changing the connection string for individual sites. Alternatively, you can also use the REST API for this purpose.
Step 3: Updating the datastore connection string
The datastore connection string ensures that the dashboard data is connected to the correct database server. To update the datastore connection string, follow these steps:
- Navigate to the Data Store Settings page within the Bold BI site. - https://<your-domain>/bi/site/<site-identifier>/administration/data-process
- Refer to this documentation for detailed instructions on updating the datastore connection string.
Once you have updated the connection string, please refer to this document and restart the application to reflect the latest changes. Ensure the site and dashboards are working as expected.
Related links:
