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.
Founder and Salesforce Consultant at SaaSnic
Strong database feature but not very flexible in app development
Pros and Cons
- "The database is super easy to use for creating tables."
- "Oracle is more of a database-oriented solution and is not very flexible in app development."
What is our primary use case?
How has it helped my organization?
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.
What is most valuable?
Databases are the most valuable feature in Oracle APEX for me. The database is super easy to use for creating tables.
What needs improvement?
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.
Buyer's Guide
Oracle Application Express (APEX)
December 2024
Learn what your peers think about Oracle Application Express (APEX). Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
For how long have I used the solution?
I have been using this solution for three years. We are using version 22.5.
What do I think about the stability of the solution?
It is a stable solution. I would rate the stability a seven out of ten.
What do I think about the scalability of the solution?
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.
How are customer service and support?
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.
Which solution did I use previously and why did I switch?
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.
How was the initial setup?
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.
What about the implementation team?
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.
What's my experience with pricing, setup cost, and licensing?
I would rate it around an eight in terms of price, with one being low and ten being high.
Which other solutions did I evaluate?
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.
What other advice do I have?
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.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Sr. Information MGT Analyst at Pertamina
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.
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.
Buyer's Guide
Oracle Application Express (APEX)
December 2024
Learn what your peers think about Oracle Application Express (APEX). Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
Solution & Software System Architect at Shaparak
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.
Last updated: Aug 7, 2024
Flag as inappropriateHead of Development and Implementation at Arak Petrochemical Company
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
Senior Database Administrator at Overonix Technologies
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.
Senior Software Developer at Cegal
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.
Computer Specialist at a government with 10,001+ employees
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.
Technical Manager IT Development at Sostenia
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
Last updated: Jun 20, 2024
Flag as inappropriateBuyer's Guide
Download our free Oracle Application Express (APEX) Report and get advice and tips from experienced pros
sharing their opinions.
Updated: December 2024
Product Categories
Rapid Application Development Software Development Platforms Low-Code Development PlatformsPopular Comparisons
Microsoft Power Apps
Pega Platform
Salesforce Platform
Microsoft Azure App Service
GitHub CoPilot
ServiceNow Now Platform
Oracle Visual Builder Cloud Service
Buyer's Guide
Download our free Oracle Application Express (APEX) Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Looking for recommendations for a no-code backend database for 500,000+ users - looking at CASPIO
- Help to migrate IBM Lotus Domino to another platform
- When should you use rapid application development and what are the most suitable projects for it?
- Who uses and benefits the most from rapid application development?
- Why is rapid application development important?
- When evaluating Rapid Application Development Software, what aspect do you think is the most important to look for?
- Why is Rapid Application Development Software important for companies?