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 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

Related articles

Was this article helpful?
2 out of 2 found this helpful