Sharepoint-Apex Single Sign-On
640627May 21 2008 — edited May 22 2008Hello guys,
I'm a newbie in Oracle ApEx environment.
Last couple of days I've searched all over the Internet a solution to my problem. I've decided to share it, maybe I can found a solution:
So, I have an application in APEX and I want to publish it in my Sharepoint Portal. Everything's ok so far. The problem appears when I want to use the Sharepoint user's login for the autologin in APEX. In other words, when a user logs in the Sharepoint Portal, I want to use the same username and password to automatically log in the APEX application.
For the moment it doesn't matter where the user & password are kept. Could be the Active Directory Repository as both Sharepoint and APEX can use LDAP as authentication provider. Or we can use any other auth provider that works with both.
I'm searching for something simple, without additional servers (like OID or Oracle SSO).
I've tried to create a custom authentication from scratch on the APEX, but I don't know how to write my Page Sentry Function so that I can access the Sharepoint Login information. I was thinking of using the Sharepoint Authentication Cookie but I don't know how.
The APEX is from Oracle Database 10g Express Edition (so it's Application Express 2.1.0.00.39) and the portal is Microsoft Sharepoint 2007.
Do you have any suggestions?
Thanks,