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 |