- Enter a server name in the Name field.
- Select FileSystem from DBMS type dropdown.Tip: GMT offset (minutes) shows how many minutes your local time differs from Greenwich Mean Time (GMT). For example, Boston is 300 minutes behind GMT. This information is for reference only.
- Click the Settings tab to add or modify parameters. See the Server Properties dialog for FileSystem table for descriptions.
| Parameter | Description |
|---|---|
| Connection Type |
|
| Rollover criteria | The system creates a new target file when certain events occur. By default, this happens when the request stops. When a rollover occurs, an alert is sent to monitoring and control tools such as Connect CDC MonCon. Rollover file naming format:
where:
The other options are:
|
| File format |
Sets the format for messages sent to Kafka:
Omit null columns - Select this option to remove any data fields with null values from the message. Note: This option is only available when the target is set to use the JSON message format.
|
| Images for update |
Specifies how Connect CDC records before and after values for all columns in a file when capturing an Update statement:
Each in a separate record: - Connect CDC records both before and after values, but places them in separate records. For the before value, Connect CDC sets the entry in the sv_manip_type column to B. |
| Character set |
Choose one of the following options:
|
| Null string | The default is “~”. Connect CDC differentiates between null and empty strings. Connect CDC identifies an empty string as no character. |
| Quote character | The default is a double quote ("). The quote character has the same requirements as the delimiter character. |
| Delimiter |
|
Valid Character set for Field and Record
You can specify multiple printable characters as delimiters. The default size value of the record delimiter is 10, and 20 in the case where escaped characters are used. At least one printable character, or two for an escaped character, should be entered as a delimiter.
Valid Values and Limitations
- Maximum printable characters allowed:
10 - Minimum printable characters allowed:
1 - Any upper and lower case letters
- Any numeric digits
- Any special characters from the following set:
`,~!@#$%^&*()-_++{}[]|;:”’<>./?
- Escaped characters (backslash character
\), followed by the characters from the following subset:t, n, \, 0, or r
Each of these will be counted as one (1) character. If you use a space, you must enter \b. The binary zero is not allowed in the list of escaped characters.