Data Integration — Database views
- Last UpdatedOct 22, 2025
- 3 minute read
The default configuration includes a comprehensive set of pre-configured database views across three categories which are designed to streamline the data exchange with AVEVA applications, such as AVEVA Information Management, and third-party applications.
The following is the included set of pre-configured database views:
-
AVEVA Information Management Export List Database View
-
AVEVA Engineering Data Import Database View
AVEVA Information Management Export List Database View
The default configuration includes a comprehensive set of 294 pre-configured database views that are designed to streamline the data exchange between AVEVA Engineering and AVEVA Information Management as outlined in the following summarized list.
|
No. |
Database View Sets Category |
Database Views Quantity |
|---|---|---|
|
1 |
Drawing Data Export List Database View Sets |
8 |
|
2 |
Project Code Data Export List Database View Sets |
29 |
|
3 |
Default Configuration Data Export List Database View Sets |
15 |
|
4 |
Project Deliverables Data Export List Database View Sets |
3 |
|
5 |
Project Document Data Export List Database View Sets |
3 |
|
6 |
Electrical Data Export List Database View Sets |
40 |
|
7 |
Instrumentation Data Export List Database View Sets |
64 |
|
8 |
Mechanical Data Export List Database View Sets |
94 |
|
9 |
Package Data Export List Database View Sets |
5 |
|
10 |
Process Data Export List Database View Sets |
12 |
|
11 |
Simulation Data Export List Database View Sets |
13 |
|
12 |
Functional item Data Export List Database View Sets |
1 |
|
13 |
Plant Summary Data Export List Database View Sets |
7 |
|
Total |
294 |
The following is an example of an AVEVA Unified Engineering Default Configuration AVEVA Information Export List Database View list.
|
Database View Set Category |
User-defined name |
Name |
|---|---|---|
|
UERP_EXPORTLIST_DBViewSET_ELEC |
Distribution Board Export List |
DistributionBoardExportList |
|
UERP_EXPORTLIST_DBViewSET_ELEC |
IEC-Cable Sizing Export List |
CableSizingExportList |
|
UERP_EXPORTLIST_DBViewSET_ELEC |
Installation Details Export List |
InstallationDetailsExportList |
|
UERP_EXPORTLIST_DBViewSET_ELEC |
Electric Cable Schedule Export List |
ElectricCableScheduleExportList |
|
UERP_EXPORTLIST_DBViewSET_ELEC |
Electrical Equipment Export List |
ElectricalEquipmentExportList |
|
UERP_EXPORTLIST_DBViewSET_ELEC |
Generators Export List |
GeneratorsExportList |
|
UERP_EXPORTLIST_DBViewSET_ELEC |
Power Transformer Export List |
PowerTransfomerExportList |
|
UERP_EXPORTLIST_DBViewSET_ELEC |
Power Centers Compartments Export List |
PowerCentersCompartmentsExportList |
|
UERP_EXPORTLIST_DBViewSET_ELEC |
Loads and Spares Assigned Export List |
LoadsandSparesAssignedExportList |
|
UERP_EXPORTLIST_DBViewSET_ELEC |
Busbars Export List |
BusbarsExportList |
|
UERP_EXPORTLIST_DBViewSET_ELEC |
PowerCenters Load and Spares Export List |
PowerCentersLoadandSparesExportList |
|
UERP_EXPORTLIST_DBViewSET_ELEC |
Load Power Detail Export List |
LoadPowerDetailExportList |
AVEVA Engineering Data Import Database View
The default configuration includes a comprehensive set of 24 pre-configured database views designed to streamline data exchange between AVEVA Engineering and third-party applications as per the Microsoft Excel Import capability in AVEVA Engineering.
The following is an example of an AVEVA Unified Engineering Default Configuration Data Import Database View list.
|
No |
Database View Name |
Database View Category |
DatabaseView Name |
Class Name |
|---|---|---|---|---|
|
1 |
Data-Import-PID-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-PID-DBView |
:Diagram |
|
2 |
Data-Import-Loads-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-Loads-DBView |
:ElectricMotor |
|
3 |
Data-Import-Supplies-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-Supplies-DBView |
:MotorControlCentre |
|
4 |
Data-Import-PressRegulator-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-PressRegulator-DBView |
:ControlledActuatingFunction |
|
5 |
Data-Import-ControlValveFunc-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-ControlValveFunc-DBView |
:ControlledActuatingFunction |
|
6 |
Data-Import-ProcessActFunction-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-ProcessActFunction-DBView |
:ActuatingFunction |
|
7 |
Data-Import-ProcessInstMeasure-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-ProcessInstMeasure-DBView |
:Instrument |
|
8 |
Data-Import-HazardousCond-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-HazardousCond-DBView |
:HazardousConditionsIECATEX |
|
9 |
Data-Import-Instruments-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-Instruments-DBView |
:Instrument |
|
10 |
Data-Import-Enclosures-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-Enclosures-DBView |
:Cabinet |
|
11 |
Data-Import-Loops-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-Loops-DBView |
:ControlLoop |
|
12 |
Data-Import-Filter-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-Filter-DBView |
:Filter |
|
13 |
Data-Import-Blower-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-Blower-DBView |
:SootBlower |
|
14 |
Data-Import-Fan-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-Fan-DBView |
:Fan |
|
15 |
Data-Import-Columns-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-Columns-DBView |
:Column |
|
16 |
Data-Import-ReciprocatingPump-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-ReciprocatingPump-DBView |
:ReciprocatingPump |
|
17 |
Data-Import-Vessel-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-Vessel-DBView |
:PressureVessel |
|
18 |
Data-Import-Tank-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-Tank-DBView |
:AtmosphericStorageTank |
|
19 |
Data-Import-CentrifugalPump-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-CentrifugalPump-DBView |
:CentrifugalPump |
|
20 |
Data-Import-Pipelines&Parts-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-Pipelines&Parts-DBView |
:PipingNetworkSystem |
|
21 |
Data-Import-Pipelines-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-Pipelines-DBView |
:PipingNetworkSystem |
|
22 |
Data-Import-FlowBulk-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-FlowBulk-DBView |
:FUNMaterialFlowBulk |
|
23 |
Data-Import-Stream&Parts-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-Stream&Parts-DBView |
:FUNStream |
|
24 |
Data-Import-Stream-DBView |
DATA-IMPORT-DBVIEW |
Data-Import-Stream-DBView |
:FUNStream |