What does Atlan crawl from Oracle?

Have more questions? Submit a request

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
PARTITIONS partitionList
TEMPORARY isTemporary
ALIAS alias

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
PARTITIONS partitionList
TEMPORARY isTemporary
ALIAS alias

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?
1 out of 1 found this helpful