Complete the following steps in each Smart Materials database that you plan to interface with Smart Construction.
-
Log on to SQLPlus using the user name and password of your Smart Materials database.
-
Using SQL Plus, browse to the Materials folder in the Smart Construction server installation location. For example, navigate to [Drive]:\Program Files (x86)\SmartConstruction\2019\SPCServer\Support\Materials.
-
Select the folder that corresponds to your version of Smart Materials.
-
Run the following file scripts located in the Materials folder:
-
m_api_site_spc_spec.sql
-
m_api_site_spc_body.sql
-
For more information, see Configuring a Smart Materials system using Site API.