Skip to the content
LeaplogicLeaplogic
  • Home
  • About Us
  • Contact
SIGN IN
  • Home
  • About Us
  • Contact

  • Getting Started
    • Before You Begin
    • Creating an Account
    • Logging into LeapLogic
    • Reset Password
    • Quick Tour of the Web Interface
    • LeapLogic in 15 minutes
      • Prerequisites
      • Step 1. Log into LeapLogic
      • Step 2. Create Assessment and Get Insights
      • Step 3. Create Transformation Pipeline and See Results
      • Step 4. Edit or Optimize the Transformed Code
      • Step 5: Complete the Transformation Lifecycle
  • Introduction to LeapLogic
    • Overview
    • High Level Architecture
    • Supported Legacy and Cloud Platforms
    • Key Features
  • Workload Assessment
    • Overview
    • Value Proposition
    • Creating Assessment
      • Prerequisites
      • Step 1. Provide Primary Inputs
        • Automation Coverage
      • Step 2. Add the Additional Inputs
        • Table Stat Extraction Steps
          • Teradata
          • Oracle
          • Netezza
      • Step 3. Update the Source Configuration
      • Step 4. Configure the Recommendation Settings
    • Assessment Listing
    • Understanding Insights and Recommendations
      • Volumetric Info
      • EDW
        • Oracle
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Vertica
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Snowflake
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Azure Synapse
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • SQL Server
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Teradata
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Netezza
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Google Big Query
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Redshift
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • PostgreSQL
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Duck DB
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • ClickHouse
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Exasol
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • DB2
          • Highlights
          • Analysis
          • Optimization
          • Recommendations
          • Lineage
          • Downloadable Reports
      • ETL
        • Informatica
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Ab Initio
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • DataStage
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Talend
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • SSIS
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Informatica BDM
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Oracle Data Integrator
          • Highlights
          • Analysis
          • Downloadable Reports
        • Pentaho
          • Highlights
          • Analysis
          • Downloadable Reports
        • Azure Data Factory
          • ARM Template
          • Highlights
          • Analysis
          • Downloadable Reports
        • Matillion
          • Highlights
          • Analysis
          • Downloadable Reports
        • SnapLogic
          • Highlights
          • Analysis
          • Downloadable Reports
      • Orchestration
        • AutoSys
          • Highlights
          • Analysis
          • Downloadable Reports
        • Control-M
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • SQL Server
          • Highlights
          • Analysis
      • BI
        • OBIEE
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Tableau
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • IBM Cognos
          • Highlights
          • Analysis
          • Downloadable Reports
        • MicroStrategy
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Power BI
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • SSRS
          • Highlights
          • Analysis
          • Downloadable Reports
        • SAP BO
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • WebFOCUS
          • Highlights
          • Analysis
          • Downloadable Reports
      • Analytics
        • SAS
          • Highlight
          • Analysis
          • Lineage
          • Downloadable Reports
        • Alteryx
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
      • Integrated Assessment (EDW, ETL, Orchestration, BI)
        • Highlights
        • Analysis
        • Optimization
        • Lineage
        • Recommendations
    • Managing Assessment Reports
      • Downloading Report
      • Input Report Utility
      • View Configuration
    • Complexity Calculation Logic
    • Key Benefits
    • Ad hoc Query
  • Metadata Management
    • Overview
    • Introduction to Data Catalog
      • Managing Data Catalog
        • Building Data Catalog
        • Insights to Data Catalog
        • Managing the Repository and Data Source
      • Creating Repository (Repo)
      • Creating Data Source
    • Tag Management
    • Key benefits
  • Batch Processing using Pipeline
    • Introduction
    • Designing Pipeline
      • How to create a pipeline
        • Configuring Migration Stage
          • Schema Optimization
        • Configuring Transformation Stage
          • On-premises to Cloud
          • Cloud-to-Cloud
          • LeapLogic Express
        • Configuring Validation Stage
          • Data Validation
            • Table
            • File
            • File and Table
            • Cell-by-cell validation
          • Query Validation
            • Query Validation (When Data is Available)
            • Query Validation (When Data is Not Available)
          • Schema Validation
        • Configuring Execution Stage
        • Configuring ETL Conversion Stage
          • Ab Initio
          • Informatica
          • Informatica BDM
          • Matillion
          • DataStage
          • SSIS
          • IICS
          • Talend
          • Oracle Data Integrator
          • Pentaho
          • SnapLogic
        • Configuring Mainframe Conversion Stage
          • Cobol
          • JCL
        • Configuring Orchestration Stage
          • AutoSys
          • Control-M
        • Configuring BI Conversion Stage
          • OBIEE to Power BI
          • OBIEE to AWS QuickSight
          • Tableau to Amazon QuickSight
          • Tableau to Power BI
          • Tableau to Superset
          • Tableau to Looker
          • IBM Cognos to Power BI
        • Configuring Analytics Conversion Stage
          • SAS
          • Alteryx
        • Configuring Script Conversion Stage
    • Key Features
      • How to schedule a pipeline
      • Configuring Parameters
  • Pipeline Reports
    • Overview of Pipeline Report
    • Pipeline Listing
    • Reports and Insights
      • Migration
      • Transformation
        • On-premises to Cloud
        • Cloud-to-Cloud
        • LeapLogic Express
      • Validation
        • Data
          • File
          • Table
          • File and Table
        • Query
          • Query Validation Report (When Data is Available)
          • Query Validation Report (When Data is not Available)
        • Schema
      • Execution
      • ETL
        • Ab Initio
        • Informatica
        • Informatica BDM
        • Matillion
        • DataStage
        • SSIS
        • IICS
        • Talend
        • Oracle Data Integrator
        • Pentaho
        • SnapLogic
      • Mainframe
        • Cobol
        • JCL
      • Orchestration
        • AutoSys
        • Control-M
      • BI
        • OBIEE to Power BI
        • OBIEE to Amazon QuickSight
        • Tableau to Amazon QuickSight
        • Tableau to Power BI
        • Tableau to Superset
        • Tableau to Looker
        • IBM Cognos to Power BI
      • Analytics
        • SAS
        • Alteryx
      • Shell Script
      • Common Model
    • Automation Level Indicator
      • ETL
        • Informatica
        • Matillion
        • DataStage
        • Informatica BDM
        • SnapLogic
        • IICS
        • Ab Initio
        • SSIS
        • Talend
        • Pentaho
      • Orchestration
        • AutoSys
        • Control-M
      • EDW
      • Analytics
        • SAS
        • Alteryx
      • BI
      • Shell Script
    • Error Specifications & Troubleshooting
  • SQL Transformation
    • Overview
    • Creating and Executing the Online Notebook
      • How to Create and Execute the Notebook
      • Supported Features
    • Configuring the Notebook
      • Transformation
      • Unit Level Validation
      • Script Level Validation
    • Notebook Listing
  • Operationalization
    • Overview
      • Basic
      • Advanced
      • Cron Expression
    • Parallel Run Pipeline Listing
  • Transformation Source
    • Introduction
    • Creating Transformation Source Type
  • Governance
    • Summary of Governance - Roles and Permissions
    • User Creation
      • Creating a new User Account
    • Adding Roles and permissions
      • How to add Roles and Permissions to a new user?
    • Adding Group Accounts
    • Default Quota Limits
    • Product Usage Metrics
  • License
    • EDW
    • ETL
  • LeapLogic Desktop Version
    • Overview
    • Registration and Installation
    • Getting Started
    • Creating Assessment
      • ETL
      • DML
      • Procedure
      • Analytics
      • Hadoop
    • Reports and Insights
      • Downloadable Reports
      • Reports for Estimation
    • Logging and Troubleshooting
    • Sample Scripts
    • Desktop vs. Web Version
    • Getting Help
  • LeapLogic (Version 4.8) Deployment
    • System Requirements
    • Prerequisites
    • Deployment
      • Extracting Package
      • Placing License Key
      • Executing Deployment Script
      • Accessing LeapLogic
    • Uploading License
    • Appendix
    • Getting Help
  • Removed Features
    • Configuring File Validation Stage
    • Variable Extractor Stage
      • Variable Extractor Report
    • Configuring Meta Diff Stage
      • Meta Diff
    • Configuring Data Load Stage
      • Data Load
    • Configuring Multi Algo Stage
  • FAQs
  • Tutorial Videos
  • Notice
