OWB with OBIEE
712117Aug 24 2009 — edited Jun 21 2010Hi 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