Before you begin
- The MDM server is already launched.
-
You have been assigned a role with the appropriate user authorization and access rights.
-
You have selected the data container which holds the master data records and staging data records you want to manage and the corresponding data model against which the data will be validated.
-
At least one view has been created in Talend Studio. For more information, see Views.
Note:If a smart view has already been created for the business entity in Talend Studio, the Master Data Browser and Staging Data Browser pages the Master Data Browser page will open on this customized view and not on the usual generated view.
For more information on smart views, see Creating a Smart View process.
Procedure
-
From the Menu pane, click
Browse to expand the menu
items and then click Staging Data
Browser to open the Staging
Data Browser page.
Example
-
If required, you can define the search criteria
to filter the results.
Note: If you have already bookmarked your search criteria, click
from the list to the right, select a search bookmark
and then click Search.Consider, for example, searching the Product entity for all staging data records in which the price is equal to 30.
After setting the entity name in the first field, click the arrow in the second field and select Price.
In the drop-down list immediately to the right, click the arrow and select a search option, is equal to in this example.
In the next field, enter 30.
Click Search to display all products whose price is equal to 30.
The first record in the list is automatically selected and its details are displayed in the panel to the right, including the details of those entities that are linked with this entity through foreign keys if any.
When defining the search criteria, bear in mind the following:- The search criteria available depend on the parameters set in Talend Studio when creating a view for the entity.
- If you are using a SQL database, you cannot combine a full text query with other search criteria.
- If the field is a foreign key of composite key or numeric type, only two operators is equal to and is empty or null are available, and you can specify the search keyword in a suggest box field, which can display a suggest list of values that match your input based on the foreign key info.
- If the field is a foreign key of string type, six operators contains the word(s), contains the sentence, is equal to, is not equal to, starts with, and is empty or null are available.
- If the field is a foreign key, the Select the relationship button displayed next to the search field allows you to specify the search keyword by selecting a foreign key value in a pop-up Select the related record dialog box.
- Searches in master database support both full text search and standard SQL search, while searches in staging database only support standard SQL search.
- In addition to the elements defined in entities, several built-in elements (also known as metadata elements) exist in staging database, which are Match group, Status, Error, and Source. You can use conditions based on those elements to search the staging data records.