16.20 - Job Example 9: Active Directory Scan - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval

Job Objective

Periodically scan for transactional data files that continuously appear in two directories. Read the data from each new file and use it to perform updates on Teradata Database tables.

For strategies on how to set up this job, see Active Directory Scan: Continuous Loading of Transactional Data and "DataConnector Operator" in Teradata® Parallel Transporter Reference, B035-2436.

Data Flow Diagram

The following figure shows a flow diagram of the elements in Job Example 9.

Job Example PTS00015 – Active Directory Scan

Sample Script

For the sample script that corresponds to this job, see the following script in the sample/userguide directory:

PTS00015: Active Directory Scan.

Rationale

This job uses:
  • DataConnector operator because it is the only producer operator that can scan a directory periodically for new files and extract data from only the files that are new since the previous scan.
  • Stream operator because it is the only operator that can perform continuous updates of Teradata Database tables.