Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Read data from XML

  1. #1

    Default Read data from XML

    Hi,

    I want to use the Get Data from XML step to parse the attached XML file and extract this piece of information:

    Code:
    <property name="odaDriverClass">org.postgresql.Driver</property>
                <property name="odaURL">jdbc:postgresql://localhost:5432/</property>
                <property name="odaUser">postgres</property>
    and

    Code:
    <property name="odaDriverClass">org.postgresql.Driver</property>
    			<property name="odaURL">jdbc:postgresql://localhost:5432/</property>
    			<property name="odaUser">postgres123</property>
    In the end I want to write the URL and User to a csv file.
    But it looks like I am plain too stupid to create the proper XPath notation to extract those values. Can somebody please point me in the right direction how to do it properly?

    Bobse

    test - Copy.xml
    PDI 7
    Postgres
    Windows 7

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

    Default

    Here we go.
    Attached Files Attached Files
    So long, and thanks for all the fish.

  3. #3

    Default

    Do you accept donations to a charity as a token of gratitude?!
    PDI 7
    Postgres
    Windows 7

  4. #4
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Quote Originally Posted by Bobse View Post
    Do you accept donations to a charity as a token of gratitude?!
    I don't think marabu does... But there might be a numbered account in Switzerland that you could deposit it into...

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

    Default

    If only I could afford to hold such an account ...

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.