This tutorial shows you how to load data from a table into a csv file in SAP BO Data Services.

Open Data services

  • create a new job
  • Create a new workflow – drag & drop from the menu on the right
  • Create a new dataflow – drag & drop from the menu on the right
  • Add table as source, using drag & drop from the datastore area.
  • Add a query item using drag & drop from the menu on the right
  • connect the Source Table to the query object
  • Open the query object, drag & drop the columns to the output area. Right Click on the output area & Select New File Format .
  • In the new File Format Findow Window , Enter the File path and File Name . Set Skip Row header value to yes in order to show up the column names

    • in the Output File . Take a note of the File format name and click on “Save & Close”

  • Drag & Drop the newly created File format from the File Format Tab in the Bottom left & Select as Target .
  • Connect the Query Object to the File Format target object.
  • Validate the Job.
  • Run the job, view the output file to confirm.