Gene's Notes

Being a DBA is just like being a rock star - except for the groupies, and the music, and the private jets. OK - it's not much like being a rock star.

Name:
Location: Columbus, GA, United States

Wednesday, July 15, 2009

Trade Your F-150 Discoverer Pick up for an OBIEE Lexus

It's always true - I'm never sure how many people will be there when I give a presentation. Will it be 4 or 40? And then when I have a topic that's a bit narrow, I'm really surprised when I get 30 people. But that's how many people wanted to find out about trading in a F150 Discoverer Pick-up truck on a shiny new OBIEE Lexus this past May at Collaborate 2009 .All the people in the room were Discoverer users or admins. None had OBIEE. That really shows the push throughout various industries for companies to work towards better, faster, more robust business intelligence.

My talk stepped through how to extract Discoverer metadata, and migrate that to OBIEE repository files. Then we saw how to verify the success of the migration by connecting back to the original database and viewing some results.

What was interesting was the depth of the questions the attendees were asking:
Will my current security model be used by OBIEE?
When we migrate to OBIEE, can we turn off the old Discoverer database with metadata?
Can we run OBIEE in a Linux environment?

So the basic steps to get your Discoverer EUL metata into OBIEE? (See the answer to this one below)- Extract the Discoverer Metadata- Use the OBIEE migration tool- MigrateEUL.exe- Create a new RPD file- OBIEE uses repository Data file- Verify connectivity in new RPD file- View the new OBIEE reports
My white paper goes into more detail, but as you can see the basic steps are few.
BTW - I drive an old Hyundai!