Procedure

DB Generic

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend Open Studio for MDM
Talend Open Studio for ESB
Talend Big Data
Talend Real-Time Big Data Platform
Talend Data Integration
Talend MDM Platform
Talend Open Studio for Big Data
Talend Big Data Platform
Talend Open Studio for Data Integration
Talend Data Services Platform
Talend Data Management Platform
Talend Data Fabric
Talend ESB
task
Data Governance > Third-party systems > Database components > DB Generic components
Data Quality and Preparation > Third-party systems > Database components > DB Generic components
Design and Development > Third-party systems > Database components > DB Generic components
EnrichPlatform
Talend Studio

Procedure

  1. Drop tDBOutput and tRowGenerator from the Palette to the design workspace.
  2. Connect the components using a Row > Main link.
  3. Double-click tRowGenerator to open its Schema editor.
  4. Click the [+] button to add a line.
    Enter date as the column name.
    Select Date from the data type list.
    Select getCurrentDate from the Functions list.
    Enter 1 in the Number of Rows for RowGenerator field as only one row will be added to the table.
    Click OK to close the editor and propagate the schema changes to tDBOutput subsequently.
  5. Double-click tDBOutput to open its Basic settings view in the Component tab.
  6. In the Database field, enter the name of the data source defined during the configuration of the MySql ODBC connection.
    To configure an ODBC connection, click to open the database connection configuration wizard.
  7. In the Username and Password fields, enter the database authentication credentials.
  8. In the Table field, enter the table name, Date in this example.
  9. In the Action on data field, select Insert to insert a line to the table.
  10. Select the check box Clear data in table to clear the table before the insertion.
  11. Save the Job and press F6 to run.
    As shown above, the table now has only one line about the current date and time.