Try our new research platform with insights from 80,000+ expert users
Dedy Rachmanto - PeerSpot reviewer
Sr. Information MGT Analyst at Pertamina
Real User
Building dashboards is quick and easy with this tool
Pros and Cons
  • "By using Express, we are able to load the data and integrate it into our data map."
  • "Oracle Application Express would be improved if you could use it on a mobile platform."

What is our primary use case?

We are using Oracle Application Express for user support. We provide users with data for analytics, ad hoc purposes, and to help build daily analytical reports. Also, we are using workflows in artificial intelligence and data science. Providing our users with this kind of data helps them with their data science workflow.

Oracle Application Express is also used to deploy data monitoring for data concurrency, data completeness, and data quality. 

What is most valuable?

We used many data types and format types, like Excel files. By using Express, we are able to load the data and integrate it into our data map. This makes formatting much easier.

Building dashboards with the solution is easy and quick.

What needs improvement?

Oracle Application Express would be improved if you could use it on a mobile platform.

For how long have I used the solution?

I have been using Oracle for 15 years.

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

What do I think about the stability of the solution?

I have no complaints about the performance of this solution.

What do I think about the scalability of the solution?

Oracle Application Express is scalable. The size of the software is tied with the license.

How are customer service and support?

Personally, I have not had to contact technical support. If I have any concerns, I will search the internet or ask one of my colleagues who have experienced the same problem.

How was the initial setup?

The initial setup of Oracle Application Express is easy. Deployment was completed in less than four days.

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

Oracle Express comes with the Oracle license, it is a bundle. 

Which other solutions did I evaluate?

Prior to using Oracle Application Express, we evaluated Power BI. Power BI can deploy dashboards, charts and reporting, however, Oracle is faster. 

What other advice do I have?

Oracle is faster than Power BI, however, it does require more skill to use. It is not easy for the common user to produce a chart from the data. 

I would rate Oracle Application Express (APEX) an eight of 10 overall. 

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
Emad Mokhatab - PeerSpot reviewer
Solution & Software System Architect at Shaparak
Real User
Top 5Leaderboard
Offers good integration capabilities and performance, but stability needs improvement
Pros and Cons
  • "The product's initial setup phase was straightforward."
  • "The product's stability has certain shortcomings, making it an area where improvements are required."

What is our primary use case?

I have some hands-on experience with the tool, but it is not too much. I just installed it and used it for my work. I used the tool for an inventory project, and after some research, my company decided to go somewhere else.

What is most valuable?

The solution's most valuable features stem from the fact that the tool's performance was not bad at all. We wanted to use the tool for faster development because it helps us avoid and omit boilerplate codes.

What needs improvement?

The product's stability has certain shortcomings, making it an area where improvements are required.

For how long have I used the solution?

I have experience with Oracle Application Express (APEX).

What do I think about the stability of the solution?

Stability-wise, I rate the solution a five to six out of ten.

What do I think about the scalability of the solution?

It is a scalable solution.

Around six or seven developers in our company use the product. In my company, we did some research on the tool with the help of our research and development team.

How was the initial setup?

The product's initial setup phase was straightforward. Most Oracle products have a straightforward installation process.

My company doesn't get involved in the tool's deployment phase. My company's project was deployed over Oracle Application Express (APEX).

What other advice do I have?

The product's integration capabilities were okay. I don't have much to say about it.

I don't feel eligible enough to comment on whether I would recommend the product to others.

If other people want the product in some of their projects, they want a solution that can help with fast development and delivery phases while not wanting a very high performance. They can go for Oracle Application Express (APEX) after PoC and MVP to find its suitability.

In my company, we don't use AI with the tool.

The measurable benefits from the use of the product can be seen in areas like SaaS development and SaaS delivery, and I think the features associated with both areas are good in the tool.

