HANA学院(2)-使用数据服务(use data services)

1. To use Data Services to load XML file to HANA

1.1 log in the Data Services Designer- Down left-file-DTD-NEW- with the name STS

 MATERIAL MASTER LIST CAN be found in first line of DTD file.

1.2 Create a project in the up left and create a job.- create a dataflow in the right- double click and drag STS- double click and choose the xml file- save

1.3  add a query transform and unnest.

1.3.1 drag the table  from schema in to schema out

1.3.2 right click the node and make current and unnest.

1.4 add another query transform

1.4.1 create a primary key.

1.5 add a template table 

1.6 execute the job

( to be finished)