August 15, 2023

Reading data from a database table – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Reading data from a database table – Docs for ESB 6.x

Reading data from a database table

  1. Double-click tMemSQLInput to open its Basic Settings view in the Component tab.

    use_case-tmemsqlinput5.png

  2. Select the Use Existing Connection check
    box. The Component List is filled in
    automatically with tMemSQLConnection_1.
  3. Set the Schema as Built-in and click Edit
    schema     to define the data structure of the database table to
    read data from.

    use_case-tmemsqlinput6.png

    Click the [+] button to add the rows that
    you will use to define the schema, three columns in this example
    id, firstName, and
    lastName.
    Under Column, click in the fields to enter the
    corresponding column names.
    Click the field under Type to define the type of
    data.
    Click OK to close the schema editor.
  4. Fill the Table field with the database
    table, customers in this example.

    Alternatively, click the […] button
    next to the Table Name field to select the
    database table of interest. A dialog box opens showing a tree diagram of all
    the tables in the selected database. Select customers
    and click OK to close the dialog
    box.
    use_case-tmemsqlinput7.png

  5. Set the Query Type as Built-In. Click the Guess
    Query     button. The Query box
    is filled in automatically to retrieve all columns from the selected table.
  6. Double-click tLogRow to set its Basic settings in the Component tab.

    use_case-tmemsqlinput8.png

  7. In the Mode area, select Table (print values in cells of a table) for a
    better display of the results.
  8. Save the Job.
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