Show TOC

Smart Data Access (HANA)Locate this document in the navigation structure

With SAP HANA Smart Data Access, data can be merged in heterogeneous EDW landscapes (data federation), making it possible to access data in remote sources without having to replicate it to the SAP HANA database beforehand. PowerDesigner models virtual tables as tables with a stereotype of VirtualTable and remote sources as extended objects with a stereotype of RemoteSource.

Procedure

  1. Prepare the PDM containing the source table and have it open in your workspace.
  2. In the HANA PDM, select the Virtual Table tool and click in the diagram at the model root.
  3. In the object picker, select the source table and click OK.

    PowerDesigner creates the virtual table and links it to a remote source initialized to point to the source PDM.

  4. Open the virtual table property sheet tab, click the Properties tool to the right of the Remote source field to open the remote source property sheet, and complete the properties of the remote source:

    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

    Adapter

    Specifies the adapter, and the type of access method to be used by the SAP HANA database to access the data.

    Scripting name: RSAdapter

    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

    Model

    Specifies the PDM that contains the definition of the remote source.

    Scripting name: RSPDM

    Keywords

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

    Scripting name: Keywords