Job Example 16: Extract BLOB/CLOB/JSON Data and Write It to an External File - Parallel Transporter

Teradata® Parallel Transporter User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Parallel Transporter
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-08-25
dita:mapPath
uzp1645128359760.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
Product Category
Teradata Tools and Utilities

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.