What does Atlan crawl from SAP HANA?
During a SAP HANA crawl, Atlan extracts metadata for Schemas, Tables, Views, Calculation Views, Functions, Stored Procedures, and User Defined Functions. Reference tables map each SAP HANA property to its Atlan asset.
Atlan extracts metadata for Schemas, Tables, Views, Calculation Views, Functions, Stored Procedures, and User Defined Functions from SAP HANA and maps each property to its internal asset model. The tables below list which SAP HANA properties are read and how they appear on the corresponding Atlan asset.
Schemas
Atlan maps schemas from SAP HANA to its Schema asset type.
| Source property | Atlan property |
|---|---|
SCHEMA_NAME | name |
TABLE_COUNT | tableCount |
VIEW_COUNT | viewsCount |
Tables
Atlan maps tables from SAP HANA to its Table asset type.
| Source property | Atlan property |
|---|---|
TABLE_NAME | name |
COMMENTS | description |
COLUMN_COUNT | columnCount |
ROW_COUNT | rowCount |
TABLE_SIZE | sizeBytes |
IS_PARTITIONED | isPartitioned |
IS_TEMPORARY | isTemporary |
Views
Atlan maps views from SAP HANA to its View asset type.
| Source property | Atlan property |
|---|---|
VIEW_NAME | name |
COMMENTS | description |
COLUMN_COUNT | columnCount |
DEFINITION | definition |
Calculation views
Atlan maps calculation views from SAP HANA to its CalculationView asset type. Atlan supports upstream lineage to source tables and calculation views. Column-level lineage is currently not supported.
| Source property | Atlan property |
|---|---|
OBJECT_NAME | name |
COLUMN_COUNT | columnCount |
VERSION_ID | calculationViewVersionId |
ACTIVATED_BY | calculationViewActivatedBy |
ACTIVATED_AT | calculationViewActivatedAt |
Columns
For tables and views
Atlan maps columns for tables and views from SAP HANA to its Column asset type.
| Source property | Atlan property |
|---|---|
COLUMN_NAME | name |
COMMENTS | description |
POSITION | order |
DATA_TYPE_NAME | dataType |
IS_NULLABLE | isNullable |
LENGTH | maxLength |
CONSTRAINT (PRIMARY KEY) | isPrimary |
REFERENCED_COLUMN_NAME | isForeign |
DECIMAL_DIGITS | precision |
SCALE | numericScale |
DEFAULT_VALUE | defaultValue |
For calculation views
Atlan maps columns for calculation views from SAP HANA to its Column asset type.
| Source property | Atlan property |
|---|---|
COLUMN_NAME | name |
LABEL | description |
ORDER | order |
COLUMN_SQL_TYPE | dataType |
| - | columnIsMeasure |
MEASURE_TYPE | columnMeasureType |
The columnIsMeasure property is derived as a Boolean value based on the MEASURE_TYPE field.
Functions
Atlan maps table functions from SAP HANA to its Function asset type.
| Source property | Atlan property |
|---|---|
FUNCTION_NAME | name |
FUNCTION_TYPE | functionType |
IS_ENCRYPTED | functionIsSecure |
OWNER_NAME | sourceOwners |
DEFINITION | functionDefinition |
Stored procedures
Atlan maps stored procedures in SAP HANA to its Procedure asset type.
| Source property | Atlan property |
|---|---|
PROCEDURE_NAME | name |
PROCEDURE_TYPE | subType |
DEFINITION | definition |
User defined functions
Atlan maps user defined functions from SAP HANA's sys.functions view to its asset type.
| Source property | Atlan property |
|---|---|
FUNCTION_NAME | name |
DEFINITION | Handler Code |
SCHEMA_NAME | schemaName |
FUNCTION_TYPE + ': ' + FUNCTION_USAGE_TYPE | functionType |
OWNER_NAME | Source Owner |
IS_ENCRYPTED | Is Secure |