Connecting to the Instance

From a web browser

These instructions assume you have already successfully launched Matillion ETL from the AWS marketplace. See here for detail.

These instructions assume you have already successfully launched Matillion ETL from the AWS marketplace. See here for detail.

Once the Amazon EC2 Instance is started all you should need is a web browser to connected to Instance and get started building ETL jobs.

  • The URL to connect to is:- http://<Host Name or IP address>/
  • The host name or IP address can be found in the EC2 Management Console in Services -> EC2 -> Instances
  • You should then see a login screen such as.  



Note: When starting a new instance the default username is ec2-user and the default password is the instance ID i-xxxxxxxx (e.g. i-88ed92c6)

Alternatively, if the instance is public then use the public DNS as below.

Initial Environment Set-up

To get started building ETL Jobs in Matillion ETL the final step is to get connected to your Redshift cluster. If you attached an IAM Role to your AMI Matillion ETL can interrogate your cluster to discover the basic connection information otherwise it will need to be set manually.


On first run the product will take you to the Create Project screen:
  • The Project Group is any name used for logically grouping projects.
  • The Project Name is any name for your first project.
  • The searchable Project Description for you project.
  • Deselect if you do not want to Include Sample jobs in the project.
  • In Environment Details:-
    • Name - describes the environment. e.g. Test/Live etc
    • Cluster - if you have created an IAM Role this box will list your Redshift clusters that are visible to that role in the same region as the Instance is running. Selecting that cluster will populate the remaining fields on the screen with sensible defaults. If the box is empty these will need to be set manually.
    • Schema - 'public' by default, but if you have configured multiple schemas within your Redshift database, specify the schema you would like to use here.
    • Endpoint  - the physical address of the Leader Node. It will be either a name or I.P. address.
    • Port will usually be 5439 or 5432, but could be configured differently when setting up Redshift.
    • Database -  however you named it when setting up your Redshift cluster. You may run with multiple database names, in which choose the one you would like to use for this project here.
    • Enable SSL to encrypt communications between Matillion and Redshift. Some Redshift clusters may be configured to require this.
    • Enter a username and password with write permission to the above database.
  • Click Test and ensure connection is successful.
  • Finally click OK to create your project and environment
Matillion ETL will launch the sample job. To get started building your own job right click on the Explorer panel.
 

To get started building ETL Jobs in Matillion ETL the final step is to get connected to your Snowflake account. To do so, please refer to the documentation on Connecting To Snowflake.