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
- App Service
- Description: Required to host the iRely application for the company and Master Data Manager (MDM).
- App Service (Company)
- App Service (MDM)
- Only required if Master Data Manager is used for multi-company infrastructure.
- Operating System: Windows
- Plan: App Service Premium plan (based on usage)
- Tier: P2mv3 or greater (4 cores, 32 GB RAM minimum and can scale to higher tiers based on usage)
- Microsoft Pricing Details
- Azure SQL Database
- Description: Required for the databases used by the App Service.
- Company Database
- Backup redundancy: Geo-redundant (RA-GRS)
- Replica: Named Replica (Recommend at least 1 for reporting)
- Replica: High Availability
- MDM Database
- Required if Master Data is required for multi-company.
- Backup redundancy: Geo-redundant (RA-GRS)
- Replica: High Availability
- Test Environment Databases
- TE1, TE2, etc.
- Backup redundancy: Locally-redundant (LRS)
- Type: Elastic Pool
- Purchase Model: vCore (4 cores or higher depending on users and usage patterns)
- Service Tier: Hyperscale
- Hardware Type: Gen 5
- Microsoft Pricing Details
- Storage Account
- Description: Required for attachments/documents (PDF, JPG, PNG, MP4, etc.)
- Performance: Standard (General-Purpose v2)
- Access Tier: Hot
- Microsoft Pricing Details
- Service Bus Namespace
- Description: Required for MDM real-time data push to the Company databases.
- Tier: Standard or Premium (Recommend Premium for large production workloads)
- Microsoft Pricing Details
- Power BI Embedded
- Description: Required to host the Power BI Embedded instance directly in iRely.
- Not required if using a Data Lake for reporting.
- Node Type: A1 to A8 (A1 or higher based on usage)
- Microsoft Pricing Details
- Description: Required to host the Power BI Embedded instance directly in iRely.
Overview
Content Tools