Only as required to meet the server operating system requirements.
None, other than standard backups of the server and the SQL database.
None other than standard server firewall and AV applications managed by the client.
We have successfully installed and run the EPRS on a fixed server, local virtualized server and a virtualized cloud server.
The advantages and constraints for cloud vs. local servers are independent of the ERPS and based on corporate requirements. The only additional EPRS constraint is that the installed server must have access to all data sources within the company, which generally requires the server to be within the corporate firewall.
EPRS automation engine is written in Visual C, the macro coding is programmed with a proprietary Minitab application language.
Every installation has used a MS-SQL database, but any hosted SQL database should work.
The UID & PWD used by the EPRS to acquire data from SQL databases is visible to admin users and is not encrypted in the system. For most clients, this is a unique EPRS UID/PWD setup with read-only access to a mirrored copy of the corporate data warehouse.
All entry paths are through the web application using ERPS managed user rights.
The primary outputs of the system are pushed out to the IIS Webserver. There is an ability to upload and download data from the system by developers during the system setup. No data access is available for non-admin right users.
Data input validation should be performed during the development and setup of a performance metric. A Minitab Add-In is provided for validation purposes. When the metric data and display settings are validated, the settings are transferred to the EPRS for automated reporting. If data validity issues occur after setup, the system will replace the performance graphic with a informative graphic describing the data problem.
All SQL tables include hashed metric references and ID reference values. Labels and specific parameter settings used to create the graphic are not encrypted or hashed.
User and admin
Internal userid/pwd or using Active Directories
The EPRS maintains a log documenting key activities and faults. This log may be viewed and downloaded by anyone with admin rights. If the EPRS does provide a fault during programming or setup, a code is provided at the top of the page for the admin to copy down. It is similar to the entry in the error log and will help diagnose the issue when provided to the support staff.
All intermediate data is stored within the Minitab software environment, not within the EPRS.
There is no sensitive data within the EPRS. Sensitive information may appear in .jpg graphics as part of a chart. These graphics are visible to all network and EPRS administrators
Standard network rights to the server the application resides on.
Standard network rights to the host
Smarter Solutions maintains documents that list each revision and its functionality changes.
Nothing is provided to external developers. Smarter Solutions has a single multi-faceted data set used for software and macro development.