How to Connect to the Oracle data Base ?

[Former Member]

hi i have a senario like Oracle Jdbc to FIle .

my req

1. I want to Connect to the Oracle data base in sap pi 7.0 .

2. how to coonect to the oracle data base

3. Is ther is any things to configure like installing the drivers and jar files. if yes what is the path for that.

plz kindly help me

[Former Member · Accepted solution]

Yes you need to deploy the driver of oracle database for this

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

HTH

Rajesh

[dharamveer_gaur2]

Hi

As said above you need to deploy driver.

After deploying you need to configure JDBC Channel, where you have to mention

Connection URL, Driver , User name and password parameter.

[Former Member]

Hi, Dharamveer:

Yes. As suggested from above other experts, you need to deploy the vendor specific database driver, in your case

Oracle driver. Link has been provided.

Secondly, depend on your Oracle system is sending system or receiving system, you need to design particular data type if it is receiving system.

Last, you need to configure your commnication channels.

JDBC 2 JDBC

https://wiki.sdn.sap.com/wiki/display/XI/JDBCTOJDBC

Regards.

Liang

[Former Member]

Hi,

You need ojdbc14.jar (i think you can get version 10.2.0.3.0) from oracle.com.

Or if your database with PI is Oracle. then you can find it within your PI server (/oracle/client/10x_64/instantclient - this path may vary based on your installation).

To find the version:

After you downloaded to your local desktop, rename to ojdbc14.zip and extract the file.

within the META-INF folder, open the MANIFEST.MF file in a notepad and check the version.

rename the .zip back to .jar.

Use the link provided in the earlier post to deploy the jar file in your PI server.

Then you are all set to start developing your scenario to connect to external oracle.

Regards,

Balaji.M

[Former Member]

Hi!

Check these

Examples for Connecting to the Database

[http://help.sap.com/saphelp_nw04/helpdata/en/2d/5c085d9f585d4b912392ba075e1ce7/frameset.htm]

Data Source dtd

[http://help.sap.com/saphelp_nw04/helpdata/en/64/0bee3da7138e5be10000000a114084/frameset.htm]

Defining the Connection URL

[http://help.sap.com/saphelp_nw04/helpdata/en/2d/5c085d9f585d4b912392ba075e1ce7/frameset.htm]

[/message/1364575#1364575 [original link is broken];

[;

Sender JDBC::

[http://help.sap.com/saphelp_nw04/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm]

Receiver JDBC::

[http://help.sap.com/saphelp_nw04/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm]

I hope atleast this may give you few information regarding your requirement.

Regards::

Amar Srinivas Eli