Configuring the child Job - 8.0

Data Integration Job Examples

Version
8.0
Language
English
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
Design and Development > Designing Jobs
Last publication date
2024-02-06

Procedure

  1. In the Context view, add the following three variables, leaving their values undefined:
    • filename, type String
    • tablename, type String
    • directory, type String
  2. Double-click the tFileInputDelimited component (labeled Input_file) to open its Basic settings view, and configure the component as follows:
    • Open the schema editor and add a column data, and set its type to Dynamic.
      Screenshot of the schema editor.
    • Fill the File name/Stream field with the context variables defined for file accessing: context.directory+context.filename.
      Tip: Click in the field and press Ctrl+Shift to access a list of available variables.
    • In the Header field, specify the number of rows at the beginning of the files to skip.

      In this example, the first row of each file is the header row.

    • Leave the other settings as default.
    Screenshot of the component basic settings.
  3. Double-click the tDBOutput component (labeled Write_to_DB) to open its Basic settings view, and configure the component as follows:
    • Specify the database connection details, including the host name or IP address, the port number, and database name, and the authentication credentials.
    • Fill the Table field with the context variable defined for the table name, context.tablename in this example.
    • From the Action on table list, select Default.
    • From the Action on data list, select Insert.
    • Click Sync columns to ensure the schema is the same as the input component: a single column named data, type Dynamic.
    • Leave other options as default.
    Screenshot of the component basic settings.
  4. Press Ctrl + S to save the Job.