Configure the database connection for additional schemes

Assign tenant to database schema

During the setup process you have created an empty Oracle or Microsoft SQL schema for an additional tenant (see ARIS Server Installation Guide). Additionally created tenants must be assigned to the database schema.

  1. Start ARIS Cloud Controller (ACC).
  2. To discover the database service ID (<dbserviceID>, such as db000000000), enter:

    list external services

    assign tenant <tenant name> to service <dbserviceID> com.aris.cip.db.schema =<schema name>

    For tenant names please only use up to 25 lowercase ASCII characters and numbers. The name must begin with a character. Special characters, such as _ and characters, for example, in Chinese, Cyrillic or Arabic cannot be used.

  3. To create a new tenant, enter:

    create tenant <tenant name>

The new tenant is available on ARIS Server.

Additional Settings

To enable validationQuery for external database connections (Oracle & Microsoft SQL) please use the correct validation query for the DBMS.

For Oracle use:

validationQuery="select 1 from dual" and testOnBorrow=true

For Microsoft SQL use:

validationQuery="select 1" and testOnBorrow=true

For better readability, the parameters of the command are shown with line-wraps. For execution you must enter a single-line command.

During registration of external service add parameters, for example, for Oracle:

register external service db url="jdbc:oracle:thin:@<target_host>:<target_port>:<oracle_sid>"

driverClassName="oracle.jdbc.OracleDriver"

username="<cip_app_user>

password="<cip_app_pwd>"

maxIdle=15

maxActive=100

maxWait=10000

removeAbandoned=false

removeAbandonedTimeout=600

defaultAutoCommit=false

rollbackOnReturn=true

host=<target_host>

port=<target_port>

jmxEnabled=true

validationQuery="select 1 from dual"

testOnBorrow="true"

After the external service was already registered, for example, for Oracle:

update external service <dbserviceID> url="jdbc:oracle:thin:@<target_host>:<target_port>:<oracle_sid>"

driverClassName="oracle.jdbc.OracleDriver"

username="<cip_app_user>"

password="<cip_app_pwd>"

maxIdle=15

maxActive=100

maxWait=10000

removeAbandoned=false

removeAbandonedTimeout=600

defaultAutoCommit=false

rollbackOnReturn=true

host=<target_host>

jmxEnabled=true

validationQuery="select 1 from dual"

testOnBorrow="true"

Enable validationQuery for external PostGreSQL connection

  1. Enter: stopall
  2. Enter: reconfigure <postgres_runnable> dbsp.validationQuery="select 1" dbsp.testOnBurrow=true
  3. Enter: startall

The database connection is configured.