About Data MigrationΒΆ
IFS/Data Migration is a tool provided to insert data into or modify data in IFS Application, using either flat files or an Oracle object as data source. It may also be used to transfer data between IFS and other business systems, or between different IFS installations.
IFS/Data Migration provides a quick, easy and dynamic solution to set up migration jobs based on standard IFS Business Logic.
The tool supports the following main services:
- Read data from file and update/insert into IFS (file migrations)
- Read data from an Oracle source (table/view/database link) and update/insert into IFS (source migrations)
- Read data from file and create a table in IFS
- Write data from IFS to file
- Export/Import meta-data, i.e complete Data Migration definitions.
The system allows a great deal of flexibility when setting up a migration job.
For file migrations the user may configure file settings like number of decimals, decimal point, separator characters, date formats, standard values not provided in the file, parameter values when starting the job etc.
For source migrations the system allow data manipulation of source data by ordinary PL/SQL code, value mapping from old to new values, parameter values when starting the job etc. Also for source migrations, a method list is provided, where a step by step list of IFS methods or self defined methods may be specified to be run for each set of data provided by the source table or view.
For each job execution, IFS/Data Migration can provide history information about time of execution, time spent executing, number or errors and error messages for each failed row. Depending on the kind of error that occurred, the job may be restarted for error rows.
Jobs may be started online, in background, or scheduled to run on time intervals.
See Data Migration concept overview page for more details.