|
Siebel Enterprise Integration Manager Administration Guide > Siebel EIM Tables > EIM Table and Column Mappings >
Finding Differences in EIM Tables Between Repositories
The Siebel Data Model changes from release to release, and EIM mappings change accordingly. You can use the UTLEIMDIFF utility to find EIM mapping differences between two repositories for a list of EIM tables that you input. The results can be used to help you update your EIM data loading scripts, programs, and so on. To use the UTLEIMDIFF utility
- Create the view S_EIM_MAP_V in the database.
The database-platform-independent script for creating this view is called create_EIM_MAP_V.sql. This script can be found in the <dbsrvr>\common directory.
- Find the executable UTLEIMDIFF.EXE in the <tools>\bin directory. Use the following switches for the program:
|
|
|
/U |
[username] |
Siebel username |
/P |
[password] |
Siebel password |
/C |
[connect string] |
ODBC connect string |
/D |
[table owner] |
Database table owner |
/N |
"[new Siebel repository]" |
Required. Name of the new repository. NOTE: Enclose the repository name in quotation marks.
|
/O |
"[old Siebel repository]" |
Required. Name of the old repository. NOTE: Enclose the repository name in quotation marks.
|
/I |
[input filename] |
This file contains the list of EIM tables to be compared. The default input file (eim_tbl_lst.inp) is in the <tools>\bin directory. You can edit this file. |
/M |
[report filename] |
Required. This is the output report. The default name is eim_diff.txt. |
/L |
[log filename] |
The default name is eim_diff.log. |
The program may run for several minutes, depending on the number of tables to be compared.
- Interpret the three parts of the output file as follows:
- Part 1 - Interface Table Difference. Part 1 compares all the EIM tables in the two repositories.
- Part 2 - Interface Table Mapping Difference. Part 2 compares the EIM tables listed in the input file.
- Part 3 - Interface Column Mapping Difference. Part 3 compares the interface columns for the tables listed in the input file. "UK" means "User Key sequence." "Req'd" indicates that the column in the base table is required.
The first column of each part is the repository name. If there is an entry in one repository but not the other, then that means that the entry exists in one repository but not the other. If the same entry appears in both repositories, then that means that the entry has been modified.
|
