Log on to the SDB Merge Tool - Intergraph Smart Reference Data Standard Database - Version 12.3 - Installation & Upgrade - Hexagon PPM

Standard Database for Intergraph Smart Reference Data Merge Tool Help

Intergraph Smart Reference Data Standard Database
Search by Category
Installation & Upgrade
Standard Database for Smart Reference Data Version

After hosting SDB Merge Tool successfully, user can access the tool in a web browser.

For example, URL: https://<Server Name>/SDBMerge/Index.html

User can access the tool URL from Microsoft Edge or Google Chrome web browsers.

Login UI for the SDB Merge Tool has the following inputs:

  1. In a web browser, type SDB Merge Tool URL and click Enter.

  2. Select the Source and Target Database details as follows:

  3. Type the SRD username and associated password for the respective database connections.

    You must have the PUBLIC or SUPERUSER role to proceed.

  4. Choose the data to merge from the list:

    • Select Standard Reference Data to merge SDB data into the target database.

    • Select Smart Materials to merge SMAT data in SDB into the target database.

  5. Select Product Group SDB from the list.

  6. Select the Language as English or Industry from the list, and then click Login.

  7. If you select Smart Materials in step 4, then complete merge of SMAT data to target database is initiated.

  8. If you select Smart Reference Data in step 4, then you are prompted with a menu. From the menu, select any of the following modes:

    • Differences not shown in hierarchy

    • Show differences in hierarchy

      • Non-CMS Data

      • CMS Data

  9. If you select Differences not shown in hierarchy and clicks Next, the Merge Tool User Interface is displayed.

  10. If you select Show Differences in hierarchy for the first-time, you are provided with an option to perform the comparison of CMS data and Non-CMS data separately or together based on user requirement.

  11. You can select the Non-CMS and/or CMS, then click Next. The comparison of data between source and target databases begins.

  12. After comparison, if you select Show Differences in hierarchy, the following sub modes are displayed:

    • Selective Merge of Data

      By selecting this mode, you can merge specific set of data selectively from source to target database. For example, if users want to merge only few commodity codes from source to target database, they can use this mode.

    • Complete Merge of Data

      If you select this mode, the complete merge of data will be initiated from source to target database. All the Source only and Difference records will be merged from source to target database. All the log files related to this process will be generated in the Merge Tool logs folder.

  13. If you choose to perform only the Non-CMS comparison in step 10, you will have the following options:

    • Perform the comparison of CMS data

    • Perform selective/complete merge of Non-CMS data (Comparison completed).