Disable encoding CLOB fields in CSV files

Overview

In the Etlworks Integrator, you can disable encoding CLOB fields in CSV files.

Process

When the Flow extracts data from the database and creates CSV files, the columns with the CLOB (TEXT, LONGTEXT, etc.) data types are converted to the binary string which looks like the following: H4sIAAAAAAAAAAXByxGCMBAAUC6WEwL5YPBiKZmwLLIMbJhkHc.

The Etlworks Integrator also automatically encodes nested datasets. 

If you want the Etlworks Integrator to preserve the original string value like in the source, when configuring the CSV Format, disable Encode CLOB fields using Base64. This option is enabled by default.