Running Etlworks on-premise: installation, upgrade, maintenance

Minimum requirements

2 core CPU, 8GB RAM, and 100GB SSD.

Supported operating systems are Amazon Linux 2018, Amazon Linux 2, Ubuntu 18.04, Ubuntu 20.04, CentOS 7, Red Hat 7, and Red Hat 9.

Installation

The installer provided a tar zip archive that also contains a unique license file.

• 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
• After the installation process is over, the service should be available on port8080.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.
  • UnderEmail,provide the email configuration that will be used by the system to send notifications (required for user management).

Upgrade

In order to upgrade service to the latest version:

• Navigate to/opt/etlworksdirectory.
• Executeupgradecommand. 
  

  sudo ./etlworks-cli.sh upgrade

Maintenance

Stop service

• Navigate to/opt/etlworksdirectory.
• Executestopcommand. 
  

  sudo ./etlworks-cli.sh stop

Start service

• Navigate to/opt/etlworksdirectory.
• Executestartcommand.
  

  sudo ./etlworks-cli.sh start

View service logs

• 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

• Navigate to/opt/etlworksdirectory.
• Executebackupcommand. 
  

  sudo ./etlworks-cli.sh backup

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