Scenario:
A custom document type in the repository has an attribute (or set of attributes) that stores a key value. There is an external, custom system containing various additional attributes that can be retrieved by the key value. The data in the external system may change quite frequently.
The goal: to be able to search for the document using Webtop and the external metadata as part of of the search criteria, display the external metadata in search results.
The brute-force approach would be to replicate the external attributes as part of the custom type definition and to have a separate process synchronizing the values with the external system.
Is there another way of doing this? Can Federated Search help? Again, it is like doing two-phase query...