Contents x
    Data Source - FTP/FTPS
      • Print
      • PDF
      Contents

      Data Source - FTP/FTPS

        • Print
        • PDF
        Article summary

        summary

        Help Page for ETL Configuration of Data Setting using FTP/FTPS.

        constraints

        none in particular

        Setting items

        STEP1 Basic settings

        (data) itemindispensabledefault valueContents
        FTP/FTPS 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.
        Custom Variables can also be used to dynamically determine the value of a setting during TROCCO's data ETL Configuration.
        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.
        CSV/TSV input settingsYesCSV/TSV files with header columnsSelect this option when CSV/TSV is selected as the input file format.
        If you select a CSV/TSV file that does not contain a header column, a temporary header name generated on the TROCCO side will be assigned to the column name.
        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