Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

How to Enable SSH Tunneling during a Database Source Authentication?

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Saras Pulse

    • Saras Daton

      Need help with something?

      Talk to data expert

      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.

      Instructions to authenticate any of your DB sources with daton:

      1. Log in to your Daton account and select the DB source you want to integrate.
      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:
        1. Open the Windows PowerShell application with administrative privileges.
        2. Use the ssh command 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 cd .ssh.
        4. Enter ls to check if the authorized_keys are present in the directory.
        5. Edit the authorized_keys by entering vi authorized_keys.
        6. Paste the copied Proxy SSH Public key from the integration into the authorized_keys file. 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.

          Note: You can add multiple SSH public keys to the authorized_keys file. 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.

      Was this article helpful?

      Yes
      No
      Give feedback about this article

      Related Articles

      • How exactly do Business Reports work in Daton?
      • How to get access to Google Analytics?
      • Why don't I see my data?
      • How to setup Google BigQuery Project

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Experts
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Follow Us

      Linkedin Youtube

      Company

      • Customers
      • Partner With Us
      • Contact Us

      Culture

      • About
      • People
      • Careers

      Offerings

      • Daton
      • For Brands
      • For Agencies

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA

      Follow Us

      Linkedin Youtube

      DISCLAIMER: Various trademarks are held by their respective owners

      © 2023 sarasanalytics.com

      Sitemap

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Sales
      DISCLAIMER: Trademarks are held by their respective owners
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Company

      • Customers
      • Partners
      • About
      • People
      • Careers
      • Contact Us

      Offerings

      • Daton
      • Solution for Brands
      • Solution for Agencies
      • Dashboards
      • Founder's Note
      • Status

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA
      • Sitemap

      © 2023 sarasanalytics.com

      Linkedin Youtube

      Knowledge Base Software powered by Helpjuice

      Expand