This tutorial shows you how to load XML data into a table using query transform in SAP BO Data Services.

Steps:

  • 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”.
  • Validate & Run the Job .
  • View the output table to confirm.