Home › Discussions › Questions & Answers › Seamless Oracle Discoverer Migration: Blitz Report Automated Worksheet Import Utility

Seamless Oracle Discoverer Migration: Blitz Report Automated Worksheet Import Utility

Avatar photoCustomer Questions & Answers 6 replies

With Oracle officially desupporting Discoverer, we face the immense task of migrating hundreds of complex worksheets that are critical for our business operations. We require an efficient and reliable Discoverer replacement solution capable of automatically importing the underlying worksheet SQLs, along with associated parameters and Lists of Values (LOVs), to minimize manual rework. Can the Blitz Report import utility handle this mass migration accurately and quickly?

6 replies

  • Support Enginatics

    Yes, Blitz Report was developed specifically to serve as a comprehensive Oracle Discoverer replacement, featuring automated functionality for importing Discoverer worksheets. The Blitz Report’s Discoverer report import capability automatically migrates the worksheet SQLs, including parameters and LOVs, ensuring crucial report logic is preserved.

  • Avatar photoCustomer

    We need to analyze our existing Discoverer usage first. Are there diagnostic tools available to help us prioritize which reports to migrate based on activity?

  • Support Enginatics

    We highly recommend starting with the analytical reports available in the Blitz Report library, such as ‘DIS Worksheet Execution History’. This report provides worksheet access statistics, allowing you to prioritize migration efforts based on which reports have been recently accessed or frequently run.

  • Avatar photoCustomer

    How is the actual import performed for a high volume of reports?

  • Support Enginatics

    For mass migration, you can utilize the Blitz Report API by running a single SQL script from a tool like SQL Developer. This process is highly efficient, capable of migrating roughly 1,000 reports in about 10 minutes.

  • Support Enginatics

    Once imported, the reports run through the standard concurrent manager, delivering beautifully formatted Excel output instantly, completing your move away from the desupported Discoverer platform.

  • You must be logged in to reply to this post.