read xml values in variables or textfile

 4 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Raza
New Member
Posts: 3
New Member

    i want to read an xml file with process flow and transfer the values to either variables or a csv file

    please guide me how i can do that

    kdcoate
    Veteran Member
    Posts: 44
    Veteran Member
      I created a data map using the datastage (formerly mercator) product to translate xml files into csv format and then execute the data map within processflow. I then use the file and data iterator nodes to manipulate the csv file. It's working well. I tried using the xml node but couldn't get it to work.
      Raza
      New Member
      Posts: 3
      New Member

        thanks KDCOATE appreciate it
        so does that mean we do not have any way doing that read process just by process flow itself by using xml node
        and can we do that data mapping with any other software like biztalk or gentran
        can you please tell me how we can use those data maps with in the processflow
        regards

        Gary Davies
        Veteran Member
        Posts: 248
        Veteran Member

          No, it is actually very easy to do this. The only "difficult" part is creating the schema (xsd) to map the data, I have done dozens of these. There are good resources on the internet on how to create XML schemas.

          Raza
          New Member
          Posts: 3
          New Member
            thanks gary,
            i have actually created the schema and also created an XML file from the data that i pulled from a table using the query node.
            i am having a problem reading a xml file and extracting the data from that XML file to a csv or in variables
            it will be a great help for me if you can guide me to those articles or the link of a website or thread where this option is discussed
            regards