-
Open the file [APP_HOME]/depconfig/properties/external/config.yml in a text editor.
-
Add/modify DB connections definition like the example below.
datasources:
tenant: <db-connection name>
url: jdbc:sqlserver://SERVER1:PORT1;DatabaseName=<database name>;ApplicationName=InforEAM;LoginTimeout=300
driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
user: <user>
password: '<password>'
min-size: <min-size>
max-size: <max-size>
idle-timeout-minutes: 1
tenant: <db-connection2 name>
url: jdbc:sqlserver://SERVER2:PORT2;DatabaseName=<database2 name>;ApplicationName=InforEAM;LoginTimeout=300
driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
user: <user2>
password: '<password2>'
min-size: <min-size>
max-size: <max-size>
idle-timeout-minutes: 1-
<db-connection name> - Enter the name of the connection, which you must match with the tenant name that users provide on the login URL.
-
<url> - Enter the host name of the database server, the port number for the database server
<database name> is the name of the SQL Server construct that contains the EAM tables, not the database server name
-
<user> - Enter the user name.
-
<password> - Enter the user access password.
-
<min-size> - Enter the number of connections created during the Application Server startup.
-
<max-size> - Enter the maximum number of connections allowed per data source.
-
-
Save the file.
-
Change to directory [APP_HOME]/depconfig.
-
For JBoss on Windows run deploy.bat.
-
When the modifications are complete and the server is restarted, the URL that identifies which environment is running is http://ServerName/web/base/logindisp?tenant=<db-connection name>, where <db-connection name> would be what was set as <db-connection name> in our example above