Migrate Content to Other Catalogs

You 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

You can copy or move content you create in one environment to another environment using the catalog archive/unarchive feature. Archiving saves a single object or a folder containing multiple objects to a .catalog file on your local file system.

You can upload the .catalog file at a different location.
  1. On the 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.
  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

You can upload content from Oracle Transactional Business Intelligence 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 Home page, click Catalog.
  2. Navigate to a custom folder where you want to unarchive the content of your file.
  3. Select Unarchive.
  4. Click Browse. to find the catalog file.
  5. New content is always uploaded but you can decide what happens when matching content exists in the target catalog.

    For Replace, select one from:

    • 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.
  6. Click OK.

Track the Progress of Your Catalog Unarchive Jobs

You can track the progress and current status of any catalog unarchive operations that you initiate from the Unarchive Jobs tab in your My Accounts dialog.

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

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


    Unarchive Jobs tab

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