Data360 Analyze

Using the HTTP node we are able to input an alternative location and password for a TrustStoreFile if needed. However the JDBC Query node doesn't have this same option. Is there a way to accomplish the same using a JDBC Query node?

Our company doesn't allow modifying program files, so we are not able to add additional certificates to the default KeyStore using the keytool method.

This would depend on the capabilities of the JDBC driver you are using to access the target RDBMS. For example, the SQL Server JDBC Driver documentation shows the driver supports the "trustStore" connection property which is used to specify the path to the certificate truststore file. 

The trustStore property value can be provided as part of the connection string in the node's DbUrl property or as a key:value pair in the node's DbOptons property.

See also the SQL Server JDBC Driver information for the  "trustStorePassword" and "trustStoreType" properties. If a password is used it would be prudent to specify the value on the node using a property substitution to a password-type Run property or Dataflow Property - meaning the password value would be securely stored in the java keystore rather than as a clear-text string.

Using the HTTP node we are able to input an alternative location and password for a TrustStoreFile if needed. However the JDBC Query node doesn't have this same option. Is there a way to accomplish the same using a JDBC Query node?

Our company doesn't allow modifying program files, so we are not able to add additional certificates to the default KeyStore using the keytool method.