 |
 | Open Talend Studio for Data Integration
|
Double-click on the Talend Open Studio for Data Integration shortcut to open its connection wizard.
|
 |
 | Create and open a project
|
In the Talend Open Studio for Data Integration wizard: Select Create a new local project from the Or list and click Go! to open the New Project wizard.
|
 |
In the New project wizard: In the Project name field, name the project Demo5mn. In the Generation language list, select java as the language used to generate the code. Click Finish.
 | In the Name field, accents, special characters and spaces are invalid. Also do not use numbers to start the field.
|
|
 |
In the Talend Open Studio for Data Integration wizard: In the Project area, select the newly created project Demo5mn from the list and click Open.
|
 |
When you open Talend Open Studio for Data Integration for the first time, a tab displays useful information such as links to the Installation Guide, the User Guide and the Community. Click Start now! to close the tab and access the Talend Open Studio for Data Integration main screen.
|
 |
 | Create a Job Design
|
In the Repository on the left of Talend Open Studio for Data Integration main screen: Right-click on Job Designs. In the menu, click Create Job to open the New job wizard.
|
 |
In the New job wizard: In the Name field, fill in the name of the Job: Demo5mn. Click Finish to close the wizard and create the Job. The Job Designer opens an empty Job.
|
| In the Name field, accents, special characters and spaces are invalid. Also do not use numbers to start the field.
|
|
 |
 | Create the metadata
|
In the Repository on the left of the Talend Open Studio for Data Integration main screen: Expand the Metadata node. Right-click on File delimited. In the menu, click Create file delimited to open the New Delimited File wizard.
|
 |
In the New Delimited File wizard: In the Name field, name the metadata Customers. Click Next to continue.
|
 |
Click Browse... and select customers_demo5mn.csv from the wizard. From the Format list, select your computer OS. Click Next.
|
 |
In the Preview area at the bottom of the wizard, check the Set heading row as column names box to retrieve the file column names. Click Refresh Preview to update the structure and data preview. Click Next.
|
| When you check the Set heading row as column names box, the number in the Header field is incremented.
|
|
 |
In the Description of the Schema table, you can modify the description of the data structure. Check the Key box and uncheck the Nullable box next to the id column to define it as primary key.
|
 |
In the Repository on the left: The Customers metadata is displayed in the Metadata > File delimited node.
|
 |
In the Repository on the left: To add the input component, press Ctrl+Shift while you drag and drop the Customers metadata onto the Job Designer. The tFileInputDelimited component is automatically created in the Job Designer.
|
 |
In the Palette on the right: Click the Logs & Errors family to add the output component. Click the tLogRow component and drop it onto the Job Designer.
|
 |
In the Job Designer: To link the components together, right-click on the tFileInputDelimited named Customers, hold, and drag it to the tLogRow.
|
| You can also right-click on the component, select Row > Main on the right-click menu, and click the output component to link them together.
|
|
 |
In the Job Designer: Press Ctrl+S to save the Job. Click the Run view.
In the Run view: Click the Advanced Settings tab. Check the Statistics box.
|
 |
 | Run the Job
|
In the Run view:Click the Basic Run tab. Click on the Run button to start the Job execution in the Statistics mode.
Next
|
| | |
|
The Job is working! It reads a delimited file and displays the data in the console. Now we are going to modify the data through a processing component and display the result on the console.
|
 |
| | |
