Configuring SSH as a Connection
In order to import and export from SSH, you must first create a connection.
- Click the + (plus) button and select Connection or right-click in the browser and select Create new > Connection.
- From drop-down list, select SSH as the connection type. Click Next.
- Enter your host name and port number, if necessary.
- Select whether credentials should be provided or asked for. If you choose the former, add the required user name and password.
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 ----
- Indicate whether the connection should be used for import, export, or both.
- Click Next.
- 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.
- Click the + (plus) button and select Import Job or right-click in the browser and select Create new > Import job.
- Click Select Connection and choose the name of your SSH connection (here - SSH Connection) then click Next.
- Enter the file or folder path and the delimiter.
- Click Next.
- A preview of the imported data is displayed. Review the schema.
- Review the schedule, data retention, and advanced properties for the job.
- Add a description, click Save, and name the file.