FAQ | ennSight - Automated Oracle Discoverer Migration Tool

Discoverer Migration Assessment & Proof-of-Concept

The following deliverables are included in the assessment:

A complete list of all Discoverer reports
1. All business areas, workbooks, worksheets, files, etc.
2. The total number of reports and elements by complexity
3. The total amount of time (hours) required to migrate
4. The estimated amount of effort to migrate each report
Proof-of-Concept
1. 1 Discoverer report is converted to your platform of choice
Migration Project Plan
1. Scope
2. Milestones
3. Conversion Timelines
4. Resource Plan
5. Rationalization
6. Fixed-bid price to migrate using ennVee's services

Yes. The assessment enables us to provide the most accurate pricing and time and effort estimate. It also helps you clean up your reporting environment by identifying all duplicates and outdated reports that may have been overlooked.

We categorize reports based on the complexity of the query and two other factors:

Custom folders - e.g. if there are many custom folders that make the queries too large to handle, or complex or custom folders in use with joins and other elements.
Data volume - e.g. if report execution brings in more than 100,000 records, or the data is beyond a certain limit.

These criteria are based on the perspective of the data rather than the front end.

Business Areas are a group of folders where you restrict access to a particular user for a specific business area. You can define the business areas like Account Manager and Account Junior (who might not need all information). You can also split the business areas in half, where the manager has access to everything and the account junior only has access to a few areas. Business areas can also be segregated by module, e.g. Finance, HR, Manufacturing, etc.

Both workbooks and worksheets are extracted and displayed under a single tab, “workbooks”. We gather all information for both workbooks and sheets and convert the worksheet into a SQL file. Once all information is extracted, the worksheet information pertaining to one workbook can be consolidated into a single dashboard or to various dashboards within the target platform.

This is at the discretion of the user. Multiple worksheets within the same workbook can be combined into a single dashboard.

The process will take a few days to complete. Our team will need system access and a copy of the report, and we provide a separate document that outlines the access requirements and connectivity instructions.

No problem. The assessment only requires access to your current Discoverer environment, and we can build the Proof-of-Concept using one of our licenses to the target platform. We also offer assistance in choosing a replacement platform.

Bilateral NDA
1 development instance with access to:
- Apps and EUL
- Discoverer (Desktop or Plus)
- Oracle Database
- Target System
- Microsoft SharePoint (or equivalent to share report owner information)

Discoverer Assessment Connectivity

There are three ways we can connect to conduct the assessment: VPN, Citrix, or RDP.

View and download the connectivity instructions here.

A connection is established through ODBC connectivity, however, the same credentials are required for the parameters that were picked up initially by our tool during the assessment.

As long as an ODBC connector/driver is present, we can connect to the database without making holes into the firewall.

We initiate each engagement with a formal NDA and undergo any security policy requirements required by your organization. Data is never removed from your environment or brought into our environment. Rather, you can provide access and/or user accounts for ennVee project team members to access the data directly in your environment. This is where the assessment and migration process will be done.

Discoverer Extraction

ennSight automatically extracts the following objects from Oracle Discoverer:

Reports	Conditions
Workbooks	Joins
Worksheets	Hierarchies
Infrastructure	Classes
Folders	Business Rules
Calculations	Security
Filters	Roles

Yes. For example, if you want to add a few things to a folder, Discoverer will not give you that information. ennSight gives you additional fields in folders in case you want to tweak the reports, etc.

Yes, this can be done for an additional cost.

Discoverer Migration Process

"As-is" means the Discoverer reports are migrated without any front-end enhancements and the final output (in your target platform) will match the original layout in Discoverer.

No, the migration process is manual due to technical limitations with the target platforms that do not allow reports to be imported automatically.

Yes. We can help you migrate to the following platforms:

Microsoft: Power BI, SQL Server Reporting Services (SSRS), Power Query

Oracle: OBIEE*, APEX

Tableau, Cognos, Qlik, Pentaho, MicroStrategy*, and Open Source platforms.

*Additional time and effort is required to remediate the fact and dimensions differences.

No. The same logic is applied to all Discoverer reports and there will not be any loss of data or changes to the report logic.

Yes. Users with access to the original Discoverer reports will be provided access to the same dashboards in the target platform. In the context of migrating to a Microsoft platform (Power BI, etc.), access can be granted or shared through Microsoft SharePoint. From an Active Directory standpoint, the mapping must happen from Single Sign-On.

No, the reports do not need to be re-designed before migrating. Our team will handle the re-designing while preparing the reports in your target platform.

The connections must be reconfigured in your target platform. For Microsoft target platforms, the information can be shared via:

.PBIX (Power BI) format
Microsoft SharePoint (and then by providing access to users)
Email (and then providing direct access through Office365)

Post-Migration

We prepare the converted/migrated Discoverer reports in your target platform "as-is" and work with your team to utilize the full functionality of the platform, and enhance and design the visualizations that your users want in the reports.

Yes, we will provide two weeks of support to ensure the reports work correctly and there are no new issues. This is included in the price of the migration. We also offer future support to ensure the reports are compatible if you are upgrading to Oracle E-Business Suite R12.2.

The query is kept as-is and some manual effort is required to create the representation.

Business Intelligence Strategy and Roadmapping

This is a separate engagement that assesses your internal IT systems and Business Intelligence landscape, data sources and tools. The end result is a cohesive landscape architecture diagram of all disparate systems, star schema design, entity cataloging, and data analysis. Download the data sheet.

Contact Sales for more information.

ennVee also offers the following value-added services:

Business impact analysis
Enhancing reports and creating dashboards after migrating from Discoverer to your target platform
Assistance selecting a replacement platform for Oracle Discoverer
Post-migration support (beyond 2 weeks)
Re-converting reports after an Oracle E-Business Suite R12.2 upgrade.

Discoverer Migration Pricing

We charge a fixed price for the assessment. The cost of the assessment will be credited towards your migration project.

Contact Sales for a price estimate.

Our standard "as-is" migration is priced as a fixed-bid that can range from $10,000 to $100,000. "As-is" refers to the process of migrating the Discoverer reports without any additional enhancements to the User Interface.

Contact Sales for a price estimate.

There are two key factors that determine the cost of the migration:

Number of Reports, Workbooks, and Worksheet and complexity of the SQL
The level of effort involved is determined not only by the number of reports but the quantity of workbooks and worksheets within each report. All of this information is identified during our assessment.
Complexity
This is determined by the query complexity, custom folders, and data volume.
Target platform
Some platforms like MicroStrategy and OBIEE do not have a 1:1 equivalent for certain elements that exist in Discoverer, so the reports must be re-built from scratch. In this case, pricing will be Time & Materials or Not-to-Exceed.

Contact Sales for a price estimate.

ennSight FAQs

Explore by Category

Assessment & POC

Connectivity

Extraction

Migration

Post-Migration

Pricing

Discoverer Migration Assessment & Proof-of-Concept

Discoverer Assessment Connectivity

Discoverer Extraction

Discoverer Migration Process

Post-Migration

Discoverer Migration Pricing

How long will your Discoverer migration take?