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

5 replies

  • Support Enginatics

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

  • What unique identifier is required for this API?

  • Support Enginatics

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

  • 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 Enginatics

    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.

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