Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Connect to oracle via jdbc ssl from nifi

Highlighted

Connect to oracle via jdbc ssl from nifi

Explorer

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.

3 REPLIES 3
Highlighted

Re: Connect to oracle via jdbc ssl from nifi

Contributor

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

Highlighted

Re: Connect to oracle via jdbc ssl from nifi

Explorer

@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()));

Highlighted

Re: Connect to oracle via jdbc ssl from nifi

New Contributor

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

Don't have an account?
Coming from Hortonworks? Activate your account here