Comparing Data Model Reports

Perform the following steps to extract the Data Model Report form erwin Data Modeling tool:

1.     Open the OFSA Application with your login credentials.

2.     In the Object Administration tab, Select Object Administration --> Utilities --> Compare Models.

3.     Browse the Old Data Model Report Excel File and New Data Model Report Excel File respectively. The Compare button is displayed.

 

NOTE

The Old Data Model Report and New Data Model Report should be in same format and file extension should be .xlsx

Click Reset if you want to select a different Data Model Report.

 

4.     The Compare Only Common Tables option is “No” by default, select “Yes” only if required.

 

NOTE

The Compare Only Common Tables option “Yes” is used when comparing Data Model Report of different products. The Report fields will be different for each product and only common fields are required to compare for investigation.

 

5.     Click Compare. The Data Model Difference Report will get generated.

6.     Click Download Model Difference Report link and Save the report.