dynamic connection parameter for JDBC receiver communication channel

[santanu_singharoy]

Hello Experts,

We have a requirement to select the business component & corresponding receiver jdbc channels using value mapping based on the plant field in the incoming xml payload. Now is this possible in PI 7.31 to create the connection paramter(server:port/db name) dynamically so that no need to create multiple jdbc receiver channels.

Thanks in advance for the help!!

[engswee · Accepted solution]

Hi Santanu

AFAIK, ASMA is not available for JDBC receiver adapter. As such, I don't think it's possible to dynamically set the connection details.

Regards

Eng Swee

[Former Member]

Hi Santanu,

Like Eng & Inaki said, you can not set dynamic JDBC connection parameters for multiple endpoints. However you can set multiple communication channel and use them for different endpoints using conditions during Receiver determination step.

Regards

Bibek

[iaki_vila]

Hi Santanu,

As Eng said SAP PI standard doesn´t support to determine dynamically in execution time the jdbc connection parameters.

The only way that i think to do it, it is to do the jdbc connection via own java mapping or own adapter module.

Regards.

[engswee]

to do the jdbc connection via own java mapping or own adapter module.

While that is possible, IMHO such a design would create unnecessary overhead during both development and support. The possibility of doing so needs to be weighed against the benefits gained from doing so.