Database-related setup for SQL Server and Oracle database - HxGN EAM - 12.1 - Feature Briefs - Hexagon

HxGN EAM Custom Framework

Language
English
Product
HxGN EAM
Search by Category
Feature Briefs
HxGN EAM Version
12.1
  1. Open Database Tool and Connect to your database and go through the following steps to create screen in EAM:

    1. Create a user defined table.

      Ex. This a template script to create a user defined table.

      Table Script for SQL Server Database

      HxGNEAM_CustomFrameWork.zip\Tables_Oracle.sql. See the Attachments section of Related documents for downloading instructions.

      Table Script for Oracle Database

      HxGNEAM_CustomFrameWork.zip\Tables_SQL.sql. See the Attachments section of Related documents for downloading instructions.

    2. Create User Defined Grid using below UDG script for both SQL Server and Oracle.

    3. Create a function record in r5functions table.

    4. Create a record in r5permissions table.

    5. Create records in r5boilertexts table.

    6. The table below lists the compatible data types for r5ddfield when creating records.

      CFW_Attachments-table

    7. Check whether records exist or not in r5ddfield table by running query SELECT * FROM r5ddfield WHERE ddf_tablename='U5ACCOUNTS'.

    8. If exists, no need to run insert statement for r5ddfield and reuse ddf_fieldid in Grid/Grid Fields/Query Fields.

    9. If it does not exist then, create a record in r5ddfield table, using the table which was used for grid creation.

    10. Create a grid record in r5grid table.

    11. Create a grid field records in r5gridfield table.

    12. Create a default dataspy record in r5dddataspy.

    13. Create a default query field record in r5queryfield table.

  2. Follow this order in the execution process for running the following UDG Scripts:

    1. Execute sequence script, this execution should be done only once for a single database.

    2. Execute r5ddfields creation, this execution should be done only once for a single database

    3. Execute Grid creation script, this execution should be done only once for each grid creation in a single database.

    4. Above mentioned steps can be executed with the help of following template script file.

  3. Run this UDG template script in the order above for SQL Server database:

    HxGNEAM_CustomFramework.zip\UDG_CREATE_SCRIPT_WITH_SEQUENCE_DDFIELDS_FUNC_GRID_SQL.zip. See the Attachments section of Related documents for downloading instructions.

  4. Run this UDG template script in the order above for Oracle database:

  5. HxGNEAM_CustomFramework.zip\UDG_CREATE_SCRIPT_WITH_SEQUENCE_DDFIELDS_FUNC_GRID_ORA.zip. See the Attachments section of Related documents for downloading instructions.