Thanks for the question, Anwar.
Asked: January 27, 2016 - 11:04 am UTC
Last updated: January 27, 2016 - 3:11 pm UTC
Version: APEX 5
Viewed 10K+ times! This question is 
You Asked
Hi Tom:
I've been using and recommending Oracle products for past 15 years. I've been a tacit fan of your posts and articles on this site for years. Now I think that I need your help as well. I've been working as a consultant with a credit bureau and am currently involved in project to upgrade application developed entirely in mod-plsql into a scaleable and supported platform.
We've been considering three alternatives:
1 - APEX
2 - ADF
3 - Oracle Fusion Middleware 12c (Oracle forms/reports 12c)
Our development team has a great deal of experience in Oracle Developer, SQL, PLSQL & mod plsql and can move to forms/reports 12c without much ado. However, I want to know if we could consider APEX as a scaleable solution which can run without any performance issues for:
a] large number of concurrent users (500 users)
b] multiple data file (text files) uploads of 1 million lines of 1000 characters wide each
c] multiple team members of development team working on the same project (checking in / checking out in version control system)
d] Support to integration with web-services
e] an easy switch for a forms/reports 6i develper
What's the target audience of APEX? I mean is it geared towards small and medium enterprises?
Also, if we have to consider ADF as the future development course; what should we expect and how much efforts would be required to convert a forms 6i or mod plsql applications in ADF in comparison with APEX and Oracle Forms?
Thank you & best regards
Anwar Kamal
and Chris said...
APEX runs in the database, so it scales with the database. Meaning very well.
It's a rapid application development tool. It's suitable for any enterprises who want fast application development against the Oracle database.
It support REST and SOAP web services. There is file upload capabilities.
It uses PL/SQL, so your forms developers should find it an easy change.
Converting from an application Forms -> APEX depends upon how much of your code is in database compiled PL/SQL and how much is in the forms themselves. If you've mostly used PL/SQL, then it could be relatively easy. If all your code is tied up in the forms and you do a lot of fancy stuff in the UI it may be trickier. You'll have to do this analysis yourself.
I've no experience with ADF, so can't comment on ADF vs. APEX.
Is this answer out of date? If it is, please let us know via a Comment