Loading data into a flat file

This recipe will teach you how to export information from a table into a flat file using Data Services.

Flat files are a popular choice when you need to store data externally for backup purposes or in order to transfer and feed it into another system or even send to another company.

The simplest file format usually describes a list of columns in specific order and a delimiter used to separate field values. In most cases, it's all you need. As you will see a bit later, Data Services has many extra configuration options available in the File Format object, allowing you to load the contents of the flat files into a database or export the data from a database table to a delimited text file.

How to do it…

  1. Create a new dataflow ...

Get SAP Data Services 4.x Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.