• Starter
• Business
• Enterprise
• On-Premise
• Add-on

Overview

Etlworks Integrator can be installed on Linux, Windows, and MacOS. 

Supported operating systems and platforms:

• Amazon Linux 2
• Ubuntu 18.04
• Ubuntu 20.04
• CentOS 7
• Red Hat 7
• Red Hat 9
• Windows Server (2012-2022)
• All editions of Windows 10 and Windows 11 
• MacOS via Docker 
• Docker

Hardware requirements

	CPU	RAM	Hard drive
Minimum	2 cores	8GB	100GB SSD
Better	4 cores	16GB	250GB SSD
Optimal	8-16 cores	32GB-64GB	500GB-1TB SSD

Read more.

Installation

1. Request a link to download an installer or license

To request a download link, open https://etlworks.com/downloads/request.html in any browser. Fill in the form and follow the on-screen instructions.

Select either Linux or Windows installer. Read how to run Etlworks in Docker. 

 

2. Install Etlworks Integrator

Install Etlworks Integrator on Linux

Linux installer is provided as a tar zip archive. The archive contains required libraries, a command-line script, and a unique license file.

• Download the archive with the installer and copyetlworks-installer.tar.gzfile into/opt/etlworksdirectory and then unarchive it.

  sudo tar -zxvf etlworks-installer.tar.gz

• Start the installation by executing:
  

  sudo ./etlworks-cli.sh install

• Optional parameters/flags:
  • --skip-confirm:proceed with installation without confirmation
    • aliases:-s 
  • --user (String) (Default: ec2-user):sudoer user name
    • aliases:-u
  • --no-app:do not install application artifacts, only provision the system
    • aliases:-n

Install Etlworks Integrator on Windows

Windows installer is provided as a zip archive. The archive contains required libraries, a Windows installer (Etlworks.exe), and a unique license file.

Some older versions of antivirus software, specifically Windows Defender before version 1.381.3081.0, report that Etlworks.exe contains a trojan. THIS IS A FALSE POSITIVE. To avoid warnings, we recommend updating your antivirus to the latest version before downloading and installing Etlworks on Windows.

• Download the archive with the installer and copyetlworks-installer.zipfile into any directory, for examplec:\etlworksand unarchive it.
• Start the installation by executing Etlworks.exe. 
• Continue with the setup

3. Finish installation and configuration

Keep the downloaded Windows installer, libraries required for installation, and a provided license file. The same installer can be used to upgrade Etlworks to the latest version. 

• After the installation process is over, the service should be available on port8080. You can test it by opening the Etlworks URL in the browser, for example: http://localhost:8080. The default Super Admin username and password are:
  • user: admin
  • password: admin1

• After you first log in, navigate toSettings
  • UnderGeneral, updateHome URLto your instance URL, for example http://localhost:8080
  • UnderNetwork, updateETL Engine Proxy URLto your instance URL, for example http://localhost:8080
  • UnderEmail, provide the email configuration that will be used by the system to send notifications. This is required for adding new users, resetting passwords, and sending email notifications.

Upgrade

Upgrade Etlworks Integrator on Linux

In order to upgrade service to the latest version:

• Navigate to/opt/etlworksdirectory.
• Executeupgradecommand. 
  

  sudo ./etlworks-cli.sh upgrade

Upgrade Etlworks Integrator on Windows

In order to upgrade service to the latest version:

• Navigate to the directory with Etlworks Windows installer, for examplec:\etlworks.
• Execute Etlworks.exe.

The directory must contain a valid license file.

Maintenance

Maintenance on Linux

Stop service on Linux

• Navigate to/opt/etlworksdirectory.
• Executestopcommand. 
  

  sudo ./etlworks-cli.sh stop

Start service on Linux

• Navigate to/opt/etlworksdirectory.
• Executestartcommand.
  

  sudo ./etlworks-cli.sh start

View service logs on Linux

• Navigate to/opt/etlworksdirectory.
• Executelogcommand. 
  

  sudo ./etlworks-cli.sh log

• Optional parameters/flags
  • --engine:show ETL engine log instead of the application log
    • aliases:-e
  • --follow:live log output
    • aliases:-f
  • --lines (Number):number of lines to show
    • aliases:-n <value>

Backup service on Linux

• Navigate to/opt/etlworksdirectory.
• Executebackupcommand. 
  

  sudo ./etlworks-cli.sh backup

• All backup files will be created under/opt/etlworks/backupdirectory.

Maintenance on Windows

Stop service on Windows

• Click on the Apache Tomcat icon in the Windows system tray.

• Click the Stop button. If the button is grayed out, the service is already stopped.

Start service on Windows

• Click on the Apache Tomcat icon in the Windows system tray.

• Click the Start button. If the button is grayed out, the service is already started.

View service logs on Windows

On Windows, you can find service logs under /TOMCAT_HOME/logs directory, which by default is C:\Program Files\Apache Software Foundation\Tomcat 8.5\logs.

 

Run Etlworks in Docker

To run Etlworks in Docker please use our official image.