Data Targets
      Back to home
      1. Knowledge Base
      2. Connect & Transform
      3. Data Targets

      SFTP Data Targets

      Overview

      To create an SFTP Data Target you need to have Remote SFTP credentials set up. Credentials can use the same details as for the Local SFTP. You will require the following information for your Remote SFTP credential if you are sending to a DataBlend SFTP:

      Host:

       

      sftp.ml.datablend.com

       

      Port:

      22

      IP Address

      3.18.206.127
      If you are sending to the external sources, another system will provide their own SFTP and have their own Host and Port, that should be used instead.

      Configuration

      Setting

       

      Required/Optional

       

      Description

       

      Type

      Required

      File

      Name

      Required

      Give a Name to your Data Target

      Query

      Required

      Select the query that will generate the data for this target.
      See the relevant target type documentation for additional details on what query columns are required for your target.

      Query Mode

      Required

      Select New unless you have a reason for choosing Latest or Specific

      File Data Target Type

      Required

      SFTP

      Path

      Required

      Provide a file name, including file name extension, and a path to where it will be created in the remote location.
      Example: Invoices/Test.csv

      Credential

      Required

      Select Remote SFTP Credential from the list

      File Definition

      Required

      Select from Delimited, Excel or JSON

      Delimiter

      Optional

      Select from Comma, Tab, Semicolon, Space

      Skip Rows

      Optional

      Number of rows to be skipped when saving results to the file
       Path options

      The simplest Path can consist of the file name with extension only. If the file should be saved inside a folder, the folder name should be part of the Path.

      There are also different options and a lot of other capabilities that are helpful in making the file names descriptive. Examples:

      • Invoice_.csv → Invoice_27 Oct 2022.csv

      • Invoice_.txt → Invoice_2022-10-27T17:15:18.txt

      Please remember to add file name extension at the end of the path.

      Advanced

      History Retention

      History Retention (Days) allows users to decide how long they want the information from their data targets to be stored. This field is optional.

      Timeout (seconds)

      The Timeout section allows users to determine if they would like to timeout collections taking longer than a set number of seconds to collect data.

      Skip If No Records Found

      The “Skip if No Records Found” button is used to eliminate sending information to Data Targets unnecessarily. Simply enable the “Skip if No Records Found” toggle. The use of this toggle is optional.

      Agent

      The Agent drop-down for users to select any agent they have established. This is optional.

      Run As

      Run As allows users to select from a drop-down list of users to run the Workflow. This is optional. Please note that Run As is only available to Admin users. If a user is set as the Run As and then demoted to a Member, the user which demoted the Run As user will instead be set as the Run As.