Pentaho

I have a similar issue. I am using the REST Client to get some part numbers embedded in an XML document which is on intra company sharepoint site. I am getting the following:

javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

Now a few words about my environment: I am using Pentaho 7.1

Hi,

if I understood correctly you're trying to call a Rest endpoint using client side SSL authentication (done using a client side digital certificate).

See this for further information:

https://help.pentaho.com/Documentation/8.2/Products/Data_Integration/Transformation_Step_Reference/REST_Client

It has a truststore inside SSL tab which you can configure, but I assume that only allows you to validate the server certificate. A keystore would be needed to authenticate the client.

I haven't tried this step features, but if the above is true you have one of three options:

1) Implement a proxy that authenticates and proxy PDI requests through it (keep in mind, that you may need to cipher content, and on a least effort base use a SSL certificate on the proxy to make sure that traffic between the proxy and PDI is ciphered, but also that you trust in the server identity because you trust the SSL certificate).

2) Use a Java step to access the API. It may prove to be not much efficient (if that's an issue for you).

3) Implement a custom step for PDI that accesses the Rest API authenticating with the certificate you have.

Hi,

I suggest you open a topic to request help for the issue you are having.

Did you add the certificate to the cacerts? Is the certificate valid?