is the data processing frameworks for controlling tasks and design activities for data processing. Andromeda Centre handles files processing, loading data from many data sources and provides easy to use features for setting up the actions on incoming tasks and for data transformations and calculations. The Andromeda Centre utilises MS SQL database technology, works with c# code, uses SSIS packages for data processing or any other. It can generate the routines for ETL (extract, transform and load) but it also controls production data processing. You can say it controls data processing end to end; from the initial data collection until the final presentation to the users. An important part of Andromeda Centre is the effective testing achieved by testing automation.
Andromeda Centre consists of several modules. The modules are not final and are being extended for covering more features for design or production data activities.
- Control module – Creates application code, data quality controls; directly executes process tasks and actions; and provides log information of the executed data transformations.
- Squirrel – Testing Automation module which provides the automated testing feature. This tool is different from typical manually written testing scripts. This tool focuses on reconciliation which is from the business perspective the crucial test type. Even very infamous task of regression testing, hated by developers is very simple with this tool.
- XL Spider – Provides features to understand the business logic in the excel models created in the business. This tool is a great start for creating a new generation of data business modelling in your business.
Andromeda Centre is decommissioned and replaced with LYNX.