Oracle BI Catalog Merging

Ok, now let's talk about migrate catalog of Oracle BI. There was an issue when I wanted to 'merge' or migrate catalog from one server to another. Here some ways to merge the catalogs


• Upgrade catalog
• Archive Unarchive
Details:
a. Find active catalog:
- In folder OracleBIData\web\config, find instanceconfig.xml file.
- Active catalog is referred to in tag .

b. Copy the catalog to desired location (for merging). In our case we should have two offline catalogs; development and production. It is better to put both catalogs on the same machine, related to performance when merging.

c. Choose one of the following ways to merge

d. Upgrade catalog
- Open Catalog Manager
- Open offline one of the catalogs


- Select Tools then Upgrade Catalog


- Choose Original Presentation Catalog and Modified Presentation Catalog. If one of the catalogs is original (has no changes), choose the catalog for Original Presentation Catalog, if both of them have any changes, choose any of them to be the Original Presentation Catalog.

- Notes: Upgrading the catalog only add what is previously not exist in original, any changes on modified catalaog of existing items will not be applied


e. Archive
- Open 2 Catalog Managers
- Open offline both catalogs
- On one Catalog Manager, select folder to archive, then File | Archive.



- On the other one select the folder where we want to unarchive, then File | Unarchive
- Notes: Archiving cannot be performed from root folder, add what is previously not exist in original and any changes on modified catalog of existing items will be applied

OK that's for now.