Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OWB with OBIEE

712117Aug 24 2009 — edited Jun 21 2010
Hi All,
I am a newbie in the Oracle OWB - OBIEE space. Please help me get going.

- I have already completed OBIEE setup to directly report from Oracle DB (E-Business Suite)
- Now I am struck with the flow where I bring in OWB as an interface between DB & OBIEE
- I intend to create joins, mappings in OBIEE, so I am looking for no transformations to happen in the OWB stage

Please answer my following questions.
1. In OWB, I have created 'Data Sources'. Do I have need to have a 1-to-1 'Warehouse Target' for every 'Data Source' created within OWB ?
(a) If YES, should 'Warehouse Target' necessarily be on a different physical server or can I use the same server ?
(i) If on a same server, should I create a new user and a new location for the Warehouse Target ?

2. Anyways what are the 'Connection parameters' for me to use from OBIEE to connect to OWB ?

Thanks in advance.
-Karthic
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 19 2010
Added on Aug 24 2009
10 comments
3,535 views