How to use JDBC Lookup in PI 7.1 ?

[Former Member]

Hi,

Please advise how to use JDBC lookup in message mapping PI 7.1 ? any reference link / document ?

I have followed this step below :

1. Create the external definition for the database table.

2. Use the external definition (table) in message mapping JDBC Lookup.

But the target still "Yellow colour" meanint the mapping hasnot completed yet ? why ? and when i double click the JDBC lookup

there some error message

"No suitable parameter found; define new parameter of type 'Channel' first"

Please advise.

Thank You and Best Regards

Fernand

[rajasekhar_reddy14 · Accepted solution]

Hi,

its very easy to perform JDBC Looks up using Graphical Function , just you need to create Receiver communication channel for JDBC.....

rewfer below blog

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

http://help.sap.com/saphelp_nwpi71/helpdata/en/33/1ec6ced273493a993a80c2301c03da/frameset.htm

regards,

raj

[Former Member]

Hi Fernand,

JDBC Lookup can be done in PI 7.1 using below mentioned steps :

1) Create a communication channel between PI and the database to connect to database.

2) Import the table data as External Definition.

3) In message mapping where this lookup is to be used select JDBC Lookup under Conversions and map

4) Double Click on JDBC Lookup

5) Select parameter and a database table (imported as the external definition). All the elements of the table will appear in the middle column. Select and move the input parameters to the left side column and the output parameters to the right side column. Click OK.

6) Under message mapping go to signature tab and define the parameter as channel and category as JDBC Adapter Type.

7) Under Operation mapping define the parameter & associate it with parameter defined in Message Mapping.

Thanks

Amit