Try our new research platform with insights from 80,000+ expert users
reviewer1014486 - PeerSpot reviewer
Facility director at a aerospace/defense firm with 5,001-10,000 employees
Real User
Fairly intuitive with a user-friendly UI; unfortunately the format is not recognized by Word
Pros and Cons
  • "Intuitive with a user-friendly UI."
  • "The format is not recognized by Microsoft Word products."

What is our primary use case?

We use this solution for reports, data queries and as our CMS. APEX is our purchase requisition system. We are customers of Oracle, I'm the facility director and a user of APEX. 

What is most valuable?

The solution is fairly intuitive and has a user-friendly UI. The great thing is that in terms of process mapping, it's already configured including for drag and drop and easy manipulation of objects.

What needs improvement?

It would be helpful if the solution was in a format recognized by Microsoft Word products. 

For how long have I used the solution?

I've been using this solution for five 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?

The solution is stable. We have an engineer who deals with the maintenance. 

What do I think about the scalability of the solution?

The solution is scalable. We might increase the number of users but for now we only have 20 users. 

How was the initial setup?

The deployment was easy and took no time. 

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

This solution is free for us because we use an Oracle-based product for our purchasing and it's included in that. 

What other advice do I have?

I rate this solution seven out of 10. 

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
it_user486555 - PeerSpot reviewer
Physical Scientist at a government
Real User
The most valuable features are the ease with which data can be accessed and the improvements that have made the front-end look like a real application.

Valuable Features

The most valuable features are the ease with which data can be accessed and the improvements that have made the front-end look like a real application. The graphing plug-ins are really good as well.

Room for Improvement

We are excited that they are going to go into the web service world to make the rest of the APIs available. We have been looking for master detail, but that is has been improved quite a bit. Nothing is perfect though.

Use of Solution

I have been using the product for eight years.

Stability Issues

It has been consistently stable. We have not had any issues with it.

Scalability Issues

So far it has met our needs and we hope that it will continue to do so. At the end of the summer, we are moving a flex application to APEX that will be released in August. It will have about four hundred users.

Customer Service and Technical Support

I have never personally talked to tech support, but we have had conversations with the consulting folks about some of the rack solutions for improving data expansion. From my understanding, tech support is very good.

Initial Setup

It is always fun having to do the Oracle patches. Our DBAs handle all that, but it does affect us as far as having to take systems down to do the upgrades, which gets a little frustrating. It's manageable though. They take about an hour or two.

Other Advice

It is a free product. Install it and start having fun. APEX out of the box is pretty good and very easy to get started. You can get your data out in five minutes. I’d give it an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
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.
Farah Kasabri - PeerSpot reviewer
Information Technology Manager at Augusta Victoria Hospital
Real User
Easy to use, reliable development platform with many ready modules inside
Pros and Cons
  • "It has many ready modules that can be used and developed."
  • "When exporting, we can't export dynamic reports, only static reports. For example, when we want to export charts or tables it is only exported as a static report so we can't drop down on these reports; however, we can see this information when we are on the dashboard itself."

What is our primary use case?

We use this for our healthcare system dashboard as testing.

What is most valuable?

It has many ready modules that can be used and developed.

What needs improvement?

When exporting, we can't export-dynamic reports, only static reports. For example, when we want to export charts or tables it is only exported as a static report so we can't drop down on these reports; however, we can see this information when we are on the dashboard itself.

For how long have I used the solution?

I have been using this solution for two years.

What do I think about the stability of the solution?

it is very stable and steady.

How are customer service and support?

Customer support is great.

How was the initial setup?

Initial setup was straightforward as we have a team that has good experience.

What other advice do I have?

It secure, stable, and the support is very good as well.

I would rate this an eight out of ten.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Software Developer at Watronix Information Technology Ltd
Real User
Connection is quick and simple, but stability could be improved and installation could be simplified
Pros and Cons
  • "A user interface is relatively simple to create."
  • "It would be beneficial to include WebSockets so that you can see real-time updates."

What is our primary use case?

