Page History

Below are the Azure resources required to host an iRely iRely on Azure using an Azure App Service and Azure SQL Database. This architecture is recommended when hosting Multi-Company & MDM running in a single Azure SQL Database. This solution can also use Docker Containers to deploy the App Serviceupdates.

Azure

...

System Requirements

1. Web App Service(Azure App Service)
   1. Description:
      1. Required to host the iRely application.
      2. If you are using Master Data Manager (MDM) with multi-company, then you will need to create a second Web App to host that.
   2. Name: Name of your choice
   3. Publish: Container
   4. Operating System: Windows
   5. Region: East US 2
   6. Windows Plan:
   (Company)
   7. App Service (MDM)
      1. Only required if Master Data Manager is required for multi-company.
   8. Operating System: Windows
   9. Plan: App Service Premium plan (based on usage)
   10. TierPricing Plan: Premium v3 P2mv3 or  or greater (4 cores, 32 GB RAM minimum and can scale to higher tiers based on usage)
   11. Microsoft Pricing pageDetails
       1. https://azure.microsoft.com/en-us/pricing/details/app-service/windows/
           
          
2. Azure SQL Database
   1. Description: Required for the databases used by the App Service.
   2. Type: Elastic Pool
   3. Purchase Model: vCore (4 cores or higher depending on users and usage patterns)
   4. Service Tier: Hyperscale
      1. https://learn.microsoft.com/en-gb/azure/azure-sql/database/service-tiers-sql-database-vcore?view=azuresql#service-tiers
   5. Hardware Type: Premium-series or Gen 5
   6. Company Database
      1. Backup redundancy: Geo-redundant (RA-GRS)
      2. Replica: Named Replica (Recommend at least 1 for reporting)
      3. Replica: High Availability
   7. MDM Database
      1. Required if Master Data is required for multi-company.
      2. Backup redundancy: Geo-redundant (RA-GRS)
      3. Replica: High Availability
   8. Test Environment DatabasesTier: Hyperscale
      1. TE1, TE2, etc.
      2. Backup redundancy: Locally-redundant
   9. Type: Elastic Pool
   10. 1. (LRS)
   11. Microsoft Pricing pageDetails
       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. (PDF, JPG, PNG, MP4, etc.)
   5. Performance: Standard (General-Purpose v2)Storage Account Type: General Purpose V2
   6. Access Tier: Hot
   7. Microsoft Pricing pageDetails
      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 Companiesthe Company databases.
   2. Tier: Standard or Premium (based on usageRecommend Premium for large production workloads)
   3. Microsoft Pricing pageDetails
      1. https://azure.microsoft.com/en-us/pricing/details/service-bus/
          
5. Power BI Embedded
   1. Description: Optional and can be used to host the Power BI Embedded instance directly in iRely. 
      1. Not required if using a Data Lake for reporting.
   2. Node Type: A1 to A8 (A1 or higher based on usage)
   3. Microsoft Pricing pageDetails
      1. https://azure.microsoft.com/en-us/pricing/details/power-bi-embedded/

...