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.

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), 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.

More Info

Pre-Installation checklist: DataSelf ETL+ Pre-Installation

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