Home   »  Workload Assessment   »  Understanding Insights and Recommendations   »  Orchestration  »  Control-M Assessment Report

Control-M Assessment Report

This topic contains information about the Control-M assessment report. Control-M is an automated job scheduling tool that controls scheduling, monitoring, and executing tasks. The input format for the Control-M assessment is XML.

In This Topic:

  • Highlights
    • Summary
    • Applications
    • Complexity
    • Schedules
    • Watch Files
  • Analysis
    • Orchestration Details
    • Artifacts
  • Lineage
  • Downloadable Reports
    • Insights and Recommendations
    • Source Inventory Analysis
    • Lineage Report


Highlights

The highlights section gives you a high-level overview of your assessment summary based on the analysis of the selected scheduler scripts. It includes a summary as well as orchestration details of the source input scripts.

Summary

This section provides an overview of input source files and the associated workload inventory including folders, sub folders, jobs, and more

  • Files: Displays the number of input source files.
  • Folders: Displays the number of folders present in the input source files. Folders contains the related jobs.
  • Smart Folders: Displays the number of smart folders present in the input source files. Smart folder offers advanced job scheduling capabilities, allowing the scheduling criteria to be defined at the folder level. Subsequently, all jobs in the smart folder inherit these defined criteria.
  • Jobs: Displays the number of jobs present in the folders and smart folders. Jobs are scheduler scripts that run in a certain order to perform a set of activities.
  • Unique Commands: Displays the number of unique commands.

