Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data Migration into ERP
- Thread starter jezmondo
- Start date
JerrySmith
IS-IT--Management
NOTHING will take your data directly from AS400 and put it into SAP. You need to stage the process. Try to get hold of the Data Conversion made easy book that came out a few years ago.
There are a variety of mapping/data transformation tools out there:
1) Datajunction (may be able to pull the data from AS400 into a format that the SAP system can read easily for the standard load programs).
2) Legacy Migration Workbench (LSMW) - takes flat files and maps them into SAP. (have to download from SAP...free the last time I downloaded it.)
3) has a product called SIAMEASE that is designed for data migration into SAP.
4) If you can put the data into tab delimitted format, you can use the CATT tool in SAP to load. (it's designed to test your SAP instance - but it acts like a simple Batch load system as well.
In the projects I've been involved with:
From AS400 our programmer did some of the data massage/conversion and put out a master data file that was appropriate for the materials to load via the standard program. We've always staged the data out of AS400, massaged it in MSAccess - put into SAP load friendly format (essentially using VBA) for use of standard load programs, or used CATT or use LSMW.
Good luck
There are a variety of mapping/data transformation tools out there:
1) Datajunction (may be able to pull the data from AS400 into a format that the SAP system can read easily for the standard load programs).
2) Legacy Migration Workbench (LSMW) - takes flat files and maps them into SAP. (have to download from SAP...free the last time I downloaded it.)
3) has a product called SIAMEASE that is designed for data migration into SAP.
4) If you can put the data into tab delimitted format, you can use the CATT tool in SAP to load. (it's designed to test your SAP instance - but it acts like a simple Batch load system as well.
In the projects I've been involved with:
From AS400 our programmer did some of the data massage/conversion and put out a master data file that was appropriate for the materials to load via the standard program. We've always staged the data out of AS400, massaged it in MSAccess - put into SAP load friendly format (essentially using VBA) for use of standard load programs, or used CATT or use LSMW.
Good luck
Guest_imported
New member
- Jan 1, 1970
- 0
I would suggest investigating the DTW (data transfer workbench). This is in SAP! It ties LSMW into the data loading process. What I am doing is utilizing these two tools together as a template for future business acquisitions.
Look at it from this point. Would you rather develope a new process and structure for each time you have to do this? I would say no. You will either kill off your development staff or lose all your hair from the stress and hours of effort.
Just a few words of wisdom.
Look at it from this point. Would you rather develope a new process and structure for each time you have to do this? I would say no. You will either kill off your development staff or lose all your hair from the stress and hours of effort.
Just a few words of wisdom.
I would not suggest anything except Siamease! It is incredibly easy to set up your data migaration. The AS/400 data can be extracted using query/400 and downloaded into spreadsheets. The users can record the transactions you want and use the spreadsheets to upload (NO CODING!)
will give you more info.
will give you more info.
I can also only recommend the easy to use Siamease tool, developed by people who use the tool over a period of 6 years. More detail can be viewed at
- Status
Similar threads
- Locked
- Question
- Locked
- Question