Data Migration Procedures¶
Usage¶
Procedures describes the bahaviour of a Data Migration Job. These behaviours can be divided in to 4 main types as File Migration, Source Migration, Excel Migration and Import Export.
All procedures must be pre-defined in the package Intface_Util_API and will be inserted here during installation of the FNDMIG module. No customized procedures are allowed.
| Procedure Name | Comment | Migration Type/Direction |
|---|---|---|
| CHECK_BY_METHOD_NEW | Reads data from a file, using the standard IFS business logic through a New__ method, invoking it with CheckOption which means that the data will be validated only, and not inserted it into the database. Target LU is derived from specified ViewName. |
File In |
| CREATE_OUTPUT_FILE | Used to write data to file. IFS/Data Migration can retrieve data from any view and write it to a file according to definition in the formatting tab. |
File Out |
| CREATE_TABLE_FROM_FILE | Reads data from file and stores them in a table in the database. |
File In |
| INSERT_BY_METHOD_NEW | Reads data from a file and insert them directly into IFS using the standard IFS business logic through a New__ method. Target LU is derived from specified ViewName |
File In |
| INSERT_OR_UPDATE | Same as previous, but checks if the row exists in the database first. If this is the case, a Modify__ will be performed instead of New__. |
File In |
| FNDMIG_EXPORT | Writes all basic data for one or more migration jobs to a special formatted file. Just specify file information and a WhereClause if you want to limit the selection. You will find a pre-installed job using this procedure. Read the comments on the job header carefully. |
File Out |
| FNDMIG_IMPORT | Reads data file created by previous procedure, and inserts all basic data (i.e. header, column details, method list, rules, groups and conversion lists) You will find a pre-installed job using this procedure. Read the comments on the job header carefully. |
File In |
| MIGRATE_SOURCE_DATA | Used to migrate data from an Oracle source (table, view, db-links) into IFS using valid IFS business logic. |
Source Migration |
| REPLICATION | Used to replicate data within a Logical Unit, from one Company/Contract to one or more Companies/Contracts | Source Migration |
| REPLIC_DATA_OUT | Replicate Data Structures.( outbound messages to IFS/Connect) | ReplicStructure |