I rate the tool a six to seven out of ten.

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)
November 2024
Learn what your peers think about Oracle Application Express (APEX). Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
Mehdi Hasankhan - PeerSpot reviewer
Head of Development and Implementation at Arak Petrochemical Company
Real User
Top 5Leaderboard
A hybrid solution to create web applications quickly and easily, with many options
Pros and Cons
  • "The valuable features are charts, reports, and search engines."
  • "The solution's layout could be improved for report generation to allow more configuration."

What is our primary use case?

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

What is most valuable?

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

What needs improvement?

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

For how long have I used the solution?

I have been using Oracle APEX for 15 years.

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

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.

How are customer service and support?

The technical support is very good.

How would you rate customer service and support?

Positive

How was the initial setup?

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.


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

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

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

What other advice do I have?

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.

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: Partner
PeerSpot user
Didar Moldabekov - PeerSpot reviewer
Senior Database Administrator at Overonix Technologies
Real User
Top 10
Allows us to easily configure and set up web pages but should include the ability to control shared sessions
Pros and Cons
  • "It helps us create web pages quickly."
  • "You also need an APEX specialist for deployment because not many people use it."

What is our primary use case?

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.

What is most valuable?

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.

What needs improvement?

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.

For how long have I used the solution?

I have used APEX for one year.

What do I think about the stability of the solution?

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

I would rate the stability as nine out of ten.

What do I think about the scalability of the solution?

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

I would rate the scalability as six out of ten.

How was the initial setup?

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.

What other advice do I have?

I would rate this solution as seven out of ten.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Ganesh Gurudu - PeerSpot reviewer
Senior Software Developer at Cegal
Real User
Secure with a straightforward setup and has good features, but can be a little complicated for less experienced users, and is more suited for smaller scale projects
Pros and Cons
  • "What's most valuable in Oracle Application Express (APEX) is its secure coding functionality, and the solution also has good features."
  • "I've experienced some difficulties when using Oracle Application Express (APEX), particularly when I'm designing forms. For example, when I design a form, I add buttons and controls, but I'm unable to visualize how it'll look unless I run it. You want to design and do things your way, but if you don't have much experience, then you'll find that designing in Oracle Application Express (APEX) is a little complicated. This won't be a problem with anyone more experienced, though. If I wanted to create my design, for example, a different table format or some background images, it becomes a problem, and this is an area for improvement in Oracle Application Express (APEX). Designing should be easier, even for less experienced users. An additional feature I'd like to see in Oracle Application Express (APEX) is more plugins, particularly a repository that contains a lot of plugins, so you can go to that repository and download whichever you like and use it or add it to your project. Right now, I create my plugins, so it would be helpful if Oracle Application Express (APEX) has a repository of plugins people can use, download from anywhere in the world, and integrate into projects."

What is our primary use case?

Oracle Application Express (APEX) is being used in customer companies. My company is a consultant for the solution.

What is most valuable?

What's most valuable in Oracle Application Express (APEX) is its secure coding functionality, and the solution also has good features.

What needs improvement?

I've experienced some difficulties when using Oracle Application Express (APEX), particularly when I'm designing forms. For example, when I design a form, I add buttons and controls, but I'm unable to visualize how it'll look unless I run it. You want to design and do things your way, but if you don't have much experience, then you'll find that designing in Oracle Application Express (APEX) is a little complicated. This won't be a problem with anyone more experienced, though.

If I wanted to create my design, for example, a different table format or some background images, it becomes a problem, and this is an area for improvement in Oracle Application Express (APEX). Designing should be easier, even for less experienced users.

An additional feature I'd like to see in Oracle Application Express (APEX) is more plugins, particularly a repository that contains a lot of plugins, so you can go to that repository and download whichever you like and use it or add it to your project. Right now, I create my plugins, so it would be helpful if Oracle Application Express (APEX) has a repository of plugins people can use, download from anywhere in the world, and integrate into projects.

For how long have I used the solution?

I've worked with Oracle Application Express (APEX) for the new project for the last three months. I  work in DevOps, and my team is currently going through the new release, version 21.1, and focusing on the new BPM and also a lot of other upgrades.

What do I think about the stability of the solution?

