summary
Help Page for ETL Configuration of Data Setting using FTP/FTPS.
constraints
none in particular
Setting items
STEP1 Basic settings
| (data) item | indispensable | default value | Contents |
|---|---|---|---|
| FTP/FTPS Connection Configuration | Yes | - | Select the previously registered Connection Configuration that has the necessary permissions for this ETL Configuration. |
| path prefix | Yes | - | 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 format | Yes | Uncompressed files or bzip2/gzip | If 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/gzipziptar.gzIf 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 format | Yes | CSV/TSV | Specify the format of the input file. For more information, see About input file format settings. |
| CSV/TSV input settings | Yes | CSV/TSV files with header columns | Select 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 Method | Yes | Full Data Transfer | Select either Full Data Transfer or Incremental Data Transfer. For more information on Incremental Data Transfer, see Incremental Data Transfer Function. |