Skip to main content Skip to complementary content

Configuring the components

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here