In early 2015 I was tasked to find a solution, whereby I needed to manage data in a couple of tables inside of an Oracle database.
As it would have been a very standard interface, with limited logic that was required on the front end I set out to search for some kind of database CRUD tool that I could stick on top of the database. I actually found a couple open sources projects. One of my requirements included to have a supported product, which should be a minimum cost as there has been no CAPEX allocated for software.
APEX is a rapid web application development tool that literally sits on top of an Oracle database(can easily be installed on an Oracle instance or seperate).
“Using only a web browser and limited programming experience, you can develop and deploy professional applications that are both fast and secure. Oracle application express combines the qualities of a personal database, productivity, ease of use, and flexibility with the qualities of an enterprise database, security, integrity, scalability, availability and built for the web. Application Express is a tool to build web-based applications and the application development environment is also conveniently web-based. ” – source
Coupled with the power of an Oracle database, you can use APEX to build very powerful web-based application very quickly. In my case I am using APEX to display and manage a variety of enterprise databases and bring it all together into one view for the end user. This is really made easy with Oracle views and linked servers.
I have found that more and more use cases arise with the idea that there is an easy to setup tool, that can look into business systems, and provide insight to the right users in the proper and secure way.
To give it a try – you can get free workspace to test out Oracle Express. Just register to Get Started.
I hope whilst I’m learning about Oracle APEX I would be able to post much more about my experiences from a Solutions Architect perspective, but also a more technical perspective of how this technology can be embraced.