In JDBC connection can i add properties of proxy server

[Former Member]

Hello,

I am hosting a PI-System for my customer in a Customer-DMZ which is not directly connected to the internet.

According to their LAN Operation Rules, all accesses to the internet have to use a proxy infrastructure in a special Internet DMZ or dediated networks.

This concept exactly meets the sap recommendation for PI systems which are connected to external systems (second graphic in the follwoing link)

http://help.sap.com/saphelp_nw04s/helpdata/en/d9/ef2940cbf2195de10000000

a1550b0/content.htm

When using HTTP or SOAP Adapters that is working fine. The corresponding

services on the J2EE Engine or in the ABAP Part (SICF or HTTP Client

Service) allow to configure a SOCKS compatible proxy. Concerning the

JDBC Adapter I didn't find any setting for SOCKS V5 Proxies.

Where in the JDBC Connection Options can I add the properties of a

proxy Server. If this is not available, what's the recommendation for

protocols which are not HTTP(S) or FTP according to the link above?

Should there be an dedicated VPN for every target system (costs) or a

standallone Adapter engine in an internet DMZ?

Please advise us as soon as possible.

Urs, Soorya

[Former Member · Accepted solution]

hi

for JDBC you will have to go for VPN or a decentral adapter engine.

Which is you database ?? Some databases allows enabling & calling SOAP/HTTP services also.

rgds,

Arun

[Former Member · Accepted solution]

Is VPN is supported by JDBC?

If so how can we use that connection to configure the JDBC adapter ?

Urs,

Soorya

[dharamveer_gaur2]

Hi

look this thread for VPN connection with JDBC.

[Former Member]

HI Surya

For connections other than HTTP or FTP. VPN is the best option. Although for JDBC you can implement encryption as well and make it work on normal network

Database like Oracle and MS SQL provided secure connection/encrypted JDBC calls as well

I think its OCI driver for Oracle 9i. Which allows you to do a JDBC in a encrypted call.

Thanks

Gaurav

[Former Member]

Hi,

How can you implement the VPN with JDBC adapter ?

How about using a decentral adapter engine for this purpose?

How can we use it ?

Urs,

Prakash

[Former Member]

Hi Surya

Basically you need to do telnet using Shell admin tool. This will allow you to do setup VPN.

Refer this

http://help.sap.com/saphelp_nw04s/helpdata/en/a2/6052bb98033c4dbef5df04f68b0c7e/frameset.htm

Thanks

Gaurav