3 Create Multiple Enterprises in Multi-tenant Environment

When you run ETL to transfer data from the Oracle Argus Safety database to Oracle Argus Mart, a default enterprise is automatically fetched into Oracle Argus Mart. In addition to the default enterprise, Oracle Argus Mart also enables you to create multiple enterprises by using:

• The configuration of default enterprise.
• The configuration of any other existing enterprise in Oracle Argus Safety Database.

This chapter explains the step-by-step procedure that you need to execute to create multiple enterprises in Oracle Argus Mart in a multi-tenant environment.

Note:

In case of a Multi-tenant setup, you can create additional enterprises after initial or incremental ETL as well.

To create multiple enterprises in Oracle Argus Mart:

1. Fetch a new enterprise from Oracle Argus Safety to Oracle Argus Mart by executing the script from:

   DBInstaller\Utilities\create_enterprise

   • For Windows—execute the batch script am_create_enterprise.bat
   • For Linux—execute the shell script am_create_enterprise
2. When prompted, enter the following parameters:
   • Enter the Oracle Argus Mart Database instance
   • Enter the name of ETL User in the above instance, like AM_ETL_USER
   • Enter Password for ETL User in the above instance
   • Enter comma separated enterprise short names to be copied over from Oracle Argus Safety, like ENT1,ENT2,ENT3
   • Enter the enterprise short name in Oracle Argus Mart, from which data is to be copied, like ENT_ABBREV

   Note that the Default enterprise in Oracle Argus Mart will be used to copy the base values, if no use input is provided.

3. Before bringing over the new enterprise to Oracle Argus Mart, the following checks are performed, whether:
   • the set-up is multi-tenant
   • the Factory data is loaded in the specified Oracle Argus Mart database
   • the new enterprise exists in Oracle Argus Safety
   • the new enterprise does not already exist in Oracle Argus Mart
   • the base enterprise from which data is to be copied over, exists in Oracle Argus Mart

   When all these Prerequisites are satisfied, the process of enterprise addition into Oracle Argus Mart begins.

4. Review the following log file, and check for any errors, when a confirmation message appears.

   \DBInstaller\Utilities\create_enterprise\am_create_enterprise_MMDDYYYY_HH24MISS.log.