Outputting data from a file to a database table and vice versa - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-29

About this task

You can use different templates to create a Job that writes data from a file to a database table or from a database table to a file, do the following:

Procedure

  1. In the Repository tree view of the Integration perspective, right-click Job Designs and select Create job from templates in the drop-down list. A Job creation wizard displays to help you defining the new Job main properties
    Job creation wizard.
  2. Select the Simple Template option and click Next to open a new view on the wizard.
    Job creation wizard.
  3. Enter the relevant information according to the following:
    Field Description
    Name Enter a name for your new Job. A message comes up if you enter prohibited characters.
    Purpose Enter the Job purpose or any useful information regarding the Job use.
    Description Enter a description, if need be, for the created Job.
    Author The Author field is read-only as it shows by default the current user login.
    Locker The Locker field is read-only as it shows by default the current lock.
    Version The Version is read-only. You can manually increment the version using the M and m buttons. For more information, see Managing Job and Route versions.
    Status You can define the status of a Job in your preferences. By default none is defined. To define them, go to Window > Preferences > Talend > Status.
    Path Select the folder in which the Job will be created.
  4. Once you filled in the Job information, click Next to validate and open a new view on the wizard.
    Job creation wizard.
  5. Select the template you want to use to create your Job and click Next.
    Job creation wizard.
  6. In the Type Selection area, select from the drop-down list the input file to use, tFileInputDelimited for example.
  7. In the Main properties of the component area, click the [...] button and browse to the file you want to use the properties of. The file should be centralized in the Repository tree view. The fields that follow in the Detail settings area are filled automatically with the properties of the selected file. Alternatively, you can set manually the file path and all properties fields in the Detail setting area, if needed.
    Then, click Next to validate and open a new view on the wizard.
    Job creation wizard.
  8. In the Metadata area, click the three-dot button to open the Repository Content dialog box and select the schema. Alternatively, you can use the toolbar to import it or add columns manually. Then, click Next to validate and open a new view on the wizard.
    Job creation wizard.
  9. In the Type Selection area, select the output database type from the drop-down list.
  10. In the Main properties of the component area, click the three-dot button and browse to the connection you want to use the properties of. The Database connection should be centralized in the Repository tree view. The fields that follow in the Detail settings area are filled automatically with the properties of the selected connection. Alternatively, you can set manually the database details and all properties fields in the Detail setting area, if needed.
    Then, click Finish to close the wizard.
    The ready-to-run Job is created and listed under the Job Designs node in the Repository tree view.
    Design workspace.

Results

Once the Job is created, you can modify the properties of each of the components in the Job according to your needs.