Staging for SAP HANA - DSS 6 | Data Source Solutions Documentation

Documentation: Staging for SAP HANA - DSS 6 | Data Source Solutions Documentation

Staging for SAP HANA

While running Burst Integrate and Bulk Refresh, Data Source Solutions DSS can put data into a temporary directory (‘staging file') before loading data into a target database.

For best performance, DSS performs Burst Integrate and Bulk Refresh into SAP HANA using staging files. DSS implements the file staging in SAP HANA as follows:

DSS first writes data into the local staging directory on the machine from where DSS connects to SAP HANA.
DSS then uses the SAP HANA SQL command <b>import</b> to ingest the data into the SAP HANA target tables from the staging directory.

Configuring Staging

DSS must be configured to stage data on the local directory before loading it into SAP HANA. For staging the data on local directory and perform Burst Integrate and Bulk Refresh into SAP HANA, the following are required:

Define the following location properties (while creating a location or by editing the existing location's source and target properties) for the SAP HANA location:

The Location Property equivalent to the UI field is shown inside (bracket) below.

1.  **Staging Directory Is Local** ([**Staging_Directory_Is_Local**](/docs/dss6-property-reference-location-properties#stagingdirectoryislocal)): Indicates that staging files are created in the local directory. This field is automatically selected by default and it cannot be unselected.

2.  **STAGING DIRECTORY** ([**Staging_Directory**](/docs/dss6-property-reference-location-properties#stagingdirectory)): local directory path where DSS will create the temporary staging files (e.g. **/my_staging_dir**).

3.  **STAGING DIRECTORY AS VISIBLE FROM THE DATABASE** ([**Staging_Directory_Database**](/docs/dss6-property-reference-location-properties#stagingdirectorydatabase)): directory path from where SAP HANA will access the temporary staging files (e.g. **/my_staging_dir**). This path must be configured in SAP HANA for importing data,
    ```shell
    alter system alter configuration ('indexserver.ini', 'system') set ('import_export', 'csv_import_path_filter') = '<em>Staging_Path</em>' with reconfigure
    ```

<details><summary>Sample screenshot</summary>

![SC-Dss-SrcTgtReq-HANA-Staging_Local.webp](/static/docs/docs/dss6/requirements/source-and-target-requirements/sap-hana-requirements/sap-hana-as-target/staging-for-sap-hana/_assets/SC-Dss-SrcTgtReq-HANA-Staging_Local.webp)

</details>