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

Azure System Requirements

1. Web App (Azure App Service)
   1. Description:
      1. Required to host the iRely application
      for the company and
      1. .
      2. If you are using 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. 1. with multi-company, then you will need to create a second Web App to host that.
   5. Name: Name of your choice
   6. Publish: Container
   7. Operating System: Windows
   8. Region: East US 2
   9. Windows 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 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 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 EnvironmentsEnvironment Databases
      1. TE1, TE2, etc.
      2. Backup redundancy: Locally-redundant (LRS)
      Type: Elastic Pool
   9. Purchase Model: vCore (4 cores or higher depending on users and usage patterns)
   10. Service Tier: Hyperscale
   11. Hardware Type: Gen 5
   12. 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. (PDF, JPG, PNG, MP4, etc.)
   5. Performance: Standard (General-Purpose v2)Storage Account Type: General Purpose V2
   6. Access Tier: Hot
   7. 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 Companiesthe Company databases.
   2. Tier: Standard or Premium (based on usageRecommend Premium for large production workloads)
   3. Microsoft Pricing Details
      1. https://azure.microsoft.com/en-us/pricing/details/service-bus/
          
5. Power BI Embedded
   1. Description: Required 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 Details
      1. https://azure.microsoft.com/en-us/pricing/details/power-bi-embedded/

...