cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
A Secure Shell (SSH) tunnel consists of an encrypted tunnel created through an SSH protocol connection. Users may set up SSH tunnels to transfer unencrypted traffic over a network through an encrypted channel. The purpose of the document is to specify the steps needed in order to securely connect a Sisense Server machine to a data source behind a firewall. Follow the steps below to set up an SSH tunnel between Sisense and your data source.   

Part 1: Install and configure freeSSHd server on the Data Source Machine

 This part of the document describes the steps for installing the SSH server, freeSSHd, and then guides you with the configuration setup.
  1. Go to the http://www.freesshd.com/?ctt=download and download the latest stable version of freeSSHd onto your local machine
  2. Double click the downloaded freeSSHd.exe file to start the installation
  3. Follow the instructions on the Welcome screen and click Next                                                        
  4. Accept the default value or Browse and select the location of your choice for and click Next 
  5. Ensure that the Full Installation is selected and click Next                                                                  
  6. Click Next on the next screen to accept the default start menu folder
  7. Accept the defaults on the next screen to create a desktop icon and click Next
  8. Verify and click Finish on the summary screen. The installation takes less than a minute depending upon the system resources
  9. Click Close in Try Other Product screen      
  10. Select Yes from the Setup pop-up window to create Private keys                                                       
  11. Click Yes in the next Setup window shown below:                                                                              
  12. Click Finish to exit setup
  13. Select Start > Programs > freeSSHd > freeSSHd
  14. Click the FreeSSHDService icon at the bottom tray
  15. The freeSSHd settings window is opened:                                                                                      
  16. Click Telnet tab from the top and ensure that the Port number is 22                                                   
  17. Click the Authentication tab. Browse and select or accept the default Public key folder. Make a note of this folder as you are going to use this while generating the public/private key later in this lab .                                       
  18. Add a user without public key authentication: sftpuser1
  19. Click Users tab from the top of the settings window
  20. Click Add…
  21. Provide the values as shown below in the User properties window
  22.  Login: enter any value, for Ex: sftpuser1 (This is the user name to connect to your FTP server)
  23. Authentication: select Password stored as SHA1 hash from the drop down menu
  24. Password: enter any value, for Ex: password
  25. Password (again): enter the same value entered for the above field
  26. Select the box next to SFTP,SHELL,Tunneling                                                                                              
  27. You should now see sftpuser1 added under Users tab                                                                        

Part 2: Open an exception in the Windows Firewall

  1. Go to Start -> Administrative Tools -> Windows Firewall with Advanced Security.                                        
  2. Next, Click on Inbound Rules, then on New Rule.                                                                                    
  3. Next, to add a Port rule                                       .                                                                                          
  4. Select TCP port 22 only.
  5. Select the defaults to Allow the Connection, apply this to All domains, and give the rule a Name of your choice.

Part 3: Set up the SSH Client

  1. Go to  https://www.bitvise.com/ssh-client-download and download Bitvise SSH Client
  2. Run the installer, accept the terms, select installation folder and click install:                                            
  3. Fill in the SSH server details, i.e. host IP or DNS name and the username/password you set up in the SSH server (i.e. sftpuser1). Please note you need to select password as the Initial method for Authentication:  
  4. Click on login. You should now be connected to the SSH server:                                                    
  5. You should now be able to connect to the data source from the Elasticube manager by using IP/Hostname you specified in the Bitvise client.
Rate this article:
Version history
Last update:
‎03-02-2023 09:42 AM
Updated by:
Contributors