BPM: Retrieving info utilizing a JDBC in my BPM process

[Former Member]

I receive an IDOC from R/3 which I want to evaluate and send to a third party system(RNIF adapter). Upon receiving the message I transform the data and then attempt to send the required fields through a JDBC adapter to retrieve needed information from a SQL database. This information will then be used to determine what leg of the BPM process it will travel.

My issue is how to configure the send step for connecting to the SQL database using a JDBC adapter.

Mode: Synchronous

Interface: mi_read_sql_abstract

Request_Messsage: cwf_select

Response Message: cwf_info

Receiver From: Send Context

How do I setup the Receiver Determination and Receiver Agreement in the Directory so the process can connect to the database and send the response message? Both, cwf_select and cwf_info, point to Message Interfaces that are defined as Abstract Asynchronous.

Thanks,

Audra

[justin_santhanam · Accepted solution]

Audra,

Receiver determination :

Sender Service :BPM

Sender Interface: Synchronous interface

Configured receivers : target business system[SQL]

Interface Determination:

Sender Service : BPM

Sender Interface :Synch interface

Receiver service:target business system[SQL]

Inbound Interface :Synch interface

Receiver agreement:

Sender Service : BPM

receiver servcie:target business system[SQL]

receiver interface:Synch interface

receiver communication channel : receiver jdbc adapter

Best Regards,

raj.

[Former Member]

Thanks for the response. I will make the changes.

Audra

[MichalKrawczyk]

hi,

you need to do a sync JDBC step (just like any other sync send step from a BPM)

it's nothing special (except the data format for JDBC)

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>