topic Couldn't connect Snowflake to Talend through SSL. in Talend Studio

Couldn't connect Snowflake to Talend through SSL.

MdFazil — Fri, 22 Mar 2024 06:12:58 GMT

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-Snowflake-fails/ta-p/2151246 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

Re: Couldn't connect Snowflake to Talend through SSL.

Xiaodi_Shi — Fri, 22 Mar 2024 09:00:42 GMT

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

-->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-rotation

Best regards

Sabrina

Re: Couldn't connect Snowflake to Talend through SSL.

MdFazil — Fri, 22 Mar 2024 09:08:55 GMT

Hello @Xiaodi_Shi ,

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

Regards
Fazil M