Given the sensitive data and multi-company use case, we implemented a multi-tenant architecture using separate databases per company via Azure SQL Database Elastic Pool. This securely segregated data while we tried to keep the Angular frontend and .NET backend simple and flexible expecting future iterations. The MVP featured basic time/expense tracking, offline mode, user invitations, management reports, and law firm administration pages. Extra care was given to security and reliability of the system, and we relied on Azure platform a lot, including different resources and Azure DevOps for project management. According to the requirements, we have also implemented SendGrid integration to send invitations and PDF generation for simple financial statements. The multi-tenant structure and dedicated databases enabled SaaS data isolation between customers. Our phased approach allowed a successful initial launch within time and budget constraints while positioning the product for additional capabilities in the future.
Given the sensitive data and multi-company use case, we implemented a multi-tenant architecture using separate databases per company via Azure SQL Database Elastic Pool. This securely segregated data while we tried to keep the Angular frontend and .NET backend simple and flexible expecting future iterations. The MVP featured basic time/expense tracking, offline mode, user invitations, management reports, and law firm administration pages. Extra care was given to security and reliability of the system, and we relied on Azure platform a lot, including different resources and Azure DevOps for project management. According to the requirements, we have also implemented SendGrid integration to send invitations and PDF generation for simple financial statements. The multi-tenant structure and dedicated databases enabled SaaS data isolation between customers. Our phased approach allowed a successful initial launch within time and budget constraints while positioning the product for additional capabilities in the future.