O'Reilly logo

SAP Data Services 4.x Cookbook by Ivan Shomnikov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required