Adapter type: dsv_out. The File CSV Output adapter writes data as a file in Event Stream Processor delimited format.
The file does not require a header. If the file includes a header, it specifies the field names. This adapter does not support schema discovery.
If you use the CCL ATTACH ADAPTER statement to attach an adapter, you must supply the adapter type.
| Property Label | Description |
|---|---|
| Directory | Property ID: dir Type: directory (Required) Specify the absolute path to the data files you want the adapter to read. For example, <username>/<folder name>. No default value.Use a forward slash for both UNIX and Windows paths. |
| File (in Directory) |
Property ID: file Type: tables (Required) File to which the adapter writes data. No default value. |
| Include Base Content |
Property ID:outputBase Type: boolean (Optional) Records the initial contents of the stream, not just the updates. Default value is false. |
| Only Base Content |
Property ID: onlyBase Type: boolean (Optional) Sends a one-time snapshot of initial contents in a stream. Default value is false. |
| Prepend StreamNameOpcode |
Property ID: prependStreamNameOpcode Type: boolean (Optional) If true, each merge starts the stream name and the opcode. 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 . |
| Directory (runtime) |
Property ID: runtimeDir Type: runtimeDirectory (Advanced) Location of the data files at runtime, if different from discovery time. No default value. |
| File Pattern | Property ID: filePattern Type: string (Advanced) Pattern used to look up files for discovery. Default value is *.csv . |
| Date Format |
Property ID: dateFormat Type: string (Advanced) Format string to parse data values. Default value is %Y-%m-%dT%H:%M:%S. |
| Timestamp Format |
Property ID: timestampFormat Type: string (Advanced) Format string to parse timestamp 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: <esp_columnname>=<database_columnname>:<esp_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. |