cancel
Showing results for 
Search instead for 
Did you mean: 

How to set Recever JDBC Comm_channel DB connection URL at runtime?

Former Member
0 Kudos

Hi,

We have PI 7.0, working on Idoc to JDBC scenario

Design:

We have created

1Recever dataType, 1Recever MessageType, 1Recever MessageInterface.

1MessageMapping, 1InterfaceMapping.

Sender is IDOC

Recever is JDBC

Configuration:

We are using 1 Recever JDBC Comm_channel using DB Connection url

jdbc:microsoft:sqlserver://serverA:1433;DatabaseName=databaseA

and created

1interface determination, 1Recever determination, 1Recever agreement.

Idoc to Xi to JDBC which uses "databaseA" which is on "serverA" which works fine.

based on incoming data parameter, Now we need to use same scenario which connect to multiple DB physical Servers like

Idoc to Xi to JDBC which uses "databaseA" which is on "serverA"

Idoc to Xi to JDBC which uses "databaseA" which is on "serverB"

Idoc to Xi to JDBC which uses "databaseA" which is on "serverC"

QUestion

How we need to set Recever JDBC Comm_channel DB connection URL at runtime?

jdbc:microsoft:sqlserver://serverA:1433;DatabaseName=databaseA

Where "serverA" determined based on Input data

Any help is much appreciated

Thank U

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi

There is no such explicit way of doing so.You can use Extended Receiver Determination as

/people/venkataramanan.parameswaran/blog/2006/03/17/illustration-of-enhanced-receiver-determination--sp16

Here you will have to create 3 receivers, 3 Communication Channels, 3 interface determinations, etc.

or provide some conditions.

Thanks.

justin_santhanam
Active Contributor
0 Kudos

Jagadish,

There is no adapter specific message attributes for JDBC adapter. If it's there then no issues , using single comm.channel we can achieve your scenario. But now you have to add some more objects to the scenario.

In Receiver Determination , give 3 configured receivers - DBA, DBB, DBC.

Then Choose the corresponding Interface determination for the three receivers and receiver agreements.

Remember you need to create 3 comm.channels for each server.

Now routing can be done based on giving conditions in the configured receivers, so that data been sent to corresponding DB.

raj.

Former Member
0 Kudos

Hi,

Your Scenario is 1:n that is 1 sender and multiple receivers....

If this is correct then need to configure Business systems and communication channels( each server) , receiver Determination, Interface Dtermination, and receiver agreement.

regards,

Mili-