Oracle Application Express (APEX) Reviews

I was tasked with configuring APEX for an internet installation. I'm uncertain about its specific purpose, as my involvement was limited to the tool's configuration, and I do not know the development aspects.

During the upcoming versions, we can modify the current configuration.

I have been using APEX for a few months.

I would rate the stability 9 out of 10. Every software has inherent bugs that can cause temporary unavailability. We work on fixing such issues.

We haven't encountered performance issues with the current workload, and if the workload increases, the scalability of APEX is directly linked to the scalability of the Oracle database. Since APEX functions as one of the components in the Oracle database, it is easily scalable.

We haven't encountered complex issues requiring Oracle support. Most tasks can be completed by referring to documentation or logs. 

It's a great product. Based on the level of easiness of installation, I would rate it three out of five. You need to have an Oracle database as the minimum requirement for APEX. Additionally, an HTTP server is necessary. While I'm not sure if it works with Apache, Oracle has its own HTTP server software, and in the latest version, they use WebLogic. Also, ensure that the Oracle listener is up and running.

It is easy to deploy, and I did it myself by following the documentation. It took about three hours, and we didn't use a consultant or integrator; we handled it in-house. Once the tool is deployed, developers only need to configure it according to their requirements. The development effort is minimal as many components are readily available.

Overall, on a scale of one to ten, I would rate Oracle APEX a nine.

In some cases, it is a difficult tool. However, we have found that Oracle is more of a database and not a good tool for application development. As a result, we are currently facing some challenges, and we have not received enough help from the community. We are working hard to find solutions.

We had developed a CRM for the public and companies, and we were facing a few problems. The first problem was encrypting the customer's data so that it could not be seen. The second problem was integration, which was not as easy as Salesforce, even though we are also a partner of Salesforce. Salesforce is much easier to integrate compared to Oracle APEX. And the third challenge we faced was with the UI.

These are some of the challenges I am currently facing. We have been investing a lot of time and money into Oracle Apex. However, we are facing difficulties in integrating it with third-party applications. For example, if we want to integrate a payment gateway or accounting tool like Zero or QuickBooks. We are struggling to find a solution to this. Additionally, we want to integrate AI-based chatbots that can accept and create records through voice commands. We were considering working with Oracle APEX, but we may not be able to test it.

Databases are the most valuable feature in Oracle APEX for me. The database is super easy to use for creating tables.

The most important thing, in my opinion, is that it should allow end-users to create their own custom fields. For example, if you are my customer and you want to create custom fields, you should be able to do that yourself.

Secondly, it should be easy to map fields with other objects like CRM. If you are creating custom fields in the lead and want to create a few custom fields going further on the account contact opportunity, the end customer should be able to do this themselves rather than depending on us every time.

In the next release, we would like to see easy integration with third-party applications. Currently, Oracle is lacking big time in the marketplace. If you look at Salesforce, they have more than four thousand applications that you can easily download and configure with their platform. On the other hand, Oracle Apex has a limited marketplace, with only a few companies offering basic applications. Moreover, the existing marketplace applications are not fancy or AI-based. AI is a big thing, and Oracle is currently working on it.

I have been using this solution for three years. We are using version 22.5.

It is a stable solution. I would rate the stability a seven out of ten.

I would rate the scalability of Oracle APEX a four out of ten. Oracle is more of a database-oriented solution and is not very flexible in app development.

We have only received support from MaxApex people, who have been pretty helpful. Sometimes we get stuck with configuration issues, and they advise us on how to resolve them. They also showed us how to encrypt our data. However, if Oracle APEX has a professional community, it would be great to get more help because no company in the world has a UI like the one we have in our CRM.

We haven't received any support from Oracle. We've only received support from MaxApex.

We used Salesforce before. However, we switched to Oracle Application Express because it's not user-based but rather database-oriented. With it, we can create users and set prices based on our preferences rather than being limited by Salesforce's CRM options. Someone from an Oracle background suggested we try it out during our initial phase, and it was super easy for us to create pages, layouts, and fields. However, we need help as we move forward.

The initial setup was straightforward. However, as we started doing more development work, we faced a lot of challenges. I rate the initial setup at eight on a scale of one to ten.

Down the road, at a later stage, I would rate it a two or three at maximum. The initial setup was easy, but as the complexity of the project increased, we encountered several difficulties. Currently, we only have two people who take care of maintenance and development. We have slowed down our development since we have been doing this for the past three years.

The deployment was done in-house since we have our own team of developers who took care of it. The deployment didn't take much time because MaxApex was really good, and they helped us in different areas. We have deployed it in the cloud version and used MaxApex as our cloud provider. We contacted MaxApex, and they provided us with enough space on the cloud. The rest of the deployment was handled by our technical team. Moreover, we only needed two experienced people who help us deploy on the cloud.

