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

Steps:

  • Open Data services
  • Create a new job
  • Go to the File Format tab in the left , Right click select new to create a new file format
  • In the new window Enter the File format name , Select File name to select the text file &
  • Change the skip row header column to Yes in order to show that first row in text file contains header names . Click on save & Close
  • 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 newly created file format as source, using drag & drop from the file format area.
  • Add a query item using drag & drop from the menu on the right
  • create a template table as output table, Enter the name of the table & the data store in which it needs to be created
  • connect the file format to the query object, connect the query object to the template table
  • Open the File format source and select the file name
  • Open the query object, drag & drop the columns to the output area
  • Run the job, view the output to confirm