Infowise LOB Link Item Field is a useful SharePoint web part. Easy-to-use lookup into a database-driven line-of-business application to be linked to any document or list item. No need to define connection using BDC or External List functionality. Saves item data as appears at the time of lookup.

1. WSS/Foundation support, MOSS/Server not required
2. Define MS-SQL/Oracle connection
3. Show multiple fields from the LOB system
4. Save external item data within the SharePoint item as appears at the time of retrieval
5. Easier to set up than external lists or BDC

LOB Item Link Field Features:
1. Connection info stored in column definition
2. External item selection by lookup or manual entry
3. Snapshot of data at time of entry
4. Friendly name mapping

LoB field fetches your data directly from an external data source. You specify the connection and the fields you want to extract and the field will do the rest.

You can select from a dropdown of possible items or enter manually. The imported item can contain as many additional fields as you like and you can even give simpler display names to those fields.

When the item changes in the LoB system, your SharePoint data is not affected, as long as you do not initiate a data fetch. This way you can be sure your SharePoint items stored the snapshot relevant to the point in time when your SharePoint item was created.

Requirements:
* SharePoint

The license of this software is Free Trial Software, the price is $249.00, you can free download and get a free trial.