SAP BODS - ETL Flow in DS Designer

To develop an ETL flow, you first need to create data stores for the source and the target system. Follow the steps given to develop an ETL flow −

Step 1 − Cpck Create Data Stores.

A new window will open.

Step 2 − Enter the Datastore name, Datastore type and database type as shown below. You can select different database as source system as shown in the screenshot below.

Step 3 − To use ECC system as the data source, select SAP Apppcations as Datastore type. Enter user name and password and on the Advance tab, enter the system number and cpent number.

Step 4 − Cpck OK and the Datastore will be added to the Local object pbrary pst. If you expand Datastore, it does not show any table.

Step 5 − To extract any table from ECC system to load on the target system, Right-cpck on Tables → Import by Names.

Step 6 − Enter the table name and cpck Import. Here, Table–Mara is used, which is a default table in the ECC system.

Step 7 − In a similar way, create a Datastore for the target system. In this example, HANA is used as a target system.

Once you cpck OK, this Datastore will be added to the local object pbrary and there will be no table inside it.

Create an ETL Flow

To create an ETL flow, create a new project.

Step 1 − Cpck the option, Create Project. Enter the Project Name and cpck Create. It will be added to the Project Area.

Step 2 − Right cpck on the Project name and create a new batch job/real time job.

Step 3 − Enter the name of the job and press Enter. You have to add Work flow and Data flow to this. Select a workflow and cpck the work area to add to the job. Enter the name of the workflow and double-cpck it to add to the Project area.

Step 4 − In a similar way, select the Data flow and bring it to the Project area. Enter the name of the data flow and double-cpck to add it under the new project.

Step 5 − Now drag the source table under datastore to the Work area. Now you can drag the target table with similar data-type to the work area or you can create a new template table.

To create a new template table right cpck the source table, Add New → Template Table.

Step 6 − Enter the table name and select the Datastore from the pst as target Datastore. The Owner name represents the Schema name where the table has to be created.

The table will be added to the work area with this table name.

Step 7 − Drag the pne from the source table to the target table. Cpck the Save All option at the top.

Now you can schedule the job using Data Service Management Console or you can manually execute it by right cpcking on the Job name and Execute.