Contact us at +1.415.901.7500 or

Oracle Discoverer Migration – Options, Considerations and Next Steps

Oracle Discoverer Migration – Options, Considerations and Next Steps

Options Available for Oracle Discoverer Migration

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 for Oracle Discoverer which is now desupported. 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 for a legacy reporting tool like Oracle Discoverer, you need to understand your options and make the best choice based on your unique business needs. Before embarking on Oracle Discoverer migration, you need to answer the following questions:

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?


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 Discoverer 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 Discoverer responsibilities to a single resource with the required skills, creating unnecessary dependencies. Moreover, an IT department that spends most of their 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 lead to other issues including errors, data inconsistencies, multiple versions, etc.


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. So, what are your options for Oracle Discoverer migration:

Migrate to Oracle Analytics Server (OAS)

You can migrate from Discoverer to Oracle Analytics Server – the latest on-premise BI offering from Oracle and an upgrade option for Discoverer and OBIEE customers. OAS provides a wide range of capabilities including AI that uncovers key insights from your data, data enrichment features that automatically recommend new elements for analysis, machine learning capabilities for both traditional and citizen data scientists, and advanced data visualizations for pixel-perfect reporting. OAS brings the modern, best-in-class capabilities of Oracle Analytics Cloud to customers requiring on-premises deployments. Organizations can leverage augmented analytics and data discovery capabilities, enabling customers to migrate on their own terms and preferred deployment architecture. With Oracle Analytics Server, you can retain your legacy systems while an easy and seamless path to the cloud is ready when you are.

Migrate to Oracle Analytics Cloud (OAC)

OAC is a great choice as a replacement for Oracle Discoverer. 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

Oracle tries to convince us into thinking that migrating to another Oracle BI product is the only way forward for Discoverer customers. However, there are many non-Oracle products that can meet your reporting requirements. But many of them add another layer of software that needs to be managed, often creating more silos that increases complexity for IT teams. This could leave the business without the data they need to make fast business decisions. But there are a few tools like Tableau, Power BI, and Looker that resolve ERP reporting challenges and deliver fast, user-friendly reports and dashboards.

Considering an Oracle Discoverer migration, here’s how to evaluate a replacement for Oracle Discoverer?