What users are saying about
Top Rated
80 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
485 Ratings
Top Rated
80 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.8 out of 100

SAP Crystal

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
485 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.9 out of 100

Likelihood to Recommend

Oracle APEX

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.
Glenn Roberts III | TrustRadius Reviewer

SAP Crystal

Crystal reports is a great Business Intelligence tool for any midsize business that prefers to keep its data in-house instead of in the cloud. The learning curve for parsing data source and creating first reports could be a bit steep at the beginning, but then the cost savings are invaluable. The reports generated by Crystal are easily manipulated according to different requirements and further analyzed by the recipients.
Frank Hunt | TrustRadius Reviewer

Feature Rating Comparison

Low-Code Development

Oracle APEX
8.0
SAP Crystal
Visual Modeling
Oracle APEX
7.5
SAP Crystal
Drag-and-drop Interfaces
Oracle APEX
7.8
SAP Crystal
Platform Security
Oracle APEX
8.2
SAP Crystal
Platform User Management
Oracle APEX
8.5
SAP Crystal
Reusability
Oracle APEX
8.0
SAP Crystal
Platform Scalability
Oracle APEX
8.2
SAP Crystal

BI Standard Reporting

Oracle APEX
SAP Crystal
8.0
Pixel Perfect reports
Oracle APEX
SAP Crystal
8.4
Customizable dashboards
Oracle APEX
SAP Crystal
7.7
Report Formatting Templates
Oracle APEX
SAP Crystal
7.8

Ad-hoc Reporting

Oracle APEX
SAP Crystal
7.7
Drill-down analysis
Oracle APEX
SAP Crystal
7.3
Formatting capabilities
Oracle APEX
SAP Crystal
8.1
Integration with R or other statistical packages
Oracle APEX
SAP Crystal
7.7
Report sharing and collaboration
Oracle APEX
SAP Crystal
7.8

Report Output and Scheduling

Oracle APEX
SAP Crystal
8.2
Publish to Web
Oracle APEX
SAP Crystal
7.9
Publish to PDF
Oracle APEX
SAP Crystal
8.9
Report Versioning
Oracle APEX
SAP Crystal
7.8
Report Delivery Scheduling
Oracle APEX
SAP Crystal
8.3
Delivery to Remote Servers
Oracle APEX
SAP Crystal
8.1

Data Discovery and Visualization

Oracle APEX
SAP Crystal
7.5
Pre-built visualization formats (heatmaps, scatter plots etc.)
Oracle APEX
SAP Crystal
7.6
Location Analytics / Geographic Visualization
Oracle APEX
SAP Crystal
7.3
Predictive Analytics
Oracle APEX
SAP Crystal
7.8

Access Control and Security

Oracle APEX
SAP Crystal
7.9
Multi-User Support (named login)
Oracle APEX
SAP Crystal
7.8
Role-Based Security Model
Oracle APEX
SAP Crystal
8.0
Multiple Access Permission Levels (Create, Read, Delete)
Oracle APEX
SAP Crystal
7.8
Single Sign-On (SSO)
Oracle APEX
SAP Crystal
8.0

Mobile Capabilities

Oracle APEX
SAP Crystal
7.4
Responsive Design for Web Access
Oracle APEX
SAP Crystal
7.7
Dedicated iOS Application
Oracle APEX
SAP Crystal
7.0
Dedicated Android Application
Oracle APEX
SAP Crystal
7.2
Dashboard / Report / Visualization Interactivity on Mobile
Oracle APEX
SAP Crystal
7.6

Application Program Interfaces (APIs) / Embedding

Oracle APEX
SAP Crystal
6.9
REST API
Oracle APEX
SAP Crystal
7.4
Javascript API
Oracle APEX
SAP Crystal
6.8
iFrames
Oracle APEX
SAP Crystal
7.1
Java API
Oracle APEX
SAP Crystal
6.6
Themeable User Interface (UI)
Oracle APEX
SAP Crystal
6.8
Customizable Platform (Open Source)
Oracle APEX
SAP Crystal
6.6

Pros

Oracle APEX

  • Easy upgrade path from Forms, allowing reuse of code and a low learning curve for Forms developers.
  • Very quick to develop in. Ideal for prototyping or iterative development which is how we usually work.
  • Comes with cross browser and mobile compatibility out of the box.
  • Easy to incorporate other web technologies.
  • Development environment runs straight from a browser. This has proved to be a life saver when issues crop up on a weekend.
