website logo
⌘K
Getting Started 🚀
What is DataLakeHouse.io?
Our Business-Value Focus
Learn the Basic Concepts
Connectors
Operations Applications
Toast
Asana
Aloha POS
BILL
Bloom Growth
Bullhorn
Ceridian Dayforce
ConnectWise
Facebook Ads
Food Delivery Service Connector
Google Analytics 4
Harvest
Hubspot
Jira
MailChimp
McLeod Transportation
NetSuite (Oracle NetSuite)
Optimum HRIS
Oracle EBS
Oracle PeopleSoft
QuickBooks Online
Salesforce
Shopify
Square
Square Marketplace
Stripe
TriNet
Verizon Wireless Business
Workday HCM
Xero
Zoom
Databases
Files & Object Storage
SSH Tunnel Setup for Hosted Database Systems
Databases FAQ
SQL Transformations
Terraform: Reverse Terraforming
DBT Cloud Transformations
Sync Bridge (Data Pipelines)
Create a Sync Bridge
Manually Run a Sync Bridge
Deleting a Sync Bridge
Historical Re-sync
Analytics
Access Analytics
Snowflake Usage Analytics
Data Catalog
Create the Catalog
Populate the Catalog
Access the Catalog
Data Warehouse Clouds
Snowflake
Open Source DW Models
Alerts & Notifications
Slack Notifications
Untitled doc
Logs & Monitoring
Security
Callback Links
Service Level Agreement (SLA)
Release Notes
May 2023
April 2023
Q3 2022
Q4 2022
Community Overview
Contributor Agreements
Code Contribution Guide
About
License
Viewpoint
Docs powered by archbee 

How to Test an SSH Tunnel Connection

2min

If you want to test your SSH Tunnel connection for interoperability with DLH.io to ensure DLH.io can reach your database securely behind your SSH server, the outlined instruction below should provide clarity on how to do so.

DLH.io SSH Tunneling Option
DLH.io SSH Tunneling Option


Our Recommendation for Testing

Based on our experience we recommend a few of tests to ensure that DLH.io is able to connect to your databases via SSH protocols. In DLH.io there are two options for connecting from DLH.io to your SSH Server. While the protocol is the same the selectivity of private/public key is different to allow for advanced use cases. Those options are:

  1. Customer supplied Private Key
    1. This is the default and currently the preferred method for accounts. This may be later restricted to Enterprise accounts and above.
    2. To test the connection from one machine to another to emulate how DLH.io will connect to your SSH server :
      • Open a terminal window or similar UI application on your local machine, laptop, or virtual machine
      • Locate your SSH private key that is associated with the public key on your SSH server
      • Enter the standard ssh connection command using the user on the SSH server your key is associated with.
        • ssh dlh_ssh_user@<your_ssh_server_ip_address>
          If this doesn't connect then you have an issue somewhere in your network most likely. Please confirm any firewall settings and that you have grantlisted/safelisted IPs accordingly. ICMP protocol should be open on the machine as well.
        • ping <your_database_ip_or_dns>
        • Use telnet to confirm your terminal commands will actually reach the database via correct port
          • telnet <your_database_ip_or_dns> <your_database_port>
        • Log any issues and correct them before creating an SSH enabled connection integration on DLH.io or contact support
      • Done!
  2. DLH.io supplied Public Key
    • Please contact support on how to get a public key if not on the Enterprise plan or not sure/confident on how to createa public and private key in your environment.



Updated 23 May 2023
Did this page help you?
Yes
No
PREVIOUS
Databases FAQ
NEXT
SQL Transformations
Docs powered by archbee 
TABLE OF CONTENTS
Our Recommendation for Testing