Before you begin
The MDM server is already launched.
At least one view has been created in Talend Studio. For further information, see the Talend Studio User Guide.
Make sure you have selected the data container that holds the master data you want to manage and the data model against which the master data will be validated. For further information, see Accessing data containers and data models.
About this task
Follow the steps outlined in Searching entities in the selected data container or Using the advanced search capabilities to list the data records according to a specific search
Note that the data records to be exported contain only the fields available in the list, which depend on what you have defined in the view.
- Select the data records you want to export and then click Import and Export on the menu bar.
Select Export to open the
Export File dialog box.
ExampleMake sure you have defined a multi-value separator. Otherwise, unexpected errors will occur.Depending on your choices, a foreign key element can be exported in three different ways:
If you do not select the Resolve Foreign Key check box, only the foreign key id will be exported and wrapped in brackets, for example, [FKid1], [FKid1][FKid2], and [FKid1][FKid2]|[FKid3].
If you select Resolve Foreign Key check box and then select Id-FKInfo from the Display Type list, the value of the exported foreign key element will contain both its id and the foreign key information, for example, [FKid1]|FKinfo1, [FKid1][FKid2]|FKinfo1, and [FKid1]|FKinfo1|FKinfo2.
If you select Resolve Foreign Key check box and then select FKInfo from the Display Type list, the value of the exported foreign key element will contain only the foreign key information, for example, FKinfo1, and FKinfo1|FKinfo2.
- Select the type of the file into which your search results will be exported, either Excel or CSV. In this example, it is Excel, and the search results will be exported to an XLSX file.
Click Export and then follow the
instructions in the dialog box that opens to complete the
export operation. Note that the steps to follow are
different according to your operating system.
Select the Save File option and then
click OK to close the dialog box. The
listed records are all copied from the MDM server to your
computer in an XLSX file.
You can now do necessary modifications on the records and then import them on the MDM server as outlined in Importing data records.