Creating a metadata definition from a database - 8.0

Creating and using metadata in Talend Studio

Version
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development > Designing Jobs
Last publication date
2024-02-06

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, download and extract the following file: customers_unordered.zip. You must import the database into a compatible program.

Procedure

  1. In the Repository, expand Metadata then right-click Db Connections and click Create connection.
    You are brought to Step 1 in the wizard.
  2. In the Name field, enter a name.

    Example

    MySQL
  3. Optional: In the Purpose field, enter a purpose.

    Example

    Demonstrate how to fetch metadata from a database
  4. Optional: In the Description field, enter a description.

    Example

    Fetching CSV data imported into a MySQL database
    Tip: Enter a Purpose and Description to stay organized.
  5. Click Next.
    You are brought to Step 2 in the wizard.
  6. Enter your connection details.
    Tip: To check the connection to the database, click Test connection.
  7. Click Finish.
    You are brought to the Designer.
  8. Right-click your metadata in the Repository.
    1. Click Retrieve Schema.
      You are brought to the Filter for the Table window.
    2. Click Next.
      You are brought to the Add a Schema on repository window.
    3. Select the check box next to the table name.
    4. Click Next.
      The database schema displays.
    5. Optional: Change the Schema parameters.
    6. Click Finish.

Results

All table schemas have been imported as metadata and can be reused in your components.