Data Migration

IFS Data Migration is a tool that loads data from external sources into the application core objects in IFS Applications. This tool is typically used to move data from previous legacy systems when an IFS solution is first implemented, or when systems are consolidated. The key advantage of IFS Data Migration is that it always loads data through the business logic APIs in IFS Applications. Unlike other solutions that insert data straight into tables IFS Data Migration assures that business rules, validations, and integrity checks are never bypassed.

Another strength of IFS Data Migration is that migration definitions can be packaged/exported and shared with other projects. The IFS Data Migration component itself contains a number of commonly used packaged migrations.

Data Migration Today

IFS Data Migration is a tool that moves data into any application core object in IFS

• Takes advantage of standard API's
• Insert data into one or more LU’s in one pass
• Generic functionality may be combined with specially made scripts
• Not a tool that replaces conventional upgrade scripts

IFS Data Migration reads a number of different data sources

• Text files (flexible on separators, etc.)
• Tables or Views in Oracle database
• Via database link to other sources
• Can join in information from already migrated data along with external sources

Several IFS Applications components includes pre-packaged data migration definitions, including object such as users, customers and suppliers. These migration definitions is to make it easier to come up to speed when using the tool and to more quickly perform some of the migrations that are common to most projects. These prepackaged migrations consist of:

• The definition itself which is available upon manual installation of the PROD components as migration jobs in the form Overview - Migration Jobs
• An excel spreadsheet that may act as an input container for the data with additional information about fields, formats constraints, etc.