PDS Provider Requirements Overview
The following table provides a brief overview of the data file requirements for the PDS provider adapter. These files must be made available at a location accesible to the V-Suite CORE user responsible for updating the asset database from PDS.
Description |
Default Name |
Remarks |
PDS Design Database DDL file |
design.ddl |
None |
PDS Project Control Database DDL file |
project.ddl |
None |
Reference Data Manager extracted Code List files for Standard Notes 125, 145, 180, 190, 200, 210, 220, 230, 330, 340, 390, 570, 1056, 1064 and 1606. |
code<#>.edt |
The listed standard notes are for attributes most commonly transfered to the asset database. On your project you may not require all or need a few additional ones. |
Design (dd_<proj>) Dump File of tables pdtable_12_*, pdtable_32_*, pdtable_50_*, pdtable_67_*, pdtable_80_* |
ris.dmp |
The format of the RIS dump may be fixed or variable, however fixed is preferred for performance reasons. Indexes, views and privilege definitions do not have to be extracted. For performance reasons we suggest extracting the dd_<PROJ> and pd_<PROJ> schema's into two different dump files. You may specify ALLtables to not have to enter all design table names. |
Project Control (pd_<proj>) RIS Dump File of tables pdtable_111, pdtable_112, pdtable_113 or ALL tables (indexes, views and privilege definitions are not required). Both fixed and variable format may be used. |
ris.dmp |
The format of the RIS dump may be fixed or variable, however fixed is preferred for performance reasons. Indexes, views and privilege definitions do not have to be extracted. For performance reasons we suggest extracting the dd_<PROJ> and pd_<PROJ> schema's into two different dump files. You may specify ALL tables to not have to enter all design table names. |