Migrating a Sisense Installation

This topic describes migrating a Sisense installation from one machine to another.

Backing up your installation is recommended before a migration process, but also on a regular basis for securing your data and Sisense configurations.

You may need to migrate your entire setup when moving from a staging/development environment to a production environment, when upgrading hardware, etc.

The migration process involves migrating both the Sisense application database and your ElastiCubes.

Additionally, if you are using plugins, you will need to replace the Plugins folder with your current plugins located at C:\Program Files\Sisense\PrismWeb\plugins.

Migrating ElastiCubes

The ElastiCube Server contains your ElastiCubes. To migrate ElastiCubes, you must export them as .ecdata files and import them into your new environment. If the data sources that support the ElastiCube are at a different location than they were on your original server, the ElastiCube’s connectivity settings must be updated.

To migrate your ElastiCubes:

  1. Declare downtime to avoid the loss of work during the process and stopping the IIS service. You can stop the IIS service by running the command iisreset /stop in the Command Prompt as an Administrator. Do not close the Command Prompt as you will need it in Step 3.
  2. Export and import your .ecdata files. See Importing and Exporting Elasticube Data for more information.
  3. In the Command Prompt, run the command iisreset /start to restart your IIS Server.
  4. If the database location was changed as well, modify the connectivity settings. See Change Connectivity Settings to learn how.

Sisense Web Application

To migrate your Sisense Web Application configuration, you must copy several configuration files from the current environment and migrate these files to the new environment in the same directories. These configuration files are used by Sisense to allow communication between the Sisense application database and the Sisense Web Application.

To migrate the Sisense Web Application:

  1. Back up the old environment, open your machine’s Control Panel, and go to System and Security > Administrative Tools > Services, and stop the SisenseRepository service (this will make the website inaccessible).
  2. Create a copy of the entire Repository directory located at:
    %ProgramData%\Sisense\PrismWeb\Repository
  3. Replace the existing Repository directory in the new environment with the one you backed up.
  4. Create copies of the following configuration files and paste them into the same directories in the new environment:
    %ProgramFiles%\Sisense\PrismWeb\ECMNext\GraphQL\src\config\default.yaml
    %ProgramFiles%\Sisense\PrismWeb\vnext\config\default.yaml
    %ProgramFiles%\Sisense\Infra\MongoDB\mongodbconfig.conf
    %ProgramFiles%\Sisense\PrismWeb\App_Data\Configurations\db.config
    Note: In each of the default.yaml files are the application database user credentials that the Sisense Web Application needs to access the Sisense application database. In these files, verify the values of user and password match.
  5. Start the SisenseRepository service. Your Sisense configuration has now been migrated to the new environment.