Home › Discussions › Questions & Answers › PLSQL API for Mass Importing BI Publisher Reports

PLSQL API for Mass Importing BI Publisher Reports

Avatar photoCustomer Questions & Answers 5 replies

We have hundreds of BI Publisher reports we need to migrate. Is there a PLSQL procedure for mass importing them, and what type of BI Publisher reports are supported?

5 replies

  • Support Enginatics

    You can use the PLSQL procedure `xxen_api.import_concurrent_program`. This procedure is specifically used for migrating BI Publisher reports that are registered as the Java executable type `XDODTEXE` (XML Publisher Data Template Executable).

  • Avatar photoCustomer

    What information does the API require to identify the BI Publisher report?

  • Support Enginatics

    The procedure requires the application short name (`p_application_short_name`) and the concurrent program name (`p_concurrent_program_name`) associated with the BI Publisher report.

  • Avatar photoCustomer

    If a BI Publisher data source has multiple SQL queries, what happens during the import?

  • Support Enginatics

    If the data source contains more than one SQL query, only the largest one is imported, potentially requiring additional manual work to combine the data afterward.

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