Backing Up the Sisense Application Database

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.

This page describes how to back up the application database with scripts prepared by Sisense and schedule the back up with Windows Tasks Manager.

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.

Following -u, replace WriteUser with your application database user’s username and after -p, replace Sisense with your password.

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.