Show TOC

Transferring Data from Flat FilesLocate this document in the navigation structure

Use

BW supports the transfer of data from flat files, files in ASCII format ( A merican S tandard C ode for I nformation I nterchange) or CSV format ( C omma S eparated V alue). For example, if budget planning for a company's branch offices is done in Microsoft Excel, this planning data can be loaded into BW so that a plan-actual comparison can be performed. The data for the flat file can be transferred to BW from a workstation or from an application server.

Process

  1. You define a file source system.

  2. You create a DataSource in BW, defining the metadata for your file in BW.

  3. You create an InfoPackage that includes the parameters for data transfer to the PSA.

The metadata update takes place in DataSource maintenance of BW.