cancel
Showing results for 
Search instead for 
Did you mean: 

Authorizations required in Communication Channel for JDBC Lookup mapping

Former Member
0 Kudos

Is there of list of required authorizations and or patch needed to use a JDBC Lookup in a message mapping? We are using PI 7.1, and trying to use the new JDBC Lookup feature. We currently have a user that is not an ower of the DB tables, this does work in our current solution of using UDFs, but we would like to avoid switching it to a user that has full access on the tables, e.g. SAPXI*

Current environment: PI 7.1 (not EhP1)

Thanks,

Matt

Accepted Solutions (1)

Accepted Solutions (1)

rajasekhar_reddy14
Active Contributor
0 Kudos

When you use JDBC Lookup using graphical function,you have to create receiver JDBC Communication channel,in that you have to give user name and password,the user name should have rights to access the DB System tables.

this user name different from pi user name.

so try to use the user name which has all rights.

Regards,

Raj

Answers (4)

Answers (4)

0 Kudos

Hello!

Please check the note below according to your system version:

#999962 - PI 7.10: Change passwords of PI service users

#936093 - XI 7.0: Changing the passwords of XI service users

#721548 - XI 3.0: Changing the passwords of the XI service users

Hope it helps.

Regards,

Caio Cagnani

Former Member
0 Kudos

Thank you for the responses, but I already know how to configure the JDBC Lookup. I have it working, however, in my Receiver Comm Channel I have to put in a user that has ALL access to the DB. I am wondering if there are a list of required user roles in using JDBC Lookups so I can create a user specifically for this call.

Thanks,

Matt

Former Member
0 Kudos

Hi Matt,

> In my Receiver Comm Channel I have to put in a user that has ALL access to the DB. I am wondering if there are a list of required user roles in using JDBC Lookups so I can create a user specifically for this call.

Based on your requirements (you need all access on DB) you need to assign the roles to the DB users.

Ask your Database team (DB Admin) what ever operations you will do, based on that they will create new user ID or assign the Roles to the already existing user.

Regards

Ramesh

Former Member
0 Kudos

Do you know what those authorizations should be when using a standard JDBC Lookup mapping function? Currently we have a custom UDF that calls the table via a <schema>.<table name> and the current user in the Receiver Comm Channel works just fine. It appears that when using the standard SAP JDBC Lookup function it calls the table directly and the user in the Comm Channel no longer has the correct permissions.

I would expact that the JDBC Lookup function would allow for a standard "Read" on any table as long as the user has that level of access...but not in this case. I am going to bring it up to our SAP XI software development team and see what they say, but wanted to get some views from our other experts as well.

Thanks,

Matt

Former Member
balaji_pichaimuthu
Active Participant
0 Kudos

Hi,

Whatever the lookup you performing either jdbc,rfc,soap you should have created a Communication channel in ID to do the lookup.. For your scenario you should have created a receiver jdbc channel in ID. In that channel you can mention you authentication details like user name and password of the DB can be given.

And in the message mapping to the parameters tab. there you have to give jdbc communication channel name.

Regards,

Balaji

Edited by: Balaji Pichaimuthu on Jun 3, 2010 7:38 AM

Former Member
0 Kudos

Hi Matt,

Please see the Demo where there is JDBC lookup is done in the demo .......Hope you find it useful:

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/20ab7ccf-e78a-2a10-71b4-80fc764ba...

Also look into the blogs for Lookups:

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

Regards

Ravi