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).

    ARIS Cloud Controller can be used in multiple modes.

    To start ACC under a Windows operating system click Start > All Programs > ARIS > Administration > Start ARIS Cloud Controller. If you have changed agent user credentials you must enter the user name and/or the password.

    To start ACC under a Linux operating system, execute the acc10.sh shell script instead.

  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 DB 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

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.