Posts

Showing posts from February, 2025

Install OpenRose on Network Computer(s)

Image
Multi-user Corporate Network / Team installation of OpenRose - Requirements Management - An Open Source and FREE Requirements Management Application / Tool. This guide helps users to install all required software and components to run OpenRose on a network computer(s). It guides users to install  OpenRose WebUI front-end  OpenRose API back-end  SQL Server Database  on single / multiple network connected computer(s) and configure it.  Direct Link to YouTube Video :  https://www.youtube.com/watch?v=oL6jQQvn1oQ Video Transcript : Hello, Today we are going to talk about installing OpenRose in a network environment. The first scenario we will discuss is installing all the required components on a single computer, which could be a server or a desktop computer. We will start by making sure that the required components for OpenRose to run are present in the target environment. The reason for discussing this today is to provide an overview of how this installati...

SQL ‐ Script to add IIS APP Pool user in SQL Server Database

Image
IIS is Internet Information Services in which one could host OpenRose API and OpenRose WebUI projects. OpenRose API connect to the SQL Server database mainly for CRUD (Create, Read, Update and Delete) operations. For this purpose, IIS user has to be authenticated in SQL Server. To be able to do that, Microsoft provides support for adding IIS App Pool user into SQL Server Database as Windows Identity. Following script is designed to help users to create IIS App Pool account to be added first into SQL Server and then as database owner for OpenRose database. This way, It's possible to use this user to establish communication between OpenRose API and SQL Server OpenRose Database. NOTE : We have tested below scripts in our test environment and it's provided on an "As Is" basis. OpenRose team does not guarantee it's workings and outcomes. Person running script script in SQL Server has to have sysadmin and dbowner role for SQL Server and the Database respectively ...

Install OpenRose on Standalone Computer

Image
  Personal Installation of  OpenRose - Requirements Management - An Open Source and FREE Requirements Management Application / Tool. This guide helps users to install all required software and components to run OpenRose on a single computer. It guides users to install  OpenRose WebUI front-end  OpenRose API back-end  SQL Server Database  on single computer and configure it. Direct Link to YouTube Video :  https://www.youtube.com/watch?v=yuGIZtxsXIA Video Transcript : Hi, today we are going to talk about the `Standalone Installation of OpenRose`. By "Standalone", I mean it will be installed on a single Windows computer and will be accessible locally on that specific machine.  To run any .NET application, you will need to install the .NET runtime. OpenRose currently runs on .NET Version 9.x, so you will need the .NET runtime version 9.x. Here is the download link: Download .NET 9.0 . For a standalone installation, you will require the x64 runtim...

Agile Loves Clear Requirements

Image
  Agile Loves Clear Requirements OpenRose - Requirements Management An Open Source and FREE Requirements Management Application / Tool Direct Link to YouTube Video :  Agile Loves Clear Requirements Video Transcript : Today, I would like to talk about the importance of requirements in project delivery or product delivery, especially when using Agile methodologies like Scrum or Kanban. In the Scrum ways of working, we have user stories that are put into the Sprint backlog. From the Sprint backlog, the team pulls out certain user stories for a given Sprint, which could be a two to four-week Sprint. During this Sprint, the team has daily standups to discuss progress and blockers. At the end of the Sprint, it is expected that the team will deliver a product increment, which could be a service delivery or a product delivery. Let's consider a project where we have team members, represented by circles. The size of the circle indicates their knowledge, seniority, experience, and sk...

Breadcrumbs - Requirements Management

Image
  Breadcrumbs - Requirements Management  OpenRose - Requirements Management An Open Source and FREE Requirements Management Application / Tool Direct Link to YouTube Video : Breadcrumbs - Requirements Management Video Transcript : Welcome to OpenRose, an open-source and free requirements management application. Find more information at GitHub - OpenRose . Today, we are going to talk about breadcrumbs. The question that comes to mind is how requirements management and breadcrumbs are related in anyways. Let me start by explaining that breadcrumbs are a concept in software applications whereby we can show how far deep in the hierarchy we have gone when working with structured data. OpenRose has two different possibilities for using breadcrumbs: as a technical enabler or as a visualization of data to indicate where you are in the Project or Baseline hierarchy. Let me start by going into our projects. Here we have the "Barclays terrif for Personal Customers" project, which I ...

Requirement Baseline Details View

Image
  Requirement Baseline Details View OpenRose - Requirements Management An Open Source and FREE Requirements Management Application / Tool Direct Link to YouTube Video :  Baseline Details View - Requirements Management - YouTube Video Transcript : Hi and welcome to OpenRose, a FREE and Open-Source requirements management application. You can find more information about the same at OpenRose - FREE Requirements Management Application .  Today, we are going to talk about Baseline requirements in Detail View.  Let's dive into the project titled Barclays tariff for personal customers and take a look at the tree view. First, it has well-organized requirements, and at the project level, we can see existing baselines or create new ones by project or Item Type. We have already created January and February Baselines, which are based on the entire project, as well as Loans January and Loans February Baselines, which are based on specific Item Types. Let's explore January 202...