Skip to Content
author's profile photo Former Member
Former Member

BPM: Retrieving info utilizing a JDBC in my BPM process

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on May 29, 2007 at 03:10 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 29, 2007 at 03:09 PM

    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>

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 29, 2007 at 03:23 PM

    Thanks for the response. I will make the changes.

    Audra

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.