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

Importing the table schemas

Once we have the connection set up, it is very easy to grab table metadata from the database for use in our jobs. The following example shows how simple this is.

Getting ready

If you have set up the database correctly, then you should be able to see three tables in the database; customer, order, and order_item.

How to do it…

The steps to be performed are as follows:

  1. Right-click on the cookbookDB_myCopy database connection and select Retrieve Schema.
  2. This opens up a dialogue that will enable you to define filters. We do not need to filter, so click on Next.
  3. View the list of tables in the cookbookDB database by clicking on >. This dialogue also enables us to filter the tables that we are interested in.
  4. Since we want all the tables, ...

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