Connection Pool & Connection Limit for SAP MDM 5.5 SP06 using MDM Java APIs

[Former Member]

Hello Experts,

We use both SAP Portal and Data Manager for managing data in MDM. We use PI for syndicating data to downstream systems. The java maps in PI also access data from MDM using the MDM Java APIs for some business validations and additional data fetch.

Because of all these, a huge number of connection get created while accessing MDM.

Is there a way to define a connection pool for MDM using which Portal and PI may connect to MDM. Also, is it possible to define a limit on the number of connections that can be created at a given time?

Thanks a lot in Advance.

Regards,

Uday

P.S. We are currently running MDM Build 5.5.63.73 and planning to upgrade to 5.5.65.98 soon.

[Former Member]

Hello Uday

You can do connection monitoring from your Java API application

You can set some parameters in mds.ini file:

DBMS Reconnection Attempts

Inactive Client Timeout Minutes

Client Ping Timeout Minutes

More about that parameters you can read from "MDM Console Reference guide" page 322

https://websmp201.sap-ag.de/~sapidb/011000358700006291622006E

Regards

Kanstantsin Chernichenka