Integrating SharePoint with external database application
Vladi Gubler
Vladi Gubler
April 25, 2013 | Products


In this post I'm going to show you how easy it can be to integrate an external application (using any kind of database or even just web services) with SharePoint lists, linking, exporting and importing data to and from a non-SharePoint application.

My demo illustrates the following capabilities:

  • Link an external item to SharePoint - we'll be selecting a customer from an external database table and entering sales data for that customer in a SharePoint list
  • Exporting data to external DB item - we will then update the SQL table with the amount of the last sale
  • Importing data back into SharePoint - changes made to the SQL table are imported into a log list located in SharePoint

I'll be using a SharePoint Foundation site with two custom lists: Sales and Imported Sales. I'll be also using a table in an external MS SQL database called Clients (contains: ClientID (int), Client Name (nvarchar), Phone (nvarchar), Email (nvarchar), LastSale (currency), LastUpdate (datetime)).

Link External Item

We'll be using LOB Item Link Field, it looks more or less like a lookup column, but gets its data from an external source: MS SQL, Oracle, MySQL, web services and so on. We are adding a column of this type to our Sales list, we also add Amount (currency column). The settings for the LOB Item Link Field are as follows:

LOB Field

We are basically providing the connection string and selecting a table and its column. We also chose to place each column into a separate SharePoint column (the additional columns are generated automatically).

That's it, now when you go to register a new sale, we can select a client from the DB:


Once saved, the values go right into SharePoint's columns:


Export to External DB

Once the item is saved, it's going to update the DB item with the latest sale amount. We use Smart Action Pro to execute a stored procedure in the SQL database to update the table row. The stored procedure accept SharePoint column values as parameters:

Action settings

The actions runs automatically, whenever we add a new item to the Sales list. The stored procedure updates both the LastSale and LastUpdate columns:

Update Clients SET LastSale=@LastSale, LastUpdate=GETDATE() WHERE ClientID=@ClientID

Our sale amount is now registered in the SQL table.


Import into SharePoint

Our next goal is import the latest changes to the Clients table into Imported Sales list in SharePoint, demonstrating the ability to automatically import data. We'll be using Smart Import Pro, our component that can import emails, DB or web service items into SharePoint. A great advantages of this product compared to the alternatives (such as email-enabled lists in SharePoint) are that it can import into any type of list or document library and it can not only create new items, but also update existing items, based on the new data.

We'll set up an import profile. It will run every 15 minutes and import latest changes in our Clients table into Imported Sales list. That's why we needed LastUpdate column in our SQL table, we'll be using it to figure out which items have been updated.


We've completed the whole cycle of updates now, we have information coming to SharePoints, updates pushed back into SQL DB and come back to SharePoint, without any custom development!


Add your comment

Comments are not designed to replace support calls. If you have a specific issue with one of our products, please send an email to to open a support ticket.


Build powerful business applications in SharePoint using only your browser.
100% No-Code Solution

It's never been easier, to create, innovate and share, all you need is your web browser!


Address business process pain points immediately. Save time and money.

Fantastic Support Team

Facing difficulties installing the application? Contact our fantastic support team.

Related Topics

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!


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


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


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.


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.