Anonymous | TrustRadius Reviewer

SAP Crystal

  • Great visualization for static format & precise tasks: For presentation to senior management /ex-co/vendors where concise decisions need to be made, Crystal is a nice choice to slide data into presentable views.
  • Diverse data source connect: We have used it to write reports using data from DB2, SQL, Progress, Excel spreadsheets, XML data, Access, and Lotus Notes databases. It can also be used to join different database types together in one report.
  • It uses the "recurring bands" structure for page layout which is efficient and fungible for generating different types of reports. Crystal doesn't require that we set up a metadata layer before creating reports and provides direct access to tables and dimensions.
Rohit Narang | TrustRadius Reviewer

Cons

Oracle APEX

  • Perhaps is our problem, since we haven’t explored it deeply, but I think that a better portability to mobile devices would help the adoption of APEX.
  • Applications weren’t as light as we thought, and we had to move the APEX server to the same data center where our data base was running, due to performance issues. When we started, we supposed that that situation would not be an issue.
  • At least in Argentina and Brazil, you can not find as many programmers with experience in APEX as you can find with other technologies.
Federico Shortrede | TrustRadius Reviewer

SAP Crystal

  • The option to export to Excel is very picky about report format to get a clean export. Once you know the tricks for setting up a report for this export, it's not hard to do, but it can be very tedious if the report has a lot of elements. This is the way it's been for years and SAP has indicated that it's not something that's going to be changed.
  • Crystal requires that a user knows how the data they're reporting on is configured in the database - it's not really suited for a "casual" user, but for someone with at least some technical skills in relation to databases. This is not something that can or should necessarily be changed, but it is something that potential users need to be aware of.
  • Other than new types of database connections, SAP has indicated that they will not be upgrading any functionality in "classic" Crystal. They instead have chosen to focus on upgrades to Crystal for Enterprise. The problem with that is that it requires the SAP BI Platform - either SAP BusinessObjects or SAP Crystal Reports Server.
  • One of the major things that's not being upgraded is the Charting libraries, which were last updated in the early 2000's, before SAP purchased Crystal. So, Crystal doesn't have newer chart types available.
Dell Stinnett-Christy | TrustRadius Reviewer

Likelihood to Renew

Oracle APEX

Oracle APEX 8.2
Based on 2 answers
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.
Lisandro Fernigrini | TrustRadius Reviewer

SAP Crystal

SAP Crystal 10.0
Based on 19 answers
I have made my career off Crystal Reports. Business Intelligence is a niche area of Information Technology that combines technical knowledge and an understanding of how a company uses information. Crystal Reports is the most solid, flexible and reliable business intelligence tool I have worked with, allowing me to work on projects in a variety of markets and industries, from the financial to educational, to telecommunications to governmental. Understanding how to use Crystal Reports as part of a Business Intelligence career gives you the tools you need to better connect businesses to their data, deliver quality and productive solutions, and allow you the report developer to build the experience and skills to build a reputable career in the high demand world of Business Intelligence Reporting.
David Deitch | TrustRadius Reviewer

Usability

Oracle APEX

Oracle APEX 8.2
Based on 2 answers
its easy to use as a developer and applications designed using apex are easy and intuitive to use as an end user. Even non-coders can build good applications, the more code you can write the more you can enhance the application but you can get up and running quickly with almost no technical know how.
Kathryn Gamble | TrustRadius Reviewer

SAP Crystal

SAP Crystal 8.1
Based on 22 answers
Crystal is very robust, but not always easy to use. It create wonderful looking reports, and so deserves a high rating. However, I have to take a couple of points off for the simple fact that I cannot hand it to a user and expect them to be able to do development with it.
Greg Goss | TrustRadius Reviewer

Support Rating

Oracle APEX

Oracle APEX 8.2
Based on 2 answers
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.
Kathryn Gamble | TrustRadius Reviewer

SAP Crystal

SAP Crystal 3.9
Based on 15 answers
The support community can be difficult to navigate. I've also run into issues with my login. The SAP system has a bizarre mechanism for validating users that requires users to have what is called an S-ID. A basic ID may not give you access to all the features in the portal. The limitation may include not being able to perform a simple task like downloading patches and updates. This isn't a big deal for single user license but for teams it can be a pain.
Nathan Patrick Taylor | TrustRadius Reviewer

Implementation Rating

Oracle APEX

