Move archived M3 BE data to Infor Data Lake

You can now move the table data from archiving library MVXARCH to Data Lake through the related option 22='Move Archived Records to Data Lake' in 'Archiving. Open Toolbox' (AMS100). This option enables you to move all tables used by the selected archiving function. The moved records can be found in Data Lake with archived flags equal to true.

Tables moved from MVXARCH to Data Lake can be viewed in Compass by using table function infor.ShowArchived('tableName'). For example, if records from table OSBSTD should be viewed, use the query SELECT * FROM infor.ShowArchived('OSBSTD').

You cannot start archiving while the move to Data Lake job is in progress. Similarly, you cannot move data to Data Lake when archiving is in progress for the archiving function. Also, only one move to Data Lake job can be run concurrently.

2253945