on 02-17-2009 3:15 PM
Hi,
We have the following scenario
OracleDB 9.1 -
>FIREWALL-->XI--->IDOC.
XI uses the sender JDBC adapter, to select data from the Oracle Database. This database is currently outside the Client network.
The communication between XI and OracleDB should be secured ( with Encryption ).
Can someone let me know steps to achiveve this. Is there any standard guide or blog or material to achieve this.
some questions could be
1) The Driver to be used
2) How to set the security level of the adapter in XI
3) Is an SSL or Tunneling based solution possible.
Regards,
Abhishek
hi Abhishek,
Here are a few simple straight forward answers to your questions:
Q1) The Driver to be used.
Ans: The drivers to be used is available with the third party software which can also be downloaded from the net. Secondly you need to install them on the PI server.
Q2) How to set the security level of the adapter in XI
Ans: This is the most important question , there is no explicit way of doing this , username and password is security at the very baisc level in case you are talking about encryption or something like that . That you dont need to worry because internally sap has already made the provision that all communication by adapters would be using https (secured SSL) so that you don't have to worry. Although there could be some more settings that could be done but then it would be at the db adminstration level , not at yours.
Q3) Is an SSL or Tunneling based solution possible.
Ans: Tunneling need be done in your case it is required in some problematic case where http adapter is used , you just configure a normal jdbc scenario and all would be fine
Regards
joel
Edited by: joel trinidade on Apr 15, 2009 12:49 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
To configure the adapter you must specify the following:
● A JDBC database driver to access the database
This driver is not supplied with the adapter but must be supplied by the database provider or third-parties.
● Logon data for the database to be read from( using this u can provide the security)
● An SQL statement to determine the table contents you want to read
● An SQL statement to process successfully sent table contents
● A dispatcher class (optional) with the corresponding settings and the user exits and their settings that are to be called by the dispatcher
● Sender and receiver data required by the Integration Engine for routing and mapping
Detail procedure for configuring sender JDBC ADAPTER is given in this link:[http://help.sap.com/saphelp_nw04/helpdata/en/b0/676b3c255b1475e10000000a114084/frameset.htm]
thanks and regards,
Kubra fatima.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
No need to worry about this things.
1) The Driver to be used
2) How to set the security level of the adapter in XI
3) Is an SSL or Tunneling based solution possible.
In the Firewall level they can give the security, means at the Firewall level they give access to some users/persons based on that they take the data or upgrade the data,....But in the XI side no need to do any security things.
You can configure like a ordinary JDBC to IDoc scenario.
http://help.sap.com/saphelp_nw04/helpdata/en/b0/676b3c255b1475e10000000a114084/frameset.htm
Regards
Ramesh
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
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.