...
Support table name longer than 16 characters
DP name HTAB*generated_hash* will be created. On the main screen, the user can change the view with
DP Description button to see the name of Hana native table in the description
Support table fields longer than 30 characters
The long field is cut or replaced with a field with count (fieldname_count)
Relative condition
Custom target table name
After defining target storage, the user can define a custom target table name with the mandatory prefix ZOFF* which is automatically added to the name
Possible to offload Hana native table with the same name, but from different databases (schema)
if DP name is already defined, DP name will be automatically generated (HTAB*)
...
Source storage - HANA Native Storage type SM_TRS_HNV
...
DB Connection Name - You can find an existing
...
connections through the transaction DBCO
...
.
Target storage - Hadoop cluster (set up by the IT-Support, except for the SDA parameters)
SDA parameters
...
Metastore Storage type SM_TRS_MS
...
Set up SDA parameters:
Remote source name: Hadoop cluster
Database name: Database name
...
Schema: Database schema of the primary DB
...
Database connection: DB connection to external HANA database (transaction DBCO)
Smart Data Access (SDA): Remote source in source storage HANA
...
databas
Before you set up the target storage, you must check remote sources in the HANA studio. According to the below figure you should fill out SDA parameters in the target storage (figure above).
If there isn't Hadoop as a remote source, please contact IT-Support, who can create remote sources in HANA native.
...
1. Create a DataProvider of the type HANATAB
...
Source Storage - The field must be a Hana native storage (which you set up previously in /DVD/SM_SETUP)
DataProvider category
DataProvider name - Use search help to find a source table. Please note that the displayed tables are from external HANA
Target Storage - Hadoop (Hadoop storage with SDA parameters, which you set up previously in /DVD/SM_SETUP)
Target table name (optional) - table created in target storage, with mandatory prefix ZOFF*
...
...
The virtual table is created in this step and it is always saved into the schema, where the source table is defined.
...
Generated Calculation view in Hana native:
...
| Anchor | ||||
|---|---|---|---|---|
|
...