Implementing Table Reader Transform in BODS

Table Reader:

• Table reader is used to read data from a data store table.

Steps :-

• Right click on Project -> New -> Data Flow.

• Provide Name and Description. 

• Drag and drop Table Reader to Data Flow Editor.

• Select Source System and click on OK.

• Select CE1IDEA table and click on  OK.

• Click on OK.

• Drag and drop Query transform to data flow editor.

• Join CE1IDEA  table to Query transform.

• Drag and drop CE1IDEA input fields which are require to Query output.

• Drag and drop Template Table to Data Flow Editor.

• Select Target system and click on OK.

• Enter Table owner and Table name.
• Click on OK .

• Join Query Transform to template Table.

• Click on save.

• Click on validate.

• Pop-up will appear " Validation result is successful ".

• Click on Close.

 

• Click on execute.

• Select the job Server and Click on Finish.

• Job execution is success.

• Click on view trace log.

• Right click on Template Table -> Click on view data.

• Raw data.

• Go to SAP-HANA  studio.
• Expand System ->  Catalog ->  Tables.

• Right click on Table -> Filter.
• Click on Table.

• Right click on Table -> click on data preview.

• Raw data