cancel
Showing results for 
Search instead for 
Did you mean: 

how to connect oracle!!!!!!!

Former Member
0 Kudos

Hi all,

Here is a scenario Idoc to DB...but that connection is to Oracle database...

Till now I came across MS Access db only...

Can any one tell me how can we connect to oracle database in detail???

regards,

Pavani

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Pavani,

Ask your XI admin to load the Oracle driver and normally you can connect using JDBC adapter

regards

harsha

Former Member
0 Kudos

Hi harsha,

Is there any 3rd party system connectivity involved in it??

If you have any example scenario please share those details please???

regards,

pavani

justin_santhanam
Active Contributor
0 Kudos

Pavani,

Please refer the below doc.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/bf4b1055-0d01-0010-32a3-b38...

After configuring the Oracle driver in Visual admin.

In the comm. channel u have to give

URL : jdbc:oracle:thin:@<IP adress>:<listener port>:<instance name (DB Name)>

Driver: oracle.jdbc.driver.OracleDriver

In addition to that, refer the below thread for Bhavesh's resply.

Hope it helps.

Best regards,

raj.