Coming October 25: PeerSpot Awards will be announced! Learn more

Oracle Application Express (APEX) OverviewUNIXBusinessApplication

Oracle Application Express (APEX) is #1 ranked solution in top Development Platforms, #7 ranked solution in top Rapid Application Development Software, and #7 ranked solution in top Low-Code Development Platforms. PeerSpot users give Oracle Application Express (APEX) an average rating of 8.0 out of 10. Oracle Application Express (APEX) is most commonly compared to Microsoft Power Apps: Oracle Application Express (APEX) vs Microsoft Power Apps. Oracle Application Express (APEX) is popular among the large enterprise segment, accounting for 68% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a computer software company, accounting for 20% of all views.
Oracle Application Express (APEX) Buyer's Guide

Download the Oracle Application Express (APEX) Buyer's Guide including reviews and more. Updated: September 2022

What is Oracle Application Express (APEX)?

Oracle Application Express (APEX) is a low-code development platform that enables users to build enterprise apps securely and scalably. APEX, which offers world-class features, can be deployed anywhere. As part of the Oracle Database, developers can develop superior apps 20x more quickly by using all of the tools provided in a single, extensible platform.

Oracle APEX, a cloud platform that has been around for over 20 years, eliminates complexities associated with app building while delivering results faster and at a lower cost. The low-code aspect offers developers a visual approach to app development that accelerates the development process. Oracle APEX also provides a lively, global, and growing community of developers that can connect and share resources with each other.

Features of Oracle Application Express (APEX)

App building requires complexities and expert knowledge in vast web technologies. With Oracle APEX, these complexities involved with multi-faceted applications are reduced, and developers are provided with the rich features they need to fix business problems and create solutions. These features include:

  • Data: Oracle APEX offers revolutionary functionality to enable developers to turn data into information, no matter where that data is from. Under this functionality, you can display, chart, manipulate, and process data effortlessly and accurately.
  • Accessibility: Developers can build highly accessible and inclusive web apps for users with various abilities and requirements. Oracle APEX aims to provide a good user experience for everybody, with accessibility bug fixes and continuous improvements of their testing strategies.
  • Globalization: Oracle APEX provides the ability to create a framework to maintain well-performing applications in multiple languages and environments.
  • Smart Filters and Search: users can rapidly reduce searched data and remove clutter with search terms and filter suggestions for a more simplified user experience.
  • Security: Oracle APEX empowers web application builders to develop apps without compromising on security. Despite the constant increase of attacks and modification of web standards, developers can stay focused on their tasks without leaving applications exposed.
  • Monitoring: Monitoring and logging are built into Oracle APEX, which provides valuable insight into how users interact with your applications, as well as any hacking attempts, application errors, and performance issues.
  • User Interface: Developers can build modern web applications that are responsive, easily customizable, highly accessible, and simple to maintain with Universal Theme, a user interface for Application Express.

Reviews from Real Users

Oracle Application Express is a favorite among developers looking to create web applications quickly and securely for many reasons, which include its ease of use and the ability to quickly create public applications

A senior database developer at a tech services company notes, "This is a good application for quickly creating public applications."

Alvaro L., an intelligence coordinator at Grupo Orbis, writes, "Oracle Application Express is easy to use, people don't have to be developers to use it."

Oracle Application Express (APEX) was previously known as Oracle APEX.

Oracle Application Express (APEX) Customers

Hepart AG, pharmasol, SATLOG, Collège Bois-de-Boulogne

Oracle Application Express (APEX) Video

Oracle Application Express (APEX) Pricing Advice

