Migrate Applications Using Migration Utility

You can use Migration Utility to migrate source applications and elements from Oracle Analytics Cloud - Essbase deployments and Essbase OCI releases. The utility migrates multiple applications at one time. It also migrates artifacts, rules, users and groups.

As an Essbase Service Administrator user, you can use Migration Utility to migrate an entire instance (all applications, users and groups, and other artifacts) from one cloud instance to another in a single process. Note that the Essbase Command-line Interface (CLI) commands, lcmimport and lcmexport do not migrate users and groups.

Before using the Migration Utility, the following is a prerequisite: Set Up the SSL Certificate.

Here are some use cases for migrating with Migration Utility.

• WebLogic LDAP users can migrate the users from LDAP in the source to Identity Cloud Service in the target.
• Use this utility for basic deployments that aren’t customized. If your deployment includes customizations, such as custom Single Sign On solutions, use CLI instead of Migration Utility.
• When the source deployment is from
  • Oracle Analytics Cloud - on Oracle Cloud Infrastructure, using Identity Cloud Service Native Security, or
  • Oracle Analytics Cloud - on Oracle Cloud Infrastructure Classic, using Identity Cloud Service Native Security, or
  • Oracle Analytics Cloud - on Oracle Cloud Infrastructure Classic, using Embedded LDAP
  • Essbase Marketplace on Oracle Cloud Infrastructure, using Identity Cloud Service Security, or
  • Essbase Marketplace on Oracle Cloud Infrastructure, using Embedded LDAP
  then before using the Migration utility steps below to export, first create a new Identity Cloud Service application as outlined in Create a Confidential Identity Cloud Service Application. Also, before using the Migration Utility steps below to import, change the host and Identity Cloud Service details in import.properties to point to the target Essbase instance.

To migrate cloud service applications and users using Migration Utility

1. Before you use the utility, if you haven’t already, patch your source Essbase instance to the latest version.
2. If it isn't already installed, download and install Java SE Development Kit (JDK) 8 from Oracle Technology Network.
3. Set the JAVA_HOME environment variable name on your system to point to the JDK installation folder. If the installation path contains any spaces, enclose the path in the variable value, within quotation marks, for example, "C:\Program Files\Java\jdk1.8.0_171".
4. Sign in to the target Essbase, and navigate to the Console tab.
5. In the Console, go to Desktop Tools, and expand Command Line Tools.
6. Click Download next to Migration Utility.
7. Download the Migration Utility zip file to a local drive. For best results, choose a path that has no spaces, for example, C:\Oracle.
8. Extract the zip file, and see the extracted files (properties, jar, and readme) in the migrationTools folder.
9. Before you run the import or export commands provided with Migration Utility, you must edit the properties files.
   1. Edit the properties strings in the export.properties file:
      • userName - Essbase administrator user name.
      • password - Essbase administrator password.
      • host - Essbase host or IP address.
      • port - Essbase port. Enter the value of 80 for LDAP source. Otherwise, accept the default value of 443 (SSL/TLS) for Identity Cloud Service source.
      • proxy - proxy server URL.
      • skiprole - import of roles from Oracle Analytics Cloud - Essbase is skipped. Value must be left empty or true.
   2. Edit the properties strings in import.properties file:
      • userName - Essbase administrator user name.
      • password - Essbase administrator password.
      • host - Essbase host or IP address.
      • port - Essbase HTTP listening port. Default value 443 (SSL/TLS).
      • userPassword - Initial password assigned for all new users.
      • proxy - proxy server URL (optional)
   3. Edit Identity Cloud Service information in import.properties. Obtain these values from the Service Console for Oracle Identity Cloud Service.
      • idcsHost - Identity Cloud Service host
      • idcsTenant - Identity Cloud Service tenant
      • clientId - Client identifier for OAuth authorization
      • clientSecret - Client secret for OAuth authorization
      • appId - Application identifier
10. To run Migration Utility, use the following java command to export all applications, users, and groups from the Essbase source instance catalog to a tar file.

    java -jar -Dhttps.proxyHost=<proxy-url> -Dhttps.proxyPort=<nn>
          migrationTools.jar export export.properties <new_tar_file>

    for example:

     e.g. java –jar -Dhttps.proxyHost=www-proxy-abcdef.example.com
          -Dhttps.proxyPort=80 migrationTools.jar import import.properties 115ldap.tar.gz

11. After you export from the source instance, use the following java command to import the data tar file to the target instance.

    java -jar -Dhttps.proxyHost=<proxy-url> -Dhttps.proxyPort=<nn>
          migrationTools.jar import import.properties <existing_tar_file>

12. After you run the import, the data is stored in the Essbase catalog of the target instance. If any exported applications already exist on the target, they aren’t overwritten.