MDM ConnectionPool-design required between SAP NW App server & MDM server
I have a deployable java proxy which implements the business logics using MDM Java API 5.5. to insert or modify the record in MDM repositorty, the data is send from ECC via PI 7.1.
The current design which i implemented is whenever the proxy is called a new connectionPool instance is fetched from ConnectionFactory and get the repository&user session and once the record is inserted in MDM repository i do the cleanup(i.e destroy sessions & close connection).
Since a new connection is obtained every time the performance issue occurs, i would like to whether an configuration is available to maintain/have a connectionPool in the SAP NW application server,so that only one connectionPool is obtained from that i can do the operation in MDM.This way i can reduce the performance issue.
Please pour your thoughts.