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   »  Pipeline Reports   »  Automation Level Indicator  »  Orchestration Automation Level Indicator

Orchestration Automation Level Indicator

This topic contains information about the logic used to calculate the automation level indicator of orchestration scripts including:

  • AutoSys
  • Control-M

AutoSys

Automation level indicator provides the automation conversion coverage of the AutoSys conversion. It is calculated based on the average of automation level indicator of boxes and jobs.

Automation Level Indicator = (sumtotalBoxPercentage + sumtotaljobPercentage) / (numberParentJob) + numberParentBox)

For instance, if you have two boxes – BX1 and BX2 with 95% automation level indicator for each, and a job (Other_Jobs) with 90% automation level indicator. Then the overall automation level indicator is calculated as (sumtotalBoxPercentage + sumtotaljobPercentage) / (numberParentJob) + numberParentBox); i.e., ((95+95) +90)/ (1+2) = 93.33%.

Next, let’s see how to calculate the automation level indicator of each job and box.

The automation level indicator of each job is calculated based on:

  • Successfully converted job: Automation level indicator of a successfully converted job is 100%.
  • Failed job: Automation level indicator of a job that is failed to convert is 0%.
  • Partially supported job (successfully converted job with ToDo message): Automation level indicator of a partially supported job or successfully converted job with ToDo message is 90% by default (configurable).

The automation level indicator of each box is calculated based on:

  • Successfully converted box: Automation level indicator of a successfully converted box is 100%.
  • Failed box: Automation level indicator of a box that is failed to convert is 0%.
  • Box contains jobs: If a box has ‘n’ number of jobs, then the automation level indicator for that box is average of automation level indicator of the jobs present in it.

For instance, if a BX1 box has two jobs – BX1-J1 and BX1-J2, then the Automation level indicator for:

  • BX1-J1 is 100% as the job is successfully auto-converted.
  • BX1-J2 is 90% as the job is partially supported (auto-converted with ToDo message).

Therefore, the automation level indicator of BX1 box is average of automation level indicator of the jobs; i.e, (100+90)/2 = 95%

File Name Box Name Job Name Job Type DAG Name Target Job Name Target Job Type Status Automation Level Indicator
AutoSys BX1 BOX BX1_dag BX1 task_group success 95
AutoSys BX1 BX1-J1 FW BX1_dag BX1_J1 RemoteFileSensor success 100
AutoSys BX1 BX1-J2 CMD BX1_dag BX1_J2 SSHOperator success 90
AutoSys BX2 BOX BX2_dag BX2 task_group success 95
AutoSys BX1_external_task ExternalTaskSensor BX2_dag BX1_external_task task success
AutoSys BX2 BX2-J3 FW BX2_dag BX2_J3 RemoteFileSensor success 100
AutoSys BX2 BX2-J4 CMD BX2_dag BX2_J4 SSHOperator success 90
AutoSys BX-J5 CMD BX2_dag BX_J5 SSHOperator success 90


Control-M

Automation level indicator provides the automation conversion coverage of the Control-M conversion. It is calculated based on the average of automation level indicator of folders and jobs.

Folder/SubFolder = (Sum of % of all jobs present in folder + Subfolder % (if present))/ (Number of jobs present in folder + Number of subfolders (if present))

Next, let’s see how to calculate the automation level indicator of each folder and job.

The automation level indicator of each job is calculated based on:

  • Successfully converted job: Automation level indicator of a successfully converted job is 100%.
  • Failed job: Automation level indicator of a job that is failed to convert is 0%.
  • Partially supported job (successfully converted job with ToDo message): Automation level indicator of a partially supported job or successfully converted job with ToDo message is 90% by default.

The automation level indicator of each folder is calculated based on:

  • Successfully converted folder: Automation level indicator of a successfully converted folder is 100%.
  • Failed folder: Automation level indicator of a folder that is failed to convert is 0%.
  • Folder contains jobs: If a folder has ‘n’ number of jobs, then the automation level indicator for that folder is average of automation level indicator of the jobs present in it.

For instance:

  • If a Folder1 folder has a job (OS_job1) with 90% automation level indicator (partially supported job), then the automation level indicator for the folder is also 90%.
  • If a SubFolder1 sub folder has two jobs – OS_JOB1 with 100% automation level indicator because the job is successfully auto-converted and OS_JOB2 with 90% automation level indicator because the job is partially supported (job successfully auto-converted with ToDo message), then the Automation level indicator for SubFolder1 sub-folder is calculated as average of automation level indicator of OS_JOB1 and OS_JOB2 jobs, i.e, (100+90)/2 = 95.
  • If a smart folder (SmartFolder1) has a job OS_JOB1 with 100% automation level indicator because the job is successfully auto-converted and a subfolder SubFolder1 with 95% automation level indicator because the job is partially supported (job successfully auto-converted with ToDo message). Then, the automation level indicator for SmartFolder1 is average of automation level indicator of the job and subfolder; i.e, (90+95)/2 = 92.5%
File Name Folder Name Job name Job Type DAG Name Target Job Name Target Job Type Status Automated Conversion Rate
FileName1 Folder1 Folder Folder_Dag Folder Dag success 90
FileName1 Folder1 Os_Job1 OS Os_Job1_1_dag Os_Job1_01 DummyOperator success 90
FileName2 SmartFolder1 Smart folder SmartFolder1_dag SmartFolder1 Dag success 92.5
FileName2 SmartFolder1 OS_JOB1 OS OS_JOB1_dag OS_JOB1 DummyOperator success 90
FileName2 SubFolder1 SubFolder SubFolder1_dag Subfolder1 Task group success 95
FileName2 SubFolder1 OS_JOB1 OS OS_JOB1_dag OS_JOB1 DummyOperator success 100
FileName2 SubFolder1 OS_JOB2 OS OS_JOB2_dag OS_JOB2 DummyOperator success 90


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 ↑