Skip to main content

ARIS Technical Help

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 Technical Help: ARIS server Installation - Windows or ARIS server Installation Linux). Read the documents on the ARIS Documentation website or download them from the ARIS Download Center. Additionally created tenants must be assigned to the database schema. Replace values in angle brackets, such as <tenant name> with your own values, such as new tenant1.

  1. Start ARIS Cloud Controller (ACC) and establish a connection.

  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>

      Warning

      Only use up to 25 lowercase ASCII characters and numbers for tenant names. Names must begin with a character. Special characters, such as the underscore (_), as well as characters in Chinese, Cyrillic, or Arabic, cannot be used.

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