topic Re: Service Now Components (tServiceNowConnection) in Talend Studio

Service Now Components (tServiceNowConnection)

Anonymous — Wed, 07 Mar 2018 14:15:02 GMT

This may be more of a how-to question - but I was wondering if anyone has any experience using the Service Now Components available in Talend Integration Services?

Re: Service Now Components (tServiceNowConnection)

Anonymous — Fri, 09 Mar 2018 06:52:01 GMT

Hello,

Here is online document about:TalendHelpCenter: ServiceNow components

Do you have some problem when use tServiceNowConnection component in talend?

Best regards

Sabrina

Re: Service Now Components (tServiceNowConnection)

rsaliba1122 — Tue, 20 Mar 2018 19:38:37 GMT

Yes - I have read the documentation. Sounds straight forward however I have been unsuccessful making a connection. I was wondering if there are any configurations, like certificates or anything that need to be installed on the server or workstation? Thanks for you help

Re: Service Now Components (tServiceNowConnection)

rsaliba1122 — Wed, 21 Mar 2018 15:04:00 GMT

Here is the error I get when I try a Service Now Connections? Any idea what is causing that? Seems like there may be a certificate needed?

Starting job zzzServiceNowDemo at 10:52 21/03/2018.

[statistics] connecting to socket on port 3680
[statistics] connected
Exception in component tServiceNowConnection_1
[FATAL] 2018-03-21 10:52:12,041: epic_data_migration.zzzservicenowdemo_0_1.zzzServiceNowDemo - tServiceNowConnection_1 sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at sun.security.ssl.Alerts.getSSLException(Unknown Source)
at sun.security.ssl.SSLSocketImpl.fatal(Unknown Source)
at sun.security.ssl.Handshaker.fatalSE(Unknown Source)
at sun.security.ssl.Handshaker.fatalSE(Unknown Source)
at sun.security.ssl.ClientHandshaker.serverCertificate(Unknown Source)
at sun.security.ssl.ClientHandshaker.processMessage(Unknown Source)
at sun.security.ssl.Handshaker.processLoop(Unknown Source)
at sun.security.ssl.Handshaker.process_record(Unknown Source)
at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
at sun.security.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at org.apache.http.conn.ssl.SSLConnectionSocketFactory.connectSocket(SSLConnectionSocketFactory.java:261)
at org.apache.http.impl.conn.HttpClientConnectionOperator.connect(HttpClientConnectionOperator.java:118)
at org.apache.http.impl.conn.PoolingHttpClientConnectionManager.connect(PoolingHttpClientConnectionManager.java:314)
[statistics] disconnected
at org.apache.http.impl.execchain.MainClientExec.establishRoute(MainClientExec.java:357)
at org.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:218)
at org.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:194)
at org.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:85)
at org.apache.http.impl.execchain.RedirectExec.execute(RedirectExec.java:108)
at org.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:186)
at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:82)
at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:106)
at epic_data_migration.zzzservicenowdemo_0_1.zzzServiceNowDemo.tServiceNowConnection_1Process(zzzServiceNowDemo.java:731)
at epic_data_migration.zzzservicenowdemo_0_1.zzzServiceNowDemo.runJobInTOS(zzzServiceNowDemo.java:5103)
at epic_data_migration.zzzservicenowdemo_0_1.zzzServiceNowDemo.main(zzzServiceNowDemo.java:4846)
Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at sun.security.validator.PKIXValidator.doBuild(Unknown Source)
at sun.security.validator.PKIXValidator.engineValidate(Unknown Source)
at sun.security.validator.Validator.validate(Unknown Source)
at sun.security.ssl.X509TrustManagerImpl.validate(Unknown Source)
at sun.security.ssl.X509TrustManagerImpl.checkTrusted(Unknown Source)
at sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(Unknown Source)
... 22 more
Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at sun.security.provider.certpath.SunCertPathBuilder.build(Unknown Source)
at sun.security.provider.certpath.SunCertPathBuilder.engineBuild(Unknown Source)
at java.security.cert.CertPathBuilder.build(Unknown Source)
... 28 more
Job zzzServiceNowDemo ended at 10:52 21/03/2018. [exit code=1]

Re: Service Now Components (tServiceNowConnection)

Anonymous — Thu, 22 Mar 2018 08:31:19 GMT

Hello,

It indicates that your Service Now instance requires certification.

Usually, we use tSetKeystore component to load the cert before you connect to Service Now instance using tServiceNowConnection.

