Couldn't connect Snowflake to Talend through SSL.

[MdFazil]

Hi 
I've trying to connect Snowflake to Talend via SSL 
I have followed this URL as a guide  https://community.qlik.com/t5/Official-Support-Articles/Talend-Job-using-key-pair-authentication-for... and I have followed snowflakes official documents to create the key https://docs.snowflake.com/en/user-guide/key-pair-auth 


Now what the issue I'm facing here is I cannot upload the SSL certificate and the component is throwing error like 

[statistics] connecting to socket on port 3559
[statistics] connected
[FATAL] 10:46:37 talend_snowflake_streaming.onboardingdemojob_0_1.OnBoardingDemoJob- tDBConnection_1 java.io.IOException: toDerInputStream rejects tag type 45
java.lang.RuntimeException: java.io.IOException: toDerInputStream rejects tag type 45
	at talend_snowflake_streaming.onboardingdemojob_0_1.OnBoardingDemoJob.tDBConnection_1Process(OnBoardingDemoJob.java:689) [classes/:?]
	at talend_snowflake_streaming.onboardingdemojob_0_1.OnBoardingDemoJob.tSetKeystore_1Process(OnBoardingDemoJob.java:494) [classes/:?]
	at talend_snowflake_streaming.onboardingdemojob_0_1.OnBoardingDemoJob$6.run(OnBoardingDemoJob.java:1694) [classes/:?]
Exception in component tDBConnection_1 (OnBoardingDemoJob)
java.lang.RuntimeException: java.io.IOException: toDerInputStream rejects tag type 45
	at talend_snowflake_streaming.onboardingdemojob_0_1.OnBoardingDemoJob.tDBConnection_1Process(OnBoardingDemoJob.java:689)
	at talend_snowflake_streaming.onboardingdemojob_0_1.OnBoardingDemoJob.tSetKeystore_1Process(OnBoardingDemoJob.java:494)
	at talend_snowflake_streaming.onboardingdemojob_0_1.OnBoardingDemoJob$6.run(OnBoardingDemoJob.java:1694)
[statistics] disconnected

 
I have also attached a Image here 

Can anyone please help me with this?

Regards
Fazil M

[Xiaodi_Shi]

Hello,

We met this similar issue "toDerInputStream rejects tag type 45" before due to wrong truststore type and it could not your root cause.

Could you please try to configure Keystore settings for talend in job level only to see if it works?

Keystore settings-->Studio level-->Studio initialization file

                                                     or

                                                     -->Studio SSL preferences

Keystore settings-->Job level--> tSetKeystore component without Studio SSL preferences here

Additionally, please see the following documentation link for more information:
https://docs.snowflake.com/en/user-guide/jdbc-configure.html
https://docs.snowflake.com/en/user-guide/jdbc-configure.html#using-key-pair-authentication-key-rotat...

Best regards

Sabrina

[MdFazil]

Hello @Xiaodi_Shi , 

Thanks for the reply, will try this and update you. Thanks

Regards
Fazil M