BPM JDBC?

[Former Member]

Someone can provide me some general guidelines on how to use JDBC from a BPM in order to retrieve some data and continue with the BPM process.

[Former Member · Accepted solution]

How can I do a SELECT WHERE statement with the Reciever JDBC?

[Former Member · Accepted solution]

Please check the following link in SAP help,

it has got pretty elaborate explanations.<a href="http://help.sap.com/saphelp_nw04/helpdata/en/0b/9a50465ccf84479e39a6d50c90fb3f/frameset.htm">Document Formats for the Receiver JDBC Adapter</a>

[Former Member]

I have a Sender JDBC that sends data every 2 min to a BPM, this is the start, then the BPM must via JDBC retrieve some data using data from the initial message, then the process continues.

[Former Member]

Ruben..

In the BPM,

1) you will receive step to receive into abstract interface

2)an synch step where you can call the JDBC receiver and get back your output

3) asynch step to send the outputfrom JDbc to your output

[moorthy]

Hi Ruben,

Is your Scenario is JDBC->XI->Target system ?

I think, it is better if you tell entire scenario.

Anyway, you can have these steps in the BPM, to receive the message and send the message to target system

1) Receive Step

2) Send Step

In the Receive step, you need to receive the data from the JDBC adapter.

Regards,

Moorthy