In TRNSYS its TNY2 data from meteonorm for most of the cities in the world, for which city you need ? its a data file which you can read through Dview program.
Meteonorm and TRNSYS softwares (not free sources), and SAM (free but only few locations out of the USA are available; two regions in Egypt are available in SAM: Cario and Aswan in csv format).
The request is for _spectrally-resolved_ data, which none of the software mentioned provide: TRNSYS, SAM, Meteonorm only use or simulate the broadband irradiance. You can simulate the clear-sky spectral components with SMARTS (http://solarconsultingservices.com/smarts.php) if you know the atmospheric conditions, or you can use the CMSAF spectral database derived from satellite imagery. See http://www.mdpi.com/2072-4292/4/3/622
Radiation is a general term for all kinds of electromagnetic radiation, so the unit can vary depending on context. The other terms are very specific.
Irradiance is instantaneous power in W/m2 (if broadband) or W/m2 nm (if spectral).
Radiance is irradiance emanating from a given area and over a specific view angle, in W/m2 sr (if broadband) or W/m2 nm sr (if spectral). A typical application is the analysis sky radiance because it is not isotropic, so that the quadrant containing the sun is usually brighter than the other ones. Integrating the sky radiance over the whole hemisphere gives you the sky diffuse irradiance.
Irradiation is accumulated energy, or irradiance integrated over some period of time, like a day, in J/m2 or kWh/m2.