Importing and exporting metadata using Talend Metadata Bridge
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
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.