Exporting HANA table to flat file using Data Services 4.1 only

[Former Member]

Very Urgent    

I need to export a HANA table to a flat file using data services only since the job needs to be scheduled. I also need to add two empty columns to the file. I searched but found videos to load from flat file to HANA and not the other way around.

Please write in detail how to do it. Really appreciated.

Thanks in advance

[former_member187605]

1. Start by building a dataflow with your HANA table as a source and a query transform.
2. Open the query transform, drag and drop all columns from input to output schema.
3. Add 2 extra columns to the output schema (right-click on a column and select "New output column..."
4. Create a flat file format from a Query (http://wiki.scn.sap.com/wiki/display/EIM/How+to+create+a+flat+file+format+from+a+Query)
5. Drag and drop the file format into the dataflow. Connect the dots.