Need to connect to Oracle 11g using PI 7.1 JDBC adapter

[Former Member]

Hi All,

I am trying to configure a JDBC adapter to connect Oracle 11g. For this I need to know the driver,jar and connection URL details.

Can anyone please provide the above information?

Please correct me if my details are wrong :

JDBC Driver : oracle.jdbc.driver.OracleDriver

JAR : ojdbc5.jar

URL : jdbc:oracle:thin:@localhost:1521:ora11i

Regards,

Prakash.

[rajasekhar_reddy14 · Accepted solution]

The details looks correct, i hope you know how to deploy the drivers on PI server, if no seach in sdn.

[Former Member · Accepted solution]

Yes i knew how to deploy the jars using SDA.

I will try to deploy the above jar (ojdbc5.jar ) and try to connect to Oracle 11g with URL & Driver classname.

If I face any problem then i will get back to you.