Create AVEVA Enterprise Resource Management Application Database Schemas

AVEVA Enterprise Resource Management uses the following schemas by default:

• AVEVA Enterprise Resource Management application schema for all the AVEVA Enterprise Resource Management database schema objects delivered by AVEVA, for example, tables, views, stored procedures.

• AVEVA Enterprise Resource Management Custom schema for all custom developed database objects, for example, view for auxiliary data in screens or reports. On AVEVA Enterprise Resource Management 19.x on premise installations it is possible to install both the AVEVA Enterprise Resource Management application schema objects and the custom develop database objects in the AVEVA Enterprise Resource Management application schema. You cannot upgrade to future major versions of AVEVA Enterprise Resource Management if the database objects that are not delivered by AVEVA exists in the AVEVA Enterprise Resource Management application schema. Therefore, the joined schema is not recommended.

• Database enhancements (database tables, views, packages) required by the customer for specific needs not implemented in AVEVA Enterprise Resource Management or which can not be implemented via APIs must be defined in the AVEVA Enterprise Resource Management Custom schema.

Access rights to the AVEVA Enterprise Resource Management schema objects are granted between the schemas and the AVEVA Enterprise Resource Management user roles as follows:

• From AVEVA Enterprise Resource Management, schema objects are granted directly to the Custom schema with select rights only to create, for example custom views based on the AVEVA Enterprise Resource Management schema objects.

• From AVEVA Enterprise Resource Management, schema objects are granted to the AVEVA Enterprise Resource Management user roles with select, insert, update and delete rights. You can enable the AVEVA Enterprise Resource Management user role with a password.

• AVEVA Enterprise Resource Management user role is granted to the Custom database schema and is made available by AVEVA Enterprise Resource ManagementA application server when establishing a session to Custom database schema.

To create a new AVEVA Enterprise Resource Management application schema

1. To start AVEVA Enterprise Resource Management deployment manager, in the AVEVA Enterprise Resource Management installation package, from the DeploymentManager folder, below the InstallTools, run Aveva.Erm.DeploymentManager.exe.

   The AVEVA ERM Deployment Manager 1.3.0.0 dialog appears.

2. Select Create Database Schema.

   

   The Create Database Schema window appears.

   

3. Enter the relevant details in the fields as required.

   Field	Description
   ERM Admin Password	The password of the ERMADMIN user as defined in the Initialize Database process.
   TNS Alias / EZ Connect	The TNS Alias of the database. You can view the TNS Alias in the tnsnames.ora file in the Oracle client. The value in the TNS Alias / EZ Connect field is also an EZCONNECT string (<host>:<port>/<service-name>).
   Schema Name	The ID of the new application database schema. The ID is maximum of 20 characters. The valid characters are alphanumeric characters and underscore.
   Schema Password	The password of the new application database schema. The valid values are alphanumeric characters and special characters.
   Custom Schema Name	The ID of the new application custom application database schema. The ID is pre-filled with the value in the Schema Name field and the value in the Custom Schema Name field is added after an underscore. The valid values are alphanumeric characters and underscore.
   Custom Schema Password	The password of the new application custom database schema. The valid values are alphanumeric characters and special characters ! ? + # ^ ~ _ - : , . .
   ERM Role Name	The name of the new application role. The ID is pre-filled with the value in the Schema Name field and the value in the ERM Role Name field is added after an underscore. The valid values are alphanumeric characters and underscore.
   ERM Role Password	The password of the new application custom database schema. The valid values are alphanumeric characters and special characters ! ? + # ^ ~ _ - : , . .

4. Select Create.

   A terminal pop-up window will appear processing the command.

   

5. When the process is complete, in the terminal, enter exit.

   The AVEVA Enterprise Resource Management application schema is created.