cancel
Showing results for 
Search instead for 
Did you mean: 

How to find JDBC Driver and connection details?

Former Member
0 Kudos

Hi All,

I am new to PI. Can any body let me know how to find JDBC driver and connection details.

I tried to check above details in SDN, but i could not get those details.

Regards,

SK.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Suresh,

Regarding the JDBC driver installation, Generally this work is basis guys done.

You just want to know which database they are using

If it use Microsoft Sql server 2005 or 2008 you just follow the below connections

**************************************

JDBC Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver

connection: jdbc:sqlserver://hostname:portno ;DatabaseName=SID Name

Username : ***********

Pwd: ************

***************************************

If it use the Oracle Database, you just follow the below connections

****************************************

JDBC Driver : oracle.jdbc.driver.OracleDriver

connnection: jdbc:oracle:thin:@hostname:portno:SIDName

User name: *************

Pwd: *************

*****************************************

Thank you

Sateesh

Answers (3)

Answers (3)

Former Member
0 Kudos

Answered.

Former Member
0 Kudos

Hi Suresh,

Please try this SAP Note: 639702...

Regards,

Ramesh.

maciej_jarecki
Contributor
0 Kudos

Hi,

How to install,try this sap note:

SAP note - 1138877 - PI 7.1 : How to Deploy External Drivers JDBC/JMS Adapters ?

How to find on server ?? You should ask Basis team.

Regards

M.