Connect to oracle via jdbc ssl from nifi

[#1]

DBConnectionPool controller does not contain provisions to specify truststore and truststorepassword for establishing a jdbc connection over ssl when authentication is enabled on the oracle server.

[#2]

@Anandakrishnan Ramakrishnan -- I believe this will be available once https://issues.apache.org/jira/browse/NIFI-3426 is fixed.

[#3]

@Arti Wadhwani Thanks for the information, just was looking at the source code and seems like we have it addressed.

Upon looking at the source code, the support for dynamic property for DBCPConnection has been checked in on 02/01/2017 in the git

https://github.com/apache/nifi/commit/2d6d7710c776a4e5608f1da63eba9e8435f72506

https://github.com/apache/nifi/blob/master/nifi-nar-bundles/nifi-standard-services/nifi-dbcp-service...

context.getProperties().keySet().stream().filter(PropertyDescriptor::isDynamic)

.forEach((dynamicPropDescriptor) -> dataSource.addConnectionProperty(dynamicPropDescriptor.getName(),

context.getProperty(dynamicPropDescriptor).evaluateAttributeExpressions().getValue()));

[#4]

Hi Team,

Please see if you can help provide the syntax for  JDBC SSL connection to Oracle from NiFi DB Connectionpool services.

will it be similiar to something like below ?

jdbc:sqlserver://<ip>:<port>/<username>?user=<username>&sslTrue&sslcert=/etc/.../mycerts/mycert.der&sslkey=/etc/.../mycerts/mykey.key.pk8