Connect to the As-Built Schema - Intergraph Smart Instrumentation - Help - Intergraph Process, Power & Marine Documentation

Intergraph Smart Instrumentation Internal Setup

PPMProduct
Intergraph Smart Instrumentation
PPMCategory_custom
Help
Version_SPI_custom
2018 (12.0)
  1. On the menu bar, click File > Database Type Test and Query.

  2. Connect to the Domain schema.

  3. In the Query pane, type the following command:
    select * from ENGINEERING_PROJECT;

  4. Click Execute.

  5. On the SQL Result window, scroll right to display the Eng Log Name and Eng Log Pass columns.

    • The Eng Log Name and Eng Log Pass columns contain As-Built and Project schema logon information.

    • In the ENGINEERING_PROJECT table, the As-Built row is the one whose Eng Proj ID column value is 1.

  6. Type the As-Built schema logon name, which appears in the Eng Log Name column, in the Schema logon name box in the Database Type Test and Query window.

  7. Type the As-Built schema logon password, which appears in the Eng Log Pass column, in the Schema logon password box in the Database Type Test and Query window.

  8. Do one of the following:

    • Click Actions > Connect.

    • Click .

The Results pane displays the result of the connection.  A zero (0) indicates a successful operation.  Codes that indicate a connection failure include a message explaining the reason for the failure.

See Also

Smart Instrumentation Database Schemas