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.

How to connect NIFI to Teiid data virtualization using SSL configured in teiid?

Highlighted

How to connect NIFI to Teiid data virtualization using SSL configured in teiid?

New Contributor

 

We have a Teiid 12.3 server running which is configured using ssl.

We are able to connect this teiid server using tools like pentaho etl, squirrel sql client, Tableau etc. we are using trustore file to connect these tools.

But we are not able to connect Teiid server in Apache NIfi. We tried the following ways to include trustore –

  1. Adding the trustore in the run nifi.bat <mention the statement you added in bat>
  2. set JAVA_ARGS=-Dorg.apache.nifi.bootstrap.config.log.dir=%NIFI_LOG_DIR% -Dorg.apache.nifi.bootstrap.config.pid.dir=%NIFI_PID_DIR% -Dorg.apache.nifi.bootstrap.config.file=%BOOTSTRAP_CONF_FILE% -Djavax.net.ssl.trustStore=teiid_dummy.truststore -Djavax.net.ssl.trustStorePassword=1234

 

  1. Creating a StandardSSLContextService but we cant use this service in ExecuteSQL or QueryDatabaseTableRecord processors
  2. Added trustore details in the teiid connect url -- jdbc:teiid:VDB@mms://abc123.com:443;enableTLS=true;trustStorePath=E:/nifi-1.11.4-bin/nifi-1.11.4/bin/teiid_dummy.truststore;trustStorePassword=1234

Errors:

TEIID 200020 Error establishing socket to host and port.

Sun.security.validator.validatorException : PKIX path building failed:

 

 

Amar_0-1588085698199.jpeg

 

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