Business Intelligence in Oracle APEX
Updated September 18, 2021

Business Intelligence in Oracle APEX

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

Overall Satisfaction with Oracle Application Express

Currently we use Oracle Application Express in only one department, but looking at how easy and fast is to add more small apps solving different tasks I believe it will be broadly adopted by a large audience very shortly.
I want to share my experience in one app we did. We are maintaining a relatively large data warehouse, design in star schema. This was used as a source for few BI tools and standard reports presenting some parts of Data Warehouse, but there was always a need for people with no SQL knowledge to get look in some part of data warehouse not presented in existing reports and tools to explore new possibilities or just to verify data. So we need some kind of simple presentation layer that quickly and easily can expose the data model and provide access to end user where they can review data in form of tables or charts. APEX look like is the perfect environment for that.
Missing bit in APEX is built in functionality to define data model but that was easily solved by simple web forms where power user can define relations between fact and dimensions and store that metadata to enable dynamically SQL generation later by end users. The end users can generate dataset automatically using simple graphical interface, without the need to know SQL. Data presentation is power by a dynamically populated APEX interactive data grid. It appears that the solution was adopted by users well and we enriched it quite easily with adding functionality to organize access to app by user, roles and different permissions enabling user to share report definitions between them. This is app working internally but I created an instance of it in OCI where you can see how it works presenting a sample oracle star schema model.

Login with :
user: demo
pass: demo

  • Easily create web application
  • Rich , ready to use web interface components
  • Easy deploy and maintain application
  • Simple and powerful security configuration out of the box
  • Some of the configuration options are a bit hidden, probably a bit better organization of workspace and application settings would benefit development process
  • Using low code development in big companies is the way how most of the regular tasks will be solved in the future.

Do you think Oracle APEX delivers good value for the price?


Are you happy with Oracle APEX's feature set?


Did Oracle APEX live up to sales and marketing promises?


Did implementation of Oracle APEX go as expected?


Would you buy Oracle APEX again?


APEX is very well fit for solving fast some day to day activities in every organization.

Oracle APEX Feature Ratings

Visual Modeling
Drag-and-drop Interfaces
Platform Security
Platform User Management
Platform Scalability