What is our primary use case?
Our primary use case is for human resources. We use it as an application for human resources for the Ministry of Electricity. We also use it for the complaint management system, for collecting the complaints from customers about electricity, and tracking these kinds of requests.
What is most valuable?
One of the most valuable features is that we can develop everything locally and deploy it for different kinds of operators in different locations, so we can do our job in one piece. The benefit of that is that others can use these applications. They connect to the internet to do these kinds of applications based on the permissions for those users.
Developing based on a web-based application with APEX or another language is more simple and costly.
What needs improvement?
Connecting with Oracle and the relation with Oracle at the database as a procedure needs improvement.
The main drawback is that APEX doesn't talk with other databases. It would be great for the tool if you could combine it with different open-source databases.
For how long have I used the solution?
I have been working with Oracle for around ten years.
What do I think about the stability of the solution?
It's stable but I experience instability with it when I shifted from version 3.2 to 4.2. There were some errors in the database. I couldn't understand why but after searching I found a solution. But it works now.
Stability has been for seven or eight years.
What do I think about the scalability of the solution?
We have three to five developers using this solution.
Which solution did I use previously and why did I switch?
I worked with Java and before Java, Visual Basic from Microsoft. The other person in the Ministry of Electricity is still using Access for Microsoft, Visual Basic, .NET or C#, SQL Server as the database, and PHP. Different people in my company work with different solutions.
How was the initial setup?
The initial setup wasn't easy or complex, it was somewhere in the middle. We deployed it ourselves.
I purchased the database when we started the project with Oracle. I supported the analysis for one year, but after one year we couldn't pay more for the support. We haven't had an issue with maintenance.
APEX is an open-source platform. I'm busy with the application. It is easy to maintain the application in order to go further with more versions of APEX. It has a different kind of database. Data Point 2.1, is the version that I got from Oracle.
What's my experience with pricing, setup cost, and licensing?
Oracle one of the most expensive databases in the world.
What other advice do I have?
I would rate APEX a seven out of ten. The drawback of APEX is the relation between APEX and Oracle, there is no relation between APEX and other databases. It's very good for learning APEX and it is stable.
Your company has to understand how to invest in it. It is a wonderful database. If it's Oracle, it is the best one in the world. So when we invest in people, invest in Oracle, we will get our results. Everything is available and everything can be developed with any applications.
Which deployment model are you using for this solution?