Skip to Content
avatar image
Former Member

Connection to Custom JDBC Data source from receiver JDBC communication channel

Dear SCN Friends,

I need to connect to my custom JDBC data source from JDBC communication channel.I have tried with below parameters but no luck.

JDBC Driver: oracle.jdbc.driver.OracleDriver

Connection: jdbc:oracle:thin:@PIHost:PIHTTPPort:CustomDatasourceName

User: PI server user

Pwd: Pwd

1)Can I able to call from JDBC channel ?

2)If yes does the maintained values are correct ?

NOTE:From custom data source ,when I do ping to connect to XYZ server d/b .It's successful.

Regards

Venkat

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jul 21, 2015 at 08:56 PM

    Venkat,

    Try to connect to DataBase using DBClient, to test from desktop.

    To connect from PI Help Link, sap note 831162.

    To be able to use the JDBC adapter, you must have installed the JDBC driver for the database to which you want to connect. The required Java libraries are product-specific and must be obtained from the database vendor.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I could able to achieve temporary solution to our problem by connecting to JDBC custom data source from mapping using piece of java code ,but I can't able to connect from channel .I want to make sure it's not possible to connect custom data source from JDBC channel.

      Regards

      Venkat