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.
PowerDesigner creates the virtual table and links it to a remote source initialized to point to the source PDM.
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 |