WEBINAR August 2012: Integrating SharePoint - Abel Solutions

34 Pages·2012·3.29 MB·English

by  Erik Wolf;

• Business Connectivity Services overview
• Creating External Content Types and External Lists to
interact with external data from within the SharePoint
2010 environment
• SharePoint 2010 Business Intelligence Center overview
• Creating rich, interactive dashboards using
PerformancePoint Services and SharePoint 2010 Business
Intelligence Center
Microsoft Business Connectivity Services in
Microsoft SharePoint Server 2010 enable
SharePoint deployments to connect to and
interact with data from external systems.
The types of external data to which BCS can
connect include:
• SQL Server Databases
• SAP Applications
• Web Services – including Windows
Communication Foundation (WCF) Web
Services
• SharePoint based web sites
• Third party applications
An external content type is an XML file
that defines an object, such as a SQL
Server table, that can be used in a
business application.
The definition can include the following
information:
• The fields of data that are contained in the
object
• The methods to create, read, update, query,
or delete that object
• Actions that users can take on the object
• Information that supports connecting to the
external data source that provides the
object’s data
External content types are generally
added to the Business Data Connectivity
service using either of the following:

• Microsoft SharePoint Designer 2010
• Microsoft Visual Studio 2010
• BCS authentication is handled via the
Secure Store Service.
• The Secure Store Service provides
authentication for the External Content
Type to access the external data
sources.
• External Content Type Permissions
specify who can access the External
Content Type