I would rate it around an eight in terms of price, with one being low and ten being high.

We only tried Salesforce. Salesforce has a platform called Force.com, but there was a limitation on the number of objects we could create. If we had to create more than ten objects, Salesforce would start charging twenty-five dollars per user per month. If we wanted to create an unlimited number of objects, Salesforce would charge a hundred dollars per user per month. As we were targeting a market with customers who may not have a big budget, we were trying to find a more cost-effective solution. So we were looking for a more affordable and cost-effective solution for these customers.

I would rate this product as a five out of ten, right in the middle. Number one, it is easy to scale for simple matters. However, when it comes to complex development, it can be challenging and time-consuming.

We're using version 18. This solution is deployed on a private cloud.

We're using APEX to create web pages that display data from our database.

It helps us create web pages quickly. If we create web pages manually, we need to create a web service, which requires more time and more resources from Amazon. With APEX, we can easily configure and set up web pages.

When we connect to web pages, APEX creates dedicated sessions in the databases. It would be easier if we could control the shared sessions. For example, if 10 people connect to 10 web pages, APEX will create 10 sessions for two databases. If we share the sessions, we can easily control the sessions and save resources.

I have used APEX for one year.

The stability is okay because if the database works, APEX will work.

I would rate the stability as nine out of ten.

To scale APEX, you need to scale the databases. They're directly related.

I would rate the scalability as six out of ten.

Setup isn't difficult, but you need to prepare and read the documentation. For example, the setup will be different in Amazon. 

Deployment depends on the architecture. It's easy to export configurations from APEX. You only need to make simple changes when importing configurations. 

If you want to update versions of APEX, it's difficult because you need to redesign your own web pages. For example, the new version of APEX can't use old designs, so you need to check different web page designs before updating APEX. It's one of the points of difficulty in APEX. 

You also need an APEX specialist for deployment because not many people use it.

Oracle has official documentation that shows how to do setup, so it isn't difficult.

I would rate this solution as seven out of ten.

We use Apex for the development of publications, specifically in the context of a payroll system. Presently, we are using Apex version 20, but there is an update available to version 31.2. The migration was not a one-to-one transfer, as leveraging Apex effectively requires a shift in programming approach to create an optimal user interface. Adapting to Apex involves relinquishing old programming habits, but the platform offers extensive capabilities that, once mastered, facilitate a user-friendly experience.

In our experience with Apex, we find that minimizing reliance on HTML and JavaScript is preferable, especially considering our background as seasoned programmers adept in PL/SQL. Incorporating HTML and JavaScript can pose challenges due to potential compatibility issues when updates are made to JavaScript. We also make use of JASPER report integration for generating reports, a practice integral to our reporting procedures.    

Apex has effectively incorporated new market trends into its features. The platform's user-friendly nature is notable, guiding developers through the development process. While advanced customization of the user interface with HTML and CSS is possible, the out-of-the-box options often suffice, providing 80-90% of the required functionality. The IDE is commendable, yet an enhancement in the Page Designer to allow a real-time preview of layout changes would be beneficial. Currently, running the page is necessary to visualize layout adjustments, but an immediate preview during the design phase would be a valuable improvement.

We have been using Oracle Application Express (APEX) since 2011.

It is easy to install and I would rate the installment process 8 out of 10, a piece of cake.

The installment process for our system can be intricate, especially considering ODBC connections to the Oracle database. This involves optimizing for sharing and accommodating multiple users, ensuring efficient session management. Unlike a user-friendly click-and-install approach, our Linux-based installation demands a command-line understanding, necessitating familiarity with Linux commands. We opt for Linux over Windows Server, prioritizing cost-effectiveness with platforms like Oracle Lenovo or CentOS.Initially, we provided hosting on our cloud but encountered challenges with clients reluctant to pay for hosting services. Factors such as unreliable internet and frequent electricity outages in Venezuela further contributed to this preference for on-premise deployment.

Apex is not priced separately; instead, it is associated with the Oracle database. A free option for Oracle database and Apex can be downloaded and installed on this complimentary database version. This aligns with our current approach.

I would rate it 9 out of 10. 

In the public sector, our clients are primarily using Oracle APEX to update their old systems. We have been working on government projects for over a decade, and many of our clients are moving from outdated tools like Oracle Forms and ADA Oracle to Oracle APEX. This shift lets them benefit from APEX's user-friendly, low-code approach, speeding up app development, and keeping them in line with modern web standards, resulting in better efficiency and user experiences.

