UltimateForms LOB Item Link Field

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 UltimateForms, 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 Item Link

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

Blog

Features

Feature Image Our Product SharePoint Native
Connection info stored in column definition   Included  
External item selection by lookup or manual entry   Included  
Filter external items according to current item's column values caption   Included  
Snapshot of data at time of entry caption   Included  
Support for Web Services, MS SQL, Oracle native driver, OLE DB and ODBC caption   Included  
Split external fields into multiple SharePoint columns caption   Included  
Single and multiple items links caption   Included  
Search of keys based on first characters caption   Included  
Friendly name mapping   Included  
Localized into English, French, Spanish and German caption   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.
Some apps can be used both on Office 365 and on premises, but most will not work on premises. App support must be enabled on your on-premises farm. You can install app both from the Office Store and by downloading the .app file from our website, in some cases the latter option provides more functionality, but also requires your consent to a higher level of permissions.
Want to get notified when new versions come out? Subscribe to our RSS feed now!
Version Release Date Changes
1.10.9 12-Jun-2018
  • Fixed: support for Item Copier field
1.10.8 07-May-2018
  • Added: enhanced support for parsing REST imports
  • Fixed: handling required columns
1.10.7 14-Sep-2017
  • Added: autocomplete search will now fetch results that contain typed in value
  • Fixed: support for a key column with a space in its name
  • Fixed: unresponsiveness in edit form of previously added values, after key column is changed
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
$12.46
per server per month, includes support
No Credit Card. No Obligation.

We offer special discounts to non-profits, educational or government organizations

$299
Perpetual license for one server, including first year of support
$49
Developer License per server
$69
Annual Support Renewal per server

Copyright © 2018 - Infowise Solutions Ltd

Request a Live Demo

Book an appointment for a one-on-one with an ULTIMATEforms expert trainer.

Test drive the awesome power of ULTIMATEforms

Learn how to quickly and easily turn time-consuming business processes into automated, efficient workflows.

Have a strong start

Only thirty minutes of well-coached time can translate into great future savings in time and money. So, sit back and enjoy the ride.

It's Free

Learn how to address business process pain points immediately. Save time and money.

Eastern time zone (GMT-5)