Skip to main content

What does Atlan crawl from Oracle?

Atlan crawls and maps the following assets and properties from Oracle.

Databases

Atlan maps databases from Oracle to its Database asset type.

Source propertyAtlan property
TABLE_CATALOGname
SCHEMA_COUNTschemaCount

Schemas

Atlan maps schemas from Oracle to its Schema asset type.

Source propertyAtlan property
TABLE_SCHEMAname
TABLE_COUNTtableCount
VIEW_COUNTviewsCount
TABLE_CATALOGdatabaseName

Tables

Atlan maps tables from Oracle to its Table asset type.

Source propertyAtlan property
TABLE_NAMEname
REMARKSdescription
COLUMN_COUNTcolumnCount
ROW_COUNTrowCount
BYTESsizeBytes
TABLE_TYPEsubType
HAS_PARTITIONSisPartitioned
PARTITION_STRATEGYpartitionStrategy
PARTITION_COUNTpartitionCount
TEMPORARYisTemporary
ALIASdisplayName

Views

Atlan maps views from Oracle to its View asset type.

Source propertyAtlan property
TABLE_NAMEname
REMARKSdescription
COLUMN_COUNTcolumnCount
VIEW_DEFINITIONdefinition
HAS_PARTITIONSisPartitioned
PARTITION_COUNTpartitionCount
TEMPORARYisTemporary
ALIASdisplayName

Columns

Atlan maps columns from Oracle to its Column asset type.

Source propertyAtlan property
COLUMN_NAMEname
REMARKSdescription
ORDINAL_POSITIONorder
TYPE_NAMEdataType
CONSTRAINT_TYPES (PRIMARY KEY)isPrimary
CONSTRAINT_TYPES (FOREIGN KEY)isForeign
IS_NULLABLEisNullable
NUMERIC_SCALEnumericScale
CHARACTER_MAXIMUM_LENGTHmaxLength