Migration of RPD and catalog from Development to Test Environment OR Deployment of RPD and catalog

The Migration of RPD and catalog is very known subject of oracle BI but I feel it is very much important as well.

In OBIEE11g it is very easy to deploy the RPD and catalog, as OBIEE11g provided the Enterprise manger to control parameter of instanceconfig.xml and NQSConfid.ini files parameter.

If anyone want to migrate the RPD and catalog from Dev to test then he just need to copy the .rpd file and catalog directory from dev to test.

The default location of

RPD is Oracle_Home\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository

Catalog is: Oracle_Home\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog

The location of RPD and catalog may be the different according to user or there requirement, if the OBIEE server is clustered and sharing the RPD and catalog then the location may be at shared location.

To deploy the RPD and catalog on Test environment follow the following steps 

1)  Log in to the Enterprise Manager(EM)

      URL: http://Machine_Name:7001/em(7001 Default Port)

 
2) Clock on Business Intelligence -> coreapplication  present in left pan

         
3)  Select the Deployment tab and Repository sub tab

      
4) Click on Lock and Edit Configuration button, and this will enable to upload the new RPD

 
5) Then the brows button will enable click on it and select the RPD and specify the path of catalog in catalog location text box

        
6) Click on Activate Changes Button, one Confirmation windows will popup click on ok

        
7)  After changes are getting activated, click on Restart to apply recent changes link, it will navigate over Business Intelligence ->Coreapplication page. Click on Restart