SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SharePoint 2013 External Data Connections

SharePoint 2013 External Data Connections

SharePoint 2013 External Data Connections  are part of the Business Connectivity Services (BCS)  that can be leveraged to perform CRUD operations on data stored outside of SharePoint such as SQL Server or other databases.  This means that if you have users that need to insert, update or perhaps delete information stored in a database.  You can leverage the SharePoint platform to be the user interface without having to create another one off application that requires initial costs and ongoing support.

For instance, if you need to store business rules in reference tables and would like to have users update the records instead of sending a helpdesk ticket or creating a process to upload a spreadsheet.  You can leverage the power of the SharePoint 2013 External Data Connections.  Additional benefits include:

  • Provide Reusable business content such as master data.
  • Familiar look and feel when updating information, no custom application to learn
  • Apply security to allow access and updates to the data
  • Search from SharePoint on data stored externally allowing users a single point to look for information

The diagram below shows how the BCS and External Data Conections interact within the SharePoint Framework


The post SharePoint 2013 External Data Connections appeared first on Derek Wilson - Blog.

Business Intelligence and Enterprise Architecture

Derek Wilson delivers tactical and strategic Business Intelligence and Enterprise Architecture solutions. His primary focus in on Microsoft SQL Server technologies and aligning business problems to technology solutions. He architects BI solutions leveraging SQL Server, SharePoint and any other technologies that help his clients achieve better data driven decisions. By leveraging the information learned while collecting requirements for BI projects, he helps align business processes to technology helping further organizations Enterprise Architecture. He is an author, trainer, blogger and has been using SQL Server since version 6.5.


Leave a comment on the original post [derekewilson.com, opens in a new window]

Loading comments...