How to Test a Fivetran Reverse SSH Tunnel Connection

Question

I want to connect my database to Fivetran using the reverse SSH tunnel connection method. How can I test my reverse SSH tunnel connection to ensure it's working correctly?

Environment

Database connectors using the Reverse SSH tunnel database connection method.
Destinations using the Reverse SSH tunnel [destination connection method]

Answer

To verify that your reverse SSH tunnel connection is working, run the following tests from the virtual machine (VM) hosting your SSH server:

Replace placeholder values, such as <DATABASE_IP>, with the relevant values for your environment.

Test connectivity between your VM and Fivetran:
```
ssh fivetran@<FIVETRAN_SUPPLIED_IP>
```
If the connection fails, check firewalls and security groups on both ends.
Confirm that the Fivetran IP address is safelisted in your network configuration.
Verify basic network connectivity by pinging each machine:
The ping command uses the ICMP protocol, which must be open on each machine or network for this test to work.
```
ping <DATABASE_IP>
```
Confirm that your VM can access your database:
```
telnet <DATABASE_IP> <DATABASE_PORT>
```

Test one-time port routing:

ssh <FIVETRAN_SSH_USERNAME>@<FIVETRAN_SUPPLIED_IP> -R 
<SSH_HIGH_PORT>:<DATABASE_IP>:<DATABASE_PORT>

Resources

The following diagram visualizes how SSH tunnels are implemented in Fivetran:

Reverse SSH diagram