We develop software for local governments as well as software licensing.

We look after the local government and Healthcare.

What is most valuable?

A user interface is relatively simple to create.

I can easily connect to the servers. It has a fast connection.

What needs improvement?

Making a CI/CD lane for it is a bit difficult.

It is difficult to achieve continuous delivery or continuous integration.

Stability and technical support could be enhanced.

It would be beneficial to include WebSockets so that you can see real-time updates.

For how long have I used the solution?

I have been working with Oracle Application Express (APEX) for three years.

We are not using the most recent version, but we are close.

What do I think about the stability of the solution?

Oracle Application Express (APEX) is not very stable.

What do I think about the scalability of the solution?

Oracle Application Express (APEX) is a scalable product.

This solution is used by ten developers or technical consultants in our company.

We may increase our usage in the future.

How are customer service and support?

I had a technical issue, and it took me a month to get an answer from Oracle.

Response time is very slow.

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

I work with multiple solutions simultaneously.

How was the initial setup?

We have people who surf the servers on our behalf. They are simply regular Windows computers, but not in our location, but in another. Similar to a cloud.

We have several small cloud providers. They are based in the Netherlands.

It is rather complex to install.

I would rate the installation a three out of five.

It took approximately, one day to deploy.

We need two developers to maintain this solution.

What about the implementation team?

Our in-house team completed the deployment.

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

I believe it is free, but the Oracle database license must be purchased.

It is expensive, but I don't know what the licensing cost is.

Which other solutions did I evaluate?

I did not consider alternative solutions. This solution was already chosen and in place when I started at this company.

What other advice do I have?

It all depends on the solutions you seek. But, yes, I would probably recommend this solution to others.

I would rate Oracle Application Express (APEX) a six out of ten. The idea of the product is good, but there are issues that make it difficult to work with.

Which deployment model are you using for this solution?

Private Cloud

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

Other
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1249362 - PeerSpot reviewer
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
reviewer1058394 - PeerSpot reviewer
Engineer at a university with 10,001+ employees
Real User
Great tool with simple architecture for fast webpage deployment
Pros and Cons
  • "Oracle APEX allows our company to complete webpage projects easily in a fast turnaround time."
  • "Occasionally when trying to un a page, I would be faced with an error number; however, not much information would be provided on the error itself outside of the programming language. It would be nice if more information could be provided."

What is our primary use case?

I used this to deploy some web pages. It did not have a difficult or complex architecture.

How has it helped my organization?

Oracle APEX allows our company to complete webpage projects easily in a fast turnaround time.

What is most valuable?

Oracle's simplicity is the most valuable aspect. You are able to deploy simple websites that have several pages easily. Minimal consideration is required for design. You can just make a few configurations and your website is ready to use. It is as quick as making the coffee.

What needs improvement?

Occasionally when trying to un a page, I would be faced with an error number; however, not much information would be provided on the error itself outside of the programming language. It would be nice if more information could be provided.

For how long have I used the solution?

I have been using this solution for two months.

How are customer service and support?

Due to sanctions, many users in Iran are not able to access support. For those who can, it is not an easy process.

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

Before the Oracle APEX, we used the traditional tool or write your web page by PHP, HTML, etc. And as a database, we used to use MySQL, Cassandra, and other options. I don't know why the company decided to use Oracle APEX.

How was the initial setup?

As a programmer, the setup was very easy. I do not know what the setup looks like for database administrators.

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

I do not think this would be an ideal option for a small sized company or a startup when considering the salary requirements for Oracle DBA'a and developers.

What other advice do I have?

Oracle APEX would be great for a big company and with a strong client base where project web pages are needed as soon as possible. The product reduces the time to market for your product and you can write websites by different configurations.

Overall, I would rate the product an eight 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
Sr. Director at LogiCorner Info Tech.
Real User
Leaderboard
Shortens the development cycle, enabling faster delivery to the customer
Pros and Cons
  • "Oracle APEX improved our organization by making it possible for us to implement agile project development."
  • "Currently, APEX doesn't have a building workflow engine. I think that's the most important improvement that could be made at this point."

