(SM-2411) HANA Native SQL

Owned by SNP
Nov 20, 2024
2 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 the insert in bulk using .csv files.

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

Bulk Insert

The 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 a few prerequisites listed below.

Prerequisites

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

  2. Configure file storage on the shared folder.

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

    • File: indexserver.ini

    • Section: import_export

    • Key: enable_csv_import_path_filter

    • Value: true

  4. Specify the 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>]*