OpenText Magellan BI & Reporting vs. Oracle Analytics vs. SAP Crystal

iHub is a decent enough environment that it serves our needs. We can have unlimited users and it can tie into AD although we do not use that feature currently. It is a decent place to store all of the reports in one location, even though for us it is not visually appealing to the end users. iHub is not a place where you want to create robust/interactive dashboards for end users to drill through and follow a "story".

Incentivized

Oracle Data Visualization is very effective if used in an enterprise context with huge volumes of data coming from different systems. It supports dashboard and reporting capabilities and is easy to scale. It also allows you to leverage machine learning capabilities to extract hidden data trends. Visualization capabilities are powerful but not so various if compared to other solutions on the market. If you want to present a dashboard to an executive audience and you want to make your dashboards beautiful you must adapt them through PowerPoint.

Incentivized

Generation of templated reports is the strong suit of SAP Crystal. Allows users to change formats in templates bases on requirement with minimal effort. Automated report delivery requires the user to be aware of sql which cannot be expected from all users. Should support more document export formats and improve the UI for SAP B1 Users

Incentivized

• It is fairly easy to set the sharing rules for a report/dashboard.
• They have a decent amount of time frame options for setting a schedule to generate a report.
• The support is mostly helpful and timely if you have an issue.

Incentivized

• Available without of the box connectors for Salesforce and oracle Saas Cloud. This is a huge plus for our business since we don't need another middleware solution just for this sake.
• We are able to connect to our on-prem SQL Server database where we have our RMA database and other applications seamlessly without writing custom APIs.
• OAC writes directly into ADW which is another advantage for loading Excel files into ADW after dataflow transformations.
• OAC allows replication of the database from fusion ERP and lets us create subject areas using the data modeler.

Incentivized

• Crystal Reports allows us to create a consistent template for all of our reports.
• Crystal Reports and Server allows us to house a repository for all of our reports to make them easy to find and update when necessary.
• Crystal Reports can connect to a wide variety of data sources.
• Crystal Reports can be a little daunting when first implementing. There are a lot of nuances in learning how to truly master this software and it can be frustrating at times.

Incentivized

• Setting up a "dashboard" is extremely lacking in functionality. The different chart widgets you place on the page do not interact with each other. When you select an item from one do not expect it to highlight or filter another.
• The speed and stability are not great, but maybe that is just our environment not being up to snuff...even though we are above the "recommended" settings.
• The main GUI for a user is TERRIBLE. You log into a File Tree format where you have to navigate folders to reach the correct dashboard. There are ways around this, but it would either require an expensive payment to the Professional Services team to revamp to UI or another option they gave us was to create the "Default Dashboard" and provide that link to users and in that Dashboard, you use a new tab to include the navigation back to the main screen so that at least on the initial load the user is taken to a friendly looking dashboard instead of a file tree.

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

• The export of reports to Excel is very cumbersome and the results are difficult to format.
• The design of reports and the graphical features (e.g. charts) feel quite rigid.
• The learning curve for a non-programmer is incredibly steep, making Crystal a specialty tool.

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.

We have been using this product for so many years and it has truly become a cornerstone to our business processes when it comes to developing and distributing information via reports. We currently have over 500 reports developed to date over about 30 systems and that will continue to grow as user needs change.

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

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.

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

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.

Incentivized

Oracle University offers very in-depth training.

Trainer was patient and thorough in going through the basics and willing to answer questions by email after the initial training

Incentivized

It was a private training site.

Incentivized

A properly implemented Endeca solution performs extremely well on the largest of datasets and it positions your organization to immediately achieve your ROI.

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!

Incentivized

Our instance of iHub does not stack up against the other larger BI tools out today. It is a good place to store reports in a central location that allows users to run very specific reports on demand, but it is not a place I would want to store all of my "dashboards". As far as holding individual reports that are specific to an individual need, it is a great tool. If you want to create a report that will be used as a Template for a Form or a Label, iHub is a good choice to store and schedule the report or call it via API to generate it and return it to your calling app.

Incentivized

Oracle Analytics Cloud, is one of the most agile and secure data analysis platforms that according to the budget and the amount of use, you can use the resources you need under the cloud. The Oracle brand is also very well known in this field and can meet all the needs of an organization or industry in any sector.

Crystal reports is useful in case we want to import data from data base . We can write queries in it but Google Charts require to be implemented in our application using code so crystal reports is better than Google Charts.

Incentivized

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 is a decent buy for specific departments in terms of reporting capabilities but updates and cost (frequent) demands are higher with the benefits offered.
• So long as the requirements are not ever changing, with scheduling functionality, it's a handsome tool.

Incentivized