Multiple Records in XI

[Former Member]

Hi Folks ,

Can you guide me in

1. Handling multiple records from source and posting one at a time into JDBC .

2. Fetching single records from JDBC and sending as a batch.

Regards,

[Former Member]

Hi Folks,

My scenario goes like this :

1. I want to pick multiple records from source and post it one at at time into JDBC.

2. I want to fetch single record from JDBC and want to send as a batch.

for both scenarios <b>i don't want to use BPM...</b>

for both scenarios <b>i don't want to use BPM...</b>

Can anybody help me to make my scenarios work in a batch processing mode as explained above without using BPM.

Points will be awarded ..:-)

Thanks and Regards,

[Former Member]

These blogs will definitely help you..if not plz let me know

jdbc sender(theory)

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

JDBC receiver

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 - File to JDBC

How to use SELECT statement in JDBC scenario's.

Ref : https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1725 [original link is broken] [original link is broken] [original link is broken]

Integration with Databases made easy – Part 1

/people/laxman.molugu/blog/2006/08/13/integration-with-databases-made-easy-150-part-1

XI : Recent Enhancements to JDBC Adapter

/people/sap.user72/blog/2006/02/22/xi-recent-enhancements-to-jdbc-adapter

JDBC Receiver Adapter -- Synchronous Select – Step by Step

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

XI: How-to on JDBC receiver response

/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response

Best Regards,

Srikanth

Reward the useful answers and you will get one point yourself

/people/baris.buyuktanir2/blog/2007/04/04/point-for-points-reward-yourself ---onepoint blog

[Former Member]

Sorry folks,

I forget to put the condition without BPM.

Regards,

[Former Member]

Hi Santosh,

Maybe this might help

Thanks.

Kiran

[Former Member]

Hi,

For 1., you can try Message splitting in BPM, and sending each record to JDBC Receiver by using a forEach Loop.

For 2. you can use a loop step in BPM, with finishing condition as count = the number of records you want to send in a single batch.

Regards,

Amitabha

[Former Member]

Hi santosh

refer the below links

http://help.sap.com/saphelp_nw04/helpdata/en/42/ed364cf8593eebe10000000a1553f7/content.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Multiple Records insertion

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Sending Multiple records

http://help.sap.com/saphelp_nw04/helpdata/en/08/16163ff8519a06e10000000a114084/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/ae/fd773f12f14a18e10000000a114084/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/62/dcef46dae42142911c8f14ca7a7c39/content.htm

just have a look may be help you

[Former Member]

Hi,

1. To handle multiple from source use BPM collect pattern and post into jdbc.

2. Use BPM multicast to send to batch.

Regards,

S.RamNarender