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 |