UltimateForms: External data lookup

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.
UltimateForms: External data lookup column (formerly LOB Item Link), a component of UltimateForms, links items from line-of-business application to SharePoint items.
  • Natively supports all kinds of database connections - MS SQL, Oracle, OLE DB and ODBC
  • Supports SOAP-based and REST-based web services
  • Supports data connections configured in UltimateForms
  • Show multiple fields from the external system
  • Save external item fields in one column or split across multiple columns
  • Filter external 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

External data lookup column 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

Features

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 2016 and up. Except for SharePoint Online 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.12.1 30-Nov-2023
  • Installer improvements: longer timeout period and adjustments to services restarting
1.12.0 05-Oct-2023
  • Renamed to External data lookup
  • Important: SharePoint 2013 is not supported starting this version of the product!
  • Fixed: Connection error when modifying field data source settings
1.11.4 20-Feb-2023
  • Added: sanitizing connection details in field settings
  • Installer got a new logo and a new file naming convention
1.11.3 29-Aug-2022
  • Fixed: Clearing control value in Associated item grid entry mode
  • Upgraded to Microsoft .Net Framework 4.8
1.11.2 01-Mar-2022
  • Added: In/NotIn filtering operators
1.11.1 09-Feb-2020
  • Added: modern experience views in SharePoint 2019
1.11.0 25-Aug-2019
  • Important: SharePoint 2010 is not supported starting this version of the product!
  • Added: option to clear single value in autocomplete mode
  • Fixed: autocomplete compatibility with Connected Field
1.10.12 26-Feb-2019
  • Fixed: keeping column value in edit form, after data source was deleted (only with Get button)
Although this feature can be purchased and installed separately, we highly recommend always installing the complete UltimateForms suite. It will ensure you are not limited in any way when implementing your business solutions and achieve the best possible result.
$13.08
per server per month, includes support
or
$314
Perpetual license for one server, including first year of support
      No Credit Card. No Obligation.
$51
Developer License per server
$72
Annual Support Renewal per server
We offer special discounts to non-profits, educational or government organizations

What is right for you?

Online Trial

Not ready to install yet? Create a trial site in our environment
  • Full control of the site and its settings
  • Optionally pre-install one of our solution templates
  • Site provisioned instantly
  • Automatically removed after 30 days
  • Available to everyone!

Error!

There was an error processing your request.
Please contact us for further details.

Installation

Install in your own environment, on Microsoft 365 and on premises
  • Start working with real users and data
  • Install online or on premises
  • Register for 30 day trial
  • Seemlessly convert to paid license
  • Requires administrator permissions

Success!

Download link has been emailed to .
If you do not receive it within 5 minutes, please check your spam.
The link is valid for 72 hours.
If you are having problems, please contact us.

Error!

There was an error processing your request.
Please contact us for further details.
Technical details:

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.