How to export and then import OBIEE catalog

User_3V9PJ

I have some reports thare currently in a folder with Shared Folders and I need to export the catelog from my production environment to my pre-production enviroment - suggestions please...

Gianni Ceresa

Catalog Manager has an archive and unarchive feature. Did you try it?

Gianni Ceresa

The first thing to do is to know if you just want to copy a part of the catalog, a folder and all its content for example, or the whole catalog (including the personal folders).

If it's the first case (that's what your original question hints at), if you have an account with the permissions to access all the objects in the folder you want to copy, you can do it from the web interface directly, just open the 2 environment in 2 pages: archive in one, download the file on your PC, unarchive in the second by uploading the file you just saved.

In alternative to the web interface you can use Catalog Manager installed when you install the OBIEE client tools. Connect to one environment, archive and save the file somewhere, connect to the second environment and unarchive the file.

If permissions can be a problem, you will have to work offline. You can connect in offline mode with the Catalog Manager tool, but that requires to be on the OBIEE server itself (if it's a linux without GUI, Catalog Manager also fully works by command line). When connecting offline you should provide the path on disk where the catalog is physically stored (and in OBIEE the catalog is still on disk, it's only with OAS that it has been moved inside the database).

Sumanth V -Oracle

Hi @User_3V9PJ,

If you are looking to move only specific catalog folders and objects you can use Archive(source env) and Unarchive in target environment.

If you want to move the entire catalog you can use BAR file approach if it's OBIEE 12c and higher versions.

User_3V9PJ

What process is required for the BAR file approach to export (and then import)

EzequielC-Oracle

Hi @User_3V9PJ ,

To export/import using BAR fil, please look at this MOS note:

2611464.1 OBI 12c: How To Export/Import Metadata To/From A BAR File Using 'exportarchive' And 'importarchive' Commands

Here is the Oracle documentation:

Managing Metadata and Working with Service Instances

https://docs.oracle.com/middleware/bi12214/biee/BIESG/GUID-7FCD90A3-E005-49BF-902F-30FBF9B41B07.htm

Regards,

Ezequiel.

User_3V9PJ

WIll the Catalog manager allow me to export and tehn import the catelog to a different environment

Gianni Ceresa

Yes, because the "archive" generate a file, and when you do the "unarchive" you much provide the file you want to unarchive.

You just have to connect to the 2 different environments for the job.

User_3V9PJ

What is the best way to connect the environments to complete the process