Installing Matillion ETL using the Universal Installer (RPM install)
Customers installing Matillion ETL via the Matillion Hub and the "bring your own license" (BYOL) method must download the correct configuration files for their environment, and then download and execute a single install script, as described below.
This article replaces the detailed instructions given in the article Installing Matillion ETL from RPMs with a process that uses a pre-packaged script, to make the installation quicker and simpler to perform.
- To use this build process, all RPM build actions must be run as a root user on the virtual machine (VM) that the installation is being executed on.
- The RPM installation method only applies to Matillion Hub customers and bring your own license (BYOL) customers. AWS customers who launch Matillion ETL via the original marketplace method can only install Matillion ETL on their golden AMI, via Private Image Build. Please submit a case at the Matillion Support Portal if you require further assistance with this.
- New customers are advised to go through the Matillion Hub to select their preferred cloud provider and data warehouse to begin their Matillion ETL journey. For further information, read Matillion Hub - Instance Creation.
- To update Matillion ETL to a specific version, refer to Updating - Specific Releases.
Download the configuration files
There are two configuration files needed for the installation of Matillion ETL:
- installation.vars — is used to tell your environment how Matillion ETL will be installed.
- Emerald.properties — is used to define the product you want to install. There are several versions of this file, one for each possible product variant. You will need to choose the file that matches your requirements.
To download the installation.vars file, run the following command:
curl https://bitbucket.org/matillion/matillion-etl-system-configuration/raw/stable/example-config/installation.vars > /tmp/installation.vars
To download the correct Emerald.properties file:
- In a browser, go to https://bitbucket.org/matillion/matillion-etl-system-configuration/src/stable/example-config/. This will show you a list of Emerald.properties files.
- The filename suffix will identify which product variant the properties file is for. For example,
Emerald.properties-AWS-SF-HUBis the properties file for Snowflake (SF) on AWS, for Hub licensing. Identify which file you need and copy or make a note of the filename for use in the following command.
- Download the correct
Emerald.propertiesfile into the
/tmpdirectory using the following command:
curl https://bitbucket.org/matillion/matillion-etl-system-configuration/raw/stable/example-config/[filename] > /tmp/Emerald.properties
filename is the name you determined in step 2. For example, to install Matillion ETL for Snowflake on AWS using Hub licensing, the command is:
curl https://bitbucket.org/matillion/matillion-etl-system-configuration/raw/stable/example-config/Emerald.properties-AWS-SF-HUB > /tmp/Emerald.properties
Execute the install script
- Login with administrator privileges (root):
- Run the following command to download the latest install script:
curl https://bitbucket.org/matillion/matillion-etl-system-configuration/raw/stable/orchestrate-install.sh > /tmp/orchestrate-install.sh
- Change the script permissions as follows:
chmod a+x /tmp/orchestrate-install.sh
- Run the script as follows:
/bin/bash /tmp/orchestrate-install.sh /tmp/installation.vars
- After a successful install, restart your Matillion ETL instance by running the following command:
- An alternative method for restarting your Matillion ETl instance is to perform a reboot via your cloud provider.
- An example of a more granular installation can be found here: https://bitbucket.org/matillion/matillion-etl-system-configuration/raw/stable/Matillion-ETL/ansible/group_vars/installationservers.