Set up a reverse SSH tunnel from Windows

SSH (secure shell) tunneling is the process of forwarding selected ports through an authenticated and encrypted tunnel. In many cases, SSH tunneling is used to connect to a remote database that is secured behind a restrictive firewall or other network restrictions.This article walks you through the process of creating an SSH tunnel on Windows using PuTTy.

  1. Add a public key in your user settings. The public key will be propogated to all Xplenty servers in up to 30 minutes.

  2. Create a “Tunnel connection” in Xplenty with and retrieve Xplenty’s tunnel server (Xplenty server) and connection port.

    create_tunnel

  1. Download PuTTy.

  2. Start a new PuTTy session and set the Hostname to Xplenty server with port 50683. For example:

    putty-1

  1. Connection->Data, enter the tunnel username: sshtunnel
    putty-2

  2. Connection->SSH, check “Don’t start a shell or command at all”
    putty-3

  3. Connection->SSH->Auth, browse for your PPK private key that matches the public key you added in Xplenty.
    putty-4

  4. Connection->SSH->Auth->TTY, check “Don’t allocate a pseudo terminal”.
    putty-5

  5. Connection->SSH->Tunnel: Specify the source port (the connection port assigned to your connection, 53359 in this example), Specify the destination database’s host and port in the destination as “hostname:port”, select the “Remote” option and click “Add”.
    putty-6

  6. Save the connection - Go back to Session section in sidebar, enter a description for your stored session (xplenty here) then click the save button.
    putty-7

  7. Connect - double click the Xplenty session to initiate the connection.

Connectivity And Security

  1. Allowing Xplenty access to data on Amazon S3
  2. Allowing Xplenty access to my Redshift cluster
  3. Allowing Xplenty access to my data on Google AdWords
  4. Allowing Xplenty access to my data on Google Analytics
  5. Allowing Xplenty access to my Google BigQuery dataset
  6. Allow Xplenty access to my Google Cloud Spanner instance
  7. Allow Xplenty access to my data on Google Cloud Storage
  8. Allowing Xplenty access to my data on Hadoop Distributed File System (HDFS)
  9. Allowing Xplenty access to my server behind a firewall
  10. Allowing Xplenty direct access to relational databases on Amazon Web Services RDS
  11. Allowing Xplenty access to MongoDB
  12. Importing Heroku Connections
  13. Allowing Xplenty access to my data on Bing Ads
  14. Allowing Xplenty access to Azure SQL Databases
  15. Allowing Xplenty access to my data on Secure File Transfer Protocol (SFTP)
  16. Allowing Xplenty access to Facebook Ads Insights data (Beta)
  17. Allow Xplenty access your data on Salesforce
  18. Allowing Xplenty access to NetSuite
  19. Allowing Xplenty access to my data on Intercom
  20. Set up a reverse SSH tunnel from Windows
  21. Allowing Xplenty access to my data on Xero (Beta)
  22. Allow Xplenty access to my data on Azure Blob Storage
  23. Allowing Xplenty access to my Snowflake account
  24. Allowing Xplenty access to my data on YouTube
  25. Allowing Xplenty access to my data on Google Sheets
  26. Allowing Xplenty access to my data on Linkedin
  27. Allowing Xplenty access to my data on Instagram
  28. Allowing Xplenty access to my data on Shopify
  29. Allowing Xplenty access to my data on Pinterest

Feedback and Knowledge Base