Show TOC

Dynamic Tiering (HANA)Locate this document in the navigation structure

You can define an extended storage for your HANA database, which is an external SAP IQ database automatically used to transparently archive and query data stored in extended tables. Extended tables are physically located in the SAP IQ server, but logically sit in HANA and can be used as if they were regular HANA tables.

Procedure

  1. Open the model property sheet, and click the Create Extended Storage button to the right of the Extended storage field.
  2. Click the Properties button to open the extended storage property sheet and enter the following properties:

    Name

    Description

    Name/Code/Comment

    Identify the object. The name should clearly convey the object's purpose to non-technical users, while the code, which is used for generating code or scripts, may be abbreviated, and should not normally include spaces. You can optionally add a comment to provide more detailed information about the object. By default the code is generated from the name by applying the naming conventions specified in the model options. To decouple name-code synchronization, click to release the = button to the right of the Code field.

    Scripting name: Name, Code, Comment

    Configuration

    Specifies the connection parameters for the adapter.

    Scripting name: ESConfiguration

    Credential type / Credentials

    Specifies the type of credentials required (currently only password) and the credentials to use

    Scripting name: ESCredentialType, ESCredentials

    Keywords

    Provide a way of loosely grouping objects through tagging. To enter multiple keywords, separate them with commas.

    Scripting name: Keywords

  3. To specify that a table should be located in the extended storage, simply check the Using extended storage option on the HANA tab of the table property sheet.