Export to 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 export to this format for reporting purposed, or edit and re-import as an ETL model using the Excel Metadata Format file import bridge.
Only query mappings are supported by the Excel format.
Steps
- 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.
- Navigate to the object page for the data mapping model. Create a new empty model if necessary.
- Go to More Actions > Export.
- Select the Metadata Excel Format in EXPORT TO and specify a file pathname for the output.
- Click EXPORT.
Example
Sign in as Administrator and open the Adjustments to Staging data mapping.
Go to More Actions > Export.
Select the Metadata Excel Format in EXPORT TO and specify “C:\temp\export.xlsx”for the File parameter.
Click EXPORT
When the export is completed
Open the spreadsheet file.
Again, it is not a good practice to then re-import or update and re-import the spreadsheet into a data mapping. See details here. Instead, the best practice, is to import the spreadsheet as an ETL model using the Excel Metadata Format file import bridge.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!