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 Questions & Answers 5 replies

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?

5 replies

  • Support Enginatics

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

  • What is the required input parameter for this API?

  • Support Enginatics

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

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

  • Support Enginatics

    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.

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