Best regards

Sabrina

Re: Service Now Components (tServiceNowConnection)

sonalijagtap — Fri, 26 Oct 2018 08:03:15 GMT

Hi,

I am getting below error while connecting via Talend. But when I am tring using Browser, it is working fine. Auto login is there in browser.

Please let me know your comments.

Re: Service Now Components (tServiceNowConnection)

sonalijagtap — Fri, 26 Oct 2018 14:35:30 GMT

Hi,

But I am not aware of where this certificate is stored &also the credentials for the same.

My credentials to connect to service now are autopopulated in browser. So I am not sure about this certificate.

Could you please help me here with the details.?

Thanks,
Sonali Jagtap

Re: Service Now Components (tServiceNowConnection)

rsaliba1122 — Fri, 26 Oct 2018 14:44:30 GMT

For us, we got the cert from our service now web site. Then we stored it in a share folder and point the talend component to it. To see the cert, left click on the little lock or info icon on the left (in chrome) next to the url in your browser. You can then export it.

Re: Service Now Components (tServiceNowConnection)

sonalijagtap — Fri, 26 Oct 2018 15:01:38 GMT

Thank you so much for the quick reply.

In the component, it is asking password. Is it mandatory field, then what is the password? Is it the same as service now?

Thank you,
Sonali Jagtap

Re: Service Now Components (tServiceNowConnection)

rsaliba1122 — Fri, 26 Oct 2018 15:03:33 GMT

we had to set up a special user just for the purpose

Re: Service Now Components (tServiceNowConnection)

sonalijagtap — Mon, 19 Nov 2018 13:24:56 GMT

Hi,

When I am trying to save the certificate from site, it's extension is .cer but in the tsetkeystore, it is asking for
.Truststore &.keystore files.

How this files are generated?

Thanks,
Sonali Jagtap

Re: Service Now Components (tServiceNowConnection)

rsaliba1122 — Mon, 19 Nov 2018 14:22:03 GMT

The steps I took to make the ServiceNow component work:

1. Download the certificate for service-now using a browser (you can easily google how to do this). I initially downloaded the cert given from my laptop and it was different from my virtual machine that was running Talend, so be careful of this. I named the cert "servicenow_zscaler.cer".
2. Using command line
* Browse to a directory that you want to create the truststore
* Run keytool -import -file "servicenow_zscaler.cer" -alias servicenow_zscaler -keystore talend_truststore -storepass talend
* This should have created a file called talend_truststore in your current directory
3. Created a job that used this truststore with the Talend tSetKeystore component.
4. Configured tServiceNowInput normally and ran the job

[cid:image001.jpg@01D47FE9.4B0FC820]

Re: Service Now Components (tServiceNowConnection)

sonalijagtap — Thu, 22 Nov 2018 12:41:15 GMT

Re: Service Now Components (tServiceNowConnection)

sonalijagtap — Thu, 22 Nov 2018 12:42:44 GMT

Hi,

Now I am connected to ServiceNow, But while retrieving the data from Incident table, I am getting the attached error.

Kindly let me know your comments

Re: Service Now Components (tServiceNowConnection)

rsaliba1122 — Mon, 26 Nov 2018 13:30:29 GMT

You still need to have a keystore component pointing to your Certificate prior to your Service Now Connection

Something like this

Re: Service Now Components (tServiceNowConnection)

Yuagen0 — Fri, 30 Jun 2023 01:02:46 GMT

I tried many time with Tsetkeystore and Tservicenowconnection, It still will be display the below error message. I have already done for create the JKS file and import the certificate to the JKS file. May I know who can give me any tips for this issue?

Exception in component tServiceNowConnection_1 (testserver)

javax.net.ssl.SSLException: java.net.SocketException: Connection reset

at sun.security.ssl.Alert.createSSLException(Unknown Source)

at sun.security.ssl.TransportContext.fatal(Unknown Source)

Re: Service Now Components (tServiceNowConnection)

Anonymous — Fri, 30 Jun 2023 07:10:09 GMT

Hello,

It looks like you are using a proxy on your machine.

Are you able to run requests with tRestClient successfully?

Best regards

Sabrina

Re: Service Now Components (tServiceNowConnection)

Yuagen0 — Fri, 30 Jun 2023 07:52:35 GMT

I didn't try it with tRestClient! but I'm not sure we have proxy . May I know which information can see using proxy?