Using centralized metadata in a Job - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-29

About this task

For recurrent use of files and database connections in various Jobs, we recommend you to store the connection and schema metadata in the Repository tree view under the Metadata node. Different folders under the Metadata node will group the established connections including those to databases, files, and systems.

Different wizards will help you centralize connection and schema metadata in the Repository tree view.

Once the relevant metadata is stored under the Metadata node, you will be able to drop the corresponding components directly onto the design workspace.

Procedure

  1. In the Repository tree view of the Integration perspective, expand Metadata and the folder holding the connection you want to use in your Job.
  2. Drop the relevant connection or schema onto the design workspace.
    Screenshot showing how to drop a table schema from the Metadata view into the design workspace.
    A dialog box prompts you to select the component you want to use among those offered.
    Dialog box to select the component to use.
  3. Select the component and then click OK. The selected component displays on the design workspace.

Results

Alternatively, according to the type of component (Input or Output) you want to use, perform one of the following operations:

  • Output: Press Ctrl on your keyboard while you are dropping the component onto the design workspace to directly include it in the active Job.
  • Input: Press Alt on your keyboard while you drop the component onto the design workspace to directly include it in the active Job.

If you double-click the component, the Component view shows the selected connection details as well as the selected schema information.

Note: If you select the connection without selecting a schema, then the properties will be filled with the first encountered schema.