(SM-2202) HANA Native SQL

Owned by SNP
Feb 03, 2022
1 min read

Storage setup

  • Storage ID: Storage name

  • Storage Type: Type of storage; use the storage type "SM_TRS_HNV" for Hana Native storage

  • Description: Short text description

  • DB Connection Name: Existing SAP database connection

  • Hana database table type:

    • COLUMN - Column table type

    • ROW - Row table type

    • HIST_COL - History column table type

    • GL_TMP - Global temporary table type

    • GL_TMP_COL - Global temporary column table type

    • LC_TMP - Local temporary table type

    • LC_TMP_COL - Local temporary column table type

  • Activate bulk insert: Activates insert in bulk using .csv files

  • File storage(Bulk insert): Existing file storage (represents a shared folder that is accessible from both application and database server)

Bulk Insert

Bulk insert uses compressed .csv files to mass insert data into HANA tables.

This approach is significantly faster than standard SQL insert but there are few prerequisites listed below.

Prerequisites

  1. Configure a shared folder(mountpoint that needs to be accessible from both source system application server and HANA DB server itself with sufficient rights).

  2. Configure file storage on the shared folder.

  3. Enable .csv import path filter via configuration tab of HANA Administration Console

    • File: indexserver.ini

    • Section: import_export

    • Key: enable_csv_import_path_filter

    • Value: true

  4. Specify import path in the following INI configuration parameter

    • File: indexserver.ini

    • Section: import_export

    • Key: csv_import_path_filter

    • Value: <absolute directory path>[;<absolute directory path>]*