Microsoft Azure Infrastructure

Below are the Azure resources required to host an iRely Multi-Company & MDM running in a single Azure SQL Database. This solution can use Docker Containers to deploy the App Service.

Azure Resources Required

1. App Service
   1. App Service (Company)
   2. App Service (MDM)
      1. Required if Master Data is required for multi-company.
   3. Operating System: Windows
   4. Tier: Premium V3 (based on usage)
   5. Instance: P1 or greater
   6. https://azure.microsoft.com/en-us/pricing/details/app-service/windows/
       
2. Azure SQL Database
   1. Company Database
      1. Backup redundancy: Geo-redundant
      2. Replica: Named Replica (Recommend at least 1 for reporting)
      3. Replica: High Availability
   2. MDM Database
      1. Required if Master Data is required for multi-company.
      2. Backup redundancy: Geo-redundant
      3. Replica: High Availability
   3. Test Environment
      1. TE1, TE2, etc.
      2. Backup redundancy: Locally-redundant
   4. Type: Elastic Pool
   5. Tier: Hyperscale
   6. https://azure.microsoft.com/en-us/pricing/details/azure-sql-database/elastic/
       
3. Storage Account
   1. Required for attachments/documents
   2. Type: Block Blob Storage
   3. File Structure: Hierarchical Namespace
   4. Storage Account Type: General Purpose V2
   5. Access Tier: Hot
   6. https://azure.microsoft.com/en-us/pricing/details/storage/blobs/
       
4. Service Bus Namespace
   1. Required for MDM real-time data push to Companies
   2. Tier: Standard or Premium (based on usage)
   3. https://azure.microsoft.com/en-us/pricing/details/service-bus/
       
5. Power BI Embedded
   1. Node Type: A1 to A8 (based on usage)
   2. https://azure.microsoft.com/en-us/pricing/details/power-bi-embedded/