Configuring the components

Logs and errors (Integration)

author
Talend Documentation Team
EnrichVersion
6.4
EnrichProdName
Talend ESB
Talend Big Data Platform
Talend MDM Platform
Talend Data Services Platform
Talend Real-Time Big Data Platform
Talend Data Management Platform
Talend Data Integration
Talend Open Studio for Data Integration
Talend Data Fabric
Talend Open Studio for MDM
Talend Open Studio for ESB
Talend Big Data
Talend Open Studio for Big Data
task
Data Governance > Third-party systems > Logs and errors components (Integration)
Data Quality and Preparation > Third-party systems > Logs and errors components (Integration)
Design and Development > Third-party systems > Logs and errors components (Integration)
EnrichPlatform
Talend Studio

Procedure

  1. Double-click tFixedFlowInput to open its Basic settings view.
    Select Use Inline Content (delimited file) in the Mode area.
    In the Content field, enter the data to write to the Mysql database, for example:
    AS2152;Washingto Berry Juice;2013-02-19 11:14:15;3.6
    AS2152;Washingto Berry Juice;2013-02-19 12:14:15;3.6
    AS2152;Washingto Berry Juice;2013-02-19 13:14:15;3.6
    AS2152;Washingto Berry Juice;2013-02-19 14:14:15;3.6
    AS2152;Washingto Berry Juice;2013-02-19 12:14:15;3.6
    AS2152;Washingto Berry Juice;2013-02-19 12:14:15;3.6
    AS2152;Washingto Berry Juice;2013-02-19 12:14:15;3.6
    AS2152;Washingto Berry Juice;2013-02-19 12:14:15;3.6
    AS2152;Washingto Berry Juice;2013-02-19 12:14:15;3.6
    AS2152;Washingto Berry Juice;2013-02-19 12:14:15;3.6
    AS2152;Washingto Berry Juice;2013-02-19 12:14:15;3.6
    AS2152;Washingto Berry Juice;2013-02-19 12:14:15;3.6
    AS2152;Washingto Berry Juice;2013-02-19 12:14:15;3.6
    Note that the orders listed are just for illustration of how tAssert functions and the number here is less than 20.
  2. Click the Edit schema button to open the schema editor.
  3. Click the [+] button to add four columns, namely product_id, product_name, date and price, of the String, Date, Float types respectively.
    Click OK to validate the setup and close the editor.
  4. Double-click tMysqlOutput to display the Basic settings view.
  5. In the Host, Port, Database, Username and Password fields, enter the connection details and the authentication credentials.
  6. In the Table field, enter the name of the table, for example order.
  7. In the Action on table list, select the option Drop table if exists and create.
  8. In the Action on data list, select the option Insert.
  9. Double-click tAssert to display the Basic settings view.
  10. In the description field, enter the descriptive information for the purpose of tAssert in this case.
  11. In the expression field, enter the expression allowing you to compare the data to a fixed number:
    ((Integer)globalMap.get("tMysqlOutput_1_NB_LINE_INSERTED"))>=20
  12. Double-click tLogRow to display the Basic settings view.
  13. In the Mode area, select Table (print values in cells of a table) for a better display.