Oracle APEX 9.1
Based on 2 answers
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.
Lisandro Fernigrini | TrustRadius Reviewer

SAP Crystal

SAP Crystal 8.8
Based on 14 answers
Just like any other implementation: When designing the differing reports, get end users' input, make sure to design the reports so that they display the information that the company requires, in the best and clearest way possible.
Test, test, test, revise when needed, and, particularly, do sufficient training so users are comfortable using Crystal Reports!
John Suit | TrustRadius Reviewer

Alternatives Considered

Oracle APEX

Obviously Oracle Application Express cannot replace WebLogic in terms of creating domains but it is not designed to do that. We can use this tool to prototype and later develop a product using the Oracle WebLogic platform. We selected Oracle Application Express due to the ease of learning, and not having to buy licenses to use it.
Anonymous | TrustRadius Reviewer

SAP Crystal

As I said before I never used a reporting tool before Crystal Reports but I have since used SSRS. Crystal Reports blows SSRS out of the water. The reports look nicer and it was easier, faster, and better to create a report in Crystal Reports. Prior to using Crystal Reports I wrote reports by coding them using RPG on the iSeries. I could never go back to doing that.
Janet Fawcett | TrustRadius Reviewer

Return on Investment

Oracle APEX

  • In the mid-size organization, we had a BI tool that had a significant license cost involved. With Oracle back-end we were able to switch to APEX and move all reporting at literally zero cost.
  • For Oracle PL/SQL users the learning curve is very quick and easy, there are ready templates that you can start with and eventually create complex reports.
  • You can track authorization and authentication on data editing and usage. High performance as it is native oracle sql codes.
  • Centralized data capturing, makes your datawarehouse writable for lookup tables or reference tables.
Anonymous | TrustRadius Reviewer

SAP Crystal

  • Employee Empowerment - Now that our Crystal Reports are written and published, all of our team members have access to run the same reports across the company. Previously, there was only 1 point person in charge of running reports, which took a lot of time away from other job duties.
  • Increased Employee Efficiency - One of the Crystal Reports my company uses has allowed me to take a task that took 3 days to complete and cut the time down to 4 hours. There was a lot of manual data collection and calculations that were done, which has also led to less errors.
  • Accurate real-time data - Since Crystal Reports are very quick to run, we are able to give real time data to our customers rather than maintaining oudated databases in other systems such as Excel.
Shannon Odland | TrustRadius Reviewer

Screenshots

Pricing Details

Oracle APEX

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Oracle APEX Editions & Modules

Additional Pricing Details

SAP Crystal

General

Free Trial
Yes
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
Optional

SAP Crystal Editions & Modules

Edition
SAP Crystal Reports 2020 - Full version$4951
SAP Crystal Server 2020 1 NUL$8692
SAP Crystal Server 2020 5 CAL$8,7443
SAP Crystal Reports Viewer 2020$04
SAP Crystal Reports 2020 - Upgrade$2954
  1. per user
  2. per named user
  3. per 5 concurrent users
  4. per user
Additional Pricing Details
* SAP Crystal Reports 2020 Viewer allows you to view static data within a SAP Crystal Reports file. * SAP Crystal Reports 2020 - Full version allows you to create powerful, richly formatted, and dynamic reports from virtually any data source, delivered in dozens of formats, in up to 28 languages. If you already have an older version of Crystal Reports, buy a license for SAP Crystal Reports 2020 - Upgrade at a discounted, upgrade price. * SAP Crystal Server 2020, 1 NUL includes 1 license of: SAP Crystal Reports 2020 - SAP Crystal Server 2020. * As an add-on to SAP Crystal Server 2020 1 NUL, SAP Crystal Server 2020 5 CAL allows you to support a wider, intermittent audience of end users, up to five logged on at the same time.

Rating Summary

Likelihood to Recommend

Oracle APEX
9.2
SAP Crystal
8.1

Likelihood to Renew

Oracle APEX
8.2
SAP Crystal
10.0

Usability

Oracle APEX
8.2
SAP Crystal
8.1

Reliability and Availability

Oracle APEX
SAP Crystal
8.0

Performance

Oracle APEX
SAP Crystal
8.0

Support Rating

Oracle APEX
8.2
SAP Crystal
3.9

In-Person Training

Oracle APEX
SAP Crystal
10.0

Implementation Rating

Oracle APEX
9.1
SAP Crystal
8.8

Scalability

Oracle APEX
SAP Crystal
7.0

Add comparison