Displays the database information for the plant structure. Different options display on this tab depending on the Database type you selected when you created the plant structure and, if using Workshare, whether the plant is a host or satellite.
Database type
Displays the database type used by this plant structure.
Oracle service / alias
Displays the name of the Oracle net service alias that you are using for this plant structure. This option appears only if Oracle is selected as the database type.
Database server
Displays the node name of the server on which the SQL Server database used by the plant resides. This option appears only if SQL Server is selected as the database type.
Database name
Displays the name of the SQL Server database where the plant schemas are located. This option appears only if SQL Server is selected as the database type.
Plant schema username
Displays the plant schema user name.
Plant data dictionary username
Displays the data dictionary user name used by the plant structure.
Replication schema username
Displays only for plant structures at a connected satellite site.
System user
Displays the database system user name specified during plant creation. You can change this value as needed. This name does not have to be the database administrator user name, but this user must have minimum DBA privileges to be able to perform Smart Engineering Manager procedures. See Create Oracle Admin Users with Limited Privileges and Create SQL Server Admin Users with Limited Privileges.
System password
Displays the system user password. You can change this value as needed. Oracle system passwords cannot contain any special characters other than: @ ('at' symbol), . (period), and _ (underscore). SQL Server database passwords cannot contain the character: '.