## What does Atlan crawl from SAP HANA?

URL: https://docs.atlan.com/apps/connectors/database/sap-hana/references/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` |

---