Connect to Smart Reference Data Database - Intergraph Smart Reference Data - 2020 10.0 - Customization & Programming - Hexagon

Intergraph Smart Reference Data Integration (2020)
Language
English
Product
Intergraph Smart Reference Data
Search by Category
Customization & Programming
Smart Materials/Smart Reference Data Version
2020 (10.0)

  1. From the desktop, double-click the P&IDIcon icon.

  2. Type the DB Connection String, SPRD Project Name, and then click Connect.

    For example, if the Smart Reference Data database server name is IN-SPMATDBSRV, the Oracle database SID is SDB2012, and the listener port number is 1521, then type DB Connection String as IN-SPMATDBSRV:1521/SDB2012. Similarly, if the Smart Reference Data project or the product Group Name is SDB, type SPRD Project Name as SDB.

    Ensure that you are connected to the Smart Reference Data Oracle database. Use the following format to connect from Oracle client SQL command prompt:conn <user name>/<password>-<machine name>/<SID>.

    For example, type the following command string to connect to the Smart Reference Data Oracle database with user name as M_SYS, password as manager@in, machine name as sprdapidb, and Oracle SID as sprd713

    conn M-SYS/manager@in-sprdapidb/sprd713