A simple subjob

We will begin with a simple subjob example. Our integration scenario is as follows:

  • We want to extract data from a database to a delimited file
  • We need to zip the file to archive it

We will use the same database that we used for the integration examples in Chapter 4, Working with Databases. Let's build the subjob by performing the following steps:

  1. Create a new job and name it SimpleSubjob.
  2. We will extract data from the order_lines table, so expand the DEMO_DB 0.1 metadata connection (in the Repository window) to reveal the Table Schemas.
    A simple subjob
  3. Click on the order_lines table and drag it onto the Job Designer. Select tMySQLInput from the pop-up ...

Get Getting Started with Talend Open Studio for Data Integration now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.