Skip to main content

Star-knowledge

Customer story

Property Database Management System – ASP.NET MVC App

One of the world’s leading rental-housing and real estate development companies, with operations spanning Latin America, Asia-Pacific, Europe, and the United States, needed a secure, enterprise-grade way to manage its property data alongside Office 365 and Azure AD single sign-on. We built a scalable ASP.NET MVC application on Azure PaaS, with SSO, security-group-based access, and Power BI analytics built in, keeping this sensitive data locked down while the platform scaled to thousands of requests.

Engagement facts

Client

Leading development & construction services provider and global rental-housing operator

Industry

Real estate — Investment, Property & Rental Housing Management

Region

Latin America, Asia-Pacific, Europe, and the United States

Service

Custom ASP.NET MVC property database management system

Stack

ASP.NET MVC

Azure PaaS

Azure SQL

Azure AD (SSO)

Power BI

Azure DevOps

0

regions with active operations — Latin America, Asia-Pacific, Europe, US

SSO

single sign-on via Azure AD, with security-group–based access

0

technologies integrated into the platform 

5

key benefits delivered, from scalability to automated DevOps releases

Property Database Management System

The client

One of the world's leading rental-housing and real estate development companies

The client is one of the leading development and construction services providers, and a global leader in rental housing, operating across Latin America, Asia-Pacific, Europe, and the United States. Its real estate expertise spans Investment Management, Property Management, Apartment Search, and rental housing services.

The need

A secure, SSO-enabled property database, tightly integrated with Office 365 and Azure AD

The client wanted to build an enterprise-grade property database management system, integrated with Office 365 and Azure AD for single sign-on (SSO). Because the data involved was highly sensitive, the solution needed to be securely locked down and restricted to certain security groups. The client also had unique filtering and custom-grid requirements, with a Power BI dashboard to highlight several parameters for monitoring and measurement. The system needed to be scalable enough to handle thousands of requests, and the client approached Star Knowledge’s Microsoft-certified consultants to build it.

The challenge

Integrating a new cloud-based system with existing Yardi, Procore, and Power BI tools

The client already relied on several third-party project management tools, including Yardi and Procore, for project and cost-code management, along with custom Power BI dashboards for analytics and data insights. Given this existing software landscape, the client wanted the new property database management system to be fully cloud-based, highly scalable, and built with enterprise-grade security and performance. It also needed to integrate with the client’s existing tools and systems, and support several unique, on-the-fly data filters and search features.

The solution

An OAuth-enabled ASP.NET MVC app on Azure PaaS with a microservice architecture

Star Knowledge’s team of bespoke software consultants conducted a detailed analysis of the client’s business needs, along with a thorough assessment of the existing software and third-party tools that would need to integrate with the new solution. The team proposed building an OAuth-enabled ASP.NET MVC application that integrates with the client’s Azure AD for SSO and authorized application access. The application was built on Microsoft Azure PaaS with a microservice architecture layer for the web services and web application, so each could scale independently.

01

OAuth & Azure AD SSO

Built an OAuth-enabled ASP.NET MVC application integrating with the client’s Azure AD for single sign-on and authorized application access.

02

Azure PaaS microservice architecture

Built the application on Microsoft Azure PaaS with a microservice layer for web services and the web app, so each could scale independently.

03

Azure SQL, built for future NoSQL

Built the database management system on Azure SQL, designed with future integration of a NoSQL database such as Cosmos DB in mind.

04

Automated DevOps release pipeline

Brought in DevOps engineers to design automated test cases and deploy Azure DevOps Services for automated release and pipeline management.

Benefits

What changed for the client

Scalable, purpose-built architecture

A scalable property database management system delivered with a unique design and architecture.

Highly secure & SSO-enabled

Highly secure, SSO-enabled access, configured to work with the client’s Azure AD security groups.

Synced, automated integrations

Custom integration to sync multiple systems and automate updates across them.

Automated DevOps release management

DevOps configuration and automated release management put in place for the new platform.

Technology

What we used

Reading this because your organization needs a secure, custom-built data platform?

See how our ASP.NET and Azure team scopes an enterprise application build.

Your platform

Looking to get a similar solution?

Looking to develop a custom business solution of your own? Get in touch with our team to discuss your project.

More migration work

Related case studies