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