cancel
Showing results for 
Search instead for 
Did you mean: 

Secured JDBC connection to Oracle database

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

JoelTrinidade
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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