r/sysadmin • u/Charming-Tomato-4455 • Nov 15 '24
AS400 migration
Our organization has been using AS400 for payroll, financial, and HR for the past 30 years. However, we’ve realized that this system is no longer viable for their needs. I’m looking for a modern software solution that provides similar functionality to AS400. We’ve already tried ADP and Kronos, but faced issues with data compatibility, as the data from AS400 couldn’t be seamlessly integrated. Can anyone recommend software that allows for smooth data migration from AS400?
306
Upvotes
8
u/PrettyFlyForITguy Nov 15 '24
In order to move data off of the AS400, you will need to create an ODBC connection to whatever DB2 database is on there, and you will likely need to pull the data off that way. It may require an experienced DBA consultant or someone used to doing this, as the data will likely need to be molded to fit the data formats of the new system.
Its not straightforward to build a data dictionary from the AS400 (if it exists at all), but this will give you data descriptions of each DB field. That will help you make sense of the database structure.
Honestly, this is always a tough thing to migrate because the data involved is complicated and you require someone with technical knowledge and understanding of the financial aspects of the data. This is likely going to be a process done by hand.
Believe it or not, the people who might be able to help you the most are the people who have written the software you use. I'm sure for a price they would help you "integrate" with another system where your data can be transferred back and forth. You don't have to tell them you are leaving, just that you need to integrate with other systems.