August 15, 2023

Retrieving data from the Teradata database table – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Retrieving data from the Teradata database table – Docs for ESB 6.x

Retrieving data from the Teradata database table

  1. Double-click tTeradataInput to open its
    Basic settings view.

    components-tteradatatptexec_s1_tteradatainput.png

  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.

  4. Click the […] button next to Edit schema to open the schema editor.

    components-tteradatatptexec_s1_tteradatainput_schema.png

  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.

    components-tteradatatptexec_s1_tlogrow.png

  8. In the Mode area, select the Table (print values in cells of a table) option
    for a better display of the result.
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x