Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: PDI Challenge

  1. #1
    Join Date
    Dec 2017
    Posts
    1

    Default PDI Challenge

    Here is what I have to accomplish.

    1. I have an XML file, I want to parse that XML file and get all the details for an ID. (Not able to accomplish this first step)
    2. I need to store that ID details from STEP 1 and need to pass that ID one at a time to another XML file from a web service call to get Task/user details.
    3. Need to check User against the LDAP to check if that user is a human user.
    4. if yes, then need to combine data gathered from 1 & 2 for meeting condition in Step 3 and pass the value back to java api through a web service call...

    I would appreciate if someone can help me with this.

    Thanks
    S


    I am using PDI 8.0

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Quote Originally Posted by sanka View Post
    I have an XML file, I want to parse that XML file and get all the details for an ID. (Not able to accomplish this first step)
    You can choose between Get-Data-From-XML (DOM parser) and XML-Input-Stream (StAX parser).
    I recommend to use the DOM parser as long as you don't run into memory problems.
    In case you didn't find them, yet: There are sample transformations in your PDI installation folder you can study.

    Good luck.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.