Re-Locate is the solution developed by Systsoft Systems & Software to simplify the data migration from the IBM System i (iSeries or AS/400) applications to other databases like Oracle, IBM DB2 UDB & Microsoft SQL Server.
Re-Locate has been designed with a "Zero Coding" approach to data migration. Only the business rules for the migration need to be setup through a web-based Cloud application, which are used in Re-Locate to generate the SQL scripts for the actual Data Migration. Since there is no code to develop and test, the process is simpler, faster and easily accessible to all the teams involved in migration.
The business rules can be setup
- Data flow of Target tables to be loaded from different Source tables
- The Data Extraction and Filteration Logic from the Source Tables
- The Data Quality Validations for the Source tables
- The Join Conditions for the Source Tables
- The Source - Target Mapping & data Transformation conditions
- The Data Quality Validations for the transformed Target table
- The Target Loading method
Re-Locate has been specifically designed to provide for the Audit, Balance & Control requirements of data migration. The data validation and verification is vital to ensure that there are no data changes or omissions during migration, which could lead to significant problems for the business at a later date. Hence, at each stage of the process, Re-Locate compiles the Control values, which can be verified against data in existing reports.
