Data Quality Module

COMPONENTS

DQM – There are two DQM areas where it can be deployed. The first  consists of elements of Data Profiling and Data Validation and Correction.  
Here, the DQM is used to specify Data Profiling requirements as well as Data Validation rules via 
user-friendly interface. 
The Data Profiler can be used as a starting point for a detailed Data Validation specification. 
DQM allows repeated testing of the specified Data Validation rules against real dataset before the integration into the actual Orchestration structure. Both testing and Data Validation processing produce summary and detailed reports on items that failed validation containing enough information to pin-point the problem item. The detailed report can be used in further processing to eliminate bad records

Transformation Module

COMPONENTS

TD - Task Designer module is interactive web based graphical interface used to design various data processing tasks such as transforming inputs and creating outputs, executing SQL statements, executing system commands, etc. 

Input and output components in ams are called IO Objects and processing or transformation components are called services.

The types of IO objects and services are easily recognisable by their colours and icons. IO objects and services are connected with arrows that represent data flow. They connect IO objects with services.

IO objects can be dataset of any type and location which includes tables of almost all known DB types or vendors, and files of most formats.

TD Tasks can take environment variables defined on the calling procedure level or defined globaly.

The same TD task can be used in different procedures.

All the details relevant to a TD task are stored in Meta Tables and open for viewing.

The objects in the task pane can be moved around, and they retain their last position automatically.

Users and Audience:

• Large, Medium, and small businesses
• System Architects
• Business Analysts
• Developers

Orchestration Module

COMPONENTS

PPT - short for Phase Procedure and Task. PPT is Orchestration component that allows to design and build application and application components by defining and structuring phases and procedures and procedure dependencies. It also allows to brake down complex procedures into a set of sequential tasks. PPT provides framework for deconstructing a complex application into manageable units of work that constitute a single, recoverable system. The lowest in the structure is a Task and it is the only executable. 
The task could be anything with an exe permission.

SCHEDULER - provides: immediate, one off or repetitive, timing and/or event triggered scheduling capabilities. Multiple entries are allowed for both timing and event conditions so even the most complex and sophisticated requirements can be specified. The Scheduler interface is simple and easy to use.

MONITOR - Monitor provides a wide range of capabilities that are essential to daily operations in production environment, or providing practical support in development environment. These include job/phase scheduling, monitoring, alerting – and performing phase level actions such as starting, stopping, and rerunning. Across all applications/systems, the Operational Console collects, integrates, and manages the associated operational metadata, helping the operational team and business analysts in planning and maintaining efficient operations.