Discoverer’s extended support ended in June 2017. Without further upgrades or support, Discoverer can become prey to bugs, end up incompatible with web browsers, and even worse, represent an all-out security risk for your company. It’s time to find an Oracle Discoverer Replacement.
3rd party solutions promise compatibility with your Oracle stack, but they also represent an additional application layer to deal with for your IT team. Oracle’s recommended OAS (Oracle Analytics Server) does not fit into everybody’s budget, and might be out of your reach. And while it has many advantages, it’s not built to be a transactional reporting tool for day-to-day ad hoc analysis or easy drilling into data details.
There is an alternative!
APEX is Oracle’s native low-code-for-the-enterprise development platform. It enables fast migration of your Discoverer reports into a user-friendly, web-based environment. It is fully supported by Oracle and can quickly provide realtime interactive reporting while integrating perfectly with Oracle’s software suite.
Oracle APEX‘s database-driven processes and simple integration with REST enabled services ensures your migrated reports will be:
Most 3rd party software a significant monthly fee per report or per user. Not so with Oracle APEX. This no-cost option of the Oracle database is already covered under your database license and allows you to build an unlimited amount of reports for an unlimited amount of end-users, with zero licensing costs.
Oracle APEX is the perfect Discoverer replacement for organizations using Oracle E-Business Suite (EBS). As it sits in the Oracle database, its data security and function security are handled using standard EBS functionality. All reports can be accessed through the standard EBS menus.
While it has many advantages, OAS is not built to be a transactional reporting tool for day-to-day ad hoc analysis or easy drilling into data details. If you have little need or budget for the advanced BI, OLAP and data-warehouse capabilities of OAS, you might want to consider leveraging the much simpler but feature-rich interactive capabilities of Oracle APEX.
We don’t just convert SQL Queries. Insum accelerates your Discoverer migration by converting Discoverer Workbooks to APEX using our Discoverer Migrator automation tool. This can save your organization thousands of dollars compared to manually converting each workbook.
The process begins with our Discoverer Migrator tool, which extracts the structure of your Discoverer reports (workbooks and worksheets).
Each individual Discoverer worksheet (report) is converted from the extracted Discoverer file into an APEX page containing an interactive report
An operator reviews the conversions and validates the results and accuracy of the converted reports.
Responsibility security via Handshake for EBS or workbook user security assignments
With APEX, we create a new page for each Discoverer worksheet in your workbooks.
Reports can be easily accessed from the APEX-Discoverer Home Page, or directly from EBS Navigation for Oracle E-Business Suite organizations.
Reporting, data visualizations, and accurate business domain metrics are essential to quickly pinpointing the business issues you need to focus on. With APEX running your favorite reports, your organization will benefit from greater functionality:
Once you convert your reports through our automated migration process, you’ll be able to: