SAP BO Data Services Tutorial: sql operation

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.

By Driven By Analytics|2018-05-21T16:57:06+01:00March 20th, 2019|Data Services|

About the Author: Driven By Analytics

Driven By Analytics provides solutions for ETL tool conversions and database migrations. Please visit our homepage or contact us directly to know more!

All the information on this website is published in good faith and for general information purpose only. We do not make any warranties about the completeness, reliability and accuracy of this information. Any action you take upon the information on our website is strictly at your own risk. We will not be liable for any losses and damages in connection with the use of our website. From our website, you can visit other websites by following hyperlinks to these sites. While we strive to provide only links to useful and ethical websites, we have no control over the content and nature of these sites and the links to other websites do not imply a recommendation for all the content found on these sites. Please be also aware that when you leave our website, other sites may have different privacy policies and terms which are beyond our control. Finally, although we offer products relating to other IT vendors, we are in no way affiliated with these vendors. The content on this site, and products and services offered here is owned and maintained by Driven By Analytics AS, Norway.

SAP BO Data Services Tutorial: sql operation