Breadcrumbs

Compliance Testing from Workbench

The Workbench Check Compliance functionality is used to validate DataStage assets against a set of quality criteria which MettleCI refers to as Compliance Rules. MettleCI ships with a set of sample Compliance Rules (delivered as a Git repository) which act as the basis for customers to use as supplied, ignore, modify, or augment with new customer-specific rules as required to meet specific needs.

Data Migrators can provide assistance to help you add or modify rules to suit your specific needs.  Take a look at the MettleCI documentation to start modifying or writing your own Compliance Rules

The concept of Compliance Testing can have a variety of uses:

  • Enforcing Coding Standards in DataStage jobs, for consistency and improved readability over time

  • Tracking external assets, which may require external management

  • Identifying deprecated stages, allowing upgrade effort to be quantified.

As an example of evaluating Compliance and removing a test failure, let's look at an example DataStage job in the classic (Windows-based) Designer. 

WARNING

Before running Compliance you should ensure you have COMPILED the job which you wish to test.  Merely saving the job will update your DataStage repository with the details of your current job design WITH THE EXCEPTION OF THE CONTENTS OF TRANSFORMER STAGES!  The code for the Transformer Stages as configured on your DataStage Canvas is only generated during the compile process.

Through the DataStage Designer’s Tools > Custom... menu, select Check Compliance to invoke MettleCI Workbench with an open dialog box preopulated with the details of the active job in the DataStage Designer.  Note that the Compliance functionality can also be selected directly from the Navigation menu in the Workbench application, though in that case the DataStage Asset field will be blank.

test1-engn.datamigrators.io_8080_projects(720p (1280 x 720)) (2)-20250827-014517.png

Click the Run button to execute compliance testing against the job. While the compliance testing is executing, the logs can be viewed to monitor progress.

test1-engn.datamigrators.io_8080_projects(720p (1280 x 720)) (1)-20250827-014503.png

Once the compliance test execution has completed, the Results tab displays the outcome.

test1-engn.datamigrators.io_8080_projects(720p (1280 x 720)) copy-20250827-015954.png

Expand Failed rows to see a description of which asset component(s) caused each compliance failure.

test1-engn.datamigrators.io_8080_projects(720p (1280 x 720)) (2) copy-20250827-020101.png