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.
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.
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
The database connection is configured.