SharePoint components - business processes without development, InfoPath, SharePoint Designer or workflows. SharePoint Services, SharePoint Foundation & SharePoint Server 2010-2016.

Ultimate Forms LOB Item Link Field

Easy-to-use lookup into a database or web service-driven line-of-business application to be linked to any document or list item. No need to define connections using BDC or External List settings, all is done using just your browser.
LOB Item Link Field, a component of Ultimate Forms, links items from line-of-business application to SharePoint items.
  • WSS/Foundation support, MOSS/Server not required
  • Natively supports all kinds of database connections - MS SQL, Oracle, OLE DB and ODBC
  • Supports SOAP-based web services
  • Show multiple fields from the LOB system
  • Save external item fields in one SharePoint field or split across multiple fields
  • Filter database items according to column values of current item
  • Save external item data within the SharePoint item as appears at the time of retrieval
  • Easier to set up than external lists or BDC
  • Localized into English, French, Spanish and German

LOB field fetches your data directly from an external data source, such as database or web service. 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.

  • Link you proposal or reports to the actual operational data.
  • Create a snapshot of data in your LOB system for regulatory purposes
  • Maintain just one copy of your data
Feature Image Our Product SharePoint Native
Connection info stored in column definition caption  Included  
External item selection by lookup or manual entry caption  Included  
Filter external items according to current item's column values   Included  
Snapshot of data at time of entry   Included  
Support for Web Services, MS SQL, Oracle native driver, OLE DB and ODBC   Included  
Split external fields into multiple SharePoint columns   Included  
Single and multiple items links   Included  
Search of keys based on first characters   Included  
Friendly name mapping caption  Included  
Localized into English, French, Spanish and German   Included  
Note: unless specifically stated otherwise, all products require only SharePoint Foundation 4.0/5.0. Microsoft SharePoint Server 2010-2016 is supported, but not required. Except for SharePoint 2013-2016 apps, all of our products must be installed as farm solutions.
Want to get notified when new versions come out? Subscribe to our RSS feed now!
Version Release Date Changes
1.10.6 30-May-2017
  • Fixed: backward-compatibility for field settings
1.10.5 22-Feb-2017
  • Fixed: width issue when displayed in Associated items grid entry row
1.10.4 20-Feb-2017
  • Fixed: filtering autocomplete results according to typed text, when Preload is on
1.10.3 30-Jan-2017
  • Fixed: response times in working against large data sources
1.10.2 29-Dec-2016
  • Added: additional override for select2 css style
  • Added: internal field overrides to provide support for fetching field value as Text and as Html
  • Fixed: issue in saving changes to additional fields
1.10.1 10-Nov-2016
  • Added: paging mechanism for no-preload mode
1.10.0 10-May-2016
  • Added: Hide get button option
  • Added: new autocomplete control
1.9.7 25-Mar-2016
  • Added: schema name for table selection dropdowns, except for Oracle provider
  • Added: MDS compatibility
  • Fixed: filtering several columns by another column
  • Important: SharePoint 2007 is not supported as of this version
Most Recent Newer  
Want to try before you buy? Just download the 30-day full-featured trial version! You can even turn it into a registered version by simply entering a license key.
License Type Price Buy Now
Server License with Annual Support 299 US$
Server License 249 US$
Developer License 49 US$
Annual Support Renewal 69 US$
On premises
  • Server License with Annual Support - entitles you to the right of installing the product on one front-end server, including the right to contact us on non-bug related issues within the period of one year, you may also upgrade to any future major/minor version.
  • Server License - entitles you to the right of installing the product on one front-end server. Front-end server is one responding to user requests (web server). This license is not time-limited, but you are not entitled to new major/minor versions, except for explicit bug fixes within the first 12 months.
  • Developer License - entitles you to the right of installing the product on one front-end server in non-production environment. Note that you must order at least one full server license to have the right to order a developer license.
  • Annual Support Renewal - extends the annual support for another year.
Office 365
  • Monthly Site Subscription - grants to up to 1000 users the right of using the product on a single SharePoint site, does not include technical support.
  • Monthly Site Collection Subscription - grants to up to 1000 users the right of using the product on any site of a single site collection, does not include technical support.
  • Monthly Tenant Subscription - grants to up to 1000 users the right of using the product on any site of a single tenant, including technical support.
  • Monthly Site Subscription for Small Business - grants to up to 100 users the right of using the product on a single SharePoint site, does not include technical support.
  • Monthly Site Collection Subscription for Small Business - grants to up to 100 users the right of using the product on any site of a single site collection, does not include technical support.
  • Monthly Tenant Subscription for Small Business - grants to up to 100 users the right of using the product on any site of a single tenant, does not include technical support.

Every server running Windows SharePoint Services Web Application requires a license, regardless whether or not it is accessed by users. Free licenses for application servers will be provided upon request.