Page History

Here's a typical infrastructure that can be used to host Microsoft Azure SQL Database.

Azure Resources Required

1. App Service Plan
   1. App Service (MDM)
      1. Required if Master Data is required for multi-company
   2. App Service (Company)
2. Azure SQL Server (Hyperscale tier)
   1. Azure SQL Database (MDM)
      1. Required if Master Data is required for multi-company
   2. Azure SQL Database (Company)
3. Storage Account
   1. Required for attachments/documents
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/