SAP HANA - Studio Import (CSV|Flat File)

About

The import of CSV file with Studio

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 important>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.

Documentation / Reference


Powered by ComboStrap