Skip to Content

JDBC lookup

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!

Capture.PNG (1.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 15, 2016 at 07:00 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 15, 2016 at 10:04 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 16, 2016 at 11:07 AM

    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

    Add comment
    10|10000 characters needed characters exceeded