Attachment F - Technical Requirements Form
The City has an established technology architecture that describes standard services and operating requirements for desktop, data center environments, and network communications. Vendor systems hosted in the City environment are expected to operate within these standards.
To be considered a complete response to this section of the RFP, Vendors must indicate that their systems can operate within standards and/or meet these requirements (where applicable), or describe in detail any recommended or required variations to optimize performance of their installed products.
The City encourages and is open to cloud-based solutions and, in such instances, it is acceptable to respond with a “Not Applicable” to these requirements as appropriate.
Using the tables in the matrix document, the Vendor will respond to each individual requirement by entering an ‘X’ in one of the columns provided. Select the appropriate response using the following guidelines below.
ID / Unique identifier for reference purposes.Requirement / The specific function or behavior necessary to satisfy city business needs.
Standard (S) / The requirement is satisfied by the solution proposed without configuration. Where the requirement is satisfied by third-party software, indicate the third party product proposed.
Configured (Cf) / The requirement is not satisfied by the solution out of the box, but is satisfied by configuration.
Customized (Cs) / A modification to the solution is required to satisfy this requirement. Provide an explanation of the volume of labor and work complexity. In addition, indicate whether the requirement will be satisfied by an upcoming release, and if so, give the version number and date of release.
Unavailable (U) / The solution will not satisfy the requirement.
Not Applicable (NA) / The requirement is not applicable to the proposed solution. E.g. a server operating system requirement would not be applicable for a cloud-based or hosted solution.
Describe how requirement will be met / Details regarding the delivery of the requirement. Narrative must adequately describe how the Vendor solution can satisfy the requirement. Screenshots, sample reports, or supporting documentation may be included in the response.
Overview of City Technical Operating Environment
The City operates out of 21 different facilities throughout Overland Park. Each building is connected to the City-owned and maintained fiber ring network. The vast majority of desktop PC’s within each facility are connected to the network via 1 Gbps connections with a small number of PC’s operating on a 100 Mbps connection. The City maintains 2, redundant internet service provider connections - 1 dedicated 25 Mbps connection and 1 dedicated 50 Mbps connection - with configuration to support failover during any unplanned network outages. Each City facility is also wired with 802.11 a/g wireless access points with both a secure (RADIUS authenticated city personnel and devices only) and public wireless network access.
Desktop computing is provided via desktop PC’s, laptop computers, and a virtual desktop infrastructure (VDI) using Wyse terminals and Citrix XEN Server 6.2. Of the approximately 860 PC’s within the City, approximately 150 are of the VDI variety.
The City has standardized on a desktop PC operating system environment of a combination of Windows 7 with Service Pack 1 and Windows 10. Every authenticated user is granted local administrator rights on each PC. Supported internet browsers are Internet Explorer (version 9 or higher), Firefox (version 28.0 or higher), or Google Chrome (version 31.0 or higher). The City does not require nor mandate a default browser as varying applications within use in the City require different browsers. For email, calendaring and contacts the City has standardized on Google Apps for Government (Gmail) and for office productivity, the city uses Google Docs (Drive, Docs, Spreadsheets and Presentations) along with a small install base of Microsoft Word and Excel 2013 where Criminal Justice Information Systems (CJIS) regulations and core business practices require.
All server environments within the City operate on a virtualized server infrastructure based on VMware vSphere ESXi 5.1. The VMware host infrastructure is redundant across the 2 main city technology facilities. All server data storage is handled via the City’s Compellent storage array (SCOS version 6.3.10) with 2, 150 TB storage arrays connected via 8 Gbps fiber channel across the 2 main City technology facilities. Preferred server operating system environment is Windows Server 2008 R2 or later. Preferred web server is Internet Information Server (IIS) but there are instances of Apache and Weblogic within the City where required by specific software solutions.
From a mobile perspective, the City supports both iOS and Android tablet and smartphones. iOS 7 or higher is the preferred mobile environment, particularly in instances where City-developed and/or maintained custom software is required. Android platforms are allowed if no City developed applications or customizations are required (e.g. native, vendor supported applications only). Varying Android versions are supported based on vendor requirements.
The City supports numerous off the shelf and custom developed software solutions and integrations. The preferred development platforms and/or tools for custom developed software, tools and integrations include:
● PHP and C# (Microsoft .Net) for web development
● C# for desktop client-server application and Windows service development
● Microsoft SQL Server 2008 or higher and MySQL for database platforms (note that the city does currently have and support Oracle databases but is moving away from Oracle as a supported database platform)
● jQuery and jQueryUI for JavaScript and user interface design/development
● Git for source control and version management
The City prefers the use of web services to support integrations between disparate information systems but recognizes this may not always be feasible. Therefore, the City will be open to suggestions for other forms of integration between systems such as database triggers and stored procedures, automated extract-transact-load (ETL) procedures, etc.
Operating Environment
Requirement / S / Cf / Cs / U / NA / How will this be satisfied?Virtualization: VMware Ability
Server: Microsoft Windows Server (2012 minimum)
Database: Microsoft SQL Server (2012 minimum)
Desktop: Windows 7 and Windows 10
Email Client: Gmail - Google Apps for Government
Desktop Productivity Software: Google Apps for Government
Desktop Browser: current versions of Google Chrome and Internet Explorer (IE)
Remote Access: SSL VPN
System & Data Security
The future system must provide a completely secure tool with logging and audit capabilities. Along with the security, audit reports must be able to be generated to determine what a specific user inquired on or updated, as well as the reverse, all staff touching certain data records. Proper security should be implemented to ensure safekeeping of financial and personnel data.
Requirement / S / Cf / Cs / U / NA / How will this be satisfied?Secure user login tied to the City’s Active Directory (AD) setup or login with Google apps authentication.
Role-based security to allow for users to be assigned one or more roles. Security is granted based on these roles. Roles must be fully manageable in the system and include a name and description describing the purpose of each role.
Restricted access to specific modules, screens, records, and fields. Ideally each of these securities is fully configurable in the system by Information Technology staff or department heads.
Allow for continuous upgrades of technology to support current and future core functional needs.
Actions and changes made by all resources are recorded using timestamps, with the ability to easily query a user’s or group of user’s activities (auditing).
Integrations
The expectation is that the future system can integrate with the systems below and provide a complete, robust, and manageable application program interface (API) which can be utilized by City.
Below are the interfacing systems the City desires to automate communication with.
Requirement / S / Cf / Cs / U / NA / How will this be satisfied?Google Apps for Government - for email and office productivity. Tools from the future system must be able to accept and export files from these sources. Also needs to interface with email and calendars provided from Google.
Active Directory Domain Services or login with Google apps to integrate security and single-sign-on.