What users are saying about Oracle Application Express (APEX) pricing:
  • "When you have a licensed database in an Oracle environment, APEX is free."
  • "When buying the data license, APEX is included."
  • "It's a free solution with no additional costs."
  • "Oracle Application Express (APEX) comes with Oracle. The Oracle price itself. I do not know the exact cost. Oracle is flexible on its price. If you overspend on your hardware, then I don't think you will overpay. I heard that Oracle is more expensive than other databases, but when you consider Oracle is the best traditional relational database out there. You get what you pay for."
  • "Pricing is expensive, overall on an enterprise system but we consider that it gives corresponding value in the product."
  • Oracle Application Express (APEX) Reviews

    Filter by:
    Filter Reviews
    Industry
    Loading...
    Filter Unavailable
    Company Size
    Loading...
    Filter Unavailable
    Job Level
    Loading...
    Filter Unavailable
    Rating
    Loading...
    Filter Unavailable
    Considered
    Loading...
    Filter Unavailable
    Order by:
    Loading...
    • Date
    • Highest Rating
    • Lowest Rating
    • Review Length
    Search:
    Showingreviews based on the current filters. Reset all filters
    Omar Al-Qaysie - PeerSpot reviewer
    Senior Chief Engineer at ministry of electricity
    Real User
    Top 5Leaderboard
    We can develop everything locally with it but it doesn't talk with other databases
    Pros and Cons
    • "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."
    • "Connecting with Oracle and the relation with Oracle at the database as a procedure needs improvement."

    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 front-end development that's looking for HTML, Java, C++, etc also needs improvement. In order to get more out of APEX, there should be more training courses to help beginners start from A to Z. When I started with APEX, I focused on the first part, the relation between database procedure, and later I found I needed more learning courses for the HTML. There should be more training or books looking at the relationship between APEX and Oracle, not between APEX and HTML, CSL, or JavaScript. In order to go more and more with APEX, it needs to start with HTML, CSL, JavaScript, and web development.

    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. 

    Buyer's Guide
    Oracle Application Express (APEX)
    September 2022
    Learn what your peers think about Oracle Application Express (APEX). Get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
    633,184 professionals have used our research since 2012.

    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?

    In order to go with APEX, you need to know everything about Oracle as a database, starting from a secure fundamental as the beginning, PL/SQL, and administration of the database. You have to know about HTML5, JavaScript query, and jQuery.

    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?

    On-premises
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Enterprise Architect at Prinzhorn IT
    Real User
    Top 10Leaderboard
    This solution builds fast, web-based, data-driven UIs, but I would love to see more integration with other tools
    Pros and Cons
    • "One of the most valuable features is the ability to build very fast data-driven UIs."
    • "I would like to see easier integration into active directory authentication. Also, maybe integration of JavaScript frameworks would resolve some issues."

    What is our primary use case?

    I would call them small supporting applications, so we use them when we need a web UI for certain users to show data from our environment, mainly in operations.

    What is most valuable?

    One of the most valuable features is the ability to build very fast data-driven UIs. Also, those UIs are web-based and don't require any deployment on the user side. We try to avoid complex add-ons or additions, so we stick to the standard features that APEX provides. We also use it for some workflows and to present data out of services or databases.

    What needs improvement?

    I think version control can be improved, meaning the ability to track what has changed from the previous version of the application and to see it in standard tools like the code repository. I know in the last versions they were working on it, but I haven't seen it yet. 

    The product deployment could be easier. 

    In the past, I've thought about dockerization, or the ability to deliver the application as a docker container, and establish the production environment in a job. 

    What I would love to see is more integration. I would like to see easier integration into active directory authentication. Also, maybe integration of JavaScript frameworks would resolve some issues.

    For how long have I used the solution?

    We have been using APEX for at least eight to ten years.

    What do I think about the stability of the solution?

    The solution is highly stable and we have had no issues with it. On a scale of one to five, where one is highly stable and five is not, I would rate it as a one. 

    What do I think about the scalability of the solution?

    The scalability could be improved. It depends on the use cases. We will never use this solution for a productive environment with 500 to 1000 users because this would be a bit difficult in my opinion. I would say that the scalability for small applications is good, but the scalability for big applications is bad.

    About 100 to 150 people are currently using the solution at my company.
    We are continuously building small applications, but we don't plan to use this solution to make big applications. It's very use case driven. When we get a use case that is not big and it's easy to create a web-based application, then we use this solution. So we may extend our use of the solution, but we do not plan to migrate anything directly to it.

    How was the initial setup?

    On a scale of one to five, where one is easy and five is complicated, I would rate the initial setup as a four.

    What about the implementation team?

    We always lose a lot of time with our outsourcing partner because we don't host the service on our own. This takes some time, so to create the concept for us between the different environments and to do implement it, I would say it takes a minimum of five days.

    What's my experience with pricing, setup cost, and licensing?

    When you have a licensed database in an Oracle environment, APEX is free.

    What other advice do I have?

    I would tell those considering this tool that if you have an Oracle environment, it's worth taking a look at. If you don't have an Oracle environment in place, it's the wrong tool. Also, I would tell them to stick to the standard functionalities of APEX and not try to extend it with custom code. We learned that if you stick to the standards the application gives you, it's easy to maintain and it's easy to transfer from one developer to another. If you start to create custom code in hidden areas, it's very hard for the next developer to find the code.

    I would rate this solution as an eight out of ten.

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    Flag as inappropriate
    PeerSpot user
    Buyer's Guide
    Oracle Application Express (APEX)
    September 2022
    Learn what your peers think about Oracle Application Express (APEX). Get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
    633,184 professionals have used our research since 2012.
    Senol YILMAZ - PeerSpot reviewer
    Founder at Avsa Danismanlik Ltd Sti
    Real User
    Top 10Leaderboard
    Easy and cost-effective to develop, install, and deploy
    Pros and Cons
    • "With only a browser, it is very easy to develop in a web environment."
    • "Visual Builder and APEX should meld in one product."

    What is our primary use case?

    With APEX, I developed a web portal for an insurance company. With this portal, every agency can look at its customer's personal data, their claims, policies, coverage, and collections.

    I am using this solution and I am developing software for my customers.

    How has it helped my organization?

    For three years, we have done the same application with more than 10 people.

    With APEX, we can reduce our costs by reducing the size of our teams.

    Before APEX, we were using Oracle Forms. This required larger teams.

    With small teams of four to six, with a maximum of 10 people, you can build every kind of product.

    APEX will also benefit enterprise companies.

    What is most valuable?


    Developing in a web environment is very easy with just one browser. With a username and password, I can develop this product very easily. With this product, it is very easy to develop. Many sample applications have been created by Apex in the Applications Gallery.

    You can built multilingual applications, each user can interact the application with their own depending localization parameter.

    Apex supports Restful Service in JSON format. It is very easy to create a web service for Apex Environment.

    It's suitable for team development.

    What needs improvement?

    It would be my dream to merge two products into one. Visual Builder and APEX should meld in one product. 

    Each has different strengths. Visual Builder is very strong in Java, and you can build HTML applications very easily with low code. APEX is very important to have a direct connection to the Oracle database.

    If these two products would meld into one in the future, it would be very nice. 

    In the future of APEX, I would expect features more like Visual Builder. Also being able to use HTML codes directly. Visual Builder produces HTML codes and source codes.

    APEX does not have source code, it runs from the database. We can export our objects, our source, and import them in different environments and different hardware, but it's not readable in HTML codes. 

    For how long have I used the solution?

    I have been using this solution for three years.

    We are using the latest version and will be upgrading to 20.2

    What do I think about the stability of the solution?

    It's a stable solution.

    What do I think about the scalability of the solution?

    Oracle Application Express (APEX) is a scalable product.

    We have four users in our organization.

    How are customer service and technical support?

    We don't need direct support from Oracle. We are using Oracle Websites.

    How was the initial setup?

    It's very easy to install and easy to deploy.

    The first time, I spend six weeks, but now it can be done in a few hours.

    We need only one person to maintain this solution.

    What about the implementation team?

    We completed the implementation of it ourselves.

    What's my experience with pricing, setup cost, and licensing?

    This is a built-in license with data.

    When buying the data license, APEX is included.

    Which other solutions did I evaluate?

    Currently, I am doing some research on Visual Builder. I saw a demo.

    It's an application that is ready for the cloud. You cannot use it on-premises or on your local machine. It's just for the cloud.

    They have very nice features.

    You can easily build your applications at a very low cost, and it is very powerful with JavaScript.

    What other advice do I have?

    We are a consultancy firm for IT purposes, software. Especially, we are engaged in the insurance and banking finance sector. 

    We have a very large and deep knowledge of accounting software. Our team is very experienced, senior developers, and business analysts.

    We are migrating our Oracle Forms to APEX. In the future, we will continue to use APEX.

    I would highly recommend this product to others who are interested in using it.

    I would rate this solution an eight out of ten.

    Which deployment model are you using for this solution?

    Hybrid Cloud
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Consultant at a energy/utilities company with 1,001-5,000 employees
    Consultant
    Develop applications quickly and easily, with excellent technical support
    Pros and Cons
    • "The most valuable features are security, stability, and ease of implementation."
    • "The collaboration and the workflow engine could use some improvement."

    What is our primary use case?

    The primary use case of this solution is for developing applications to help with the daily work, customer support, and for production in small to medium-sized businesses.

    How has it helped my organization?

    It's a large organization producing energy. APEX is a platform that helps in the daily works of many parts of the organization. It is not producing any energy, although it is helping us to save energy that is is the result of friction between the different areas of the enterprise.

    What is most valuable?

    The most valuable features are security, stability, and ease of implementation. 

    You can concentrate on the solution. You don't have to worry about the environment, the security, the servers, or the access. It is all there automatically.

    Communication and solutions are easier to use.

    What needs improvement?

    The collaboration and the workflow engine could use some improvement. If you have a larger team working with APEX, it is not that easy to synchronize the team. It is easier with a code-rich application because of the tools. It is not that easy in a low-code environment.

    In the next release, I would like to see a better workflow tool.

    For how long have I used the solution?

    I have been using this solution since 2005.

    What do I think about the stability of the solution?

    This solution is very stable. We have never experienced any issues.

    What do I think about the scalability of the solution?

    This solution is scalable. We have not come anywhere near the maximum with our engines. 

    We have never experienced any performance issues or performance warnings in our company.

    We have 3000 users in our company, but not all of them are using the same application at the same time.

    We have many applications with many departments and it's used every day. They are using applications with APEX. They are not developing in APEX, but they are using APEX solutions to launch, for feedback, for security, and monitoring.

    How are customer service and technical support?

    The technical support is excellent.

    Which solution did I use previously and why did I switch?

    Previously, we did not use another solution. We used a different form of Oracle. There haven't been that many solutions available or programming platforms. APEX was the first local solution.

    It was the only solution at the time.

    How was the initial setup?

    The initial setup is quite straightforward and very easy.

    With one person, it took half an hour to install and get running.

    We have two people to maintain this solution.

    What about the implementation team?

    This solution was implemented 15 years ago with the help of our team.

    What's my experience with pricing, setup cost, and licensing?

    There are zero costs. It's a free solution with no additional costs.

    We are using a point system, but it's only being used with a few applications at the moment.

    What other advice do I have?

    Once you start to develop with APEX, you will be hated by programmers and coders. They will want to show you that they can do the same as you can do. 

    My advice would be to just use this solution.

    I would rate this solution a ten out of ten.

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Konstantin K - PeerSpot reviewer
    Advisory Systems Engineer at a tech services company with 10,001+ employees
    Real User
    Top 10Leaderboard
    Simple to develop, high availability, and plenty of online documentation
    Pros and Cons
    • "The most valuable features of Oracle Application Express (APEX) are the ease and speed of development. Instead of engaging a large team of middleware, front-end, and database engineers, we can have professional look at the front end and have the user interface up and running in a matter of days. However, if you want to go far and implement very custom features, it doesn't require a lot of knowledge of front-end development, such as HTML, JavaScript, or other aspects."

      What is our primary use case?

      Oracle Application Express (APEX) can be used for anything which requires quick creation of a user interface with user interaction with a database. Sometimes it's used more for reporting, but in many cases, it's for interactive reporting or interactions with the tool to record dates in the database. For example, it can be used for internal use within the company for the testing team to conveniently add test cases. Additionally, it can be used for comprehensive reporting for the financial teams, they can perform some work related to revenue recognition. 

      I didn't work with big projects exposed to the public, the use cases were mostly internal platform projects.

      What is most valuable?

      The most valuable features of Oracle Application Express (APEX) are the ease and speed of development. Instead of engaging a large team of middleware, front-end, and database engineers, we can have professional look at the front end and have the user interface up and running in a matter of days. However, if you want to go far and implement very custom features, it doesn't require a lot of knowledge of front-end development, such as HTML, JavaScript, or other aspects.

      For how long have I used the solution?

      I have been using Oracle Application Express (APEX) for approximately 10 years.

      What do I think about the stability of the solution?

      The stability of Oracle Application Express (APEX) is 100 percent. It is highly stable.

      What do I think about the scalability of the solution?

      Oracle Application Express (APEX) is highly scalable and can serve up to a required number of users. However, I do not have experience with serving more than approximately100 users. I'm always advertising this tool as being scalable. Bring in the shop.oracle.com as an example, because that site is running on Oracle Application Express (APEX), and you can imagine it can serve up to an unlimited number of users. With good hardware behind the solution, it's scalable, but since I don't have direct experience, I'm pretty sure it's scalable to any possible level. My confidence level in that is 90 percent scalable.

      How are customer service and support?

      I have not had the need to contact technical support because of the number of resources and amount of information available with only a couple of mouse clicks, such as documentation, Q&A, and FAQ, they have a lot of material available. I know that browsing those websites people sometimes face some issues with not having their issue resolved, but this has not been my experience.

      What's my experience with pricing, setup cost, and licensing?

      Oracle Application Express (APEX) comes with Oracle. The Oracle price itself. I do not know the exact cost. Oracle is flexible on its price. If you overspend on your hardware, then I don't think you will overpay. I heard that Oracle is more expensive than other databases, but when you consider Oracle is the best traditional relational database out there. You get what you pay for.

      What other advice do I have?

      I rate Oracle Application Express (APEX) a nine out of ten.

      Which deployment model are you using for this solution?

      On-premises
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      Flag as inappropriate
      PeerSpot user
      Luís Silva - PeerSpot reviewer
      Manager at Ginkgo Management Consulting
      Real User
      Top 5Leaderboard
      It's a solid "low-code" solution that works quite well for simple and complex scenarios of data-intensive applications
      Pros and Cons
      • "Oracle APEX's reporting features are simple yet powerful. The ability to quickly create CRUD screens has simplified many RAD discovery processes, while the APEX environment allows the product owners and dev teams to quickly understand the complex solutions and employ usage statistics to identify areas requiring improvement. The option to add external JavaScript tools in screen development enables the development of complicated mobile or web usage scenarios in rare cases where the APEX UX is not enough."
      • "Oracle should implement vertical and horizontal data segmentation in APEX's security framework, so Dev teams don't need to do any heavy lifting in the APEX screens. This is a common issue in enterprise apps. It would be nice to seamlessly integrate Git repositories into the development process since the current solution can result in overlapping work or an eventual overwrite. The provided example apps are great, but they could benefit from some added documentation in the "explanation screens"."

      What is our primary use case?

      Our business applications include healthcare, administrative, and planning tools. The environment consists of on-premise databases with an Oracle ORDS Tomcat stack and other JavaScript utilities on top of Linux Virtual Machines. There are legacy solutions, such as Oracle 11 with APEX 5.1 and Oracle 19 with APEX 20. These solutions have proven to be quite stable, but you need to do proper planning and profiling of heavy database transactions for more significant queries and heavy transaction processing.

      How has it helped my organization?

      Oracle APEX has proven to be a solid "low-code" solution that works quite well for simple and complex scenarios of data-intensive applications. Integrating the tool with the robust underlying Oracle Database allows a team to quickly create and deploy functionality iteratively. Running the tool on top of Linux-based virtual machines can slow things down, but the work gets done, and using the Oracle XE editions for some clients has been an adequate solution for POCs or even small non-critical production apps.

      What is most valuable?

      Oracle APEX's reporting features are simple yet powerful. The ability to quickly create CRUD screens has simplified many RAD discovery processes, while the APEX environment allows the product owners and dev teams to quickly understand the complex solutions and employ usage statistics to identify areas requiring improvement. The option to add external JavaScript tools in screen development enables the development of complicated mobile or web usage scenarios in rare cases where the APEX UX  is not enough.

      What needs improvement?

      Oracle should implement vertical and horizontal data segmentation in APEX's security framework, so Dev teams don't need to do any heavy lifting in the APEX screens. This is a common issue in enterprise apps. It would be nice to seamlessly integrate Git repositories into the development process since the current solution can result in overlapping work or an eventual overwrite. The provided example apps are great, but they could benefit from some added documentation in the "explanation screens".

      For how long have I used the solution?

      I've been using Oracle APEX since 2006.

      What do I think about the stability of the solution?

      Oracle Apex is stable.

      What do I think about the scalability of the solution?

      Oracle Apex scales well, but you need a good admin who knows how to work with DBA and Linux.

      How are customer service and support?

      Oracle support has room for improvement.

      How would you rate customer service and support?

      Neutral

      How was the initial setup?

      Setting up APEX requires Oracle and Linux admin experience.

      What about the implementation team?

      We implemented APEX with an in-house team.

      What's my experience with pricing, setup cost, and licensing?

      APEX is free, but Oracle Database is not.

      What other advice do I have?

      I rate Oracle APEX eight out of 10. It's a good tool that needs more promotion, particularly the cloud solution.

      Which deployment model are you using for this solution?

      On-premises
      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      Flag as inappropriate
      PeerSpot user
      CTO at a tech services company with 51-200 employees
      Real User
      Top 10
      Easy initial setup and scalable but lacks process management
      Pros and Cons
      • "The solution's most valuable aspect is its Graphics Form Design."
      • "The solution has some stability problems that need to be resolved."

      What is our primary use case?

      We primarily want to use the solution for rapid development.

      What is most valuable?

      The solution's most valuable aspect is its Graphics Form Design.

      The initial setup is quite simple. I was able to handle it myself.

      The product can scale if you need it to.

      What needs improvement?

      The solution does not offer everything under one umbrella solution.

      In terms of the VPNs and process management, Oracle can make it better. It's an area that definitely could be improved upon. They really don't have anything going on there.

      The solution has some stability problems that need to be resolved.

      The product should add a separate site with a development language supporting Java, or other languages such as this.

      For how long have I used the solution?

      I've been using the solution for about three months or so. It's quite a new solution for us. We're still in the testing phase.

      What do I think about the stability of the solution?

      The software seems to have stability issues. It can crash or the software can shut down and sometimes it doesn't return. I'm not sure what causes these issues.

      What do I think about the scalability of the solution?

      The product has inside solutions for scalability. You can expand using a talented application server. We tend to have loads of balance there and we find it to be scalable.

      We're currently in evaluation mode, and therefore have a limited amount of users on the solution currently. It's not fully rolled out.

      How are customer service and technical support?

      We haven't been in touch with technical support per se. We have referenced documentation and other materials to assist us. I can't speak to the effectiveness or knowledgeability of their services.

      Which solution did I use previously and why did I switch?

      We didn't use any previous solution. 

      How was the initial setup?

      The initial setup was not complex at all. It was very easy and quite straightforward. A company shouldn't have trouble with the implementation.

      What about the implementation team?

      I handled the initial setup myself. I did not need the assistance of a consultant or integrator.

      Which other solutions did I evaluate?

      We also looked at other options. We thought about doing a combination of two solutions due to the fact that the process management was very weak.

      What other advice do I have?

      We are just customers and end-users of the product.

      We are still running a test, or a POC, to see if we like how the system operates for our organization.

      I would rate the solution at a six out of ten. If it had VPN process management, I would likely rate it higher.

      While I would recommend the solution, it would depend on an organization's requirements.

      Disclosure: I am a real user, and this review is based on my own experience and opinions.
      PeerSpot user
      Freelancer with 1-10 employees
      Real User
      Top 5Leaderboard
      It has a well-designed architecture and is a simple 3rd party application
      Pros and Cons
      • "It has a well-designed architecture and is a simple 3rd party application."
      • "It has been reported that the technology is very hard to learn, and the service is expensive."

      What is our primary use case?

      The APEX database is based on a SaaS service. We use a distributor based in Malaysia for that. We integrate this with other Oracle technologies. To use Oracle Apex, you require a licence. We rely on our distributors for the service, and then we advise our end users and support them. Our clients invest in Oracle technology for their application platform. Still, the devil is in the detail with the contract, explaining how the new technology enhances their solution.

      How has it helped my organization?

      It is risky to move to a new staging instance or new solution, which may cause an issue. In Malaysia, we don't need to take any risks. It is a mostly new architecture. Our clients are mainly in government. 

      What is most valuable?

      Our clients use this solution continuously. It has a well-designed architecture and is a simple 3rd party application. Our clients really like the new version. It does not need to be maintained very often. 

      What needs improvement?

      It has been reported that the technology is tough to learn, and the service is expensive. The online supporting documentation could be better and offered in other languages, as Malaysian does not seem to be covered. Oracle could improve server and data migration from the cloud. This is achieved easier via a hybrid version. Sometimes we perform migrations and have to roll them back, as there are unforeseen issues.

      For how long have I used the solution?

      We have been using APEX since 2020. It's a cloud service, with a cloud structure.

      What do I think about the stability of the solution?

      Oracle is stable, as it is a data container, and it includes advanced framework development.

      Which solution did I use previously and why did I switch?

      We have considered Azure Cloud, Oracle Cloud, Google GCP and Microsoft Azure. Oracle has value in that they have related products. We have been looking at products to standardise, and hence is why we chose Oracle as a uniform solution.

      How was the initial setup?

      The implementation for clients is the responsibility of the distributor or reseller. The consultants must go directly to the users to understand their requirements. Implementation is usually carried out on-premise.

      What's my experience with pricing, setup cost, and licensing?

      Pricing is expensive overall on an enterprise system, but we consider that it gives corresponding value to the product. It becomes more expensive when more products are added to the main product. The Apex element itself is free to use, so it's useful for learning individually.

      What other advice do I have?

      I would rate Apex 10 out of 10.

      Which deployment model are you using for this solution?

      Hybrid Cloud

      If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

      Other
      Disclosure: My company has a business relationship with this vendor other than being a customer: Integrator (solution provider)
      PeerSpot user
      Buyer's Guide
      Download our free Oracle Application Express (APEX) Report and get advice and tips from experienced pros sharing their opinions.
      Updated: September 2022
      Buyer's Guide
      Download our free Oracle Application Express (APEX) Report and get advice and tips from experienced pros sharing their opinions.