210 likes | 322 Views
Overview of the technology that comprises Attendance Enterprise. MDAC. IIS. NT/2K. NT/2K Server. ODBC. SQL Server. Web Server. Application Servers. Integrating the Labor Management Process. Data Collection Devices. Human Resources. Time and Attendance. Payroll Processing.
E N D
Overview of the technology that comprises Attendance Enterprise
MDAC IIS NT/2K NT/2K Server ODBC SQL Server Web Server Application Servers Integrating the Labor Management Process Data Collection Devices Human Resources Time and Attendance Payroll Processing Desk Top Network Backbone ERP & Labor Management Analytics Automated Solution DatabaseTools
Development Principles Flexibility User defined workflow management tools Connectivity Fiber Networks to 28.8K Dial up Connections Scalability MS SQL Robust Scalable Architecture
Application Services Browser Based Clients Scalable Architecture MS SQL Servers Web Server Network Server MSI CSC Windows Workstation
MS SQL Server • Multiplexing, Multipooling & Distributed Processing • OLTP, OLAP and Data Mining utilities • Automatic fall back and data mirroring • Server Clustering • No need for a ‘repair tables’ utility
Database Merging • MS SQL Triggers & Scripts • ODBC Scripts • Flexible Importing & Exporting • Processes Utility
Application Services Browser Based Clients Application Server MS SQL Servers Web Server Network Server MSI CSC Windows Workstation
Attendance Enterprise is available in a multi-tiered configuration. Many lengthy processes can be ‘off-loaded’ onto central Windows 2000/NT Servers for faster processing. Application Services Why Services?
3 Tier Architecture Database Processing Client
Application Services Browser Based Clients Client Management MS SQL Servers Web Server Network Server MSI CSC Windows Workstation
The user interface is based upon the Microsoft ‘Outlook’ frame design. Attendance Enterprise uses Microsoft SQL Server (7 or 2000) for data storage. ADO (Active Data Objects) are used for communication between the application and the database provider. User Interface
Any Summary Sheet data presented within Attendance Enterprise can be easily copied to Microsoft Excel. OLE Automation
Application Services Browser Based Clients Web Services MS SQL Servers Web Server Network Server MSI CSC Windows Workstation
Integrate Self Service Goals Administrative Reducing Cost & Overhead Eliminating process’s, steps, approval, forms Strategic Improve Service to Employees and Managers Increase Information Accessibility
Attendance Enterprise implements its own ISAPI component for all Browser clients. Client state information is maintained without the need for browser cookies or java applets. Supervisor access and Employee Self Service each maintain individual thread pools and connection management for ‘best possible’ IIS scalability. ISAPI Browser Component
Application Services Browser Based Clients Security MS SQL Servers Web Server Network Server ADO MSI DCOM CSC Windows Workstation
Attendance Enterprise tables are protected through the use of MS-SQL Application Roles, MS-SQL Accounts or NT Authenticated User Accounts. Network traffic is optionally encrypted by MS-SQL. Security
WORKSTATIONS • NT Authentication NETWORK • AE User Account • Application Role / SQL Account ATTENDANCE ENTERPRISE MS SQL SERVER WEB SERVER www.abcInc.com/ virtualDirectory/ bbe.aew/ DEFAULT BROWSER Optional Assigned Domain Does not require any downloading such as ‘Cookies’ or ‘Java Applets’ for enhanced security IIS ‘Read Only’ Attributes ISAPI Filter ISAPI Driven PUSH protocol
Feature Set • Scalability • 3 Tier Architecture • Thin Client (Browser Based) • ISAPI Driven • Full utilization of MS SQL Server • C2 Level Government Security