What is SMART

The Quantum SMART Utility provides a full warehouse management toolkit incorporating a fully featured scheduler, comprehensive ETL functionality and environmental management tools – monitoring and alerts for failed or out of bounds jobs.

Additionally the utility incorporates Data Migration modules supporting the end to end processing stream from source extract to staging, through validation, cleansing, reconciliation and transformation. The methodology and supporting functions enable a clear definition of the scope of the task at the validation stage and by reporting directly from the scripts that perform the subsequent steps, provide management with unambiguous status monitoring of the progress of the migration assignment.  

The Issue Management functions contained in the utility supports on-line interaction between technical and business team members enabling spotlight focus on inhibitors to progress.

SMART Solution

  • Graphical User Interface Utility
  • Supports data warehouse and data migration of any data source to SQL Server and Oracle target
  • Data Warehouse/Migration process: Extract, Profiling, Validation, Cleanse, Reconciliation, Transform, and Load processes driven by a metadata engine (maintained via GUI)
  • Scheduling function that organises and monitors warehouse and migration jobs to simplify schedule and dependency assignment and enable reporting on process statistics such as updates and execution performance
  • Source System meta data extract - forms the basis of the validation, cleansing, transformation processing
  • Reporting: Automated migration project status reporting
  • For data migrations, every step in the process is automated and repeatable – every week or every day you can see the size of the task and how far through it we are

A methodology as well as a tool;

QuantumIT and the SMART utility provide data management projects with a tool as well as a methodology that centers on iterations and tracking progress.
A migration with Iterations will validate automated process, quantify progress, cater for late business rule changes and avoid stress at GO LIVE.
Tracking progress is key for reporting how much closer to finishing the migration you are every week or even every day if you need to. It validates you have a project with an end date that you can manage.

QuantumIT understands and recognises the special requirements of data migration projects and has a long history of delivering reconciled and functional data migration projects on time and budget.

To assist businesses in the effective delivery of data migration projects, QuantumIT, can provide experienced professionals and specialised methodologies and tools to deal with any data migration need.

QuantumIT can help your migration project meet best practice by providing

  • Project Management
  • Business, data and process analysis services
  • Development services
  • A specialised data migration tool (SMART data migration) and methodology

These best practice requirements are supported by features in the QuantumIT SMART data migration toolset.

  • Source System meta data extract - forms the basis of the validation, cleansing, transformation processing
  • Graphical User Interface Migration Utility
  • Supports data migration of any data source to SQL Server and Oracle target
  • Scheduling function that organises and monitors migration jobs to simplify schedule and dependency assignment and enable reporting on process statistics such as updates and execution performance
  • Migration process: Extract, Validation, Cleanse, Reconciliation, Transform, and Load processes driven by a metadata engine (maintained via GUI)
  • Reporting: Automated migration project status reporting
  • Every step in the process is automated and repeatable – every week or every day you can see the size of the task and how far through it we are