Search and Analysis Application

The vendor is required to provide search and analysis application includes but is not limited to record management systems data, calls for service data, traffic created data, license plate readers data, and text documents.
•    Application will allow for the creation of different user groups with different roles and Permissions (user, admin, super admin). 
•    users should authenticate using multi-factor authentication and the system must use enhanced security features, such as captcha, for protecting the web-based application against bot attacks.
•    Application should query data sources live or cache and delete data within a specific set time frame. 
•    Application should allow for the query of all data sources including SQL or oracle-based datasets, text documents, images and other media files if included in the original datasets (ex. LPR photos) and APIs to access features such as query execution and return of data. 
•    Application should only query the data sources selected during the querying process by users and limit results to a configurable number of rows determined by centers staff. 
•    Explain how queries and query results delimitation would be implemented. 
•    The application currently used by centers staff and partners leverages more than 170 i PSEC VPN connections to partner agencies networks in a microsoft azure tenant (currently about 35% of rms data sources are connected). 
•    The application should be able to leverage those pre-existing connections and additional connections to partner agencies as they are established. 
•    Such connections could be leveraged by application and environment. 
•    Application must support batch queries. 
•    Users should be able to save and export their search results (csv, pdf, integration with third-party email to disseminate results automatically). 
•    Users should be able to save, automate, and create alerts for specific queries.
•    The application should include editable dashboards including dashboards to allow admins to monitor application performance and connections status. dashboards should easily present application information such as top users and top searches.
- Optional features:
•    Ability to generate data reports to summarize query results. 
•    Ability to generate link charts to allow users to visualize query results. please provide examples and screenshots of such link charts. 
•    Ability to map data if applicable. 
•    Ability to save the results of automated queries to a specified file name and location on a network drive, without requiring any user interaction.

- Questions/Inquires Deadline: September 19, 2025