on 06-03-2010 12:40 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Hi Matt,
This links helpful to you
http://www.erpgenie.com/sap/netweaver/xi/xiauthorizations.htm
DB level roles and privilizes
http://msdn.microsoft.com/en-us/library/ms189121.aspx
http://www.enterprisedb.com/documentation/user-manag.html
Regards
Ramesh
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Matt,
Please see the Demo where there is JDBC lookup is done in the demo .......Hope you find it useful:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.