1. Migrating and Upgrading to Oracle Analytics Server
  2. Migrating to Oracle Analytics Server
  3. Migrating from Oracle Business Intelligence 12c or the Previous Release of Oracle Analytics Server

Migrating from Oracle Business Intelligence 12c or the Previous Release of Oracle Analytics Server

If you want to use a new server, or change the operating system, or use a newer version of operating system for Oracle Analytics Server, install Oracle Analytics Server in the new server, and migrate your metadata and configuration from Oracle Business Intelligence 12c or the previous release of Oracle Analytics Server to the latest release of Oracle Analytics Server.

Choose the correct metadata export script depending on the release of the source system.

When you perform an out-of-place migration from a source system, you export a BAR file from the source system, and then restore the content of the BAR file in the target Oracle Analytics Server system. After you restore the BAR file in your target system, you must explicitly add additional application policies to your Administrator application role so that you can perform administrative tasks in Oracle Analytics Server.

To review your application roles and polices, see Manage Application Roles. To see the permission sets available in Oracle Analytics Server or to change any of these default assignments, see Grant or Revoke Permissions Assignments.

  • Export Metadata Using Command Line
    This topic describes the steps to create an archive file (.bar) from Oracle Business Intelligence 12.2.1.4.0 or the previous release of Oracle Analytics Server using command line. If you want to export metadata from other 12c releases, use the corresponding command to create the export bundle.
  • Import Metadata in Oracle Analytics Server
    This topic describes the steps to import the metadata archived in a .bar file (snapshot) from the source system that you previously saved on your local file system. The time it takes to import the snapshot depends on the size of the snapshot .bar file.

Parent topic: Migrating to Oracle Analytics Server

Export Metadata Using Command Line

This topic describes the steps to create an archive file (.bar) from Oracle Business Intelligence 12.2.1.4.0 or the previous release of Oracle Analytics Server using command line. If you want to export metadata from other 12c releases, use the corresponding command to create the export bundle.

To create archive file (.bar) from Oracle Business Intelligence 12.2.1.4.0 or the previous release of Oracle Analytics Server (source system):
  1. In your source system, navigate to:
    • (Linux) DOMAIN_HOME/bitools/bin/
    • (Windows) DOMAIN_HOME\bitools\bin\
  2. Run and view the exportarchive command help:
    • (Linux) exportarchive.sh -help
    • (Windows) exportarchive.cmd -help

    Note that the service instance key and the export directory are mandatory arguments.

    Provide an encryption password when you run the exportarchive command because the importarchive command expects an encryption password.

  3. Generate the archive file (.bar) . For example, run the following command to generate the archive file (.bar) and save the archive file (.bar) in the temp directory. The default service key name is ssi.
    • (Linux) ./exportarchive.sh ssi /temp
    • (Windows) exportarchive.cmd ssi /temp

Parent topic: Migrating from Oracle Business Intelligence 12c or the Previous Release of Oracle Analytics Server

Import Metadata in Oracle Analytics Server

This topic describes the steps to import the metadata archived in a .bar file (snapshot) from the source system that you previously saved on your local file system. The time it takes to import the snapshot depends on the size of the snapshot .bar file.

When you import a snapshot, the file itself is uploaded to your system but the artifacts stored inside the snapshot aren’t immediately available in your environment. Snapshots you import display in the snapshot list. When you’re ready to do so, you can overwrite your current artifacts, such as your catalog, by restoring the snapshot.

  1. In the Oracle Analytics Server Home page (URL format: https://host:port/dv), click the Navigator and select Console, and then click Snapshots.
  2. Click the Page menu Page menu , select Migrate, and then click Import Snapshot.
  3. Click Select to locate the export bundle that you want to upload.
    Select the snapshot file (.bar) contains the metadata from your source system.
  4. Enter the snapshot password.
    This is the password that you specify whenever you download a snapshot to your local file system.
  5. Click Import.

Parent topic: Migrating from Oracle Business Intelligence 12c or the Previous Release of Oracle Analytics Server