Retrieving data from the Teradata database table - 7.1

Teradata

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Database components > Teradata components
Data Quality and Preparation > Third-party systems > Database components > Teradata components
Design and Development > Third-party systems > Database components > Teradata components
EnrichPlatform
Talend Studio

Procedure

  1. Double-click tTeradataInput to open its Basic settings view.
  2. In the Table Name field, enter the name of the table to read data from. In this example, it is person.
  3. In the Query field, enter the following SQL statement to retrieve data from the table person.
    SELECT * FROM samples.person ORDER BY id
  4. Click the [...] button next to Edit schema to open the schema editor.
  5. Click the [+] button to add three columns: id of the integer type, name and sex of the string type. Note that id and name in Db Column are enclosed in a pair of \" since they are Teradata database keywords.
  6. Click OK to close the schema editor and accept the propagation prompted by the pop-up dialog box.
  7. Double-click tLogRow to open its Basic settings view.
  8. In the Mode area, select the Table (print values in cells of a table) option for a better display of the result.