This tutorial shows you how to use the SQL operation in SAP BO Data Services.

Steps:

  • 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 a SQL Transformation , using drag & drop from the Transformation area.
  • Add a query object using drag & drop from the menu on the right.
  • Add a template table as a target in the Oracle DB Datastore, using drag & drop from the datastore area
  • connect SQL Transform to the Query object, connect the query object to the template table object.
  • Open the SQL Transform, Select the datastore from the drop down and then paste the SQL Query in the SQL Text Pane . Click on Update Schema and then validate the column names from the top window.
  • Open the query object, drag & drop the columns required to the output area.
  • Validate & Run the Job.
  • View the output table to confirm.