Oracle Application Express (APEX) is stable, but twice I faced JavaScript errors when I used the sample application. JavaScript normally works, but when I do a lot of exhaustive usage of the grid, controls, and sorting, the solution hangs or becomes stuck. It won't do anything unless you refresh the page, so I have to refresh the entire page, then restart it. I have to reset Oracle Application Express (APEX).

What do I think about the scalability of the solution?

Oracle Application Express (APEX) is scalable and you can grow it, but its UI gets a little bit complicated. The solution is comparable to Visual Studio and Eclipse, where you don't need to install anything because you can just use it on a browser, but if you're into enterprise-level applications or higher-level applications, you have to look at the bigger picture, and this means that if Oracle Application Express (APEX) has a studio or proper ID'ing, it can go huge potentially.

How are customer service and support?

I didn't contact technical support that much because, in the last three months, my team handled issues on its own. Right now, there's no need for technical support for Oracle Application Express (APEX), but soon, my team might need to contact support.

How was the initial setup?

The initial setup for Oracle Application Express (APEX) was very straightforward. I didn't find any problems with setting it up.

Which other solutions did I evaluate?

I worked on other .NET-focused solutions as well as JAVA-focused solutions, and I'd recommend Oracle Application Express (APEX) for small-scale projects. It's okay for the enterprise level or if you want to develop big applications, but it could be very difficult, though I didn't explore the solution much, I feel that for big applications or enterprise applications, it could be a little challenging.

Oracle Application Express (APEX) can be suitable for enterprise-level applications, but that would require a lot of work and a lot of effort to develop and maintain the applications. The solution has some cool features, but some features could be a bit complicated. The debugging is cool because you just click on the page and directly edit a component on it.

What other advice do I have?

I'm not a partner of Oracle Application Express (APEX). I work in a company that uses Oracle products.

As Oracle Application Express (APEX) seems to be a good solution, I'd rate it seven out of ten. It has some issues that, if fixed, would make it better.

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
Computer Specialist at a government with 10,001+ employees
Real User
Good design features, easy to use, straightforward and easy to deploy
Pros and Cons
  • "I like the way that it automatically goes into the spreadsheets and the users can deal with it."
  • "There is not a lot of Wiki help or in Google, but there is some."

What is our primary use case?

We have several projects with 200 to 300 users. 

It is used by developers, building applications for people who want to track things in spreadsheets.

What is most valuable?

The most valuable part of this solution is the database design features. We are able to create tables and prototypes for people during design meetings.

The use of the platform seems straightforward.

It's easy to use.

I like the way that it automatically goes into the spreadsheets and the users can deal with it.

What needs improvement?

There is not a lot of Wiki help or in Google, but there is some.

For how long have I used the solution?

I have been working with Oracle Application Express (APEX) for a year.

We are still on version 5.1. We are trying to upgrade and move to the cloud.

What do I think about the stability of the solution?

It seems pretty stable.

What do I think about the scalability of the solution?

This is an area of concern, as we are not sure. We have not explored its scalability.

We have the source code in the database and also produce the forms at the same time.

I don't believe that it is a problem. In most of our use cases, we are either going to have small amounts of people and small amounts of data. 

We have many different teams using it in different areas. For example, we have a big glassware ordering team that uses it, a national management team that uses it to schedule groups and managing programs or agricultural programs. There are nine or ten different teams.

How was the initial setup?

I was not a part of the installation, but it is straightforward when deploying the updates.

We have a team of three or four developers and one admin to maintain this solution.

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

There is a trial version available that can be used free of charge.

What other advice do I have?

I would suggest trying it for free on the web to see how well it works. You start with the free version, which is version 5.,1 and it's really good. Once you download it and implement it, you have the newest version.

I would rate this solution 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.
PeerSpot user
Ashraf Hamza - PeerSpot reviewer
Consultant at International Turnkey Systems - ITS
Consultant
Efficient with good data retrieval but improvement needed in user interface
Pros and Cons
  • "Oracle APEX is very easy to use and comes with a lot of ready-made components that speed up the process of creating reports and dashboards."
  • "Oracle APEX is very easy to use and comes with a lot of ready-made components that speed up the process of creating reports and dashboards."
  • "The user interface needs to be improved."
  • "The user interface needs to be improved. It should be more user-friendly."

