Design Question - BPM and dynamic JDBC adapters

37 Views

Hello,

I need help to finish my scenario.

scenario:

step1 : Idoc ~~> PI(7.1) <~~ > JDBC stored procedure call

step2: If the Sync. JDBC call is successful then make a sync. BAPI call to R/3.

step3: If JDBC all fails ( in step 1 ) it should tigger an emial and do not make BAPI call ( do not execute step 2).

I have 200 SQL servers and each time IDOC goes to any one of these 200 servers ( yes, only one server ) , depending on the connection parameters in one of the idoc segment.

Questions:

1. Can we do this without BPM?

2. can we configure dynamic JDBC adapte depending on the login credentials in IDOC ( server name, port, user name , passwore).

3. If dynamic JDBC adapter configuration is not possible, what should be my design. Do i need to create 200 communication channels and 200 rec. determination, 200 interface determination, 200 receiver agreement..I dont think this is a good design