Oracle Discoverer to Oracle BI Enterprise Edition

Tuesday I went to a session regarding migrating Oracle Discoverer to OBIEE which was a very interesting resume on do’s and don’ts when migrating.

First of all only metadata is migrated, not the reports itself. When you think about that is a logical approach as well because you don’t want all your front-end reports and logic to be delivered in OBI. OBI has a lot of more features which you wouldn’t be using when migrating as well metadata as reports.

Tip: Use different rpd-files when you have loads of data to resolve performance issues because BI Server reads through the whole rpd-file when starting up.

How to start migrating:

Export ‘End User Layer’ in discoverer to a .eex file

The migrate tool itseld is a windows based tool which you can use command-line to migrate the .eex file to an .rpd file. You can change the properties of the migration tool in the MigrationConfig.properties file.

Copy the .rpd-file to your BI Server/Repository folder

Define which .rpd-file to start-up with in the NQSConfig.INI file

Update the .rpd-file online

Login to your OBI-environment and open up the Answers-tab to look through the Subject Area and data that has been created using the .rpd file. From now on you start creating your own reports as a business user.

What isn’t migrated when opening the rpd-file in OBI EE:

You have to reestablish the connection to your database

You have to define a password for your Administrator user otherwise your BI Server won’t come up on your linux environment. This is a very important tip: because it takes a while to find out which error occured when you’ve migrated your discoverer metadata to an .rpd file and your BI Server crashes.

Post navigation

2 thoughts on “Oracle Discoverer to Oracle BI Enterprise Edition”

Hi…I’m starting to learn about BI using Oracle. A few years ago I learn using Oracle BI Disoverer. Now, when I want to learn Oracle BI I found Oracle BI Enterprise. Coluld You give me the explanation regarding these two tools?

Oracle Discoverer gives you the possibility to define reports for end-users in Oracle BI EE you can also define reports for end-users but you have loads of other possibilities, e.g. each user has it’s own user-defined reports and dashboards with pre-filtered data, a user can define his/hers own reports, data can be exported to excel, word, powerpoint, pdf, you have api’s to deliver reports using web services, … You can find all needed information regarding these products on the oracle websites such as oracle.com and technet.oracle.com. You have specific technical questions, issues regarding these tools or regarding migration please leave a message.