I am new to Software AG webMethods. We have requirement to connect to IBM DB2 iSeries DB and it works fine to create a connection/JDBC Adapter and connect to a Schema. I am also able to fetch data from the schema (Database) fine. However the way our setup is, there is a new schema (copy of same one) per Geographic Location. This leads to a multi tenant database architecture. I do not want to create a new adapter for every query and every geographic location. Is there a way I can write single JDBC adapter pointing to one schema and reuse it across all other schemas on the Server. All schemas follow same database schema structure and separation of concerns is provided by individual schemas per Geographic location.
Please help with best architecture for this kind of connection.
Thanks in advance for the help.