topic Re: How to Configure SLL in Talend Open Studio in Talend Studio

How to Configure SLL in Talend Open Studio

hami1 — Thu, 08 Mar 2018 12:37:53 GMT

Hi Guys,

I am facing connection Reset , java.security.ProviderException, fatal Error Exceptions while executing the ETL Job in Production Environment.But its working fine in my local System.

I have used tJava Components as per my business logic where I will connect to the Particular Website and scrap the contents of the website.For few websites am getting the above mentioned alerts. How to get rid of those Errors while scrapping the website. As per my knowledge I think the Server is not allowing the SSL - certifications, Kindly guide me how to configure the SSL - Certificate inside the Talend Design.

Thanks,

Hameed

Re: How to Configure SLL in Talend Open Studio

Anonymous — Thu, 08 Mar 2018 12:55:27 GMT

Try executing the ETL job again without SSL this time and see if the error still persist.

Re: How to Configure SLL in Talend Open Studio

hami1 — Fri, 09 Mar 2018 07:22:24 GMT

Thanks for your reply,

In my case I am creating HttpConnection for each website before parsing the contents which requires SSL/TLS get validated.

After setting the "https.protocols" to "TLSv1.2", I get rid of Connection reset Errors. But still there are few more Errors "java.security.ProviderException" & sun.security.validator Errors are occuring.

Any Idea on these above will be helpful. Can we set more than on protocols like "TLSv1","TLSv1.1" & "TLSv1.2" will it accept this.

Which Property I need to set for to get rid of the above 2-mentioned Errors in Talend.

Thanks,

Hameed

Re: How to Configure SLL in Talend Open Studio

hami1 — Tue, 13 Mar 2018 09:47:03 GMT

Folks,

Any help on this will be appreciable. Updating the Java from jdk1.7 to jdk 1.8 will solve this problem?

Updating the OpenSSL to latest version will help on this..?

Thanks,

Hameed

Re: How to Configure SLL in Talend Open Studio

Anonymous — Wed, 14 Mar 2018 07:49:24 GMT

Hello,

Are you using talend open studio for data integration or ESB? Usually, we use tSetKeyStore component to achieve SSL transport mechanism.

Could you please give us more information about your current situation?

Best regards

Sabrina

Re: How to Configure SLL in Talend Open Studio

hami1 — Wed, 14 Mar 2018 08:14:35 GMT

Thanks for your reply,

I am using Talend Open Studio for Data Integration (6.3.0).

I designed an ETL Job whose functionality is to check the availability of some urls in provided list of websites.

For this I am creating HTTP Connections to open the website and then checking the availability of my urls. When I tried to run it in the server its returning Connection Reset , java.security.ProviderException, handshake Exceptions for few Govt website Urls.

Sample Code :

try
{
               URL url = new URL(((String)globalMap.get("row1.url")));
               System.out.println("***********************************");
               System.out.println("Checking for State URL Connection Status: ");
                System.setProperty("https.protocols", "TLSv1.2");
               HttpURLConnection con = (HttpURLConnection) url.openConnection();
               con.connect();
               Flag = con.getResponseCode();
                System.out.println(url+" : Current Status : "+Flag);

//* get redirect url from "location" header field
               rUrl = con.getHeaderField("Location");
               System.out.println("Redirect to URL : " + rUrl);
                Thread.sleep(10000);
                con.disconnect();
}
catch (Exception e)
{
       System.out.println("Exception Occured while Checking State URL...");
}

Thanks In Advance,

Hameed.

Re: How to Configure SLL in Talend Open Studio

Anonymous — Tue, 25 Sep 2018 05:40:02 GMT

Hey hi Thanks !

Have a go at executing the ETL work again without SSL this time and check whether the blunder still hold on.

Re: How to Configure SLL in Talend Open Studio

Anonymous — Thu, 25 Oct 2018 03:16:35 GMT

People,

Any assistance on this will be calculable. Refreshing the Java from jdk1.7 to jdk 1.8 will tackle this issue?

Refreshing the OpenSSL to most recent form will help on this..?

Regards,

peterhean

Re: How to Configure SLL in Talend Open Studio

hami1 — Mon, 17 Dec 2018 08:17:15 GMT

peterhean,

The issue is with the protocol used by the different websites for few websites are using 1.1, 1.2 or 1.3. So I have configured the settings in my java code to allow them according to these protocol versions.

Thanks,

Hameed

Re: How to Configure SLL in Talend Open Studio

Anonymous — Wed, 09 Jan 2019 09:15:52 GMT

very impressive information dear. love your article.

I love your Website.

kindly go here for tvtap is one of the best streaming application.

Tvtap pro Mac | tvtap pro iPad

Re: How to Configure SLL in Talend Open Studio

Anonymous — Fri, 08 Feb 2019 16:08:01 GMT

This is a very helpful article. It was very useful to me. Good job

________________________

Thorstienx

Show-box

Re: How to Configure SLL in Talend Open Studio

Anonymous — Mon, 06 May 2019 15:25:02 GMT

If you really, want to know about SSL certificates then you should go to youtube and if you really, want to know about all login worldwide then you should first study about login to khan academy

Re: How to Configure SLL in Talend Open Studio

Anonymous — Sat, 11 May 2019 15:53:57 GMT

Thank you very much for providing such amazing information but I am going to tell something new that will really, help you.workspacelogin email

Re: How to Configure SLL in Talend Open Studio

Anonymous — Wed, 12 Feb 2020 13:09:23 GMT

This article is helpful for me. Thank you

http://ooh-club.com/