Installing Web API 2.0 Database Patch - Intergraph Smart Materials - Version 2017 (2.0) - Installation - Hexagon PPM

Intergraph Smart Materials Web API Installation 2017 (2.0)

Intergraph Smart Materials
Installation & Upgrade

Before running the Web API database scripts, place the tnsnames.ora into the \\Network\Admin\ folder of the Oracle installation path.


  • Web API 2.0 is only supported on Smart Materials database version 8.0 or higher.

  • 'EcoSys Web Services Pack for Smart Materials' is a pre-requisite for the Smart Materials - EcoSys integration to work.

Once the prerequisites are met, follow the below procedure to install WebAPI 2.0 database patches on a Smart Materials database (version 8.0 or higher).

  1. Open a Command Prompt window and navigate to the WebAPI DB Scripts folder.

  2. Start SQL*Plus.

  3. Connect to the database with M_SYS user credentials and TNS network alias name.

  4. To install the Smart Materials Web API database patch, run the patch_install.sql file.

    You will be prompted to enter the following values:

    sys_pwd - password of sys user

    db_conn - TNS network alias name of the database

    m_sys_pwd - password of m_sys user

    db_conn - TNS network alias name of the database

When all WebAPI DB scripts are installed, the message ‘Installing objects for SPMatWebAPI ended’ is displayed.