Automatically Backup Sisense Web Data
Applicable to Sisense on Microsoft Windows
The Sisense application database installed with Sisense contains metadata for ElastiCubes, dashboards, and users. As your metadata can change frequently, Sisense recommends backing up your application database regularly.
Sisense provides scripts that will back up your application database and restore it if necessary. To back up your application database, you need to create an application database user with WriteUser access and then replace the credentials in the script. Once the credentials have been updated, you can schedule the scripts to back up your database with the Windows Task Scheduler.
Note: This page is relevant for Sisense V6.7 and later.
Downloading the Scripts
There are two scripts Sisense provides one for backing up the application database and a second for restoring a back up copy of your application database. You can download the scripts below:
MongoBackup.bat: This script is used for backing up your application database.
MongoRestore.bat: This script is used in case you need to restore the backed up information.
Activating a WriteUser
To be able to access the application database, you need to have a WriteUser to your application database. See Accessing the Sisense Application Database for instructions on how to activate a user with WriteUser access to your Sisense application database.
Changing the Credentials
After you have activated a WriteUser for the Sisense application database, you need to replace the credentials in the relevant script file.
The example below displays where you need to add your WriteUser’s credentials.
Scheduling Back Ups
The MongoBackup.bat is the script you should use to schedule periodic backups of your application database. The MongoRestore.bat should not be scheduled as you use it only to restore a back up file.
The easiest way to schedule a back up is with Windows Task Scheduler. For information, see Schedule a Task.