Use case 6 - Cobol, JEE, HTML5 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 two previous Oracle analysis units, has been added. Dependency between, “JEE and the new one SQL analysis unit”, “Cobol and the new one SQL analysis unit”, and “HTML5 analysis unit and the new one SQL analysis” has been added at the end.

New dashboard

Now, you can also note SQL quality rules applied on client code, e.g.:

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: 417741
Nb of modules: 1
Nb of active analysis units: 4
Nb of inactive analysis units: 0
Total nb of analysis units: 4
Nb of saved objects: 407039
Number of applications with full call graph: 1 (#31463)
Number of relevant objects in repository: 423494
Number of OMG AFP-links in repository: 611958
Number of DF records / TR end points: 11605
Number of transactions: 192
Number of empty transactions: 165
Number of links -> DF records / TR end points: 10521
Number of links -> other objects in full graph: 13282
Number of transaction links generated (sum): 23803
Number of objects in largest transaction: 9563
Number of elements in largest SCC group: 98
Number of applications with full call graph: 1 (#31463)
Number of relevant objects in repository: 407149
Number of OMG AFP-links in repository: 596093
Number of DF records/TR end points: 11641
Number of transactions: 192
Number of empty transactions: 165
Number of links -> DF records/TR end points: 10532
Number of links -> other objects in full graph: 13293
Number of transaction links generated (sum): 23825
Number of objects in largest transaction: 9574
Number of elements in largest SCC group: 98