Reg:RFC to JDBC scenario

[Former Member]

Hi All,

My actual requirement is,A project ID is being triggered to PI which will download the data from the R3 Server through a RFC call and it has to post to a database(SQL Server 2000) ,to different tables based on the project ID.

Can someone please suggest me how do this scenario.

Thanks in Advance

Lavanya.B

[Former Member · Accepted solution]

Dear Lavanya,

You can do this scenario using BPM and without BPM also.

With BPM, you can do like

1. Receive

2.Transformation (RFC Request mapping)

3.Send (Synchronous)

4.Transformation (RFC Response mapping)

5.Transformation (Insert data to Tables ,JDBC)

6.Send (JDBC)

If you want to insert the data into differt tables, i suggest you to use stored procedure in your scenario.

Regards

Leela

[Former Member · Accepted solution]

Hi ,

1. Receive

2.Transformation (RFC Request mapping)

3.Send (Synchronous)

4.Transformation (RFC Response mapping)

5.Transformation (Insert data to Tables ,JDBC)

6.Send (JDBC)

Step 4 and 5 is not required. we can configure that part in step3 . You can ignore the step 2 also. You use mapping call outside BPM.It gives u better performance.

Look at this blog for reference.

[Former Member · Accepted solution]

Hi Sekhar,

Thank u for ur suggestion.

Regards

Leela

[Former Member]

Lavanya,

For the above Scenario can I do with a RFC lookup table.ie.

--> yeah sure..

Sender = Soap Adapter

Receiver = RFC lookup

Receiver= JDBC Adapter

Please suggest me on this.

i'll prefer your approach over BPM.

Regards,

[Former Member]

Hi All,

My actual requirement is,A project ID is being triggered to PI which will download the data from the R3 Server through a RFC call and it has to post to a database(SQL Server 2000) ,to different tables based on the project ID.

For the above Scenario can I do with a RFC lookup table.ie.

Sender = Soap Adapter

Receiver = RFC lookup

Receiver= JDBC Adapter

Please suggest me on this.

Thanks in Advance

Lavanya.B

[Former Member]

We have 2 options to achieve this...

i)You have to use RFC lookups in mapping If you dont want to use BPM, .

ii)Follow the below steps if you want to use BPM.

1)Trigger the data from webservice (ProjectID) -

---

Recieves the Recieves step

2)Call synch send step - call RFC and get the response.

3)asynch send -- To send the response to the data base

[Former Member]

Hi,

you can also do RFC to JDBC scenario without BPM,

Updation of Tables based on project Id can be taken care either at the mapping level or applying Transformation rules in ur receiver determination

[prateek]

I think there would be a lot of data to be downloaded using RFC. Therefore you may opt for BPM to receiver the data in response message of RFC. Your steps would be:

Receive (to receive project ID)

Transformation (Optional)

Sync Send (RFC)

Transformation (Optional)

Async Send (JDBC)

Regards,

Prateek