Importing and exporting metadata using Talend Metadata Bridge

EnrichVersion
6.4
6.3
6.2
6.1
6.0
5.6
EnrichProdName
Talend Big Data
Talend Data Integration
Talend Real-Time Big Data Platform
Talend ESB
Talend Data Services Platform
Talend MDM Platform
Talend Data Fabric
Talend Big Data Platform
Talend Data Management Platform
task
Data Governance > Third-party systems
Design and Development > Third-party systems
Data Quality and Preparation > Third-party systems
EnrichPlatform
Talend Studio

Importing and exporting metadata using Talend Metadata Bridge

This article describes how to import and export metadata between Talend Studio and external IT systems.

Powered by Meta Integration® Model Bridge (MIMB), the Talend Metadata Bridge brings into the Talend Studio import and export capabilities for metadata. Using the Talend Metadata Bridge you can import metadata into your Talend Studio and export metadata from your Talend Studio to external IT systems including:

  • process modeling tools such as CA ErWin, Embarcadero ER/Studio, IBM Infosphere Data Architect or SAP Power Designer
  • Business Intelligence databases or front-ends such as Oracle Essbase and OBI, SAP BW or Business Objects, Microstrategy, QlikView, Tableau, and so on
  • ETL tools such as IBM Infosphere DataStage and Informatica PowerCenter
  • Applications such as Excel, Access, or Visio

The Talend Metadata Bridge requires a separate installation and some optional preference settings to enable it to work the way you want. From Talend Studio 5.6.2 onwards, the Talend Metadata Bridge is installed through the [Additional Talend Packages] wizard. If you are using Talend Studio 5.6.1, contact your Talend support for information on how to obtain and install the Talend Metadata Bridge.

For other useful information on this feature, see the article "Getting Started with the Talend Metadata Bridge (FAQ)".

How to import metadata from external systems

Procedure

  1. From your Talend Studio, select the File > Component... menu.
  2. In the [Import] wizard, select Import metadata under the Metadata Bridge node, and click Next.
  3. Select a bridge from the Bridges list.

    In this example, we will import metadata from a data file exported from CA ErWin 9.x Data Modeler.

    Tip: The parameters to set vary depending on the bridge you choose. Select any parameter to view a detailed description about it, and click in the Value field to set the value of the parameter.
  4. Click in the Value field for the File parameter, and click the [...] button to browse to the source file to import metadata from.
  5. Set the optional parameters if needed, and click Next.
  6. Select a date format and/or a directory to hold the data files as needed. Then click Next to start importing metadata from the selected object.
  7. When the import process is complete, click Finish to close the wizard.

Results

Now a new database connection is created and automatically selected under the Metadata node of the Repository tree view. You can edit the connection and its schemas as needed and reuse the metadata in your Jobs.

How to export metadata to external systems

Procedure

  1. From your Talend Studio, select the File > Export... menu.
  2. In the [Export] wizard, select Export metadata under the Metadata Bridge node, and then click Next to define Talend Bridge parameters.
  3. Click in the Value field for the Project items parameter, and click the [...] button to browse to the item to export.
    This is the only required parameter to set in this example. You can select any parameter to view its description, and click in the Value field to set the value of the parameter.
  4. Click Next.
  5. Select a bridge from the Bridges list.

    In this example, we will export the selected Job into a data file for CA ErWin 9.x Data Modeler.

  6. Specify the target file in the Value field for the File parameter, or click in the Value field and then click the [...] button to browse to the target file.

    If the specified file doesn't exist, it will be created; if the specified file already exists, it will be overwritten.

    This is the only required parameter to set in this example. The parameters to set vary depending on the bridge you choose. Select any parameter to view a detailed description about it, and click in the Value field to set the value of the parameter.

  7. Set the optional parameters according as needed and click Next to start exporting the specified item.
  8. When the export process is complete, click Finish to close the wizard.