Import from a Metadata Excel Format (Deprecated)

The data mapper is compatible with the Excel metadata format that is defined and provided as part of the delivery of Talend Data Catalog . In this way, you may import an existing spreadsheet in this format into a data mapping. Note, this process may fail due to differences in the definition of the source and/or target data stores in the spreadsheet vs. the versions of those models in Talend Data Catalog and associated with the specific mappings.

Only query mappings are supported by the Excel format.

Steps to import into a data mapping (generally not a supported practice)

1. Sign in as a user with at least the Metadata Import / Export capability object role assignment on the Data Mapping you are going to edit.
2. Navigate to the object page for the data mapping model.
3. Go to More Actions > Import.
4. Select the file pathname for the spreadsheet.
5. Click IMPORT.

Steps to import into model (Best Practice)

1. Import the spreadsheet as an ETL model using the Excel Metadata Format file import bridge just as for any other model import.
2. Go to the Connections tab and stitch the data store models which are source and target of the original data mapping.
3. Click UPDATE AND BUILD to resolve the stitchings.

Example of Best Practice with Spreadsheets

Sign in as Administrator and open the Adjustments to Staging data mapping.

Go to MANAGE > Configuration and Create a new model using the Metadata Format file import bridge:

Go to the Connections tab and stitch the data store models which are source and target of the original data mapping.

Click UPDATE AND BUILD to resolve the stitchings.

And you are done.