This content has been marked as final. Show 3 replies
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