Configuring the components - Cloud - 8.0

ログとエラー(インテグレーション)
Version
Cloud
8.0
Language
日本語
Product
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 Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
ジョブデザインと開発 > サードパーティーシステム > ロギングコンポーネント
データガバナンス > サードパーティーシステム > ロギングコンポーネント
データクオリティとプレパレーション > サードパーティーシステム > ロギングコンポーネント
Last publication date
2023-09-14

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.