• Blog
  • Talend DI
  • Accessing secured REST web services from a Talend job
Monday, 09 February 2015 15:58

Accessing secured REST web services from a Talend job

Written by
Rate this item
(3 votes)

Accessing secured web services from a Talend job requires that the jvm authenticate with a trust store file (.jks). Failing to do so results in a java.lang.Exception: nulljavax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed exception. The solution is to configure the Talend job to present a jks file when accessing the service.

This error indicates that the JVM that’s created (to run the Talend job) is denied access to the web service because it does not present a valid SSL certificate. What you'd have to do is to define a JKS (java key store) location for the JVM as follows (Run tab in Talend job):

 -Djavax.net.ssl.trustStore=/usr/local/tlnd/myapptruststore.jks

a6

 So how do you create a jks file that will allow your  job to run?

Go to the URL that you need to access. Right click and inspect the certificate, click on Certificate information.

 a1

 Go to the Details tab and click on Copy File... follow the wizard prompts. 

Finally, save the file as .cer.

a3

 Then run the following commands to create the jks file (from a QA_root_CA_v2.cer certificate file):

  • "C:\Program Files\Java\jdk1.7.0_71\jre\bin\keytool" -genkey -keyalg RSA -alias selfsigned -keystore myapptruststore.jks -storepass changeit -validity 3600 -keysize 2048
  • "C:\Program Files\Java\jdk1.7.0_71\jre\bin\keytool" -import -trustcacerts -alias myapptruststore -file C:\WMunji\QA_root_CA_v2.cer -keystore C:\WMunji\myapptruststore.jks

  To import the certificate into the existing cacerts trust store:

  • Checked JAVA_HOME on my machine – which is what Talend would be using to create a JVM. 
  • Locate the cacerts file - C:\Program Files\Java\jdk1.7.0_45\jre\lib\security\cacerts
  • Right-click, select Properties , go to Security tab and ensure you have permissions to edit the file – if not, give yourself full-control on the file
  • Install the certificates: "C:\Program Files\Java\jdk1.7.0_45\jre\bin\keytool" -importkeystore -srckeystore C:\opt\isv\myapptruststore.jks -destkeystore "C:\Program Files\Java\jdk1.7.0_45\jre\lib\security\cacerts"
  • List the certificates in your trust store to confirm, by running: "C:\Program Files\Java\jdk1.7.0_45\jre\bin\keytool" -list -keystore "C:\Program Files\Java\jdk1.7.0_45\jre\lib\security\cacerts"

 

Read 5352 times Last modified on Tuesday, 09 February 2016 19:59
Will Munji

Will Munji is a seasoned data integration, data warehousing and business intelligence (BI) architect & developer who has been working in the DW/BI space for a while. He got his start in BI working on Brio SQR (later Hyperion SQR) and the Crystal Decisions stack (Reports, Analysis & Enterprise) and SAP BusinessObjects / Microsoft BI stacks. He currently focuses on Talend Data Management Suite, Hadoop, SAP BusinessObjects BI stack as well as Jaspersoft and Tableau. He has consulted for many organizations across a variety of industries including healthcare, manufacturing, retail, insurance and banking. At Kindle Consulting, Will delivers DW/BI/Data Integration solutions that range from front-end BI development (dashboards, reports, cube development, T-SQL/ PL/SQL ...) to data services (ETL/ DI development), data warehouse architecture and development, data integration to BI Architecture design and deployment.

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.

Contact Us

Kindle Consulting, Inc

6595 Roswell Road 
Suite G2025 
Atlanta, GA 30328

Phone: 404.551.5494
Fax: 404.551.5452
Email: info@kindleconsulting.com

Talend Gold Partner