17.10 - Transfer of Data From S3 to a Database - Access Module

Teradata® Tools and Utilities Access Module Reference

Product
Access Module
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
uur1608578381725.ditamap
dita:ditavalPath
obe1474387269547.ditaval

The following figure shows how the Teradata Access Module for S3 imports data to the database through Teradata Parallel Transporter loading operators.



  1. The Teradata Parallel Transporter DataConnector operator dynamically loads the Teradata Access Module for S3.
  2. The Teradata Access Module for S3 supports the Teradata Parallel Transporter DataConnector API by providing implementation for the required generic instructions such as File Open, File Read, File Get Position, File Set Position, File Close and Shutdown.
  3. The Teradata Parallel Transporter DataConnector operator uses the Init and File Open instructions to have the Teradata Access Module for S3 establish a number, specified by the user through the initialization string of encrypted TCP connections to S3.
  4. The Teradata Access Module for S3 retrieves data asynchronously from S3 using the number of connections specified in the Init instruction.
  5. As File Read instructions are received by the Teradata Access Module for S3 from the Teradata Parallel Transporter DataConnector Operator, the reads are matched up with the appropriate S3 buffer. Since data is read from S3 asynchronously using multiple connections and buffers, read operations may be completed immediately.
  6. In response to the Teradata Parallel Transporter DataConnector operator instructions mentioned in step 1 above, the Teradata Access Module for S3 establishes connections to S3 and fetches data from file object stored at S3.
  7. The Teradata Parallel Transporter DataConnector operator transfers the data to a Teradata Parallel Transporter loading operator.
  8. The Teradata Parallel Transporter loading operators process and load the data into a table in the database.
  9. Once an end-of-file has been received and communicated through the response to the last read instruction, Close and Shutdown instructions are sent by the Teradata Parallel Transporter DataConnector so that the Teradata Access Module for S3 can close the encrypted TCP connections to S3.