Contents x
    Data Source - SFTP
      • Print
      • PDF
      Contents

      Data Source - SFTP

        • Print
        • PDF
        Article summary

        summary

        Help Page for ETL Configuration of Data Setting from SFTP.

        constraints

        • none in particular

        Setting items

        STEP1 Basic settings

        (data) itemindispensabledefault valueContents
        SFTP Connection ConfigurationYes-Select the previously registered Connection Configuration that has the necessary permissions for this ETL Configuration.
        path prefixYes-Specify the path prefix of the Data Source from which the Data Source is to be stored.
        Be sure to add / at the beginning. If not, an error is generated.
        For information on how to search for a path, check the path search settings in the connection settings.
        Custom Variables can also be used to dynamically determine the value of a setting during TROCCO's data ETL Configuration.
        path regular expressionNo-By entering a regular expression, you can specify which files under the path prefix are to be transferred.
        If not entered, all files matching the path prefix will be included.
        decompression formatYesUncompressed files or bzip2/gzipIf the Data Source data is compressed, it can be decompressed and transferred.
        The following decompression formats are supported Select according to the compression format of the data to be transferred.
      • Uncompressed files or bzip2/gzip
      • zip
      • tar.gz

        • If you change the decompression format later, be sure to perform Automatic Data Setting.
        Relative path after decompression (regular expression)No-This can be entered when zip or tar.gz is selected as the decompression format.
        If you include a path separator, escape it using a backslash ( ⌘).
        Input file formatYesCSV/TSVSpecify the format of the input file.
        For more information, see About input file format settings.
        Transfer MethodYesFull Data TransferSelect either Full Data Transfer or Incremental Data Transfer.
        For more information on Incremental Data Transfer, see Incremental Data Transfer Function.
        Was this article helpful?
        What's Next