This tutorial shows you how to load XML data into a table using query transform in SAP BO Data Services.
Open Data services
Create a new job
Create a new dataflow – drag & drop from the menu on the right.
Go to the Formats tab and Under Nested Schemas , Right Click and select new -> XML schema .
In the new Window, enter format name , Select the xsd associated with the xml file and from the Root element name drop down select the name of the root element associated with your xml file.
Drag and drop the newly created file format & make it file source.
Open the File Format source and select the xml file name .
Add a template table as a target , using drag & drop from the datastore area , name the table and select the associated datastore.
Add a query object using drag & drop from the menu on the right.
Connect File format source to the query object, connect the query object to the template table object.
Open the query object,drag & drop the columns required to the output area. Right click the node in the Output window and select “Make Current” & then select each node and select “Unnest with Sub Schemas”.
All the information on this website is published in good faith and for general information purpose only. We do not make any warranties about the completeness, reliability and accuracy of this information. Any action you take upon the information on our website is strictly at your own risk. We will not be liable for any losses and damages in connection with the use of our website. From our website, you can visit other websites by following hyperlinks to these sites. While we strive to provide only links to useful and ethical websites, we have no control over the content and nature of these sites and the links to other websites do not imply a recommendation for all the content found on these sites. Please be also aware that when you leave our website, other sites may have different privacy policies and terms which are beyond our control.
Finally, although we offer products relating to other IT vendors, we are in no way affiliated with these vendors. The content on this site, and products and services offered here is owned and maintained by Driven By Analytics AS, Norway.