The most valuable feature of Oracle APEX is its comprehensive set of features for creating user-friendly and visually appealing applications. This includes local development, remote templates, and graphic capabilities. Additionally, the platform offers tools like smart sheets, search wizards, and easy application creation from various file formats, making it highly adaptable. It also excels in configuring workloads and notifications, implementing reports, and allowing seamless attachment handling. The availability of plugins further enhances its value, making it a go-to choice for application development and use.

In terms of improvement, there should be a greater focus on AI and machine learning tools in Oracle APEX. While the platform is evolving, making these tools more accessible and user-friendly is crucial due to the rapid growth of AI and ML. Providing more pre-built packages and simplifying their usage would facilitate the platform's adoption in AI applications and machine learning, ensuring it stays relevant in these rapidly advancing fields.

I have been using Oracle APEX for three years.

I would rate the stability of the solution as a ten out of ten.

It is a very scalable solution. I would rate the scalability as a nine out of ten. Most of my clients are medium-sized businesses.

I would rate the technical support as a ten out of ten.

Positive

Deployment in Oracle APEX is a smooth and straightforward process, and we haven't had any issues with it. Even when creating different environment clones, we can easily migrate applications without complications. Deployment is quite efficient, and it typically takes less than an hour, often around half an hour, thanks to the support of a dedicated DBA and the use of the WebLogic application server. For deployment, after completing application development, we export the application files, including standard features. Then, these files are sent to the Logical Manager, who is the application server administrator. They handle the deployment on the WebLogic server.

I find the pricing of Oracle APEX to be very reasonable because it is free when you already have a license for Oracle database. This cost-effectiveness is a significant advantage.

My advice for those interested in using Oracle APEX is to start promptly, as there is a learning curve, particularly if you are less familiar with CSS and JavaScript. In the initial stages, you may encounter limitations when creating more complex interfaces and feature-rich applications, which may require additional effort in terms of CSS and workload. However, for straightforward applications, Oracle APEX is user-friendly and easy to use. Overall, I would rate it as a ten out of ten.

Oracle APEX provides a fast web page for any application or dashboard, enabling users to create ad hoc reports.

The valuable features are charts, reports, and search engines.

The solution's layout could be improved for report generation to allow more configuration.

I have been using Oracle APEX for 15 years.

I rate the solution’s stability a ten out of ten.

The solution’s scalability is not high. 50-60 online users are using this solution.

I rate the solution’s scalability an eight out of ten.

The technical support is very good.

Positive

The initial setup is neither easy nor hard. I rate it three or four out of ten.

We must set up more than five tools to run the Oracle APEX application, including the database, assets, API publisher, Application Express, web logies, and several tools.

The deployment depends on the project and can be handled by one person. It takes less than one month for a single project or another month for other projects.

The deployment process is the same as for other applications. It typically involves analysis, implementation, coding, database package development, design, and front-end development.

The solution is cheap. It's a free solution.

I rate the solution's pricing a six or seven out of ten.

Oracle APEX is a good solution to create web applications quickly and easily, with many options.

Overall, I rate the solution a ten out of ten.

Our company uses the solution as a development platform for client projects that include marketplaces.  

We have five developers and 200 other users. 

The autonomous database is valuable and provides the main structure for code development. 

The solution does not include a default or custom template like other products. 

The PL/SQL format is a bit limiting so newer technologies should be added. We currently cannot write anything beyond PL/SQL. 

I have been using the solution for a few months. 

The solution is stable. 

The solution is scalable. 

Customer support is good and gives unconditional assistance. 

I rate support a ten out of ten. 

Positive

One of our customers previously used OutSystems and Mendix. 

The setup is very easy and just takes a few minutes. We can start building applications within five minutes. 

The solution cloud-based so there is no implementation. Everything is almost done already so it takes two clicks to complete setup. 

The pricing is very good and less expensive than Mendix or OutSystems. Pricing is a little bit higher than Microsoft products. 

Extra features can be purchased based on your needs. Identity access management and token authentication are a little bit costly. 

We also use SharePoint for normal application development.

I rate the solution an eight out of ten. 

Our company has a partnership with the solution and we use it as a development platform. We have between 500 to 1,000 users. 

The virtual patching feature is valuable. 

The solution does its job by providing the needed protection. 

The easy-to-use format is flexible and can scale. 

The solution does not support the Linux platform. 

I have been using the solution for two years. 

The solution is pretty stable. 

The solution is scalable with no issues. 

Technical support is good and interactions with them are smooth. 

I rate technical support a nine out of ten. 

Positive

The initial setup is straightforward so I rate it a ten out of ten. 

Our company is meeting goals for ROI. 

The pricing is mid-range so is neither expensive nor cheap. 

I rate pricing a nine out of ten. 

Evaluate your implementation team properly before contracting with them. It is important to receive help from the best team in the market.

I rate the solution a nine out of ten.