Use case 2 - JEE and Oracle

Introduction

After moving from Oracle AIP to SQL Analyzer as explained here Transitioning from Oracle Server , at the end of the new scan the following report has been generated: SQLAnalyzerMetricsReport.csv .

During transition, Oracle source will not change, the same extraction will be now analyzed by SQL Analyzer. A new UA analysis unit, equivalent of all previous Oracle analysis units, has been added. Dependency between “JEE and the the new SQL analysis unit” has been added at the end.

New dashboard

Numbers 

Before After
Nb of modules: 1
Nb of active analysis units: 9
Nb of inactive analysis units: 0
Total nb of analysis units: 9
Nb of saved objects: 75275
Nb of modules: 1
Nb of active analysis units: 8
Nb of inactive analysis units: 0
Total nb of analysis units: 8
Nb of saved objects: 75187

Number of applications with full call graph : 1 (#32598)
Number of relevant objects in repository : 78924
Number of OMG AFP-links in repository : 519702
Number of DF records / TR end points : 308
Number of transactions : 1
Number of empty transactions : 1
Number of links -> DF records / TR end points : 0
Number of links -> other objects in full graph : 65
Number of transaction links generated (sum) : 65
Number of objects in largest transaction : 0
Number of elements in largest SCC group : 13

Number of applications with full call graph : 1 (#32598)
Number of relevant objects in repository : 78776
Number of OMG AFP-links in repository : 519476
Number of DF records / TR end points : 310
Number of transactions : 1
Number of empty transactions : 1
Number of links -> DF records / TR end points : 0
Number of links -> other objects in full graph : 65
Number of transaction links generated (sum) : 65
Number of objects in largest transaction : 0
Number of elements in largest SCC group : 13