What does Atlan crawl from SAP ASE?
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: Configure authentication and permissions
- Crawl SAP ASE: Configure and run the crawler