Show TOC

Socket (As Client) CSV Output AdapterLocate this document in the navigation structure

Adapter type: dsv_sockout_out. The Socket (as Client) CSV Output adapter sends data in delimited format to the outgoing network.

The Socket (as Client) CSV Output adapter initiates the connection to an external datasource and sends out the data. The data does not require a header (accepted by streamingconvert). If the file includes a header, it specifies the field names. The adapter retries a connection if the connection breaks.

If you use the CCL ATTACH ADAPTER statement to attach an adapter, you must supply the adapter type.

Property Label Description
Server

Property ID: host

Type: string

(Required) Server host name. Default value is localhost.

Port

Property ID: port

Type: int

(Required) Server port. If port is set to -1, the adapter reads from the Ephemeral Port File. Default value is 12345.

Prepend stream name, opcode

Property ID: prependStreamNameOpcode

Type: boolean

(Optional) If true, the first two fields are interpreted as stream name and opcode respectively. The adapter discards messages with unmatched stream names. Default value is false.

Delimiter

Property ID: delimiter

Type: string

(Advanced) Symbol used to separate the columns. Default value is a comma ( , ).

Has Header

Property ID: hasHeader

Type: boolean

(Advanced) Determines whether the first line of the file contains the description of the fields. Default value is false.

Ephemeral Port File

Property ID: epFile

Type: filename

(Advanced) File that contains the server port number, if port is -1. No default value.

Retry Period, s

Property ID: retryperiod

Type: uint

(Advanced) Period for trying to re-establish an outgoing connection, in seconds. Default value is 1.

Include Base Content

Property ID: outputBase

Type: boolean

(Optional) Starts by recording the initial contents of the stream, not just the updates. Default value is false.

Only Base Content

Property ID: onlyBase

Type: boolean

(Advanced) Sends the initial contents of the stream once. Default value is false.

MsDate Format

Property ID: msdateFormat

Type: string

(Advanced) Format string for parsing msdate values. Default value is %Y-%m-%dT%H:%M:%S.

SecondDate Format

Property ID: seconddateFormat

Type: string

(Advanced) Format string for parsing seconddate values. Default value is %Y-%m-%dT%H:%M:%S.

Field Mapping

Property ID: permutation

Type: permutation

Mapping between Event Stream Processor and external fields, for example:

<streaming_columnname>=<database_columnname>:<streaming_columnname>=<database_columnname>. No default value.

PropertySet

Property ID: propertyset

Type: string

(Advanced) Specifies the name of the property set. Property sets are reusable sets of properties that are stored in the project configuration file. Using these sets allows you to move adapter configuration properties out of the CCL file and into the CCR file. If you specify the same properties in the project configuration file and the ATTACH ADAPTER statement, the values in the property set override the values defined in the ATTACH ADAPTER statement. No default value.