Skip to Content

PI 7.31 - JDBC driver query

hi,

PI 7.31 has to connect to Oracle 11.2.0.4.

Can you please let me know the exact driver name and details for this version and how to install it in PI 7.31

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Apr 15, 2014 at 06:55 AM

    Hi

    you need to deploy jdbc driver.

    choose suitable here http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

    JDBC Driver installation procedure is described here http://help.sap.com/saphelp_nw73ehp1/helpdata/en/48/cafc972fbb5c97e10000000a42189d/frameset.htm

    Regards, Mikhail

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 15, 2014 at 06:41 AM
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member


      hi,

      Just you need to update the driver oracle details in config -Admin tool and restart the system, it will work. no need to deploy the drivers through SUM.

      Regards,

      Krushi.

  • Apr 15, 2014 at 06:52 AM
    Add comment
    10|10000 characters needed characters exceeded

  • Apr 15, 2014 at 07:21 AM

    Hi,

    Once you have deployed the jdbc driver. In ID part under the connection tab make following entries:

    JDBC Driver: oracle.jdbc.driver.OracleDriver

    Connection:  jdbc:oracle:thin:@[HOST][:PORT]:SID

    along with valid Username and Password.

    Add comment
    10|10000 characters needed characters exceeded