Configuring the tMysqlInput component - 6.4

Dynamic Schema

author
Talend Documentation Team
EnrichVersion
6.4
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 Real-Time Big Data Platform
task
Data Governance > Third-party systems > Custom code components (Integration) > Dynamic Schema components
Data Quality and Preparation > Third-party systems > Custom code components (Integration) > Dynamic Schema components
Design and Development > Third-party systems > Custom code components (Integration) > Dynamic Schema components
EnrichPlatform
Talend Studio

Procedure

  1. Double-click tMysqlInput to open its Basic Settings view in the Component tab.
    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:

  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:

  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.