What does Atlan crawl from SAP Datasphere
Atlan integrates with SAP Datasphere to crawl and map asset metadata. All assets are cataloged under the sap-sql connector. This page outlines the SAP Datasphere asset types that Atlan supports and how their properties are mapped.
Analytical models are cataloged as views in Atlan when the Analytical Models option is enabled during crawler configuration.
Assets
Atlan extracts metadata from SAP Datasphere across the following asset types:
- Spaces: Isolated working environments within SAP Datasphere that contain data models and business content.
- Views: Logical representations of data built on top of source data in a space.
- Analytical models: Multidimensional models used for analysis and reporting, cataloged as views in Atlan.
- Columns: Individual data attributes within views and analytical models.
Spaces
Spaces are isolated working environments within SAP Datasphere. Each space contains its own data models, remote connections, and business content.
| Source property | Atlan property |
|---|---|
| Space Technical Name | name |
| Space Label | displayName |
Views
Views in SAP Datasphere define logical data models built on source data within a space. Only views marked as exposed are crawled.
| Source property | Atlan property |
|---|---|
| View Technical Name | name |
| View Label | displayName |
| Space Technical Name | schemaName |
| Database Name | databaseName |
Analytical models
Analytical models define multidimensional structures for reporting and analysis. When the Analytical Models option is enabled, these are crawled and cataloged as views in Atlan.
| Source property | Atlan property |
|---|---|
| Model Technical Name | name |
| Model Label | displayName |
| Space Technical Name | schemaName |
| Database Name | databaseName |
Columns
Columns define individual data attributes within views and analytical models.
| Source property | Atlan property |
|---|---|
| Column Name | name |
| Data Type | dataType |
| Column Position | order |
Data type mapping
The following table shows how SAP Datasphere (OData EDM) data types are mapped to Atlan data types.
| SAP Datasphere data type | Atlan data type | Condition |
|---|---|---|
Edm.String | NVARCHAR | If @MaxLength exists: NVARCHAR(@MaxLength) |
Edm.Decimal | DECIMAL | DECIMAL(@Precision, @Scale); defaults to DECIMAL(18,0) |
Edm.Int64 | BIGINT | Always |
Edm.Int32 | INT | Always |
Edm.Int16 | SMALLINT | Always |
Edm.Date | DATE | Always |
Edm.Byte | BYTE | Always |
Edm.Binary | BINARY | Always |
Edm.Boolean | BOOLEAN | Always |
Edm.DateTimeOffset | DATETIMEOFFSET | If @Precision exists: DATETIMEOFFSET(@Precision) |
Edm.Double | DOUBLE | Always |
Edm.Guid | VARCHAR | Always |
Edm.SByte | TINYINT | Always |
Edm.Single | REAL | Always |
Edm.DateTime | TIMESTAMP | Always |
Edm.Time | TIME | Always |
Edm.Stream | BLOB | Always |
Edm.ComplexType | NVARCHAR | Always |
Edm.EnumType | NVARCHAR | Always |
Edm.Geography | NVARCHAR | Always |
Edm.Geometry | NVARCHAR | Always |
| Any other type | UNKNOWN | Any unrecognized type |
See also
- Crawl SAP Datasphere: Step-by-step guide for configuring and running the SAP Datasphere crawler.