topic Re: Open Studio for MDM tREST https in Talend Data Catalog

Open Studio for MDM tREST https

Anonymous — Wed, 22 May 2019 15:29:55 GMT

Using Talend Open Studio for MDM (7.0.1.20180411_1414)

How do I configure Talend Open Studio to use a certificate for https in tREST component?

If tREST component is the wrong componenet, what do I use?

Trying to use the tREST component as a lookup for each row from a tMap.

Re: Open Studio for MDM tREST https

Anonymous — Mon, 27 May 2019 08:16:27 GMT

Hello,

Could you please let us know if this article helps?

https://community.talend.com/t5/Design-and-Development/Three-ways-to-set-a-truststore-for-an-SSL-TLS-connection-in-a/ta-p/34811?collapse_discussion=true&page=2&q=certificate%20for%20https&search_type=thread

Best regards

Sabrina

Re: Open Studio for MDM tREST https

Anonymous — Tue, 28 May 2019 14:59:21 GMT

Unfortunately that didn't help.

I can't post images, but...

I have a tSetkeystore:

TrustStore Type: JKS

TrustStore File: correct path to .jks file

TrustStore password: is correct, in quotes in the dialogue to set it

checked Need Client Authentication

KeyStore type: PKCS12

KeyStore file: correct path to .p12

KeyStore passowrd: is correct, in quotes in the dialogue to set it

no Advanced settings

no Dynamic settings

Connected via OnSubjobOk

to a tRest component

Schema: built in

URL: correctly url "https://<the url>?key=aaa"

HTTP Method: Get

No HTTP Headers

No Advanced settings

No Dynamic settings

When I run the job I get the following:

Starting job SimpleWatchJob1 at 13:28 28/05/2019.

[statistics] connecting to socket on port 3584

[statistics] connected

Exception in component tREST_1 (SimpleWatchJob1)

com.sun.jersey.api.client.ClientHandler Exception: javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake

at com.sun.jersey.client.urlconnection.URLConnectionClientHandler.handle(URLConnectionClientHandler.java:131)

at com.sun.jersey.api.client.Client.handle(Client.java:616)

at com.sun.jersey.api.client.WebResource.handle(WebResource.java:559)

at come.sun.jersey.api.client.WebResource.get(WebResource.java:182)

at simplewatchjob1.simplewatchjob1_0_1.SimplteWatchJob1.tRest_1Process(SimpleWatchJob1.java:1110)

at simplewatchjob1.simplewatchjob1_0_1.SimplteWatchJob1.tSetKeystore_1Process(SimpleWatchJob1.java:720)

at simplewatchjob1.simplewatchjob1_0_1.SimplteWatchJob1.runJobInTOS(SimpleWatchJob1.java:4495)

at simplewatchjob1.simplewatchjob1_0_1.SimplteWatchJob1.main(SimpleWatchJob1.java:4332)

........ <and more>

Any ideas? Is it a certificate problem not a my use of Talend?

Thank you.

Re: Open Studio for MDM tREST https

Anonymous — Tue, 28 May 2019 16:13:30 GMT

Sigh.... Never mind... I was using the wrong certificate file. Thanks anyway.

Re: Open Studio for MDM tREST https

Anonymous — Thu, 30 May 2019 03:43:26 GMT

Hello,

Thanks for letting us know it. Feel free to let us know if there is any further help we can give.

Best regards

Sabrina