LOB Item Link Field

Turning to a custom field such as LOB Link Item Field is something you may want to do if you are planning to look up, then link items from your line-of-business programs to SharePoint.

It is worth pointing out that you also have the possibility of creating a snapshot that encapsulates all the external data and integrating it into your item.

First and foremost, you need to indicate the data source connection, with options such as web service URL and database connection string being put at your disposal.

Another notable aspect regarding LOB Link Item Field is that it is capable of handling any database that supports Oracle Native, MS-SQL native, OLE DB, or ODBC driver, which gives you considerable flexibility since you should be covered as long as the database or web service you are relying on complies with the SOAP standard.

The next step you need to take is select a view, table, or operation, then begin mapping your fields. If you deem that necessary, coming up with new names for said fields is possible.

You may also want to know that, in case you plan on saving external item fields, you can decide whether you target one single SharePoint field or prefer to divide the content across multiple destinations. What’s more, filters can be applied to your database items, all with minimal effort on your side.