Home Discussions Questions & Answers Oracle Discoverer Replacement Strategy

Oracle Discoverer Replacement Strategy

Avatar photoCustomer August 23, 2021 at 1:28 am

We are facing end-of-life concerns with Oracle Discoverer 11g and need a replacement strategy. We have heard Blitz Report offers automated migration. How comprehensive is this automated process for importing existing Discoverer worksheets and their underlying metadata?

Viewing 4 reply threads
  • Author
    Replies
    • Support August 24, 2021 at 4:58 pm  

      Blitz Report offers fully automated Discoverer migration functionality, as noted in recent feature updates. This feature allows for the direct import of Discoverer worksheets into the Blitz Report application, streamlining the transition.

    • Avatar photoCustomer August 26, 2021 at 11:19 am  

      That sounds promising. What input files or formats are required to initiate the migration of these worksheets? Do we need access to the original Discoverer Business Areas or folders?

    • Support August 27, 2021 at 8:35 am  

      The migration functionality focuses on importing the existing worksheets. You would use the ‘Oracle Discoverer replacement – importing worksheets into Blitz Report™’ functionality. While the specific technical format isn’t detailed here, the tool handles the complexity of replacing Discoverer by importing these worksheet definitions, which typically include the SQL logic derived from the Business Areas and folders.

    • Avatar photoCustomer August 28, 2021 at 3:55 pm  

      We are also concerned about older Discoverer versions. For instance, does Discoverer 11g still integrate properly with modern Oracle Database versions, specifically 19c? This affects our timeline regardless of migration.

    • Support August 30, 2021 at 2:03 pm  

      That is a valid concern, as older tools face compatibility issues. Based on recent discussions, even when trying to use Oracle Discoverer 11g with Oracle Database 19c, users sometimes encounter authentication protocol errors, indicating compatibility challenges with the Desktop version 11.1.1.7. Blitz Report eliminates this dependency by providing a modern, integrated EBS reporting mechanism.

Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with: