Job Objective
Extract rows that include BLOB/CLOB/JSON data from a database table and write them to an external flat file.
Data Flow Diagram
The following figure shows a diagram of the elements for Job Example 16.
Job Example PTS00021, PS00027 – Extract BLOB/CLOB/JSON Data and Write It to an External File

Sample Script
For the sample script that corresponds to this job, see the following scripts in the sample/userguide directory:
- PTS00021: Extracting BLOB/CLOB Data and Writing It to an External Target
- PTS00027: Extracting BLOB/CLOB/JSON Data and Writing It to an External Target
Rationale
This job uses the operators shown for the following reasons:
- Use SQL Selector operator because it is the only operator that can read BLOB/CLOB/JSON data from the database and write it to separate external data files. One data file stores data for one LOB/JSON column.
- Use DataConnector operator because it is the only operator that can write LOB/JSON data to an external file.