To SFTP/FTP

Basic parameters

Output Directory

Directory on the SFTP server to which data will be written

/TO_DIRECTORY/

File Format

Format used for transmitting data

The CSV format is supported for migration to tables, and the binary format is supported for file migration.

CSV

Advanced attributes

Line Separator

This parameter is displayed only when File Format is set to CSV.

It indicates the line feed character in a file. By default, the system automatically identifies \n, \r, and \r\n.

This parameter is added to identify line feed characters.

\f

Field Delimiter

This parameter is displayed only when File Format is set to CSV.

It indicates the field delimiter in the file.

,

File Size

This parameter is displayed only when File Format is set to CSV.

You can enter a file size to split the file to ensure that the exported files are not too large. The unit is MB.

1024

Encode type

This parameter is displayed only when File Format is set to CSV.

It indicates the file encoding type.

The encoding type can be set only for text files. Otherwise, the setting is invalid.

The value can be UTF-8 or GBK.

UTF-8

Write to Temporary File

This parameter is displayed only when File Format is set to Binary.

It indicates writing the binary file to a temporary file whose name extension is .tmp.

No

First Row As Header

If you set this parameter, the program reads the first row as the header row when extracting data.

No

Use Quote Char

This parameter is displayed only when File Format is set to CSV.

Quote characters are used to enclose a string value.

Field separators in the quote characters are regarded as a part of the string value. Only quotation marks (") can be used as quote characters.

No

Job Success Marker File

Marker file name

When the job is successful, a marker file is generated in the destination directory. If this parameter is left blank, no marker file will be generated.

finish.txt

Encryption

Encryption mode for the uploaded data.

• NONE
• AES-256-GCM

NONE

Data Encryption Key

This parameter is displayed only when the AES-256-GCM encryption mode is selected.

It indicates the data encryption key. The AES-256-GCM key consists of 64 hexadecimal digits.

DD0AE00DF************457DCDC1B

Initialized Vector

This parameter is displayed only when the AES-256-GCM encryption mode is selected.

It indicates the initialization vector, which consists of 32 hexadecimal digits.

5C916*************A3C3F

File Name Prefix

This parameter is displayed only when File Format is set to CSV.

It indicates the prefix of the file name.

File name format: prefix-jobname-timestamp-index

data