This is relevant from Sisense V6.7 and later.
When Sisense is installed, Sisense creates three application database users:
- AppUser: The user used by the Sisense application to access data stored in the application database.
- ReadUser: A user with read-only access to the application database.
- WriteUser: A user with read-write access to the application database.
The AppUser is created to allow the Sisense Application to interact with the application database. This password is unique to your Sisense installation and should not be changed. The credentials of the AppUser are shared between each node of the replica set. If you want to create an application database instance on server where Sisense is not installed, see Hosting an Application Server.
The ReadUser and WriteUser can be used to access your Sisense application database. These users have the relevant read-only and write-only application database roles assigned to them for accessing the application database. To use these users, you need to provide a password for each user through the Sisense REST API POST admin/app_database/change_database_user_password endpoint by providing the username (ReadUser or WriteUser depending on which user’s password you want to change) and the new password in the body of the request:
"userName": "string", (ReadUser or WriteUser)
"password": "string" (The password you enter here is the password you will provide when connecting to the database)
This endpoint encrypts your password and saves it in Sisense application database. When you connect to the application database, use the plaintext password you entered as the value of the password parameter, not the encrypted password returned by the API.
Once you have defined the username and passwords for your application database users, these users can connect to the application database through applications such as RoboMongo or when importing data into an ElastiCube from your application database as described in Connecting to MongoDB.
For example, in RoboMongo, you can connect to your local application database by connecting to the Address localhost through port 27018.
In the Authentication tab, enter the name of the Sisense application database, admin, and your username and password. The username is the user whose password you changed, in this example, ReadUser. The password is the password you provided through the POST admin/app_database/change_database_user_password endpoint. This password is not the encrypted password that was returned, but the password you defined as the value of the password parameter, for example “mypassword”.
Click Test to verify that your user can connect. If your credentials are authenticated successfully, click Save and then connect to the database. Your application database tables will be displayed.
Hey! Was this article helpful?
Questions? Ask the community.