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

Compare with Current View Page History

« Previous Version 9 Next »

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

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: Standard or Premium (based on usage)
       
  2. Azure SQL Database
    1. Azure SQL Database (Company)
    2. Azure SQL Database (MDM)
      1. Required if Master Data is required for multi-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,
    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/




  • No labels