Matillion ETL Shared Job

Check Network Access

Check connectivity between Matillion ETL and a network data source.

Use this Shared Job whenever you need to check if your Matillion ETL instance has access to a specific SaaS or on-prem network resource, for example a source database. It works for both Public and Private IPv4 addresses.

The Shared Job will fail if the Matillion ETL instance does not have access to the network resource on the chosen port.

Database access check

To check whether this Matillion ETL instance has network access to a source database, for example one that you intend to query with a Database Query component:

  • Set the Address to the network endpoint of the database
  • Set the Port Number for that database’s network protocol

Most databases have commonly used port numbers, such as:

  • Postgres, Redshift: 5432
  • SQL Server: 1433
  • Oracle: 1521 and above
  • DB2: 48000 and above

Check Database Access

REST API access check

To check whether this Matillion ETL instance has network access to a REST API that you intend to use, for example with an API Query component:

  • Set the Address to the host part of the API, for example devrel.matillion.com. Don’t include any paths or query parameters.
  • Set the Port Number to whatever the API is using, for example 443 for https://

Check REST API Access

Internet access check

To check whether this Matillion ETL instance has access to the internet:

  • Set the Address to the name of a server on the internet - for example www.google.com
  • Set the Port Number to an open port on that server - for example 443 for https://

Use the success branch for components that require internet access. Use the failure branch to handle the case that there is no internet access.

Check Internet Access

Prerequisites

The nc command line utility must be installed on your Matillion ETL instance.

Downloads

Licensed under: Matillion Free Subscription License

Download Check-Network-Access.melt

  • Target: Any target cloud data platform
  • Version: 1.61.6 or higher

Installation Instructions

How to Install a Matillion ETL Shared Job
Author: Matillion
Date Posted: Oct 24, 2023
Last Modified: Jun 18, 2024