Covering the essentials of business intelligence, explore the features & functions for an overview.
Orbit accelerators are purpose built and customizable to fit your requirements.
Knowledge is power, signup forOrbit customer portal access.
Leading provider of enterprise Reporting and Analytics software.
Oracle Discoverer used to be a trusted ad-hoc operational reporting tool, that was primarily used by Oracle ERP customers. However, it reached its end of life (i.e. Oracle stopped offering support for Discoverer) a few years back.
In spite of this lack of support and upgrades, organizations continued to use Oracle Discoverer for basic analysis. They did this because they didn’t want to lose some of their legacy data and reports, in case they needed to use it for data analysis in the future.
But now, business leaders and IT decision-makers have realized that if their companies are still using Oracle Discoverer, it is time to migrate as soon as possible.
Additionally, when it comes to operational reporting, the need of the hour is adopting self-service, next-generation tools where the reliance on IT teams is reduced. They are looking for a modern reporting and analytics solution that can offer the following features and capabilities:
In this post, we cover a wide range of topics related to replacing Oracle Discoverer and the process you need to adopt to find the right tool to replace it.
Oracle’s Discoverer application was designed as a smart ad hoc query and analysis reporting tool for businesses. In January of 2009, Oracle released a public statement encouraging its users to migrate from Discoverer. Fast forward a decade and organizations are still using this solution, even after Oracle announced Discoverer’s end of life in June 2017. What was special about Discoverer? Why did companies use this tool for transactional and operational reporting?
There were three key reasons:
Integration with other Oracle tools was seamless: Discoverer seamlessly integrated with other Oracle business intelligence and reporting tools, such as Oracle Reports and Oracle BI Publisher. This integration allowed companies to leverage their existing Oracle investments and create a unified reporting and analytics ecosystem.
Integration with Oracle Database was a critical factor: Oracle Discoverer was developed by Oracle Corporation and as a result, Discoverer seamlessly integrated with Oracle Databases, making it an attractive choice for companies already using any Oracle tool.
Ad-hoc query capabilities used to be top-notch: Discoverer offered powerful ad hoc query capabilities, allowing users to create custom reports and analyze data according to their specific requirements. This flexibility made it popular among business users who needed to access and manipulate data in real-time without relying too much on IT or technical support.
If your organization has not done so already, it’s time to select a Discoverer replacement solution and begin migrating your reports. In fact, it’s already too late.
The image above – which is a screenshot from a Discoverer training session a few years back – depicts how outdated the Discoverer solution has become. Even the example shown is that of a video rental company!
Changing a reporting solution isn’t an easy decision. It’s not an easy project either, especially if you have to manually recreate reports. Many large organizations have created hundreds or thousands of reports using Discoverer, so a project to migrate from them is a significant undertaking; one that impacts many critical departments in an organization.
Businesses don’t always see a benefit from moving off a legacy solution. Replacing existing reports with similar versions generated by another system is time-consuming and not particularly profitable.
Oracle’s own replacement reporting options, OBIEE and OTBI, are expensive. And complex.
Moving users to these solutions will take a significant amount of training and hand-holding. For example, OBIEE offers a Discoverer migration utility, but it does not migrate the end user layer (EUL) that contains the database metadata. A migration project will have to dedicate time to rebuilding the semantic layer for all reports.
Nonetheless, if your business is still using Discoverer for ad hoc and operational reporting in Oracle E-Business Suite (EBS) and/or custom database applications, you need to migrate.
Staying on an unsupported legacy product is a risk for a number of reasons:
With easy data access, better organizational insights, and one of the fastest times to value in the industry, Orbit is the clear replacement to Oracle’s Discoverer.
Depending on the number of your Discoverer reports in Oracle EBS and custom applications, manual migration by a dedicated team of experts can take anywhere from a few months to a few years. But with a Discoverer replacement like Orbit Analytics paired with adherence to best practices, migration can happen quickly, efficiently and affordably.
Orbit supports multiple system platforms, including Oracle E-Business Suite, Oracle Fusion, PeopleSoft, Taleo and more. It’s a powerful reporting application for creating simple to complex reports for your organization, delivered with over a thousand pre-built reports encompassing Oracle Financials, Supply Chain, and HRMS.
Orbit connects to multiple databases such as Oracle, MySQL, IBM DB2, and Microsoft SQL Server – in fact, any database with a JDBC driver. With an HTML5 front end for a modern, web-based UI, it delivers real-time operational reporting, drill-to-detail, dashboarding, and ad hoc inquiry capabilities in an integrated business intelligence package.
Watch this video to find out more:
Oracle Transactional Business Intelligence (OTBI) is an Oracle BI product for OLTP reporting against Fusion (Oracle Cloud) apps only. While a good option for cloud-only environments, it may be less optimal for organizations that need to report on a variety of cloud and on-premises data sources.
OTBI is not an ad hoc or self-service reporting solution
Its report creation interface is somewhat rigid and outdated, using a wizard instead of a more modern drag-and-drop interface. Because OTBI does not come with an inventory of prebuilt reports, a migration project will need to budget time to recreate all Discoverer reports and dashboards. OTBI also requires another Oracle product, BI Publisher, for report bursting and distribution and pixel-perfect reporting.
SAP Crystal Reports
A Legacy Reporting Solution Crystal is another popular reporting solution with a long lifespan. Organizations that have an existing Crystal implementation may think it’s a good idea to consolidate reporting in the tool.
However, Crystal has a number of critical drawbacks including
Orbit is one of several modern alternatives to Discoverer. The many benefits of modern reporting and analytics solutions in general (and Orbit in particular) include
It is worthwhile, as part of a Discoverer migration project, to talk to one or more third-party analytics vendors before committing to an enterprise BI product that may be more complex or expensive than you need.
Discoverer Migration: Made Easy with Orbit’s Automated Solution
With our migration utility, automatic conversion of Oracle Discoverer Reports is possible.
You shouldn’t need to put your operations on hold when you replace your Oracle Discoverer reporting tool. Orbit comes with an Oracle Discoverer migration assistant that converts all the Discoverer reports, ensuring quick time to value.
Listen to this Webinar titled “Dealing with a Desupported EBS Reporting Tool like Oracle Discoverer?” click here