Migrate Content to Other Catalogs

Administrators can copy catalog content from one environment to another using the catalog archive and unarchive options. Archiving saves your content to a .catalog file on your local file system. Unarchiving uploads content from catalog files to another catalog location.

Save Content to a Catalog Archive

Administrators can copy or move content you create in one environment to another environment using the catalog archive/unarchive feature. Archiving saves one or more objects or folders that contain multiple objects to a .catalog file on your local file system.

You can upload the .catalog file at a different location.
  1. On the Classic Home page, click Catalog.
  2. Navigate to the folder or object you want to copy or move to another catalog.

    If you select a folder, all the content in that folder is included in the catalog archive, including any subfolders.

    To select multiple items, press and hold the Ctrl key, and click the objects you want.

  3. Select More and then select Archive.
  4. Select Keep Permissions to save the permission settings, if any.
    If you don’t select this option, permissions are excluded. This can be useful if you're migrating content from a test environment and none of the permissions you assigned to test users are required in the production system. When you unarchive, the content inherits permissions from the parent folder on the target system.
  5. Select Keep Timestamps to save information such as time created, last modified, and last accessed.
    When you unarchive, timestamp information is retained and you can choose to only overwrite items that are older than those in the catalog archive.
    If you don’t select Keep Timestamps, the original age of content isn’t saved or considered when you unarchive the content.
  6. Click OK.
  7. Select Save File.
    If you want to, change the name of the catalog file.
  8. Select a folder and click Save.

Upload Content from a Catalog Archive

Administrators can upload content from Oracle Analytics and Oracle BI Enterprise Edition 11.1.1.9.0 or later. Select the custom catalog folder where you want the content to go, and , if you have BI Consumer permissions, you'll see an Unarchive option. Point to a catalog archive, any valid .catalog file, to copy its content to this folder.

  1. On the Classic Home page, click Catalog.
  2. Navigate to a custom folder where you want to unarchive the content of your file.
  3. In Unarchive, click Browse to select the archive file.
  4. In Replace, select an option:
    • None: Never overwrite existing content. This is the default setting.
    • All: Overwrite existing content, except for content marked Read-Only.
    • Old: Overwrite existing content if it’s older than the content in the file.
    • Force: Overwrite all content, even newer content and content marked Read-Only.
  5. In ACL, select an option.
  6. Click OK.

For reports to work, all the required tables and data must be available to Oracle Analytics. Load the data or connect to the data if it’s stored in an Oracle Cloud database.

Track the Progress of Your Catalog Unarchive Tasks

Administrators can track the progress and current status of any catalog unarchive operations that you initiate from the Unarchive Tasks tab.

Large catalogs might take some time to process. Check the information on this tab to find out when your task starts or completes, and troubleshoot any errors that might occur.
  1. Navigate to the Classic Home page.
  2. Click My Profile, and select Background Tasks.
  3. Click Unarchive Tasks.

    If the tab doesn't display, clear the browser cache.


    Unarchive

  4. Check the status to see whether your unarchive operation is complete, still in progress, not started yet (submitted), or failed for some reason.