Home Discussions Questions & Answers API for Mass Import of ECC Dataset Queries

API for Mass Import of ECC Dataset Queries

Avatar photoCustomer November 27, 2021 at 6:57 pm

We need to migrate our ECC dataset queries to Blitz Report for accessing larger data extracts. What PLSQL API procedure handles this migration?

Viewing 4 reply threads
  • Author
    Replies
    • Support November 28, 2021 at 2:54 am  

      You can use the procedure `xxen_api.import_ecc_dataset`. This allows programmatic importing of ECC dataset queries.

    • Avatar photoCustomer November 29, 2021 at 4:02 am  

      What unique identifier is required for this API?

    • Support November 29, 2021 at 10:22 pm  

      The required input parameter is the `p_dataset_key` (varchar2), which identifies the specific ECC dataset you wish to import.

    • Avatar photoCustomer November 30, 2021 at 9:00 pm  

      If we upgrade our Command Centers, what script should we run to clean up old ECC Blitz Reports before re-importing the new queries?

    • Support December 2, 2021 at 8:21 pm  

      If you upgrade command centers, you can use the script `mass_delete_ecc_reports.sql` to remove all previously imported ECC Blitz Reports before re-importing Oracle’s latest dataset queries.

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

Login with: