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

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://

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.

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