Oracle Analytics vs. Oracle APEX

The entire deployment and configuration stage was easy and it was accessible across the organization in a matter of days. Oracle Analytics Server being a cloud-based solution helped right from Input of Bulk Data to Info preparation, Data cleaning, and finally Data Modeling. Everything was visual and the Help Wizard was very intuitive.

Incentivized

It is appropriate for database application development supporting data driven processes, online transaction processing, BI/reports/analytics ... for addressing about any business data processing need I can think of. Oracle Application Express is fantastic for creating beautiful rich user interfaces with support for all major browsers rendering well on a range of devices. It is less appropriate for applications requiring native low level access to device peripherals and is less appropriate for applications that must execute offline without network/internet connection to supporting application and database servers.

Incentivized

• Oracle helps with easy customization of reports.
• It helps with the creation of dashboards and the integration of different data sources.
• Oracle BI was a package used for multiple users across our organization - publishing and distributing reports was a breeze.

Incentivized

• It is an easy tool to adopt, which allowed us to replace developments in Oracle Forms in many cases.
• It is very simple to develop different kinds of analysis, in a faster and more friendly way than running Oracle Reports.
• It helped us to extend our approval workflow, in order to cope with difficult branches that were hard to solve with the standard workflow.
• It was possible to develop web applications, to share information and transactions with our commercial partners.

Incentivized

• More AI but with human back up.
• Less mumbo jumbo so even IT guys/gals can more easily work.
• More statistics (math) and orientation for those not familiar with it.
• More live as well as virtual (live) show casing of real situations in business.

Incentivized

• For complex APEX applications you need to be a pro expert in PL/SQL
• Debugging in APEX can be complicated if there is a logical error. Syntax errors will end up shown as ORA errors
• Lack of designer interface. Even though you are designing a form you need to do it by means of APEX interface using a series of steps, no UI for design
• Oracle specific not applicable for other databases

Incentivized

Scalability and rich integration capabilities. In the future, if we go with Hyperion for the Financial Consolidation and planning purposes -BI integration with Hyperion is going to be much simpler as it has native interface connectivity and even integration capabilities with well known CRM products (Siebel) and ERP Products (Oracle EBS, Peoplesoft, SAP) is going to be easy and straight forward.

I felt very comfortable using Oracle Application Express from the start. I designed my data model and quickly developed the basic CRUD pages for master tables. Then I designed the main functionality and was able to test and deploy it in a couple of days work. I will probably share the app with other members of the team and continue adding some features in the short term.

Incentivized

Great, if you are limited to using it along with other Oracle products; sadly, not if you are integrating with other products, which can be a challenge. It is a great product with tons of functionality and great integration with other in-house platforms. Great visuals and customization for data and analytics to provide decision-making data and analysis.

Incentivized

Because it's very easy to develop, fast, secure, has a lot of features. It's like a prototyping tool such as figma, but it can be used as a real product. Dynamic action, plugin, rest api, minimize a lot of coding, a lot of templates, PWA, really bring Oracle APEX functionality to be able to solve most common internal users pain points.

Incentivized

No problems, it's that simple.

Incentivized

Other than anomalies or expected quirks, there were never any earth-shattering delays.

Incentivized

Oracle Analytics Support team is very proactive and I have never had a situation where I had to wait for more than a day or two to get my issues resolved. This is a very big help for us and we appreciate Oracle and its team for guaranteeing that experience.

Incentivized

Very active and knowledgeable community support includes quick and helpful responses from the Oracle employees on the product development team. I've never had to raise an official support request - everything is dealt with via forums and user groups - or via direct emails. The supposrt commuinty is one of the great things about Apex.

Incentivized

Oracle University offers very in-depth training.

It was a private training site.

Incentivized

Like most other large implementations of such technical programs, it pays to plan as much upfront as possible, and this is why we are researching this great product so much.

Incentivized

Using it on the cloud is really simple, the entire process of configuring and provisioning an Oracle Database takes only a few minutes (less than 10) and then Oracle APEX is already deployed on the database, so you just have to start using it. I would strongly recommend using APEX on Oracle Cloud Free Tier.

Incentivized

If compared with other major BI and data visualization tools ODVC guarantees a higher level o scalability. In fact, ODVC is ideal to be used to cover very complex use cases with data coming from different enterprise systems through different integration technology. ODVC can easily deal with millions of records.

Incentivized

Oracle APEX and Oracle Visual Builder are both low-code development platforms within the Oracle ecosystem, but they serve different purposes. Oracle APEX is more suited for the people who are familiar with SQL, PLSQL. It provides rapid application development features based on data residing in Oracle database. It's a low code platform and best suited for web based applications/extensions based on Oracle DB that may use REST APIs and other web services. It also provides mobile application support. Oracle Visual Builder is best suited for web applications based on Oracle Cloud services. It utilizes javascript based drag-drop UI builder. It's very deeply integrated with Oracle Fusion Cloud platform.

We have seen the results of this in our initial research and are not surprised that Oracle does this like it does soo many other things in this area, so well.

Incentivized

• We've used OBIEE (or it's previous named product) for over 13 years and it's still the most used tool for BI by the business.
• We moved our largest business system off of Business Object into OBI so we could gain improved performance, reliability, and easier management of metadata.

• It has increased our development output over Forms greatly. For instance, when starting at my current company, I was able to replace our aging ASP Intranet site within 4 months when our IT manager had budgeted over a year for the task.
• We've been able to standardize under one technology, incorporating previously unsupportable disparate systems under one roof.
• It's free with an Oracle Database so the only investment was our time, something we now have more of thanks to Application Express.

Incentivized