Home Discussions Questions & Answers API for Polaris RWB Report Migration

API for Polaris RWB Report Migration

Avatar photoCustomer January 7, 2021 at 9:06 pm

We need to execute a mass migration of Polaris Reporting Workbench reports. Which specific PLSQL procedure should we utilize, and does this process include consolidation?

Viewing 2 reply threads
  • Author
    Replies
    • Support January 8, 2021 at 9:38 am  

      You should use the procedure `xxen_api.import_reporting_workbench`. The import process consolidates different RWB reports that are based on the same database views into single Blitz Reports, with specific column selections imported as templates.

    • Avatar photoCustomer January 9, 2021 at 1:26 pm  

      If we need to re-run the import, is there a simple way to clean up the existing Polaris reports?

    • Support January 11, 2021 at 1:08 am  

      Yes, you can use the script `mass_delete_polaris_reporting_workbench_reports.sql` to remove all previously imported RWB reports before attempting a re-import.

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

Login with: