Downloadable Reports

Downloadable reports allow you to export detailed assessment reports of your source data which enables you to gain in-depth insights with ease.

In This Topic:

Insights and Recommendations
Source Inventory Analysis
Assessment Detail Report
High Level Summary
Lineage Report

Related Topics:

To access these assessment reports, click Reports.

In the Reports section, you can see various reports such as Insights and Recommendations, Source Inventory Analysis, Assessment Detail Report, High Level Summary, and Lineage Reports. Each report type offers detailed information allowing you to explore your assessment results.

Insights and Recommendations

This report provides an in-depth insight into the source input files. It contains the final output including the details of procedures, dead codes, analyzed queries, complexity, Query Log DML Mapping, Dependency Records, Detail Report, and so on.

Procedure.xlsx: This report contains information about procedures. It includes information about macros, complexity, entities, functions in SQL, and more.

This report contains the following information:

Report Summary: Provides information about all the generated artifacts.
Indexing: Provides a reference to the respective sheet.
Macros: Lists all the macros existing in the input source files. It also provides information about the total number of queries, and statement types such as SELECT, UPDATE, INSERT, DELETE, and so on.
Query Count Summary: Provides the total number of queries existing in the procedural source files. It also includes the count of queries segregated by statement types such as SELECT, UPDATE, INSERT, DELETE, and so on.
Complexity Summary: Provides complexity of queries existing in the procedural source files.
Parsed Files: Lists all the parsed files along with the total number of functions, procedures, and queries. It also provides the count and percentage of auto-converted queries.
Conversion Compatibility: Provides auto conversion details such as the count and percentage of auto-converted queries as well as the total number of queries in each file.
Packages Procedures Functions: Lists all the existing packages, procedures, and functions in the input files. It also provides the total number of queries, and the number of queries segregated by statement types such as SELECT, UPDATE, INSERT, DELETE, and so on.
Entities (Tables or Views): Lists all the entities in the input source files along with procedures, functions, blocks, and their usage types.
Schemas: Lists all the existing schemas.
SQLs: Lists all the SQL queries along with procedures, functions, blocks, complexities, complexity matrices, SQL statement types, and status of the auto conversion of queries.
Package Cursor Queries: Lists all the cursor queries along with complexities, complexity matrices, SQL statement types, and status of the auto conversion of cursor queries.
Functions in SQL: Lists all the functions such as sum, min, max, and so forth, implemented in the source files. It also provides information about the custom functions, and the category of functions such as aggregate functions, custom functions, arithmetic functions, and so on, as well as whether UDF is required or not.
Entities for DDL: Lists all the entities such as tables and views existing in the DDL files.
Summary: Provides the total number of functions and procedures.

Assessment Dead Code File.xlsx: This report contains information about the dead codes i.e., completely unused codes.

This report contains the following information:

Report Summary: Provides information about all the generated artifacts.
Dead Code File: Lists all the existing dead code files. It includes the number of mapped and unmapped queries as well as the low, medium, and high complexity counts. Dead codes are queries that are available in DML scripts but do not have any footprint in query execution logs.

Assessment Analysis Analyzed Queries.xlsx: This report contains information about analyzed queries.

This report contains the following information:

Report Summary: Provides information about all the generated artifacts.
Analyzed Queries: Lists all the queries along with information about the time required to execute, I/O and CPU utilization ratios, the status of the query analysis and so on.

Assessment Query Log Dml Mapping.xlsx: This report provides information about DML and execution log mappings.

This report contains the following information:

Report Summary: Provides information about all the generated artifacts.
Query Log DML Mapping: Provides the count of mapped and unmapped queries in the file. It also includes information about the time required to execute, I/O and CPU utilization ratios, complexities, and so on.

Assessment Dependency Records.xlsx: This report provides information about dependency details of tables in the source files.

This report contains the following information:

Report Summary: Provides information about all the generated artifacts.
Assessment Dependency Records: Displays dependency details of tables in the source files. It provides information about impacted tables, previously used tables, parent files, and so on.

Source Inventory Analysis

It is an intermediate report which helps to debug failures or calculate the final report. It includes all the generated CSV reports (such as entities, macros, queries, schema, etc.), analysis report, inventory sheet, and more.

Analysis Report.xlsx: Provides a detailed analysis report of the source inventory including column lineage, schema recommendations, missing DDLs, queries, procedures, and more.

This report contains the following information:

Report Summary: Provides information about all the generated artifacts.
Volumetric Info: Lists an aggregated inventory of every source input file. For instance, it provides information about the total number of DML and DDL scripts, entities, queries, procedures, lines of code, and a lot more.
Element Metadata Collection: Provides metadata details. It includes information about the source and target data storage, source and target data elements, element types, and a lot more.
Column Flow: Provides information about the source and target data storage schema code, source and target data containers, source and target data element codes and a lot more.
Schema Recommendation: Provides the schema recommendation details. It includes information about the table names, primary keys, unique keys, partition keys, partition by, cluster by, buckets, and a lot more.
Column Level Lineage: Provides more granular column level details of the lineage. It displays information about the schemas, source and target tables, source and target elements, source and target element data types, and so on.
Missing DDLs: Lists all the missing entities in the DDL files.
Query List: Lists all the queries in the source files along with the complexity.
Query Type Count: Lists all the queries segregated by statement types along with the count.
Source Inventory: Provides detailed information about the source files. It lists all the files along with information about the components, component types, usages, and so on.
Query Complexity Wise Query Count: Provides query complexity along with the number of queries that have the same query complexity values.
Procedure List: Lists all the procedures existing in the source files along with the total number of queries and count of queries segregated by statement types such as CREATE, INSERT, DELETE, DROP, and so on.
Query Analysis: Lists all the queries along with the input types, script names, and sub-process names.

Inventory Sheet.xlsx: This report provides information about tables, scripts, unparsed queries, and unresolved properties.

This report contains the following information:

Report Summary: Provides information about all the generated artifacts.
Table Details: Lists all the tables existing in the source files. It also includes information about usages, table types, unresolved table names, and so on.
Script Details: Lists all the scripts along with information about the components, usages, and component types.
Unparsed Queries Details: Lists all queries that could not be parsed.
Unresolved Property: The source DML files contains properties that hold key-value information. The key represents the property name, and the value represents the associated data. In some cases, the system encounters multiple values for a property name and fails to resolve it. Those unresolved properties are listed here.

Assessment Detail Report

This report provides detailed information about users, applications, queries, and more.

This report contains the following information:

Report Summary: Provides information about all the generated artifacts.
Volumetric Info: Presents a summary of the aggregated inventory after analyzing the source files. For instance, it provides volumetric information about the total number of queries, analyzed and non-analyzed queries, entities, and complexity of queries.
User Wise Info: Lists all the users along with the percentage of execution time, CPU utilization, I/O utilization, and count of queries.
Application Wise Info: Lists all the applications along with the percentage of execution time, CPU utilization, I/O utilization, and count of queries.
Unique Query Count: Provides the total count of queries along with the count of queries segregated by statement types such as SELECT, UPDATE, DROP, DELETE, CREATE, etc.
User Query Type Distribution: Lists all users along with the total count of queries. It also provides the count and percentage of queries segregated by statement types such as SELECT, UPDATE, DROP, DELETE, CREATE, etc.
Query Type User Distribution: Lists the users along with the count and percentage of queries segregated by statement types such as SELECT, UPDATE, DROP, DELETE, CREATE, etc.
App Query Type Distribution: Lists all applications along with the total count of queries. It also provides the count and percentage of queries segregated by statement types such as SELECT, UPDATE, DROP, DELETE, CREATE, etc.
User App Mapping: Lists all users along with their associated applications. It also provides the percentage of execution time, CPU utilization, I/O utilization, and query counts.

High Level Summary

This report provides an integrated assessment report including information about the DML and PL/SQL input files.

This report contains the following information:

Report Summary: Provides information about all the generated artifacts.
DML: Provides statistical information about the DML queries segregated by the statement type.
PLSql: Provides information about the PL/SQL source files including procedure function blocks, total number of queries, queries segregated by the statement types and so on.

Lineage Report

This report provides complete dependency details for all nodes. It provides an end-to-end data and process lineage that helps to identify the complete dependency structure and the data flow.

This report contains the following information:

Dependency (Process): Provides information about the process lineage.
Dependency (Data): Provides information about the data lineage.
Nodes: Lists all the source and target nodes along with its type.
Volumetric Info (Summary): Provides volumetric information about the artifact types such as workflows, input tables, output tables, and schedulers.