Infowise Ultimate Forms: External data lookup

Forms

Actions

Alerts

Associated Items

Connected Lookup

Import

Signature

External Data Lookup

Calendar

Rollups

Charts

List Search

Filters

Item IDs

Color Choice

User Property

Document Link

Voting

Stay in the know

Get helpful videos

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 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

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.

Features

	UltimateForms	SharePoint Native
Connection info stored in column definition	✓
External item selection by lookup or manual entry	✓
Filter external items according to current item's column values	✓
Snapshot of data at time of entry	✓
Support for Web Services, MS SQL, Oracle native driver, OLE DB and ODBC	✓
Split external fields into multiple SharePoint columns	✓
Single and multiple items links	✓
Search of keys based on first characters	✓
Friendly name mapping	✓
Localized into English, French, Spanish and German	✓	✓

Screenshots

On-premises Versions

Want to get notified when new versions come out? Subscribe to our RSS feed now!
SharePoint Online version is generally kept up to date automatically.

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)