Create or Edit an SFTP Connection | Vantage Analyst - 1.1 - Creating or Editing an SFTP Connection - Vantage Analyst

Vantage Analyst User Guide

prodname
Teradata Analytic Apps
Vantage Analyst
vrm_release
1.1
category
User Guide
featnum
B035-3805-099K
  1. Select "" > Configuration > Connections.
  2. Choose one of the following options:
    Option Action
    Create new Click CREATE NEW.
    Edit exiting Either click the connection or select > Edit.
  3. On the Connection details page, enter a unique Connection name and an optional Description.
  4. On the Connection type page, select SFTP then enter the Host URL, Port (default = 22), and optional Subdirectory.
    You cannot change the Connection type after saving the connection.
    • If the Subdirectory is blank, the connection uses the home directory of the SFTP user.
    • If the Subdirectory is /, the connection uses the Host URL root folder.
  5. On the Authentication page, enter the User and Password of the SFTP user for this connection. This user must have read and write credentials to the selected URL and subdirectory.

    The password is encrypted and cannot be edited after saving the connection. To change the password, click RESET and enter a new password.

  6. Click TEST to test the authentication credentials and subdirectory for the connection. If the test is not successful, review your entries on the Connection type and Authentication pages.
  7. On the Sample format page, click + to upload a file with your sample file that defines inbound SFTP data mappings. This sample file format contains the expected attributes of the connected system.
    The sample format file is used when creating an inbound SFTP data integration. See Creating or Editing an SFTP Data Integration.
    1. Click Browse and select a file from your PC or click-and-drag the file from your PC to the sample format file.
      Uploading subsequent files will override any existing sample attributes.
    2. On the Upload sample format window, use the Formatting fields to specify the Field, String, and Record delimiters in the sample file.
    3. Click SAVE FORMAT.
  8. Select the Type (text, numeric, datetime, or blob) and optionally edit the Name for each field (from the sample file).
  9. Click SAVE.