...
Data Source (SN Name) | Staging Table | Credentials | Source DB | View |
|---|---|---|---|---|
CMDB Racks (Dev) | u_cmdb_racks_import | [CMDB Racks (Dev) Credentials | jdbc:sqlserver://aperdb-t.its.yale.edu:1433;databaseName=VISTA | SN_Racks |
Views
View | Description |
|---|---|
SN_Blade_Chassis | |
SN_Blade_Servers | |
SN_Cards | |
SN_Network_Devices | |
SN_Physical_Servers | |
SN_Racks | physical racks |
SN_Space_Info | |
SN_Storage |
Transform Logic
Type | Mapping/Logic |
|---|---|
Racks | RACK_NAME -> name, VOB_ID -> vob_id (extend), GRID_LOCATION -> grid_location (extend), SPACE_VOB_ID -> space (CI relationship) |
Here's an overview of how the views are related:
...