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 a script 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 an earlier version. You can download the scripts below:

MongoBackup.bat: This script is used for backing up your MongoDB.

MongoRestore.bat: This script is used in case you need to restore the backed up information.

Creating a WriteUser

To be able to access the application database, you need to have a WriteUser to your MongoDB. See Accessing the Sisense Application Database for instructions on how to create a user with WriteUser access to your Sisense application database.

Changing the Credentials

After you have created 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 only script you should schedule is the MongoBackup.bat, as you’ll only use MongoRestore.bat in case you need to restore your data.

The easiest way to schedule a back up is with Windows Task Scheduler. For information, see Schedule a Task.