Wednesday, December 14, 2016

Migrate OneView Reporting Repository





Step 1 - Login to current OVR BI Server and gather information -

Navigate to Business Intelligence –> coreapplication and click on Scheduler tab here you can find the DataSource and User id for old schemas



 I have taken following notes
Username –> PROD_BIPLATFORM
Password ->  Extract from your notes.

Go to Services – Data Source
 






Click on bip_datasource - > Configuration -> Connection Pool
Note down URL.














Repeats same for mds-owsm

 




Step 2 – Run RCU on new Environment
Download  Repository Creation Utility (RCU) from the below link.
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/biee-111150-393613.html

Extract and navigate to rcuHome\BIN and double click on rcu.bat and create Schemas