JDBC to IDOC scenario

[Former Member]

Hello,  I am working on a JDBC to IDOC scenario where we are fetching the data from a database and we need to take a part of this data for an RFC call and once we get the response data from the RFC ,we need to merge the data we obtained from the JDBC and RFC and need to send vis an IDOC.  Could anyone please help in the design? I mean,how many message type and message interfaces do we need to create? is it possible without BPM?if with BPM then how we can implement in BPM? and if not then how?  Thanks for your help in advance !!  Regards,  Sambaran

[former_member184720 · Accepted solution]

Hi Sambaran,

Yes. I don't think you need to have the BPM. What is your PI version??

Develop all the objects considering that your scenario is simple

JDBC-IDOC.

In the message mapping, you can RFC look up option to get the response and use it in the mapping.

Please refer to the below document to know more about RFC look up.

http://scn.sap.com/docs/DOC-3805

Regards,

Hareesh

[Former Member]

Hello,  I think you have misunderstood the requirement.  I need to fetch the data from the database and one part of this data will call an rfc and fetch the data from ECC.Now the I need to merge the another part of the data fetched from jdbc with the fetched data from ECC and need to send it via idoc to ECC.  Once ECC save this data,it will send an status idoc which need to be registered in the database system as well.  My idea is :  1. JDBC Request 1 ---> RFC request  2. JDBC Request 2 + RFC response --- > IDOC  Is it ok as mapping?  Thanks for your help in advance !!  Regards,  Sambaran

[former_member184720]

Still a bit unclear..

when you say JDBC request 1 and JDBC request 2..are they two independent messages in XI or part of the same message ?

If it is a single message and part of this message will have to call an RFC, then as i said

in your mapping, using RFC look up - you can send part of this data to execute RFC and get the response back.

you'll have other part of the JDBC message and RFC response with you to create an IDOC in ECC.

Regards

Hareesh

[ambrish_mishra]

Hi Sambaran,

I have understood your requirement and have replied already. You can do 2 step mapping. To elaborate a bit more, You make the database call to first read the data, in first graphical mapping, make an RFC call to ECC and get the data back from ECC and populate an intermediate structure with enriched data. Then in second graphical mapping, map the data in intermediate structure to the target IDoc structure and post the IDoc in ECC.

Take care of performance issues, like I have suggested in the earlier post.

For the return leg where you need to post the data back to the database, you should treat this as another interface since IDoc communication is asynchronous.

For this, get the response IDoc from ECC and simply map it to target JDBC structure.

Hope it helps!

Ambrish

Message was edited by: Ambrish Mishra

[ambrish_mishra]

Hi Sambaran.

This is a simple scenario if you are on PI 7.1. When you are making the RFC call ( most probably for retrieving data from ECC ) make sure you pass the data in a table and retrieve it similarly. This will avoid performance issues and you will be able to retrieve the data in a single RFC call.

You will make the RFC call in the graphical mapping while mapping to the IDoc or to simplify, have 2 graphical mappings, one where you enrich the data through RFC call and another for mapping to the IDoc.

Raj has already suggested on the design objects.

Ambrish

[Former Member]

Hi Sambaran,

please check the following threads for your scenario:

https://scn.sap.com/thread/419249‎

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d09cb520-f883-2c10-56b9-adb6d9182...

hope this helps

[rajasekhar_reddy14]

Hi Sambaran,

As Hareesh mentioned you could try using JDBC----->rfclookup----->IDoc scenario.

If your lookup logic complicated then using RFC lookup not right idea,in this case i would prefer handling requirement in ECCMdevelop standard scenario JDBC---->pi-->(Proxy),in proxy implement RFC lookup logic before psoting document.

You need to create one data type/message type/Service interface/Message mapping/Operation mapping.

Search in scn.

Regards,

Raj