You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

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 Database
    1. Azure SQL Database (MDM)
      1. Required if Master Data is required for multi-company
    2. Azure SQL Database (Company)
    3. Type: Elastic Pool
    4. Tier: Hyperscale
    5. 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, General Purpose V2, Hierarchical Namespace, Hot
    3. 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/




  • No labels