What is our primary use case?

Currently, I am working on converting some reports from Oracle Discoverer to APEX. My activity involves generating reports on the E Business Suite, converting Discover AI to APEX Express. I work in a development platform capacity with Oracle APEX.

What is most valuable?

Oracle APEX is very easy to use and comes with a lot of ready-made components that speed up the process of creating reports and dashboards. It is part of our agreement with Oracle E Business Suite and offers seamless data retrieval and performance. Additionally, we utilize its dashboard and reporting capabilities.

What needs improvement?

The user interface needs to be improved. It should be more user-friendly.

For how long have I used the solution?

I have been using Oracle APEX for three years.

What do I think about the stability of the solution?

I haven't faced any stability issues with Oracle APEX. There are no issues at all.

What do I think about the scalability of the solution?

It is easy to scale up the solution for my projects.

How are customer service and support?

I haven't contacted Oracle support for some reasons or tickets yet.

How would you rate customer service and support?

Neutral

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

I was using Power BI by Microsoft before switching to Oracle APEX.

How was the initial setup?

I was not involved in the initial setup process.

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

Oracle APEX is part of our on-premises solution included in our agreement with Oracle E Business Suite, though I don't know the cost specifics. Power BI is licensed by the user.

What other advice do I have?

I would recommend using Oracle APEX, especially if users are already utilizing Oracle E Business Suite. Oracle APEX is integrated with the business suite and offers numerous features and components that are easy to use. The data can be retrieved efficiently, though the UI can be improved. My rating for the solution is seven 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
Ovidiu Vasu - PeerSpot reviewer
Technical Manager IT Development at Sostenia
Real User
Builds functionalities in a very short time and provides useful AI features
Pros and Cons
  • "The solution can build functionalities in a very short time."
  • "The grid reports contain a lot of bugs."

What is our primary use case?

We use the solution to build and customize applications for our clients. We use it internally and for external clients.

What is most valuable?

The solution can build functionalities in a very short time. It is web-based. The tool contains a set of reports for managing databases. We have integrated the product with SAP and MySQL databases. The integration is productive.

What needs improvement?

The grid reports contain a lot of bugs. The dynamic reports must contain drill-down features. It will be easy to use the reports with such features. Microsoft, SAP, and QlikView provide such functionalities.

For how long have I used the solution?

I have been using the solution for ten years.

What do I think about the stability of the solution?

The tool is very stable. I rate the product’s stability a ten out of ten. We had a problem with the database that interrupted our work, but Oracle Application Express did not face any issues. We were concerned that the application would crash, but it didn’t happen. The tool is quite reliable.

What do I think about the scalability of the solution?

I rate the product’s scalability a ten out of ten. All the new versions maintain the tool's compatibility and have all the functionalities present in the previous version. We have ten customers. Our customers are small, medium, and enterprise-level businesses.

How are customer service and support?

The support is very good. The team provides quick responses and resolves our issues.

How would you rate customer service and support?

Positive

How was the initial setup?

It is very easy to install the tool. I rate the ease of setup a ten out of ten. The product can be deployed on Oracle’s cloud and on-premises. The deployment can be done within eight hours. To deploy the tool, we install the database object, forms, and reports. The deployment can be long or short, depending on the number of objects. We cannot install the tool without an Oracle Database license.

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

If the product is installed on the cloud, the support is included in the license we pay. I rate the pricing an eight out of ten. The tool is free with the Oracle Database license. We cannot use it without the Oracle Database license.

What other advice do I have?

I am an integrator. People who want to use the tool must use structured programming. The code must be structured and disciplined. I recommend the tool to others. Overall, I rate the solution a ten out of ten.

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
Flag as inappropriate
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: November 2024
Buyer's Guide
Download our free Oracle Application Express (APEX) Report and get advice and tips from experienced pros sharing their opinions.