Home Discussions Questions & Answers API for Mass Import of Enterprise Command Center (ECC) Datasets

API for Mass Import of Enterprise Command Center (ECC) Datasets

Avatar photoCustomer October 21, 2019 at 7:30 pm

We need to integrate our ECC dataset queries into Blitz Report for larger extracts. Is there a mass import API available for ECC data sets?

Viewing 4 reply threads
  • Author
    Replies
    • Support October 23, 2019 at 12:28 am  

      Yes, you can use the API procedure **`xxen_api.import_ecc_dataset`** to programmatically import ECC dataset queries.

    • Avatar photoCustomer October 23, 2019 at 5:51 pm  

      What is the required input parameter for this API?

    • Support October 23, 2019 at 9:11 pm  

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

    • Avatar photoCustomer October 25, 2019 at 12:11 pm  

      If we upgrade our command centers, is there a clean way to refresh the imported reports?

    • Support October 25, 2019 at 11:40 pm  

      Yes, if you upgrade command centers, you should run 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: