Datapel WMS is a business software solution for small-to-medium sized companies that use MYOB accounting software. Datapel WMS provides advanced Stock Control and Order Management features using ODBC integration to improve workflow collaboration not afforded by MYOB itself.
With prior resource planning the Datapel WMS is simple to implement and easy to administer. Typically the WMS is used by 5 - 25 concurrent users. It is very important that the hardware infrastructure can provide the necessary resources to support this business solution.
PLEASE NOTE: MYOB AccountRight Editions DO NOT SUPPORT Windows Server 2008 R2 Until further notice: Datapel Systems is unable to provide support for its application on this platform with regards to MYOB Connectivity and/or MYOB installation, configuration, and setup.
This support note provides the RECOMMENDED configurations as sourced from various software suppliers and typically used in conjunction with the Datapel WMS solution.
The optimal configuration for a combination of MYOB/WMS is on a Terminal Server or Application Server. Installing MYOB/WMS on a server dramatically reduces total cost of ownership as upgrades need only be done on the server, forms and templates can be centralised. Remote Desktop support is simplified because Datapel can help individual users by providing live on-screen support. The currently supported operating systems are Windows Server 2003/2008 (Standard Edition) or Windows XP Professional/Windows 7 Professional. Windows VISTA is currently not supported other than as a Remote Desktop client.
The following examples identify common configurations based on the number of Concurrent Users:
In this configuration MYOB / WMS / MS Office are installed on the Small Business Server (SBS) box. To facilitate multi-user access Datapel recommends WinConnect or XPUnlimited as an integrated RDP Server. Microsoft SQL Server and Exchange Server should also be operating from the SBS. This configuration supports up to 5 USERS. It is important to note that OUTLOOK EXPRESS must be used in this configuration not OFFICE OUTLOOK. Outlook is not supported in this configuration. See below as Small Business Server 2008 is not support without a Terminal Server or on a case by case basis dependent on the specific Hardware Configuration installed.
Windows Small Business Server 2008
The introduction of Server 2008 has brought with it a considerable increase in the resources required of the server hardware. In general we have found Server 2008 requires double the memory (RAM) of previous Server 2003 implementations to operate within our guidelines. Furthermore, with Small Business Server 2008 we NO LONGER support direct installation of the WMS Application within the DOMAIN CONTROLLER environment. We recommend either VMWARE EX or Microsoft Virtual Server and the installation of a VIRTUAL TERMINAL SERVER.
In this configuration the Terminal Server and Domain Controller are independent hardware servers. In this configuration MYOB / WMS / MS Office are installed on the Terminal Server. This configuration is only supported up to 15 USERS and is dependent on the hardware resources available to the Terminal Server.
Splitting the Database Server and Application Terminal Server allows the Datapel and MYOB system to scale from 15 to 30 Concurrent Users.
In this configuration the SQL server is typically installed on a server and each workstation is configured to communicate to the server directly. This is the least desirable configuration as performance is totally dependent on the configuration of each client. In our experience client computers contain many user applications and are typically resource limited. Datapel ESM does not cover this configuration.
In planning the maximum number of concurrent Remote Desktop sessions that can run on a single Windows Terminal Server you should consider the following factors:
For Application and SQL Server System Requirements review see Application Resource Requirements.
The following example is based on a 15 User site where the terminal server will be required to support Office applications, MYOB and Datapel WMS.
In order to complete the project the following is suggested:
Domain Controller/SQL Server
Operating System Microsoft Windows Server 2003 - Premium Edition (64 Bit) includes SQL Server
Example: HP ProLiant ML330 G6.
Operating System Microsoft Windows Server 2003 - Standard Edition (32Bit)
Example: IBM xSeries 3500 Dual Xeon QuadCore 3GHz with 4GB RAM.
Networking and Switch
Terminal Server to have dedicated switch for client connections.
Domain/SQL server to Terminal Server direct connection bypassing any external switch.
System sizing and implementation procedures should only be followed by authorised system administrators or Datapel support technicians. This information is for a TYPICAL implementation and each site implementation should be thoroughly reviewed based on its unique requirements.