JDBC lookup

[vijay_b4]

Hi,

I clicked on JDBC Lookup in message mapping, but its showing as the below, its not accepting any input nor giving o/p,no warning message...how to use it?

Thanks!

[nidhi_srivastava22]

Hi Vijay,

The process to use JDBC lookup is mentioned below -

1) First create a channel to connect to the database, test the connectivity to the database.

For eg - Channel name is CC_JDBC_Common

2) Create an External Definition and select dbtab and add the channel name and table name as given in the below example -

3) Now add the parameter in the Message Mapping -> Signature Tab -> Parameter

4) Now when you add your JDBCLookUp node in your mapping you can assign the parameter assigned in the third step and ED used in 2nd step as shown below.

5) Keep the source fields as input and target as output and then run the test.

Hope this clears you.

Thanks,

Nidhi Srivastava

[Former Member]

Vijay

Double click on that lookup and select the table  ... From there you will see list of all fields ... Select fields which will act as inputs and those fields which you want to be output. Once you choose respective fields you will see your those number of input to the JDBC lookup and those numbers of output out of lookup

Again in signature tab first define which adapter you are going to use for lookup. Once that done then follow above process.

[Former Member]

Hey Vijay

Did you configure the RFC channel already ? If yes, then you will have to use that as parameter in signature which then will connect to backend database and pull out structure of RFC for you to configure accordingly.

Follow below link to do it graphically

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

Abhishek

[vijay_b4]

Yes I have created channel and used that as parameter, but still the jdbc lookup is showing as above.