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 updates.

Azure System Requirements

  1. App Service
    1. Description: Required to host the iRely application for the company and Master Data Manager (MDM).
    2. App Service (Company)
    3. App Service (MDM)
      1. Only required if Master Data Manager is used for multi-company infrastructure.
    4. Operating System: Windows
    5. Plan: App Service Premium plan (based on usage)
    6. Tier: P2mv3 or greater (4 cores, 32 GB RAM minimum and can scale to higher tiers based on usage)
    7. Microsoft Pricing Details
      1. https://azure.microsoft.com/en-us/pricing/details/app-service/windows/
         
  2. Azure SQL Database
    1. Description: Required for the databases used in the App Service.
    2. Company Database
      1. Backup redundancy: Geo-redundant (RA-GRS)
      2. Replica: Named Replica (Recommend at least 1 for reporting)
      3. Replica: High Availability
    3. MDM Database
      1. Required if Master Data is required for multi-company.
      2. Backup redundancy: Geo-redundant (RA-GRS)
      3. Replica: High Availability
    4. Test Environments
      1. TE1, TE2, etc.
      2. Backup redundancy: Locally-redundant (LRS)
    5. Type: Elastic Pool
    6. Purchase Model: vCore (4 cores or higher depending on users and usage patterns)
    7. Service Tier: Hyperscale
    8. Hardware Type: Gen 5
    9. Microsoft Pricing Details
      1. https://azure.microsoft.com/en-us/pricing/details/azure-sql-database/elastic/
         
  3. Storage Account
    1. Description: 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. Microsoft Pricing Details
      1. https://azure.microsoft.com/en-us/pricing/details/storage/blobs/
         
  4. Service Bus Namespace
    1. Description: Required for MDM real-time data push to Companies
    2. Tier: Standard or Premium (based on usage)
    3. Microsoft Pricing Details
      1. https://azure.microsoft.com/en-us/pricing/details/service-bus/
         
  5. Power BI Embedded
    1. Description: Required to host the Power BI Embedded instance.
    2. Node Type: A1 to A8 (A1 or higher based on usage)
    3. Microsoft Pricing Details
      1. https://azure.microsoft.com/en-us/pricing/details/power-bi-embedded/



  • No labels