In Pentaho can I make a call to a rest service secured with HTTPS? I've tried the 'REST Client' step which has inputs for truststore but I see no way to set the keystore.
Hi,
I am accessing a Https Rest Endpoint that has a self-signed certificate. I saved the certificate and created a Trust Store using the following command. I used a .cer certificate.
keytool -import -file C:\cascerts\firstCA.cer -alias firstCA -keystore myTrustStore
And when I add this to the Trust Store File path (C:\Windows\System32\myTrustStore) in Rest Client, I am getting this error.
2019/01/25 16:36:55 - Get_Data_From_SolarWinds_And_Write_To_Csv - Dispatching started for transformation [Get_Data_From_SolarWinds_And_Write_To_Csv]
2019/01/25 16:36:55 - REST client - Get Data From SolarWinds.0 - ERROR (version 8.1.0.0-365, build 8.1.0.0-365 from 2018-04-30 09.42.24 by buildguy) : Error setting configuration
2019/01/25 16:36:55 - REST client - Get Data From SolarWinds.0 - ERROR (version 8.1.0.0-365, build 8.1.0.0-365 from 2018-04-30 09.42.24 by buildguy) : org.pentaho.di.core.exception.KettleException:
2019/01/25 16:36:55 - REST client - Get Data From SolarWinds.0 - We can not find file [C:\Windows\System32\myTrustStore]
2019/01/25 16:36:55 - REST client - Get Data From SolarWinds.0 - C:\Windows\System32\myTrustStore (The system cannot find the file specified)
2019/01/25 16:36:55 - REST client - Get Data From SolarWinds.0 -
Then I tried with "C:\Windows\System32\myTrustStore.jks".
Any advice?
Hi Craig Foote I know your question is really old at this point, but perhaps you found a solution like this:
Generating a KeyStore and TrustStore (Configuring Java CAPS for SSL Support)
At the bottom of the page you'll see some steps for creating your TrustStore outside of Pentaho and manually adding your certificates there. Pentaho doesn't have a step for creating the TrustStore (well, I'm sure you could create something by configuring some other steps, but nothing out of the box specific for this), it is just a consumer of it in the REST Client step.