## What does Atlan crawl from SAP ASE?

URL: https://docs.atlan.com/apps/connectors/database/sap-ase/references/what-does-atlan-crawl-from-sap-ase

> Metadata Atlan extracts from SAP ASE - databases, schemas, tables, views, columns, stored procedures, and functions - mapped to Atlan assets.

Atlan extracts metadata for databases, schemas, tables, views, columns, stored procedures, and functions from SAP ASE (Adaptive Server Enterprise) system catalogs and maps each property to its internal asset model. The tables below list which SAP ASE properties are read and how they appear on the corresponding Atlan asset.

Atlan automatically excludes the SAP ASE system databases (`master`, `tempdb`, `model`, `sybsystemprocs`, `sybsecurity`, `dbccdb`, `sybmgmtdb`, `sybpcidb`, `sybsystemdb`), system stored procedures (names starting with `sp_`), and the system accounts `guest` and `public` from the crawl.

## Databases

Atlan maps databases from `master..sysdatabases` to its `Database` asset type.

| Source property | Atlan property |
| --- | --- |
| `name` | `name` |
| Owner login (from `master..syslogins`) | `sourceCreatedBy` |
| `crdate` | `createTime` |
| Number of schemas | `schemaCount` |

## Schemas

SAP ASE doesn't have schemas as a separate object - object owners act as schemas. Atlan maps each user from `sysusers` in a crawled database to its `Schema` asset type.

| Source property | Atlan property |
| --- | --- |
| `name` | `name` |
| Number of tables | `tableCount` |
| Number of views | `viewsCount` |

## Tables

Atlan maps user tables from `sysobjects` (type `U`) to its `Table` asset type.

| Source property | Atlan property |
| --- | --- |
| `name` | `name` |
| Owner name | `schemaName` |
| `row_count()` estimate | `rowCount` |
| Number of columns | `columnCount` |
| `crdate` | `createTime` |

The row count is an estimate from SAP ASE's `row_count()` function. It can appear as `-1` if statistics haven't been generated on the source table.

## Views

Atlan maps views from `sysobjects` (type `V`) to its `View` asset type. The view definition is reconstructed from the SQL text stored in `syscomments` and used to generate lineage to the view's source tables.

| Source property | Atlan property |
| --- | --- |
| `name` | `name` |
| Owner name | `schemaName` |
| SQL text (from `syscomments`) | `definition` |
| Number of columns | `columnCount` |
| `crdate` | `createTime` |

## Columns

Atlan maps columns of tables and views from `syscolumns` (with data types from `systypes`) to its `Column` asset type.

| Source property | Atlan property |
| --- | --- |
| `name` | `name` |
| `colid` | `order` |
| Data type name (from `systypes`) | `dataType` |
| `length` | `maxLength` |
| Nullability flag | `isNullable` |
| Primary key flag | `isPrimary` |
| Foreign key flag | `isForeign` |
| Index membership flag | `isIndexed` |
| `prec` | `precision` |
| `scale` | `numericScale` |

## Stored procedures

Atlan maps stored procedures from `sysobjects` (type `P`) to its `Procedure` asset type. System procedures with names starting with `sp_` are excluded. The procedure definition is reconstructed from `syscomments` and used to generate lineage.

| Source property | Atlan property |
| --- | --- |
| `name` | `name` |
| Owner name | `schemaName` |
| SQL text (from `syscomments`) | `definition` |
| `crdate` | `createTime` |

## Functions

Atlan maps user-defined functions from `sysobjects` (types `F` and `SF`) to its `Function` asset type. Function extraction requires SAP ASE 16.0 or later - on earlier versions, functions are skipped.

| Source property | Atlan property |
| --- | --- |
| `name` | `name` |
| Owner name | `schemaName` |
| Object type (`F` scalar, `SF` SQL function) | `type` |
| SQL text (from `syscomments`) | `functionDefinition` |
| `crdate` | `createTime` |

## Lineage

Atlan generates lineage by parsing the SQL definitions of views, stored procedures, and functions. Query history mining and usage metrics aren't supported for SAP ASE.

## See also

* [Set up SAP ASE](https://docs.atlan.com/llms/connectors/sap-ase/set-up-sap-ase/llms.txt): Configure authentication and permissions
* [Crawl SAP ASE](https://docs.atlan.com/llms/connectors/sap-ase/crawl-sap-ase/llms.txt): Configure and run the crawler

---