This tutorial shows you how to load data from a table to an xml file 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
  • Add the data source table, using drag & drop from the datastore area.
  • Add a query item using drag & drop from the menu on the right
  • Add a Nested Schema Template from the Menu in the Right, Name it.

    • connect Source table to the Query object, connect the query object to the Nested Schema object

  • Open the query object, drag & drop the columns required to the output area.
  • Open the Nested Schema object & provide the file location.
  • Validate & Run the Job.
  • View the output xml file to confirm