After hosting SDB Merge Tool successfully, user can access the tool in a web browser.
For example, URL: http://<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:
-
In a web browser, type SDB Merge Tool URL and click Enter.
-
Type Source and Target Database details along with M_SYS schema password for respective databases.
-
Source Database: SDB OOTB Database created using Standard Database Setup wizard.
-
Target Database: Customer database with Standard Database Version 2018R1 and Smart Reference Data version 2016 R4 (8.4).
-
-
Click Connect and then select Product Group SDB from the list.
-
Select the Language as English or Industry from the list, and then click Login.
-
On the menu, select any of the following modes:
-
Differences not shown in hierarchy
-
Show differences in hierarchy
-
Selective Merge of Data
-
Complete Merge of Data
-
-
-
If the user selects Differences not shown in hierarchy and clicks Next, the Merge Tool User Interface is displayed..
-
If the user selects Show Differences in hierarchy for the first time and clicks Next, the comparison of data between Source and target databases starts.
-
If the user selects Show Differences in hierarchy after the completion of Data base comparison, the following sub modes are displayed:
-
Selective Merge of Data
By selecting this mode, user can merge specific set of data selectively from source to target database. For example, if user wants to merge only few commodity codes only from source to target database, they can use this mode.
-
Complete Merge of Data
If the user selects 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.
-