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

Setting up a database connection

This recipe shows how a database connection can be easily created using the Talend supplied wizard. Note that this recipe and the next use the connection cookbookDB_myCopy. This version of the database metadata is used for demonstration only. All the other jobs in this chapter use the connection cookbookDB unless explicitly stated otherwise.

Getting ready

Ensure that MySQL is running and you have executed the command mentioned in the Introduction section.

How to do it...

The steps to be performed are as follows:

  1. Navigate to Metadata | Db Connections. Right-click on it and select Create connection.
  2. Set the name as cookbookDB_myCopy and click on Next.
  3. Select the database as MySQL from the drop-down list and then enter the ...

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