In Talend Studio, you can
fetch a metadata definition from a database, making the best use of your existing
resources.
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.
Procedure
-
In the Repository, expand
Metadata then right-click
Db Connections and click
Create connection.
You are brought to
Step 1 in the wizard.
-
In the Name field,
enter a name.
Example
MySQL
- Optional:
In the Purpose
field, enter a purpose.
Example
Demonstrate how to fetch metadata from a
database
- Optional:
In the
Description field, enter a description.
Example
Fetching CSV data imported into a MySQL
database
Information noteTip: Enter a Purpose
and Description to stay organized.
-
Click Next.
You are brought to Step 2 in the wizard.
-
Enter your connection details.
Information noteTip: To check the connection to the database, click
Test connection.
-
Click Finish.
You are brought to the
Designer.
-
Right-click your metadata in the Repository.
-
Click
Retrieve Schema.
You are brought to the Filter for the Table window.
-
Click
Next.
You are brought to the Add a Schema on repository
window.
-
Select the check box next to the table name.
-
Click
Next.
The database schema displays.
- Optional:
Change the Schema parameters.
-
Click
Finish.
Results
All table schemas have been imported as metadata and can be reused in your
components.