PI Synchronus Interfaces Without BPM

[HarshC]

Hi All,

I need to do a DB Select based on values from a file and post the query response as an IDoc. Is it possible to build such an interface in PI without using a BPM?

i.e.

Step1: File -> XI (asynch sender file adapter)

Step2: XI <-> DB (synch sender jdbc?)

Step3: XI -> IDoc (IDoc)

Regards,

Harsh

[Former Member · Accepted solution]

Hi

You can avoid BPM.

do a mapping look up to query the database.

File->MaptoIDoc{Query DB Using mapping look up}-> Post IDoc.

hope the data size is not huge.

https://help.sap.com/javadocs/pi/SP3/xpi/com/sap/aii/mapping/lookup/LookupService.html

rgds

Arun

[HarshC · Accepted solution]

Hi All,

Thanks for the prompt responses. I have a few questions regarding lookup.

a. Can it be used with with both sender and receiver channels?

b. Is there a limit on the number of lookups that can be done.

My actualy scenario involves

a. File -> XI

b. XI->DB(3 Steps)

1. Stored Procedure(Aquire Lock).

2. SQL Query.

3. Stored Procedure(Release Lock).

c. XI->File

So can I perform all three together?

Thanks,

Harsh

[Former Member · Accepted solution]

yes you can.

Mapping lookup is done from UDF in mapping.

You can do n number of look ups.

ensure that data is not huge.

rgds,

Arun

[Former Member]

Hi Harsh

follow these threads for JDBC lookup

/people/jin.shin/blog/2008/02/15/sap-pi-71-mapping-enhancements-series-graphical-support-for-jdbc-and-rfc-lookups

/people/prasad.illapani/blog/2006/10/25/how-to-check-jdbc-sql-query-syntax-and-verify-the-query-results-inside-a-user-defined-function-of-the-lookup-api

/people/francesco.bersani/blog/2007/03/05/data-lookup-optimized

/people/alessandro.guarneri/blog/2006/03/27/sap-xi-lookup-api-the-killer

/people/sap.user72/blog/2005/12/06/optimizing-lookups-in-xi

/people/varadharajan.krishnasamy/blog/2007/02/27/configuring-jdbc-connector-service-to-perform-database-lookups

/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

Thanks

sandeep

If helpful kindly reward points

[Former Member]

Hi,

With out BPM you may not able to create Asynch-Synch scenario in XI. But in your case you can call synch jdbc through JDBC lookup. This will not required BPM.

Refer the following link,

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/9aedca11-0d01-0010-3b90-9ea04182...

Regard,

Rohit

[Former Member]

Harsh,

Try using JDBC Lookup in your mapping.

It will eliminate the need for BPM.

Regards,

Sudharshan N A