on 06-15-2016 6:37 PM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.