Minimum Hardware and Software Requirements
Hardware: 1 CPU core, 1GB of free RAM, 1GB of free disk space. A shared or dedicated VM/computer. Recommended monitor resolution: 1280x800 or higher. Reliable internet connection.
Operating Systems: Windows Server 2012 R2 or 2016 or 2019 or 2022, Windows 10 or 11. We recommend Windows Server for ETL+ scheduled tasks. .NET 4.6 or newer (usually included in the OS).
Secured IP-to-IP connection: ETL+ whitelists your public IP address. Click here to learn more.
Firewall: Open outbound ports for https and SSL SQL connections. Optional: outbound SMTP protocol for refresh emails. We can provide you with our public IP addresses for your IP-to-IP whitelisting. Instead of the above, we can set up other methods such as a VPN to secure the connection.
Windows credentials to run ETL+: 1) A standard Windows user can run ETL+ manually. 2) A user with local Windows Admin rights is required to run ETL+ scheduled data extractions.
User credentials to extract data from source systems: 1) Authentication: Windows or source database built-in authentication. 2) User with reading rights from source databases.
MS SQL Server Guidelines for ETL+ Data Warehouses
DataSelf Cloud (AWS or Azure)
Nothing else is required.
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), 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 dbo role for the MS SQL database hosting the data warehouse.
Pre-Installation checklist: DataSelf ETL+ Pre-Installation
Step-by-Step Install: Install DataSelf ETL+ (Step by Step)