Minimum Hardware and Software Requirements

  • Hardware: 1 CPU core, 2GB of free RAM, 5GB 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, or 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. For more see ETL+ Public IP Whitelisting .

  • Firewall: Many servers have outbound ports open and there‚Äôs no need to adjust the firewall. If ports are closed, please allow outbound communication with HTTP (port 80), HTTPS (port 443), SSL SQL connections (port 1433), and optionally SMTP protocol for refresh emails (port 25). 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), 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)