SAP HANA Smart Data Access (SDA) for Near-Line Storage in SAP IQ

If you are running an SAP HANA database, you can use SAP HANA Smart Data Access (SDA) to access your data in SAP IQ near-line storage.

Prerequisites

You have installed SAP HANA Support Package Stack 06.

The technical content must be installed in the BW system.

You need the following authorization in SAP HANA:

  • System privilege: CREATE REMOTE SOURCE
If the remote source is not created with the SAP<SID> user but with a different database user instead, then this database user must assign the corresponding object authorizations to the SAP<SID> user:
  • Object privilege: CREATE VIRTUAL TABLE on VIRTUAL_TABLES (SYS)
  • Object privilege: DROP on VIRTUAL_TABLES (SYS)

Context

SAP HANA Smart Data Access enables you to access remote data, without needing to replicate the data in the SAP HANA database beforehand. This improves performance for queries, which use a lot of a navigation attributes and hierarchies. More information: SAP HANA Smart Data Access

Procedure

  1. Create a remote source in SAP HANA Studio.
    More information: Creating a Remote Source in SAP HANA Studio
  2. Assign the remote source to the near-line storage connection.
    More information: Assigning a Remote Source to the Near-Line Connection
  3. Reactivate the data archiving process.
    More information: (Re-)Activating Data Archiving Processes