Procedure
-
Double-click the tMysqlInput component to
display its Basic settings.
- Select Repository as Property type and click the three-dot button next to the field to retrieve the connection properties that corresponds to the metadata you want to check.
- Select Repository from the Schema drop down list and click the three-dot button next to the field to retrieve the schema that corresponds to your database table.
- Click the three-dot button next to the Table field to select the table to check.
- Click Guess Query to automatically retrieve the query corresponding to the table schema.