05-30-2016 11:01 AM
The mid-tier's not my strongest area, so thought I'd throw a design issue out for feedback:
Mid-tier configuration assumption (please confirm or verify): a mid-tier SAS web app (e.g, SASServern_1) uses a shared/fixed JDBC connection to access RDBMS data, therefore all users running the SAS web app will share the common JDBC connection ID to the data.
Issue: Internal regulatory powers-that-be of the data insist that different business groups cannot share the one common JDBC ID.
Solution/Question #1: Can the settings for the JVM be configured to conditionally set the JDBC ID to be group-dependant? (Not sure how..)
Solution/Question #2: The web app could be vertically clustered, in which case, could each instance be configured to use a different JDBC ID, and also configured to ensure each group only uses their specific instance?
Thanks in advance.
05-30-2016 12:33 PM
05-31-2016 02:50 AM
Hey, Juan - thanks for the response.
Thanks for the clarification re web application level, not web application server level - quite correct.
I'd still like to quiz the admins about vertical clustering (which is possible - horizontal and vertical clustering is one of the topics I cover when teaching SAS Administration), but although I've set up and used horizontal clustering in the past, I haven't set up vertical clustering - plus this requirement would mean they're not identically configured (different JDBC IDs).
I'm actually working with an installation team from SAS here - this was one solutions we considered, so we thought we'd throw it out here for commentary.