Products Our Products


The control system is intended for the management of the complete lifecycle of data warehouses, and is a single center for running and monitoring all processes of data processing in a warehouse. This is the main tool for an operator developed to manage and control the operation of a corporate data warehouse. 
 
The Control System has three-tier architecture with a number of core and optional modules. A browser is used as a client application. The following browsers are supported: Google Chrome, Mozilla Firefox, IE 9, Safari and higher. 
 
A list of modules with brief descriptions of their respective functionalities is provided in a table below.
 
The Engine, where all core system processes are executed, is a core component of the Control System. The Engine is implemented as a console-based application with a small server resource footprint. The Engine runs processes, schedules and schedule chains of the Control System configured in the task planner, and maintains logs of all the executed operations.
 
The Monitor module is the key tool for the monitoring and control of the running of all data warehouse control processes.
 
The Process Designer module is intended for the development of processes and the execution of the full cycle of data processing in the warehouse. It includes processes of data upload, data validation, initiation of settlements, initiation of database backups, and the initiation of data auto-tests, scripts, web services, datastage, oracle, mssql, postgresql jobs, sending e-mails, etc.
 
The Reference Tables module is intended for the management of the regulatory and reference information of an enterprise. This module is designed as a web application which can be easily integrated with the Control System of the data warehouse.
 
The Samples module is designed for data and business analysis and enables them to create parameterized samples in the form of SQL and PL\SQL scripts.
 
The Events module is integrated with the Samples module, and is designed to notify operators responsible for the day-to-day operation of the data warehouse about important events occurring in the process of its operation, the process of transformation of the uploaded data, or in case of errors in data processing processes. The same module is in charge of the auto-test functionality of the data warehouse.
 
The Web Services module makes it possible to provide web services for the online integration of the Data Warehouse with external applications via classical or WCF services for the provision of data.
 
The Datamart Map module is designed to enable Control System operators to carry out day-to-day monitoring and control of data mart calculations, view dependencies between data marts, and track the recalculation needs.
 
The Process Statistics module makes it possible to retrospectively track down changes in the runtime of Control System processes registered in monitors. The statistics can be viewed broken down by schedules, processes and stages.
 
The Skeleton Control module is designed for Control System operators for the purposes of the day-to-day monitoring of “skeletons” generated by the ETL CKGK (concatenate key generate key) mechanism.
 
The Data Check module is intended for the day-to-day fact check of data uploaded from banking systems by the data operators. 
 
The Administration module allows administering accounts, managing access of users to administrative operations of other modules, and viewing logs of the Control System and the process core.