Setting Up an SSH Tunnel Between Sisense Machine & Data Source

[intapiuser]

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.