DataSelf ETL+ Minimum System Requirements

Minimum Hardware and Software Requirements

MS SQL Server Guidelines for ETL+ Data Warehouses

DataSelf Cloud (AWS or Azure)

Nothing else is required.

On-Premises/Private-Cloud

  • Guidelines for hardware specs: Look at the data size of your source databases (no log data size):

    • Expected data space in the data warehouse: 5% to 20% of the source database data space.

    • CPU threads: 4+ for up to 32GB of data space; 8+ for 32GB to 128GB; 16+ for 128GB to 500GB; etc.

    • RAM: 8GB+ for up to 16GB of data space; 16GB+ for 16GB to 64GB; 32GB+ for 64GB to 128GB; etc. For fast performance, the largest data warehouse table should fit into the available RAM (ex.: if the largest table is 12GB, set RAM to at least 16GB). For top performance, all data space should fit into the available RAM.

    • Disk space (SSD preferably): Minimum free 150GB. Make it 5+ times the expected data space.

  • MS SQL Server versions: 2019 (preferred), 2017, 2016, 2012 R2.

  • MS SQL Editions: any.

  • Server or serverless architecture. Preferably on a dedicated server.

  • Recovery model: Simple.

  • Compatibility level: Latest available.

  • Collation: the same as your source systems', if applicable. Our default is SQL_Latin1_General_CP1_CI_AS.

  • ETL+ requires read/write roles for the MS SQL database hosting the data warehouse.

More Info

Pre-Installation checklist: DataSelf ETL+ Pre-Installation

Step-by-Step Install: Install DataSelf ETL+ (Step by Step)