This is a job for JCA for sure, and you don't need a setup with 165 deployments - that is wrong :)
It should be modelled using a ConnectionRequestInfo object with the account information, one resource adapter for the whole thing.
Take a look at our code generator - http://docs.jboss.org/ironjacamar/userguide/1.0/en-US/html/codegenerator.html - to get started; "Use CCI" should be N ! And of course <security><application/></security>.