O'Reilly logo

Talend Open Studio Cookbook by Rick Barton

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Writing to a database table

Writing to tables using Talend can seem very simple, but in fact is a very big topic, since different databases have multiple modes of writing to tables. In this simple recipe, we'll perform a basic write of data to a table as a basis for a much deeper conversation regarding this very important database requirement.

Getting ready

Open the job jo_cook_ch07_0040_writingTable.

How to do it…

The steps to be performed are as follows:

  1. Open the cookbookDB connection and drag the schema for the table customer to the canvas.
  2. Select the Component tMysqlOutput.
  3. Open tMysqlOutput and change Table to customerWriteTest.
  4. Connect it to tFileInputDelimited.
  5. Run the job and you will get the message Table'cookbookdb.customer_write_test' doesn't ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required