Applications

This section provides an overview of total and sub-applications along with their distribution across application types.

  • Total Applications: Displays the total number of applications present in the input files.
  • Sub-Applications: Displays the number of sub-applications present in the input files. Sub-applications categorize related jobs based on the specific requirements within the application.
  • Application Type: Lists the application types along with the number of associated applications.

Complexity

This section provides a summarized graphical representation of the classification of Control-M jobs based on a detailed complexity assessment. This information is required to make different decisions, including migration planning, estimating budget, etc.

Schedules

This section provides an overview of schedules along with their frequency.

  • Total Schedules: Displays the total number of schedules.
  • Frequency: Displays the frequency of scheduled jobs such as daily, weekly, monthly, etc., along with the number of schedules.

Watch Files

An overview of watch files along with their distribution across watch file types.

  • Total Watch Files: Displays the total number of watch files.
  • Name: Lists the watch file types such as Zip, TXT, CSV, etc., along with their count.


Analysis

This topic provides a detailed examination of jobs existing in the Control-M scripts.

Jobs

This section provides a complete analysis of the jobs. It lists all the jobs along with information about the jobs such as conditions, availability status, applications, and a lot more. Jobs are scheduler scripts that run in a certain order to perform a set of activities.

  • Jobs Name: Displays the name of the jobs.
  • File Name: Displays the name of the source script that is associated with each job.
  • Application: Displays the applications defined within the jobs.
  • Conditions: Displays the conditions that must be met for a job to run.
  • Job Months: Displays the months in which the job is scheduled.
  • Availability: Displays the availability of jobs.
    • Available: Jobs that are available in both scripts and execution logs.
    • Unavailable: Jobs that are available in scripts but not in execution logs.

Artifacts

This section lists all the artifacts that could not be parsed completely due to some error.


Lineage

End-to-end data and process lineage identify the complete dependency structure through interactive and drill-down options to the last level.

Typically, even within one line of business, multiple data sources, entry points, ETL tools, and orchestration mechanisms exist. Decoding this complex data web and translating it into a simple visual flow can be extremely challenging during large-scale modernization programs. The visual lineage graph adds tremendous value and helps define the roadmap to the modern data architecture. It deep dives into all the existing flows, like Autosys jobs, applications, ETL scripts, BTEQ/Shell (KSH) scripts, procedures, input and output tables, and provides integrated insights. These insights help data teams make strategic decisions with greater accuracy and completeness. Enterprises can proactively leverage integrated analysis to mitigate the risks associated with migration and avoid business disruption.

Now, let’s see how you can efficiently manage lineage.

To view the required lineage:

  1. Select either the Process or Data tab.
  2. Enter the keywords in the Search Keywords field.
  1. Click the Search icon to generate the lineage.

