August 16, 2023

Configuring the tMysqlInput component – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Configuring the tMysqlInput component – Docs for ESB 6.x

Configuring the tMysqlInput component

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

    Use_Case_tMysqlInput_Dynamic_Schema_2.png
    Warning:

    The dynamic schema feature is only supported in
    Built-In mode.

  2. Select Built-in as the
    Property Type.
  3. Select the DB Version from the corresponding list.
  4. Next to Host, enter the database server IP
    address.
  5. Next to Port, enter the listening port number of the
    database server.
  6. Enter your authentication data in the Username and
    Password fields.
  7. Set the Schema type
    as Built-in and click Edit schema to define the dynamic schema.

    The schema editor opens:

    Use_Case_tMysqlInput_Dynamic_Schema_3.png

  8. Click the [+] button to
    add a row to the schema.

    1. Under Column and Db
      Column      , click in the fields to enter the corresponding
      column names.
    2. Click the field under Type to define the type of
      data.
    3. Click the arrow and select Dynamic from the
      list.

      Warning:

      Under Type, the dynamic column type
      must be set as Dynamic.

  9. Click OK to close the
    schema editor.
  10. Next to the Table Name
    field, click the […] button to select
    the database table of interest.

    A dialog box displays a tree diagram of all the tables in the selected
    database:

    Use_Case_tMysqlInput_Dynamic_Schema_4.png

  11. Click the table of interest and then click OK to close
    the dialog box.
  12. Set the Query Type as
    Built-In.
  13. In the Query box, enter the query required to retrieve
    all of the columns from the table.

    Warning:

    In the SELECT statement it is necessary to use the
    * wildcard character, to retrieve all of the
    columns from the selected table.

    Use_Case_tMysqlInput_Dynamic_Schema_5.png

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