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.

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

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.

When you export/import a BAR file, the snapshot shows the artifacts included in the export/import. Note that a BAR file does not contain the actual Semantic Model (SMML) files. Instead, it contains pointers (metadata) to Semantic Model files stored in archived form in the Singleton Data Directory (SDD).

After you restore a snapshot, the following object types require their referenced data files to be present in the correct location:

  • File-based data used by datasets and other components
  • Custom map data
  • Semantic models (saved but not deployed semantic models)

These referenced data files are stored under: <SDD>/components/DSS/storage/bootstrap

The Singleton Data Directory (SDD) location is configurable. See Configuring the Singleton Data Directory (SDD).

In Oracle Analytics Server, to migrate these files from one environment to another, copy the entire contents of the bootstrap folder from the source environment to the target environment. Partial migration isn't supported.

Use the user interface to migrate:

  • Specific non-deployed semantic model files: Export these files using the user interface.
  • Specific file-based data for datasets: Download the data in the source environment using the user interface, then upload it in the target environment.
  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.