We have installed OBIEE 11g and PeopleSoft HRMS 9.1 with BI Apps 220.127.116.11. We want to integrate these components so that we can navigate from PeopleSoft to OBIEE and vice versa. Can you please suggest what is the best way to achieve this?
1) Can it be done without SSO?
2) If SSO is to be used then which tool is good to use?
Here is a good Metalink note and article that has a step by step on integrating 11g with PSoft via SSO:
Oracle Business Intelligence Applications Integration with PeopleSoft Enterprise Applications (with Oracle Single Sign-On) [ID 1111804.1]
My understanidng is that this is the best approach to do this..whereby the users log into the source system (PSoft, EBS, etc)..and piggy back off of the credentials to log into OBIEE.
I believe there is also external table authentication but I am unaware if anyone has actually done this successfully as this is more complex and requires a deeper understanidng of the security tables in the source system.
If this was helpful, please mark the response as correct or helpful
Thanks for you reply. But that document is focused on OBIEE 10g whereas we want to integrate OBIEE 11g. Also it is using Application server 10g which i think Oracle does not recommend now for the new development on OBIEE 11g.