I need help to finish my 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.
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