Service Now Components (tServiceNowConnection)

Four Stars

Service Now Components (tServiceNowConnection)

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?


Accepted Solutions
Moderator

Re: Service Now Components (tServiceNowConnection)

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

 

 
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

All Replies
Moderator

Re: Service Now Components (tServiceNowConnection)

Hello,

Here is online document about:TalendHelpCenter: ServiceNow components

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

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Service Now Components (tServiceNowConnection)

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

Four Stars

Re: Service Now Components (tServiceNowConnection)

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]

Moderator

Re: Service Now Components (tServiceNowConnection)

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

 

 
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Service Now Components (tServiceNowConnection)

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.

 

Capture.PNG

Six Stars

Re: Service Now Components (tServiceNowConnection)

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
Four Stars

Re: Service Now Components (tServiceNowConnection)

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.

Six Stars

Re: Service Now Components (tServiceNowConnection)

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
Four Stars

Re: Service Now Components (tServiceNowConnection)

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

Re: Service Now Components (tServiceNowConnection)

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

Four Stars

Re: Service Now Components (tServiceNowConnection)

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]


Six Stars

Re: Service Now Components (tServiceNowConnection)

Capture.PNG

Six Stars

Re: Service Now Components (tServiceNowConnection)

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
Four Stars

Re: Service Now Components (tServiceNowConnection)

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

 

Something like this

KeyStore.JPG

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download