Skip Headers

Oracle® Argus Mart Installation Guide Release 1.0 Part Number E38590-01 |
Home | Book List | Contents | Index | Contact Us

Previous | Next
| View PDF

# 4 Creating Multiple Enterprises in Multi-tenant Environment

When you run ETL to transfer data from the Argus Safety database to AM, a default enterprise is automatically migrated to AM. In addition to the default enterprise, AM also enables you to create multiple enterprises using the configuration of default enterprise or any other enterprise that you have already created in AM. However, these enterprises, which you want to create in AM, must also be present in the Argus Safety database.

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

   This displays the Argus Mart Enterprise Creation Screen as shown in the following figure:

   Figure 4-2 Entering TNS Name to Connect to Database

2. Specify the TNS Name to connect to the AM database in the Enter the TNS name to connect to the AM database field and press Enter. This displays the following text on the command screen:

   Figure 4-3 Entering Argus ETL User

3. Enter the AM database Owner with the administrator rights for the ETL process (referred to as Argus ETL User in the Creating a New Database Schema for AM section) in the Enter Argus ETL User field and press Enter. This displays the following text on the command screen:

   Figure 4-4 Entering Password for Argus ETL User

   If the user is not the database owner with the administrator rights for the ETL process, the system displays an error message.

4. Enter the password for the AM database Owner for the ETL process in the Enter Password for User field and press Enter. This displays the following text on the command screen:

   Figure 4-5 Entering Enterprise Names

5. Enter the name of the enterprises, which you want to create in AM, in the Enter comma separated enterprise short names field and press Enter. If you enter multiple values in this field, they must be separated by a comma. This displays the following text on the command screen:

   Figure 4-6 Entering Source Enterprise Name

6. Enter the Source Enterprise name using which you want to create new enterprises in the Enter source enterprise short name for copying data field and press Enter. If there is no input to this field, the Default Enterprise, imported from the Argus Safety database during the import process, is considered as the Source Enterprise. This displays the following text on the command screen:

   Figure 4-7 Entering Log File Name

7. Enter the name of the log file in the Enter log file name field and press Enter. The system displays a Connecting status message and once connected displays Connected, as shown in the following figure:

   Figure 4-8 Connecting to the Database

   The system also validates that the AM 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, the system displays an error message.

   Once done, the system starts verifying the status of enterprises created in Argus Safety and AM. The Enterprise Names that you have entered in Step 5 must already be there in the Argus Safety database and should not be already created in AM.

   The system displays the name of the enterprises that exist in Argus Safety, the enterprises that already exist in AM, and the enterprises that will be created in AM, as shown in the following figure:

   Figure 4-9 Displaying List of Enterprises to be Created in AM

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

   Once done, the system displays the names of the enterprises that have been created successfully along with the name of the log file, as shown in the following figure:

   Figure 4-10 Displaying Enterprise Creation Confirmation

8. Press Enter to exit from the window.