What does Atlan crawl from Oracle?
During an Oracle crawl, Atlan extracts metadata for Databases, Schemas, Tables, Views, and Procedures and maps it to Atlan's internal asset model. The tables below list, for each asset type, which Oracle properties are read and how they appear on the corresponding Atlan asset.
Databases
Atlan maps databases from Oracle to its Database asset type.
| Source property | Atlan property |
|---|---|
TABLE_CATALOG | name |
SCHEMA_COUNT | schemaCount |
Schemas
Atlan maps schemas from Oracle to its Schema asset type.
| Source property | Atlan property |
|---|---|
TABLE_SCHEMA | name |
TABLE_COUNT | tableCount |
VIEW_COUNT | viewsCount |
TABLE_CATALOG | databaseName |
Tables
Atlan maps tables from Oracle to its Table asset type.
| Source property | Atlan property |
|---|---|
TABLE_NAME | name |
REMARKS | description |
COLUMN_COUNT | columnCount |
ROW_COUNT | rowCount |
BYTES | sizeBytes |
TABLE_TYPE | subType |
HAS_PARTITIONS | isPartitioned |
PARTITION_STRATEGY | partitionStrategy |
PARTITION_COUNT | partitionCount |
TEMPORARY | isTemporary |
ALIAS | displayName |
Views
Atlan maps views from Oracle to its View asset type.
| Source property | Atlan property |
|---|---|
TABLE_NAME | name |
REMARKS | description |
COLUMN_COUNT | columnCount |
VIEW_DEFINITION | definition |
HAS_PARTITIONS | isPartitioned |
PARTITION_COUNT | partitionCount |
TEMPORARY | isTemporary |
ALIAS | displayName |
Columns
Atlan maps columns from Oracle to its Column asset type.
| Source property | Atlan property |
|---|---|
COLUMN_NAME | name |
REMARKS | description |
ORDINAL_POSITION | order |
TYPE_NAME | dataType |
CONSTRAINT_TYPES (PRIMARY KEY) | isPrimary |
CONSTRAINT_TYPES (FOREIGN KEY) | isForeign |
IS_NULLABLE | isNullable |
NUMERIC_SCALE | numericScale |
CHARACTER_MAXIMUM_LENGTH | maxLength |