On the Frontend host user need to modify
dojoviews.xml to reference each DB instance from the Global which is in the server.xml
Linux Path: <APG_Base>/Web-Servers/Tomcat/Default/conf/Catalina/localhost/dojoviews.xml
Example:
<?xml version="1.0" encoding="UTF-8"?>
<Context reloadable="false">
<ResourceLink name="jdbc/master" global="jdbc/master" type="javax.sql.DataSource"/>
<ResourceLink name="jdbc/APG-DB1" global="jdbc/APG-DB1" type="javax.sql.DataSource"/>
<ResourceLink name="jdbc/APG-DB2" global="jdbc/APG-DB2" type="javax.sql.DataSource"/>
<ResourceLink name="jdbc/APG-DB3" global="jdbc/APG-DB3" type="javax.sql.DataSource"/>
<ResourceLink name="jdbc/APG-DB4" global="jdbc/APG-DB4" type="javax.sql.DataSource"/>
</Context>
Restart Tomcat.