When configuring SSH tunnels for connecting to databases, authentication is performed using the SSH server. This can be done via either user name and password authentication, or by using key based authentication. Key based authentication gives the user the ability to login without a password. To authenticate using key based authentication, a key pair needs to be generated and then added to your user settings in Integrate.io ETL.
Integrate.io ETL supports only RSA keys.
To create a public key
$ ssh-keygen -t rsa Generating public/private rsa key pair. Enter file in which to save the key (/Users/joe/.ssh/id_rsa): Enter passphrase (empty for no passphrase): Enter same passphrase again: Your identification has been saved in /Users/joe/.ssh/id_rsa. Your public key has been saved in /Users/joe/.ssh/id_rsa.pub. The key fingerprint is: b6:28:f2:5c:2e:97:c2:29:54:9b:62:30:4d:53:c6:e2 email@example.com
Press Enter at the first prompt to use the default file location. At the second prompt you can type a secure passphrase for the key or press Enter for no passphrase.
To add keys to Integrate.io ETL
- Click your avatar, then click Edit profile.
- Click SSH public keys from the left pane menu
- Click New SSH public key
- In the ssh keys window enter the public key that was created. For the sample above, the key is the contents of the file /Users/joe/.ssh/id_rsa.pub.
- Click Create SSH public key.
You will receive a notification that the public key was added to your profile.