Skip to main content Skip to complementary content

Using metadata to read a database and displaying the results

You can read and manage databases in Talend Studio, allowing you to integrate them into your data management workflows.

Before you begin

This tutorial makes use of a database. If you do not have a database, click the Downloads tab and save customers_unordered.sql. You must import the database into a compatible program.
You must have created a metadata definition from a database (see Creating a metadata definition from a database).

Procedure

In the Repository, expand Metadata > Db Connections.
Drag-and-drop a database metadata on the Designer.
1. Select a tDBInput component.
  The component inherits the database schema.
In the Designer, add a tLogRow component.
Right-click the tDBInput component.
1. Select Row > Main.
2. Click on the tLogRow component to link the two.
Optional: In the tLogRow component, select the Table Mode.
In the Run view, click Run.

Results

The tDBInput component, configured through metadata, reads your database, and the tLogRow component displays its content on the console.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here