4 Creating Multiple Enterprises in Multi-tenant Environment

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

• The configuration of default enterprise.

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

This chapter explains the step-by-step procedure that you need to execute to create multiple enterprises in 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.

The following figure depicts your progress in the complete installation process:

Figure 4-1 Installation Progress: Creating Multiple Enterprises in Multi-tenant Environment

To create multiple enterprises in Argus Mart, execute the following steps:

1. Double-click the am_create_enterprise.bat file located at the following path:

   ...\ArgusMart\Database\Utils\am_create_enterprise.bat

   The Argus Mart Enterprise Creation screen appears.

   Figure 4-2 Entering TNS Name to Connect to Database

   
   

2. In the Enter the TNS name to connect to the AM database field, enter the TNS name to connect to the Argus Mart database, and press Enter.

3. Enter the following parameters for the user who have administrator rights to access the ETL process.

   
   

   Note: This user is referred to as Argus ETL User in the Section 3.4.3, "Creating a New Database Schema for Argus Mart". If the user is not the database owner with the administrator rights for the ETL process, an error message appears.

   
   

   1. In the Enter Argus ETL User field, enter the Argus Mart Database Owner, and press Enter.

   2. In the Enter Password for User field, enter the password, and press Enter.

   3. In the Enter comma separated enterprise short names field, enter the name of the enterprises, which you want to create in Argus Mart, and press Enter.

      You may enter multiple values in this field, separated by a comma.

   4. In the Enter source enterprise short name for copying data field, enter the source enterprise name using which you want to create new enterprises, and press Enter.

      If there is no input in this field, the Default Enterprise, configured during initial schema creation is considered as the source enterprise.

   5. In the Enter log file name field, enter the name of the log file, and press Enter.

      If there is no input in this field, the Default Log file, am_create_enterprise.log will be created.

      After entering all the above parameters, a status message appears.

      Figure 4-3 Connecting to the Database

      
      

      The system validates that the Argus Mart database is a multi-tenant database, which supports creation of multiple enterprises and the factory data has already been loaded to the database. If any of these requirements are not met, an error message appears.

      Once done, the system verifies the status of enterprises created in Argus Safety and Argus Mart. The Enterprise Names that you have entered in Step 3c must exist in the Argus Safety database and should not be already created in Argus Mart.

      After validation and verification, the name of the enterprises that exist in Argus Safety, and the enterprises that will be created in Argus Mart appears.

      Figure 4-4 Displaying List of Enterprises to be Created in Argus Mart

      
      

      After displaying the final list of enterprises that will be created in Argus Mart, the data is inserted into the tables referring the Source Enterprise.

      Once done, the names of the enterprises that have been created successfully appears along with the name of the log file.

      Figure 4-5 Displaying Enterprise Creation Confirmation

      
      

4. Press Enter to exit from the screen.