Migrate from Oracle BI Enterprise Edition 11g

You can migrate data models, dashboards, analyses, and application roles from Oracle BI Enterprise Edition 11g to Oracle Analytics Cloud. Before you start, download a migration utility to a Windows or UNIX system.

  1. Download the Oracle Analytics Cloud migration utility.
    1. In Oracle Analytics Cloud, click Console and then click Snapshots.
    2. Click the Page menu Page menu , select Migrate, then Download BI EE 11g Migration Utility. Follow the instructions to save the migration-tool.jar file locally.
  2. Copy the JAR file for the migration utility that you downloaded to your Oracle BI Enterprise Edition 11g environment.
  3. Run the migration-tool.jar file in your Oracle BI Enterprise Edition 11g environment.

    Usage:

    java -jar migration-tool.jar out oracle_home domain_home instance_home_optional export_jar_location

    For example:

    java -jar migration-tool.jar out /u01/app/oracle/bi /u01/app/instance/domains/example.com/myDomain /u01/app/instance/BIInstance /tmp/myBIEE11gContentBundle.jar
    The tool exports your content to a file. In this example, the file is named myBIEE11gContentBundle.jar.
  4. Upload your Oracle BI Enterprise Edition 11g bundle and restore the content on Oracle Analytics Cloud.
    1. In Oracle Analytics Cloud, click Console and then click Snapshots.
    2. Click the Page menu Page menu , select Migrate, then Upload and Restore BI EE11g Migration Bundle.
    3. Click Select to navigate to the migration bundle (JAR file) containing the content you want to migrate.
    4. Enter the password for the data model file (RPD file) included in the JAR file.
      It's important to enter the correct password here. Content migration fails if the password you enter doesn’t match the password required to access the data model file.
    5. Click Upload and Restore .

    Allow a few minutes for the content to upload and refresh through your system. The time it takes depends on the size of your content bundle. Sign out, then sign back in after, say, 15 or 20 minutes to see new content and inherit newly restored application roles, if any.

  5. Verify that your subject areas, analyses, and dashboards are available as expected.