SSH

Configuring SSH as a Connection

In order to import and export from SSH, you must first create a connection.

1. Click the + (plus) button and select Connection or right-click in the browser and select Create new > Connection.
2. From drop-down list, select  SSH  as the connection type. Click Next.
   
3. Enter your host name and port number, if necessary.
4. Select whether credentials should be provided or asked for. If you choose the former, add the required user name and password. 
   

5. Add the root path prefix or SSH key.

   The SSH key has a specific format. The key must begin with the following line:

   ---- BEGIN RSA PRIVATE KEY ----

   
   

   The key must end with the following line:

   ---- END RSA PRIVATE KEY ----

6. Indicate whether the connection should be used for import, export, or both. 
   
7. Click Next.
8. If required, add a description and click Save.
   

Importing Data with a SSH Connector

After configuring a connection to SSH, you can set up an import job to access the connection.

1. Click the + (plus) button and select I mport Job or right-click in the browser and select Create new > Import job.
2. Click Select Connection and choose the name of your SSH connection (here - SSH Connection) then click Next.
   

3. Enter the file or folder path and the delimiter.
   
   

   As of Datameer X 7.4

   Datameer X has added the Remote Data Browser feature. This file browser gives you a visual interface to select the file from your SSH connection for which to import.

   The filter box at the top of the Remote Data Browser can be used to find folders/files within the current directory.

   

   

4. A preview of the imported data is displayed. Review the schema.
   
5. Review the schedule, data retention, and advanced properties for the job.
   
6. Add a description, click Save, and name the file.