Transferring Data from Flat Files 

Purpose

BI supports the transfer of data from flat files, files in ASCII format (American Standard Code for Information Interchange) or CSV format (Comma Separated Value). For example, if budget planning for a company’s branch offices is done in Microsoft Excel, this planning data can be loaded into BI so that a plan-actual comparison can be performed. The data for the flat file can be transferred to BI from a workstation or from an application server.

Process Flow

...

       1.      You define a file source system.

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

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

The metadata update takes place in DataSource maintenance of BI.