The EBMS Client/Server is an application that runs as a service on a Microsoft Windows based server such as MS Windows Server 2008 R2, 2008, 2003 or business grade operating system such as Windows 7 Pro or higher. All file access functions are managed by the server software running on the application server. This option allows the clients to request specific information from the server rather than opening, sorting, and indexing the files individually.
Adding the EBMS server to a network is like placing an individual by the file cabinet that responds to the requests of others within the office rather than each person finding and accessing the information individually.
Companies using EBMS that have 5 or more users (or 3 or more frequent users) should adopt the EBMS Server rather than using a peer-based network solutions
EBMS client/server offers many advantages over the standard networked model of database access:
- Stability - The risk of database damage and corrupted indexes are greatly reduced because the database server is the only application that implements changes to the database. The EBMS Server is a good option to reduce data corruption caused by a faulty network.
- Performance - EBMS Server reduces traffic on a network which will reduce the strain on most networks especially in a situation with limited bandwidth. The reduced network traffic may increase the speed of database operations significantly and increase overall performance. Running the EBMS server on a high-performance server computer may also improve overall performance by allowing the client application to take advantage of the server’s inherent processing speed. Eagle Solutions recommends that the EBMS Server application is implemented when EBMS is used with more than 5 simultaneous users.
- Data Integrity – EBMS will roll back any partially created transactions if a power outage, network failure, or other interruption aborts a process such as processing invoices, timecards, payments, or writing any information. If the EBMS Server has not received all transactions within a process, EBMS ignores the entire set of transactions. This ensures that the large volume of data maintained by EBMS does not become mismatched.
- Security – The EBMS server helps the user secure company data even better. Files do not need to be shared. The only way to access the data on the network is by logging on the server. Communications with the server are encrypted. In addition to basic account information, you can also specify an IP address range for any account. If the account doesn’t log in from a machine within the specified range, access is denied.
- Scalability – The client/server application allows EBMS to scale to 50 users
- Easy Server Configuration - EBMS Server makes it much easier for the administrator and the end-users to configure and maintain the EBMS information store. All server configuration options can be accessed through the EBMS Administrator application.
- Information Reporting - The EBMS server can supply reports on a variety of information to help the administrator manage the client/server applications. The reporting enhancements include
- Server Information - Provides general information on server up-time, number of users connected and more
- Account Reports - Provides details on all current server accounts, including account-level file privileges and any IP address restrictions
- Privilege Reports - Provides a list of all individual account/table privileges recognized by the EBMS server
- Connection Information - Provides you with a number of different reports that detail which accounts are currently connected to the EBMS server, which tables each account is using and what table/record locks each account has in place. Useful both for security reasons and when troubleshooting applications
All server reports can be accessed easily through EBMS server administrator