How to Enable SSH Tunneling during a Database Source Authentication?
Daton requires database sources to authenticate using SSH (Secure Shell) for enhanced security and data protection. This helps maintain the confidentiality, integrity, and availability of the data throughout the integration process.
- 2.Follow the first step of your integration according to the requirements of your source.
- 3.After entering your Database authentication details in the second step of integration (Setup Connection), set Use SSL to TURE and select SSH from the tunneling options.
- 4.Enter the necessary information for the SSH server, such as the proxy hostname, port number, and host username.An SSH-Public Key will appear. Copy the SSH-Public Key and perform the following:
Note: You can add multiple SSH public keys to the
- 1.Open the Windows PowerShell application with administrative privileges.
- 2.Use the
sshcommand followed by the path to your private key file and the public IP address or domain name corresponding to your integration. This command establishes an SSH connection to integration. For example:
ssh -i /path/to/your/key.pem user@your-public-ip-address(Replace the placeholders with actual values)
- 3.Change to the .ssh directory by entering
lsto check if the
authorized_keysare present in the directory.
- 5.Edit the
- 6.Paste the copied Proxy SSH Public key from the integration into the
authorized_keysfile. To paste in the vi editor, click on "i" on the keyboard to get into insert mode, right-click, and then press the "Esc" button.
- 7.To save the changes, enter
:wq!in the editor and press "Enter". This command will write the changes to the file and quit the editor.
authorized_keysfile. Make sure there is one line space between each key for proper formatting.
- 5.Now, back on the integration page, hit Authenticate, follow the further integration steps according to your source's requirements, and submit the integration. After submitting, your integration will be successfully authenticated through SSH tunneling.