Enable base64 encoding of fields in CSV files

Overview

When the Flow extracts data from the source and creates CSV files, the columns with the CLOB (TEXT, LONGTEXT, etc.) data types can be converted to the binary string encoded using base64 algorithm. The encoded strings looks like the following: H4sIAAAAAAAAAAXByxGCMBAAUC6WEwL5YPBiKZmwLLIMbJhkHc.

If Base64 encoding is enabled, Etlworks also automatically encodes nested datasets. 

Process

If you want Etlworks to encode CLOB fields and nested datasets enable option Encode CLOB fields using Base64 when creating or modifying CSV format.

Keep this option disabled if you want Etlworks to preserve the original string value like it is stored in the source. This option is disabled by default.