I want to update the romote postgresql using PUTSQL processor. PUTSQL processor has DBCP connection pool controller service to connect with database. I have provided all the properties required. Am able to connect the postgresql db in my local. But when i try to connect remote postgre db which is secured by ssl protocol returning handshake-failure error. so, i have added the ssl connection parameters ssl=true , sslmode=verify-full, sslrootcert=<path to certificate> and added sslfactory=org.postgresql.ssl.DefaultJavaSSLFactory . Am getting 'certificate chaining error' . In nifi logs i can see  Caused by: java.security.cert.CertPathBuilderException: PKIXCertPathBuilderImpl could not build a valid CertPath. Caused by: java.security.cert.CertPathValidatorException: The certificate issued by CN=XXX Cloud Databases is not trusted. cerificate with extension is 'server.crt.der' . certificate in my project folder. If i need to keep that certificate in truststore of nifi. I don't know how to make trusted and accepted by that.   ... View more