This tutorial shows you how to load data from a database table to a simple text 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 the 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.
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.