We'll soon start an upgrade of our Forms / Reports 6i Application to 11g.
I was wondering, maybe, it would be nice to add some value for the upgrade process as a whole, using some of Apex new features like web mobile interface or maybe an integration between Forms an Apex, for example to provide users with the powerful features of Interactive Reports, just to name one.
I have found this interesting link: http://roelhartman.blogspot.com/2008/11/integrate-oracle-forms-with-apex.html. (not a 100% clear for me, but at least it is a start).
Obviously, to make it attractive, one would expect automatic login between the two Apps. As far as i know, this could be done like this:
1) Using SSO. With that a Portal / Forms / Reports/ Discoverer/ version would be mandatory (too expensive for some clients).
2) Oracle Access Manager? Not sure, can Oracle Forms connect to Access Manager? or LDAP? How about the licensing costs?. Not a clue.
3) Make all Apex pages public? Not feasible.
4) Now this one: in our forms application, every user authenticates within the application and we internally map that application user to an actual database user. At all times we hold metadata info about the current user (app, and DB), as well as application context. So this is my question:
It is possible to create an Apex app, with database authentication method, and somehow pass the metadata from forms, and have a kind of custom login procedure that does all the application to DB user conversion process and application context setting????
This is a very important question for us, although not sure where to really post it...
Feedback will be greatly appreciated .....!
As far as I understand SSO and Access Manager are included with the license for running forms/reports on Application Server/Weblogic.
For details pertaining to Forms 11gR1 see http://docs.oracle.com/cd/E12839_01/doc.1111/e14860/products.htm#FMWLC189
You're talking about integrating forms and APEX.
I'm saying that forms comes with a license to use sso, and as APEX is licensed with the DB you should be able to use it.
Actually I think you're right, the froms sso license only applies if you use it for forms/reports only.
Yes, i think so. But back to my question: is it possible to create an Apex app, with database authentication method, and somehow pass the metadata from forms, and have a kind of custom login procedure that does all the application to DB user conversion process and application context setting??? (NO SSO).
Regars, Luis ....
I did something like that once. What you can do is set some random session id after logging in in Forms. Pass this session id to Apex every time and let Apex check if it is a valid session id.
More information here:
In that example I create a new session id on every call to an Apex page from Forms, but you can use the same session id as long as the user is logged in in Forms.