Hardware Requirements
Below you will find the recommended hardware requirements for DataMart On-Premises deployment.
Please note: Deployment sizes and estimated warehouse database growth correspond to FluentPro internal benchmarks and may not fully reflect your organization needs for performance and stability.
Small deployment
The following are the recommended hardware requirements for small deployments. Recommended servers:
- Server 1: All-in-One box (Job processing, web, SQL)
Minimum hardware requirements for an All-in-One server
HW component |
Minimum requirement |
Processor | 64-bit, 2 cores |
RAM | 4 GB |
Hard disk | RAID1 120 GB Estimated warehouse database growth: 200MB/month |
Medium deployment
The following are the recommended hardware requirements for medium deployments. Recommended servers:
- Server 1: Job Processing and Web Role
- Server 2: SQL Server
Minimum hardware requirements for Job Processing and Web Role server
HW component |
Minimum requirement |
Processor | 64-bit, 2 cores |
RAM | 4 GB |
Hard disk | 80 GB |
Minimum hardware requirements for SQL Server
HW component |
Minimum requirement |
Processor | 64-bit, 4 cores |
RAM | 8 GB |
Hard disk | 80 GB System drive RAID1 100 GB SQL data drive Estimated warehouse database growth: 2000 MB/month |
Large deployment
The following are the recommended hardware requirements for large deployments. Recommended servers:
- Server 1: Web Role
- Server 2: Job Processing
- Server 3: SQL Server
Minimum hardware requirements for Web Role Server
HW component |
Minimum requirement |
Processor | 64-bit, 2 cores |
RAM | 2 GB |
Hard disk | 80 GB |
Minimum hardware requirements for Job Processing Server
HW component |
Minimum requirement |
Processor | 64-bit, 4 cores |
RAM | 8 GB |
Hard disk | 80 GB |
Minimum hardware requirements for SQL Server
HW component |
Minimum requirement |
Processor | 64-bit, 4 cores |
RAM | 12 GB |
Hard disk | Please refer to this article Estimated warehouse database growth: 20GB/month |
Software requirements
Software |
Minimum requirements |
Operating System | The 64-bit edition of: Minimum: Windows Server 2016 or later, Standard or Datacenter edition |
SQL Server | The 64-bit edition of: Minimum: Microsoft SQL Server 2014. Web, Standard, or Enterprise edition |
Please note: Earlier versions of Windows (e.i. Windows Server 2012R2) might still work, however, we cannot guarantee product stability and functionality as we do not test our products on legacy Windows builds that have reached EOL.
Please note: Earlier versions of Microsoft SQL Server (e.i. Microsoft SQL Server 2012) might still work, however, we can not guarantee product stability and functionality.
Please note: SQL Server mixed authentication mode must be enabled. Information about SQL Server requirements can be found here.
List of Windows components that are required to run DataMartOn-Premises instance:
Component |
Requirements |
Web Server (IIS) role | Based on IIS 7.5 or higher. Minimum required components: 1. Common HTTP Components - Default Document - HTTP Errors - Static Content 2. Health and Diagnostic - HTTP Logging 3. Performance - Static Content Compression 4. Security - Request Filtering - Windows Authentication 6. Application Development - .NET Extensibility 4.5 - ASP.NET 4.7.1 - ISAPI Extensions - ISAPI Filters |
SSL Certificate | EPM Pulse On-Premises Edition website requires HTTPS endpoint. SSL certificate can be Self-Signed or obtained from Certificate Authority center. |
.NET Framework | .NET 4.7.2 with the latest Security and Quality updates is a requirement for EPM Pulse Job Processor service .NET 4.7.2 with the latest Security and Quality updates is a requirement for EPM Pulse web site |
Windows PowerShell | Windows PowerShell 3.0 or higher is required to execute configuration scripts |
Please note: If you're going to use Audit Manager for Project Online PWA, DataMart will need to have an external URL with a valid SSL certificate. This URL should be available from SharePoint Online servers.
The list of IP addresses of SharePoint Online servers can be found here.
The purpose of the external URL for Audit Manager is to set this URL as Audit Events Receiver for Project Online PWA. The PWA must be able to send Audit events directly to Audit Manager.