Skip to Content

JDBC Custom DataSource sap pi

Hi SAPiens,

Our basis have created the custom datasource (CADATACOM) in PI _dev system.

Now when I am trying to connect to DB using JDBC Receiver channel I am getting -

Could not open connection to jdbc:datacom://xxxxx:xxx/xxxxxxx/xx

Can't we use custom datasource in JDBC Adapter?

However, basis tried to ping DB from there end and they were able to hit it. It means DB is not down.

Please suggest.

BR,

Rashmi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 10, 2017 at 10:45 AM

    Hello Rashmi,
    What DB vendor do you use and what kind of JDBC drivers have you deployed in PI?

    Best regards,
    Vadym

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Rashmi,
      All JDBC driver libraries should be deployed within com.sap.aii.adapter.lib.sda archive following recommeded way (using SUM or Telnet).

      Regarding the connection string, unfortunately I cannot suggest the correct one, because never used such DB vendor service. However, preliminary connection string testing using any 3rd-party tool (as I already suggested) is highly useful in this case, because helps to ensure that connection is possible and alive and that it is not PI's failure.

      Best regards,
      Vadym