Service Now Components (tServiceNowConnection)

[Anonymous]

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?

[Anonymous]

Hello,

Here is online document about:TalendHelpCenter: ServiceNow components

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

Best regards

Sabrina

 

[rsaliba1122]

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

[rsaliba1122]

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]

[Anonymous · Accepted solution]

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

[sonalijagtap]

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.

[sonalijagtap]

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

[rsaliba1122]

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.

[sonalijagtap]

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

[rsaliba1122]

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