SAP HANA - Studio Import (CSV|Flat File)

Sap Hana Architecture

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 (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)

Hana Studio Import Csv Properties

  • 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)

Hana Studio Import Csv Field Mapping

  • 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

Hana Studio Import Csv Job Log

  • With a double click on the row, you get more details:
    • When running

Hana Studio Import Csv Job Details Running

  • When finished:

Hana Studio Import Csv Job Details Finished

This information is also persist in the history tab. Hana Studio Job Log History

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







Share this page:
Follow us:
Task Runner