APEX? Live happy, deploy happy!
September 13, 2018

APEX? Live happy, deploy happy!

Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Application Express

We use APEX for internal applications that provide services to users within the institution.
We used APEX to implement systems that would solve the problems, for example, lack of internal controls, lack of indicators that show the amount of work performed through informal requests by email or phone calls.
Due to the high level of requests, a web tool was chosen to allow the design, development, and deployment of applications quickly and agilely. Without incurring excessive licensing costs, we take advantage of the fact that APEX is a tool that is part of the internal Oracle database engine, so its use does not imply any extra cost than what we currently pay for support.
  • It's free: it can be used with the different versions of the ORACLE database including the Express Edition.
  • It has authentication and authorization features within the development environment, which is totally web.
  • High availability in environments with Oracle RAC.
  • Installation and configuration of APEX are simple.
  • No extensive programming experience is required, the interface is very intuitive and there is a lot of information on the web and on the official site of Oracle.
  • It allows exporting interactive reports to different formats: PPT, PDF, HTML, among others. The ability to include graphs for the dashboard simulation is very attractive and quite complete, up to the level of simulating a drill-down, by clicking on a portion of the graph to redirect to a detail table.
  • Developing collaboratively can be a challenge because there is no version at the level of pages or applications.
  • There is an opportunity for improvement in the way data is exported from the interactive report to PowerPoint format.
  • Improve the way to optimize the performance of the application in the database separately from the engine.
  • Incredibly beneficial because we are getting a double benefit of the payment for the support of the licenses of the Oracle databases that we have in place. It is a free tool so we do not incur extra costs and we solve quickly.
The learning curve is small and programming knowledge is not needed.
I would recommend it completely if you need the production of functional sites quickly. Simple approvals flow through different hierarchical levels can be simulated through groups and roles, but if the need is more complex flows for robust systems, I would advise opting for other programming frameworks.