Skip to Content
0

how to connect External Oracke DB server from SAP PI 7.4

Jan 11, 2017 at 01:25 PM

183

avatar image
Former Member
10 |10000 characters needed characters left characters exceeded
Former Member

Team,

Please provide your inputs and valuable suggestions. Thanks.

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Jan 11, 2017 at 09:07 PM
0

Firewalls at both ends have to have trust rules in place - so speak to your network team. Then configure as you would usually connect to a server using JDBC... IP address might be better than a DNS incase the DNS cannot resolve.

Show 8 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Dan,

Should we need to open the firewall at both ends?

what about the driver installation? External db drivers should be installed in PI server? and already PI has Oracle data base. How to go about this. Please elucidate briefly. Thanks much.

0
Former Member
Former Member

I suspect you will need to add rules at both ends as i assume both parties will have enterprise firewalls in place. If the oracle or JDK version is different from the drivers you have installed then yes you should install the new drivers. The SCN has blogs on how to do this if you don't know how (for example https://blogs.sap.com/2013/08/28/how-to-deploy-the-jdbc-driver-in-pi-7173/ )

1
Former Member
Former Member

Hi Dan,

Both SAP PI and ORACLE DB server are different network and sub nets.

Network team response on this scenario is that the connectivity for this data flow not possible. By the way this is the first time we are integrating to an external DB outside the landscape.

SAP PI Oracle version is 12.1 -64 Bit

External Orcale DB is 10g jdk 1.6.x.

0
Former Member
Former Member

Hi Rajesh. I am no network expert but i know it is possible (having seen similar implementations). What we did at the Waikato DHB to send messages to an external lab is to send traffic through a VPN tunnel which is managed by the network team. It may slightly change IP's of your communication channel. I am sure this is not the only option either. It just sounds like you have an unhelpful network team. Apologies I cannot help you any further.

1
Former Member
Former Member

Hi Dan,

Thanks alot for your valuable inputs.

0
Former Member

Hi Dan,

DB is outside the network and IP looks like 192.xx.x.x and SAP PI IP address looks like 172.xx.xx.xxx.

Is this outside connectivity possible using JDBC adapter?

0
Former Member
Former Member

Yes it will be possible providing that the firewall rules are in place.

If you find you are having connectivity issues i would recommend having your network team monitor the traffic from your PI server so that when you try initiate a connection to the external IP address they can tell where the connectivity issue lies.

I should also note you will need to be sure that the IP addresses you are using are the external facing IP's. I know some network teams assign internal IP's on a network. Just something to keep in mind.

0
Former Member
Former Member

Hi Dan,

Should we need to deploy and add the JDBC drivers installed in External DB(192.xx.x.x) in SAP PI ?

Enable the Firewall port between SAP PI host:port and Oracle ipaddr:192.xxx.x.xx:1521 of TCP/IP ?

0
Evgeniy Kolmakov Jan 12, 2017 at 03:10 PM
0

Hi Rajesh!

I guess PI itself shouldn't take care about any kind of network connectivity issues. The network administrators should provide the way PI can reach target DB server (routing, firewalls etc.).

Regards, Evgeniy.

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks evgeniy. I will get in touch with network team.

But please provide your inputs if this setup is possible or not.

0

Hi Rajesh!

If PI server is able to access given network address/port all other settings (server name, database name, etc.) remain the same.

Regards, Evgeniy.

1
Former Member

Below error I'm getting in PI communication channel ping.

0