on 11-16-2007 3:29 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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-
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.