Process lineage illustrates the dependencies between two or more processes such as files, jobs, workflows, etc., whereas data lineage depicts data flow between two or more data-holding components such as entities, flat files, etc. 

In addition, the filter search icon allows you to include or exclude particular nodes to obtain the required dependency structure. You can also choose the direction of the lineage. By default, the Dependency Direction is Left to Right Hierarchy. You can also choose Right to Left Hierarchy or Bidirectional dependency directions as required. Moreover, you can also increase the Hierarchy Levels to nth level.

Lineage facilitates you visualize how your selected nodes are connected and depend on each other. The nodes and their connecting edges (relationships) help you to understand the overall structure and dependencies.

Nodes Edges
Tables Call
File Read
Job Execute
Flat File Write
Flat File OTHERS

Manage Lineage

This feature enables you to view and manage your lineage. You can add, modify, or delete nodes and their relationships to generate an accurate representation of the required dependency structure. There are two ways to update the lineage: either using Complete Lineage report or Lineage Template.

Using Complete Lineage report

Follow the below steps to modify the lineage:

  1. Click the Manage Graph icon.
  1. Click Download Complete Lineage to update, add, or delete the nodes and their relationships in the current lineage.
    1. Once the complete lineage report is downloaded, you can make necessary updates such as updating, deleting or adding the nodes and its relationships.
    2. After making the required changes, upload the updated lineage report in Upload to Modify Lineage.
    3. Click Apply to incorporate the updates into the dependency structure.
    4. Generate the required process or data lineage.

    Using Lineage Template

    Follow the below steps to add new nodes and their relationships to the current lineage report:

    1. Click the Manage Graph icon.
    1. Click Download Lineage Template.
    1. Once the lineage template is downloaded, you can add new nodes and relationships in the template.
    2. After making the required changes, upload the template in Upload to Modify Lineage.
    3. Click Apply to incorporate the updates into the complete dependency structure.
    4. Generate the required process or data lineage.

    Downloadable Reports

    Downloadable reports allow you to export detailed Control-M assessment reports of your source data which enables you to gain in-depth insights with ease. To access these assessment reports, click Reports.

    Types of Reports

    In the Reports section, you can see various types of reports such as Insights and Recommendations, Source Inventory Analysis, and Lineage reports. Each report type offers detailed information allowing you to explore your source inventory.

    Insights and Recommendations

    This report provides an in-depth insight into the source input files. It contains the final output including information about the Control-M jobs. Here, you can see the controlm folder and the Lineage Dependency Report.xlsx.

    Lineage Dependency Report.xlsx: This report contains information about views and script level lineage. It includes information about used and impacted tables, views, files, direct dependencies, dependency hierarchy and more.

    This report contains the following information:

    • view_report: Provides information about the views.
    • script_report: Provides information about script level lineage.

    Detailed Control-M Assessments Reports

    To access a detailed assessment report, go to the controlm folder. Here, you can see the scheduler folder along with ControlM_Assessment_Report.xlsx report.

    ControlM_Assessment_Report.xlsx: This report provides insights about the source inventory. It includes information about jobs, complexity, unparsed artifacts, etc.

    This report contains the following information:

    • Volumetric Info: Lists an aggregated inventory of every source Informatica file. For instance, it provides information about the total number of files, folders, smart folders, applications, job complexity, and more.
    • Job Detail: Provides information about jobs including applications, sub applications, frequency, complexity, and more.
    • Complexity: Provides information about the complexity of jobs present in each file.
    • Unparsed: Provides information about unparsed artifacts along with their type and the reason for parsing failure.
    • Dependency: Provides dependency details of jobs along with their associated parent job, parent application, parent sub application, and more.

    Browse through the scheduler folder to access the missing_job_details.csv report.

    missing_job_details.csv: This report provides information about the missing jobs.

    Source Inventory Analysis

    It is an intermediate report which helps to debug failures or calculate the final report. Here you can see controlm folder along with controlmunparsed_controlm_details.csv report.

    controlmunparsed_controlm_details.csv: This report provides information about unparsed files.

    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, files, jobs, and more.

    To learn more, contact our support team or write to: info@leaplogic.io

    Copyright © 2025 Impetus Technologies Inc. All Rights Reserved

    • Terms of Use
    • Privacy Policy
    • License Agreement
    To the top ↑ Up ↑