SAP HANA - Studio Import (CSV|Flat File)
About
The import of CSV file with Studio
Articles Related
Format
The format follows the CSV specification which is only an American one with the following characteristics:
- Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
- Decimal separator must be a point
- Field separator must be a comma (It can be chosen but the locale has no influence on it)
Steps
- Studio > Show View > Quick View
- Click On Import
- Sap Hana Content > Data From Local File > Next
- Target System > Select > Next
- Import Properties (<note>Don't check the “Import All Data” if you have an header. Otherwise Studio will attempt to load the header also and you can get into troubles. If you have a date column for instance with a text header, the import utility will not recognize a date in you header and will throw an exception (error)</note>
- Manage Table Definitions and Data Mappings: Select the mapping:
- One by one (Index mapping, the first column in the falt file will be the first column of the table),
- Map by Name (The column with the same name in the flat file will be mapped with the column of the same name in the table)
- Manage Table Definitions and Data Mappings: Change the data type and others parameters if needed > Next
- Summary Finish
Log
- You can follow the import with the Job Log perspective on the current tab
- With a double click on the row, you get more details:
- When running
- When finished:
This information is also persist in the history tab.
Support
Batch from record 2 to … failed: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
Don't check import all data when you have an header. Otherwise it will try to import the header and you will get this kind of error.