PeopleSoft Guys

I’m currently leading a project for a public sector client and we needed to perform a data conversion of legacy data from SBT system into PeopleSoft financials and supply chain system.

The approach I designed to bring the data into the PeopleSoft system is

• Export the data from SBT system (Which is in FoxPro) to .dbf files
• Import the data into MS Access database by using MS Access import utility
• Export the data into Sybase database (which is where PeopleSoft database is located) using MS Access export utility by using Open Database connectivity (ODBC).
• Once the data is in Sybase database we are planning to import the metadata into Convoy DM tool and map the tables to a target database.
• Then we are planning to generate the conversion SQRs using Convoy DM.

I will post more info regarding this conversion. Once we start progressing on this. I thought this would be useful for someone as I couldn’t find any information on this anywhere else.