Introduction
If you have read Fivetran’s Documentation on connection options and are unsure which option to proceed with, find out which may best fit your use case.
Recommendation
- Direct Connection
- You can provide direct access to your database port
- You want the fastest, simplest solution
- SSH Tunnel
- You cannot provide direct access to your database port
- You are happy for Fivetran to open a connection
- You want the most security with the least complexity
- Reverse SSH Tunnel
- You cannot provide direct access to your database port
- You cannot provide direct access to any instance port
- You want to open the connection to Fivetran
- You want the most security and control but do not want the setup overhead of a VPN
- Virtual Private Network (VPN)
- You cannot provide any access to your environment over the Internet
- You have a complex, multi-layered network map that cannot be solved with only an SSH solution
- You are happy with the setup overhead of a VPN
- You are happy to accept the latency of a VPN
Considerations
- SSH tunnels are only available on the Standard pricing plan and above
- Reverse SSH tunnels are only available on the Standard pricing plan and above
- VPNs are only available on the Enterprise pricing plan