Acme Treats owns 100 ice cream trucks. The trucks have routes in several counties within one state. Each truck sells various types of ice cream treats to local residents. The company wants each truck to provide daily sales and inventory information to a central-office server. The system need not be real time, because truck operators will likely update sales and inventory information only once per day, during midshift break. Please make your recommendations.
My Solution: Chris Dodge
VP, Technical Services
Virsage Solutions Inc.
Virsage, based in Lafayette, Colo., is a management services provider and a Microsoft Certified Partner that has Cisco and Citrix expertise.
By equipping each ice cream truck with an H3600 Series iPaq pocket PC from Compaq Computer (www.compaq. com/ipaq), Acme will be able to connect to the central database via wireless connections, when available, or by using a dialup modem for remote areas.
Each H3600 will be configured with a dual-slot PC Card Expansion Pack that will allow the use of a wireless Internet card, a 56-Kbps modem, or both.
Acmes sales staff will input all sales and inventory information into a custom application on the iPaq handhelds. Virsage Solutions will use Microsoft Visual Basic to develop that application. The app will have a local Microsoft SQL 2000 database, which will allow the truck drivers to enter information while they are not connected to the central database.
The H3600 (about $599 each) will reduce the total cost of ownership of this project, when compared with typical systems that use Windows 2000-based laptops ($2,000 or more each).
When the trucks are in areas that have wireless Internet coverage, drivers can connect to the central network via a VPN connection. Ricochet will provide the wireless Internet access. (To see if Ricochet can serve various customer locations, visit www.ricochet.com/getricochet.htm).
When only dialup access is available, the truck drivers will use a remote-access server connection.
The Firebox 1000 from Watch- guard will provide a secure VPN access point to the central network for the remote clients (for related firewall coverage, see SP, June 11, p. 34, www.smartpartnermag.com/issues). The Firebox uses NT security, which will ease administration because my proposed back-end system runs on Windows.
AT&T business accounts (www.ipservices.att.com) will provide dialup access for areas that do not have wireless coverage.
Once connected, the local Microsoft SQL 2000 database, running on the iPaq, will replicate any new inventory/sales information to a central Microsoft SQL Server 2000 database. The database also will provide clients with off-line access to historical sales/inventory data.
Because real-time information is not critical in this customer solution, we will use a client/server architecture to facilitate off-line data access when no wireless service is available.
A Compaq Proliant ML330 (www.compaq.com/proliant) running Windows 2000 Advanced Server with dual 1-GHz processors would provide enough processing power for the existing 100 users, as well as allow for future growth.