Skip to Content
avatar image
Former Member

Interface split based on the output from stored procedure

Hi Experts,

We need to develop 2 JDBC to IDOC interfaces. Based on the result of stored procedure, we have to decide to which interface, data needs to go.

We will get PacketID, PacketType when we execute the stored procedure.

If PacketType=1 need to go for interface 1

If PacketType=2 need to go for interface 2

DB team is not willing create separate SP's for both the interfaces and also they don't want to add PacketType as input parameter to SP.

At PO end, I know we can segregate this at Iflow level(interface split). But we want create seperate IFlow's.

I think we only left with adapter module. Please someone help me to create adapter module.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 17, 2017 at 03:26 PM

    Hi Tanu,

    At PO end, I know we can segregate this at Iflow level(interface split). But we want create seperate IFlow's.

    Yes you can use the PacketType as condition in interface determination and route it accordingly but why do you want to handle it via 2 different interface ? Even custom module cant help you here as the stored procedure is executed on DB end and before module execution.

    Br,

    Manoj

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Tanu,

      I really don't praise this solution but here is what you can do with 3 Iflows:

      First Iflow: JDBC--->RD(Condition on PackType)--->SOAP1(Pointing to Second Iflow) and SOAP2(Pointing to third Iflow)

      Second Iflow :SOAP1 (say PackType1)---->Actual Reciever

      Thirs Iflow :SOAP2 (say PackType2)---->Actual Reciever

      Br,

      Manoj

  • Aug 17, 2017 at 06:28 PM

    Hi Tanu!

    Frankly speaking, I don't understand and hardly can accept arguments like "... team doesn't want to ...".

    Ok, let's develop the heavy-weighted and hard to maintan integration process instead?

    Your primary task and duty in this situation is to explain to the business that required changes have to be made at source DB side.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded