Migrate Multiple Essbase Instances to a Single Shared Services Instance

Here you can learn how to migrate multiple Essbase instances to a single Shared Services instance. When you have a large number of applications and using LCM is not feasible to export you applications, the following steps can be used.

Note:

This feature is available only for independent deployments.

Back up multiple Essbase instances

To migrate, first do a backup of the instances.

  1. Back up content of the source application directory.
  2. Back up the source Essbase Relational Database Schema.
  3. Back up EPM Shared Services assigned roles.
  4. For all the above steps, see the instructions in Back Up Essbase: EPM Security Plus Shared Services Native Directory.
Restore multiple Essbase instance to a single Shared Services instance

Then do a restore of the instances.

  1. Restore the <Application Directory> Folder Contents from the Source Backup into the Target Instance. See: Restore Essbase: EPM Security Plus Shared Services Native Directory.
  2. Restore the Essbase Relational Database Schema. See: Restore Essbase: EPM Security Plus Shared Services Native Directory.

    Note:

    While restoring the Essbase Relational Database Schema, make sure dump file content matches the target cluster name, otherwise change it before importing.