I'm new to GISs. I'm searching for a GIS to meet following requirements.
I have a list of street addresses [A,B,C,D,E,...], with additional information associated (basically which orders to deliver at each address and to which customer), available in a DB table (DBMS: DB2 for i Series) or .xls file.
I need to show these addresses on a map and calculate the route among them. Not the global best route, but the route that touches each point maintaining the order given for them. Then the user should modify this order if necessary (e.g. [A,E,C,B,D,...]) and the route should be recalculated.
As output I need to write the points in the new order on a DB table (also with customer info etc. for each record). I also need to print a PDF with the map and route instructions for the truck driver.
I considered MapPoint, but counld't succedd with automatic route calculation for the imported addresses (to calculate a route I have to manually add each point). Google Maps API seems promising, but I don't know how to do many of the operations above.
Any hint on which GIS could fit? Both web-based or desktop applications are welcome. Many thanks!