Loading Master data from flat file

1. Create flat file

create a flat file in excel as given below and save it as csv file

2. Create DataSource

select our source system and double click on it.. in our case "Cloud flat file".

which will take us to Datasource screen..

create an application component for our exercise.. application component is simply a folder

Now you can see that our application component is created in the list

Now create data source from the context menu of our application component

give a technical name for datadource and select master data attributes as data type.

Then click on OK..

Now our Datasource is created.. Now we should configure it... below screen is the configuration screen

In the extraction tab.. mention the directory and name of the source file

Give the header rows to be ignored as " 1 ".
data format as " CSV "
data seperator as " , "
escape sign as " ; "

click on load Example data

We can see our flat file data here

Now click on fields tab

Here we can see all the proposed fields of DataSource.

Click on Preview

click on preview data

Click on Activate

Now our DataSource is created and activated

3. Create InfoPackage

From the context menu of our datasource choose create infopackage..

click on save button

As we can see , our infopackage is created below our datasource.. now we need to configure it..

we don't need to do much as of now... click on schedule tab..

and click on start button.. this action will start pulling data from our source file to our datasource..

now click on monitor button...

we can see 5 records are successfully moved..

4. Create target (infoprovider)

As we are dealing with master data now... our infoprovider is InfoObject..
we always store master data in infoobjects..

So we should create an infoobject to store the customer master file..

now click on infoprovider on the left panel..

Now we need to create an infoarea.. infoarea is just a folder .. same as application component..

as you can see our practise area is being created..
Now click on infoobjects in the left panel..

create infooject catalog from context menu of our infoarea..

we have two types of infoobject...
charateristics infoobject
keyfigure infoobject

click on activate

now lets create infoobject catalog for keyfigures..

click on activate

Now lets create infoobject for customer

give datatype as "char"
and give the needed length of the field.

In our example "Customer id " is an entity and " customer name " "customer address" and " customer phone" are attributes..

so we should define the attributes for "customer id"..

click on attributes tab..

now add all the attributes to that list..

we can give any technical name... when we press enter after adding all technical names... we will be prompted to create all the attributes...

Now click on activate...

actiavte all dependent objects

after activation we can see that all dependent objects are now in green color..

all the infoobjects needed are created now...

now click on infoprovider and assign our infoobject "zcust2" as target..

now our target is ready...

5. Create transformation

Click on datasources on the left panel... from the context menu of our datasource create transformation..

give the source and target..

Table in lefts is source and table in right is target..

Map the source to target..

No activate this transformation..

portion highlighted in green is transformation..

6. Create DTP

Create DTP from the context menu of Data Transfer Process

Give the source and target

and click ok..

Click on Execute tab..

Click on activate

click on execute button..

We can see that 5 records have been moved to our target...

our process of moving master data from a flat file to our target (infoobject) is complete...

now lets go and check our data in our target..