The SQL & SharePoint Add-On for SharePoint 2010 and SharePoint 2013

Enrich data in SharePoint Lists or SQL Server whenever Items or Documents are added, updated or deleted with a configurable EventReceiver.

This Add-On enables you to match SQL Server Data and SharePoint List Data whenever Events occur on SharePoint.
Enrich data in SharePoint Lists with data picked from SQL Server or write to SQL Server whenever Items or Documents are added, updated or deleted. Integrate SharePoint with your SQL Server databases smoothly. What it does:
  • Runs Select, Insert, Update, and Delete commands and stored procedures when Item or Document Events occur in SharePoint.
  • Maintains data in SQL Server and SharePoint simultainously.
  • Allows both, synchronous and asynchronous Receiver Actions
  • It's free!
Did you ever wish to match data in SQL Server and SharePoint, update SQL Server data when SharePoint data changes or enrich SharePoint metadata with values from SQL Server without Business Data Connectivity Services?

Latest Downloads, free License Keys, Support Forum, ...

Visit the product site to obtain a free key and download the latest version including latest fixes on
http://www.sapiens.at/en/products/sharepoint-and-sql-server/pages/default.aspx. (Click on the free download button!)

Support-Forum: http://www.sapiens.at/answers

Visit us on http://www.sapiens.at and provide your Feedback!

​Installation & Configuration

1. Download the setup (use the free download link above) and onbtain a free key.

2. Extract the setup files to a local folder on your SharePoint server.

3. Browse the setup folder (SP2013 for SharePoint 2013, SP2010 for SharePoint 2010) and run Setup as Administrator.

4. Enter the key when required and let setup install and deploy the solution.

5. In Site setting, Manage Site Features activate the Feature
sql-and-sharepoint-00-activate-feature.png

6. Browse your list, go to list settings and click on the content type you want to configure. (It might be necessary to enable management of content types for this list in list settings/advance settings first.)

7. Click on the SQL Server Matching link in content type's settings page.
sql-and-sharepoint-01-contenttype-settings.png

8. Enable the Receivers you want to perform SQL Server actions:
sql-and-sharepoint-02-available-receivers.png

9. Configure each Receiver, get inspired by the following example:
sql-and-sharepoint-03-configure-itema-dded.png

10. Finally run "Update all Items" if items already exist in the list.
sql-and-sharepoint-04-update-all-items.png

11. Trouble Shooting your SQL Statements:

All Errors are logged in SharePoint Trace logs. Use the ULS viewer to find them. ULS messages start with 'SQLMatch'!

Last edited May 15, 2013 at 2:54 PM by ma7159159, version 5