Oracle Discoverer Migration – Options, Considerations and Next Steps

December 4, 2019

Premier support for Oracle Discoverer ended in June 2014 and extended support ended in June 2017. This move put many Discoverer customers in a tough spot as they were forced to look for a new reporting tool as a replacement. Customers who have a significant investment in Oracle Discoverer frequently ask us questions regarding Oracle’s commitment to this product, support timelines, and the future strategy.  As a customer, you need to understand your options and make the best choice based on your unique business needs.

Oracle Discoverer Migration

Key Questions to Answer

Multi-Dimensional Reporting: Do you require basic static reporting capabilities or multi-dimensional reporting across multiple data sources?

Mobile BI Do your employees need to view reports on the fly? If yes, it makes sense to have ERP reports that can be accessed from a mobile device anytime, anywhere.

Data Visualization Does your business need advanced data visualization capabilities or simple table-based reporting or a combination of both?

Ad hoc Reporting Does your business generate monthly planned reports or do you need quick access to information from the ERP system?

Data Sources Are the reports coming from data stored in a single system or from multiple sources – potentially outside of the ERP solution?

Replacing Oracle Discoverer

Oracle Discoverer is a popular reporting tool for Oracle E-Business Suite but it is an older product and does not work with any data sources other than EBS. Apart from the fact that Oracle has ended support, Discoverer is a legacy reporting tool that is not intuitive and takes a long time to run reports. This is because the tool wasn’t built for end-users. Creating reports requires technical expertise, making the entire process slow and cumbersome. And when the reports are generated, users have no easy way to drill down into the reports and analyze the information further. This often results in more unanswered questions for business users and additional requests to the IT department.

As Discoverer is an older tool, it’s difficult to find resources with the right technical skills, making it more challenging for IT to generate reports quickly. As a result, IT usually ends up delegating responsibilities to a single resource with the required skills, creating unnecessary dependencies. Moreover, an IT department that spends most of its time building complex reports won’t have the time to focus on transformational projects like upgrades or integrations. Despite IT spending a lot of time creating reports for the business, due to the limited capabilities of Oracle Discoverer, users can’t interact with the reports the way they need to. As a result, users work on spreadsheets, which leads to other issues including errors, data inconsistencies, multiple versions, etc.

Migration Options

Investments in ERP and reporting tools cost a lot of time, money, and effort. You need to know and evaluate all your options, not just the options that Oracle is pushing you to consider.

Migrate to Oracle Analytics Cloud (OAC)

OAC is a great Oracle Discoverer migration option. OAC is a cloud-based solution that allows you to access reports from any device and can be used for advanced data visualization. OAC also has the ability to combine data from multiple sources including Oracle EBS. Replacing Oracle Discoverer with OAC is a cost-effective option that eliminates the risk of an unsupported system, improves performance, and delivers a better user experience with wider user adoption. OAC provides self-service analytics capabilities, enabling users to create their own reports without any help from your IT department. OAC also provides better security and a future upgrade roadmap that is aligned with Oracle’s analytics strategy.

Migrate to a Third-Party Tool

While migrating to another Oracle BI product is an option, that is not the only way forward for Discoverer customers. There are many non-Oracle products that can meet your reporting requirements such as Tableau and Power BI. Both Tableau and Power BI resolve ERP reporting challenges, deliver fast, user-friendly visualizations and dashboards, and can easily pull data from non-Oracle sources. Additionally, these products have capabilities for advanced analytics using machine learning.

Migrate to OBIEE

You can migrate from Discoverer to OBIEE and many customers are doing that but OBIEE is not the ideal choice. OBIEE is a powerful tool, but it’s not built to be a transactional reporting tool suitable for day-to-day ad hoc analysis. You can view data in attractive dashboards, which is great for C-level needs but OBIEE has limitations if you are an end-user who needs to see the details within the data. As OBIEE is a data warehouse, your business will have to plan well in advance to develop the structure of the reports that you might need in the future. It’s difficult to adapt quickly to constantly changing reporting needs and to build and customize OBIEE reports accordingly.

Subscribe to our blog