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.
Start ARIS Cloud Controller (ACC) and establish a connection.
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.
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
Enter: stopall
Enter: reconfigure <postgres_runnable> dbsp.validationQuery="select 1" dbsp.testOnBurrow=true
Enter: startall
The database connection is configured.