cancel
Showing results for 
Search instead for 
Did you mean: 

PI connectivity with ORACLE Database

0 Kudos

Hi Experts,

We have a requirement to connect Oracle DB with PI 7.11.

I am following SCN link http://scn.sap.com/thread/1893671

Can you please provide detail

- Required JDBC driver

- Where to install JDBC drivers? either on ORACLE or PI system.

- What are the prerequisites to be met for message processing between the two.

Thanks in advance

Regards,

Bharath B

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Bharath,

You need to deploy the jar file suitable to the oracle DB in your PI system.

Please refer the below link for deployment process

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00b4a020-4ae6-2c10-5a95-fed4ad9a4...

Regards,

Karthikeyan S.

iaki_vila
Active Contributor
0 Kudos

Hi Bharat,

Required JDBC driver

Depending of the Oracle version, download the corresponding. For compatibilities check this SAP Knowledge Base Article 1615198  - PI JDBC and JMS Adapter driver's JRE compatibility

Where to install JDBC drivers? either on ORACLE or PI system.

In PI system, Check this documents:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4d...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8000cffc-6b92-2d10-3493-f2ac13992...

- What are the prerequisites to be met for message processing between the two.

The PI JDBC adapter deals with this work.  Check the document formats here: http://help.sap.com/saphelp_nwpi71/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm?framese...