The DTS SAP Hana Connector fully supports all tables (column-based and row-based) and views in SAP Hana and does not differentiate between them in any meaningful way.
DTS Naming
DTS Name |
<table_or_view_name> |
DTS Key |
<schema_name>.<table_or_view_name> |
Metadata
The connector is also capable of extracting metadata regarding the table/view columns:
▪DATA_TYPE_NAME
▪LENGTH
▪SCALE
▪DEFAULT_VALUE
▪IS_NULLABLE
▪POSITION
▪CONSTRAINT -> PRIMARY_KEY
Standard functionality only makes use of DATA_TYPE_NAME, POSITION and PRIMARY_KEY, but the other items are available for extension in DTS descriptor objects.
Structured types (table types) are not supported as column data types by SAP HANA, only native and array types are. Please see Types for information of how the connector handles these.