Understanding the Database Link - Intergraph Smart P&ID - Configuration - Intergraph

Intergraph Smart P&ID Workshare Configuration and Reference (2019)

Language
English
Product
Intergraph Smart P&ID
Search by Category
Administration & Configuration
Smart Electrical Version
2019 (9.0)
Smart P&ID Version
9 (2019)
Smart Engineering Manager Version
10 (2019)

The database link is a network object stored in the local database that identifies a remote database, a communication path to that database, and optionally, a user name and password. Once defined, the database link is used to access the remote database and is vital to a successful connected Workshare collaboration.

Configuring a database link is not necessary for standalone Workshare collaboration.

Plant Schema

The database link allows each satellite to view all plant data in the plant schema. When you are at a satellite and are viewing the plant schema over an active database link, you are actually viewing the database at the host site. This plant schema, containing the data available at the time of the last reference data synchronization, is replicated at each satellite, to be used by the satellite in the event the database link is not active.

The Smart P&ID Modeler always uses the local replication plant schema, even when the database link is up. All other Smart P&ID applications use the host plant schema when the link is up.

Drawing Manager dynamically changes both the host and replication schemas when adding new drawings. All drawing-level changes are reflected in both schemas when the change is made at the satellite, allowing the Smart P&ID Modeler environment to be aware of new drawings created locally without having to synchronize reference data.

Drawing Transfer

The transfer of published drawings takes place automatically over the database link, rather than you having to manually bundle and transmit the data to the satellites.

Reference Data Synchronization

The reference data consists of data in the file system and data in the plant and P&ID schemas. Because only the Workshare host has permission to modify the reference data, the updated reference data must be shared with all satellites whenever the reference data is modified. Satellites cannot publish drawings or get the latest version of drawings until the satellite site reference data is in sync with the host.

The file system reference data (rules file, symbol files, and so forth) must be transmitted manually to satellite sites no matter the mode of Workshare collaboration.  However, in a connected Workshare collaboration, the database portion (plant and application schemas) of the reference data is synchronized via the database link.

Shared Items Synchronization

Shared items are defined as OPCs, utility connectors, shared instrument loops, and package systems. These items are referred to as "shared items" since they are designed to intelligently cross drawing boundaries. If one or more of these items crosses the boundary from one drawing to another drawing at another connected Workshare site, the Synchronize Shared Items command uses the database link to maintain data for the shared items at each site.