Step 4: Output to a MySQL table - 7.0

Data Integration Job Examples

author
Talend Documentation Team
EnrichVersion
7.0
EnrichProdName
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 Open Studio for MDM
Talend Real-Time Big Data Platform
task
Design and Development > Designing Jobs
EnrichPlatform
Talend Studio

Our Job works perfectly! To finalize it, let's direct the output flow to a MySQL table.

Procedure

  1. To do so, let's first create the Metadata describing the connection to the MySQL database. Expand the Metadata > MySQL nodes in the Repository and double-click DemoMySQL (on the condition that you imported the Demo project properly) to open the Metadata wizard.
  2. On Step2 of the wizard, type in the relevant connection parameters. Check the validity of this connection by clicking on the Check button. Eventually, validate your changes, by clicking on Finish.
  3. Drop this metadata to the right of the design workspace, while maintaining the Ctrl key down, in order to create automatically a tMysqlOutput component.
  4. Remove the tLogRow component from your Job.
  5. Reconnect the out1 output flow from the tMap to the new component tMysqlOutput.
  6. On the Basic Settings tab of this component:
    1. Type in LA_Orange_Clients in the Table field, in order to name your target table which will get created on the fly.
    2. Select the Drop table if exists and create option or on the Action on table field.
    3. Click Edit Schema and click the Reset DB type button (DB button on the tool bar) in order to fill out automatically the DB type if need be.
  7. Run again the Job.

Results

The target table should be automatically created and filled with data in less a second!

In this scenario, we did use only four different components out of hundreds of components available in the Palette and grouped according to different categories (databases, Web service, FTP and so on)!

And more components, this time created by the community, are also available on the community site (talendforge.org).