What is our primary use case?

Right now, we have two primary use cases for this solution. We are using Oracle APEX to build full-customized ERP systems for big companies and also for small and medium-sized enterprises.

How has it helped my organization?

Oracle APEX improved our organization by making it possible for us to implement agile project development. A key agile feature is shortening the development cycle, enabling faster delivery to the customer. It enables us to deliver a complete system to the customer more quickly. The customer can use a system and provide us with feedback. We then implement changes and enhance the system as part of second development cycle. 

If we were using a different tool, it would take us maybe three months to deliver a development cycle. With APEX, we're able to deliver in less than a month.

What is most valuable?

What I find the most valuable about Oracle APEX is that it is very fast.

Prior to Oracle APEX, we were using Oracle Developer/2000, or D2K for short. It's another RAD. RAD refers to rapid application development tool. These two tools are quite similar. So, they are very easy for us to migrate.

That's why we choose Oracle APEX. It is a very powerful tool. It has a lot of function and a lot of features that were not available in D2K. D2K is not available on mobile, for example. Oracle APEX is very convenient. 

What needs improvement?

1. Need more backup options, such as more than 25 backups, option for choosing what conditions to trigger the backup action, etc.

2. If APEX could add the workflow engine feature, that will be awesome.

3. If there could be a kind of chart to make the link graphics between the parent nodes and the child nodes, (currently there is a Tree feature), but sometimes the hierarchy is not only one-to-many, could be many-to-one, or many-to-many.  

4. More mobile-friendly UI features will make APEX more powerful and engaging.

For how long have I used the solution?

I have been using this solution since 2015.

How are customer service and technical support?

We do not use Oracle paid support. We use community support. 

The Oracle Community is not paid support but it is very powerful. It's a great community, made up of very intelligent and enthusiastic people. 

How was the initial setup?

I consider the initial setup simple compared to other technology. 

What other advice do I have?

Oracle APEX significantly reduces the effort that needs to be put into development, allowing us to focus more on system analysis.

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
Bulent BASIM - PeerSpot reviewer
Managing Partner & Oracle ERP Technical Consultant at a tech services company with 1-10 employees
Real User
A customizable web-based software development solution
Pros and Cons
  • "I like how we can actively develop and customize APEX because it's on the same database."
  • "I don't like the URL syntax."

What is our primary use case?

We use Oracle Application Express (APEX) to integrate solutions with E-Business Suites.

What is most valuable?

I like how we can actively develop and customize APEX because it's on the same database. We use all the E-Business Suite custom environment features in APEX. We use it because developers can fully leverage it. For example, in Oracle Application Framework, you have a download time of about half an hour before deployment. But there's no deployment time in APEX. You can see it after refreshing the page.

What needs improvement?

I don't like the URL syntax—for example, the parameters in the URL for the pages. If there are any parameters, all the users see all the parameter names. This may require some caching. The UI could be improved as well. Sometimes, based on the customization, load balancing isn't running behind the F5. 

For how long have I used the solution?

We've been using Oracle applications for about three years.

What do I think about the stability of the solution?

APEX is a stable product.

What do I think about the scalability of the solution?

APEX is scalable. We have two deployments, two of them behind a local APEX and another in Turkey. The installation is on the local area network. We got three servers that run on the APEX and an APEX installation on a single database in a lab.

What about the implementation team?

There's a technical team, but I install APEX by myself.

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

We have a full Oracle E-Business Suite license, and we use that license to develop applications. There's no license required for developing Oracle applications. It's just for the Oracle development tools we use until the final product is ready. 

What other advice do I have?

The forums are quick, and I follow those to lookup features, and I just recall it. I follow all the online seminars and that was enough for me.

There are some restrictions when using this product, but it can be valuable for developing and integrated with E-Business Suite. Because in some instances, some tools aren't available in the E-Business Suite environment. 

On a scale from one to ten, I would give Oracle Application Express (APEX) an eight.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
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.