Transcript Microsoft SQL Azure Hive Teradata IBM DB2 Oracle Excel PowerPivot Power View GeoFlow Data Explorer SQL Server SQL Server Analysis Services Reporting Services Text Files Microsoft SQL Server Reporting Services Excel Files Data Feeds Others (OLE DB/ODBC) SharePoint Excel Services PowerPivot Power View PerformancePoint Visio Services.

Microsoft
SQL Azure
Hive
Teradata
IBM DB2
Oracle
Excel
PowerPivot
Power View
GeoFlow
Data Explorer
SQL Server
SQL Server
Analysis Services
Reporting Services
Text Files
Microsoft
SQL Server
Reporting
Services
Excel
Files
Data
Feeds
Others
(OLE DB/ODBC)
SharePoint
Excel Services
PowerPivot
Power View
PerformancePoint
Visio Services
Browser Interactivity
Management
Dashboard
Power View
Workbooks as a Data
Source
All
PowerPivot
Features
Power View
Core BI
Features
Native ECS
Features
4
Deploy the PowerPivot for SharePoint 2013 Add-In
to provide additional capabilities, such as full access to
workbooks as a data source, scheduled data refresh,
PowerPivot Gallery, and IT Management Dashboard.
3
Install Reporting Services add-in and
Reporting Services in SharePoint-integrated mode
to unlock stunning browser-based data exploration,
visualization, and presentation experiences.
2
Install Analysis Services in SharePoint mode and
register the server in Excel Services
to enable the core PowerPivot functionality.
1
Deploy your SharePoint 2013 farms and
enable shared services, such as Excel Services and
PerformancePoint Services.
Analysis Services
PowerPivot for SharePoint 2013
Reporting Services Power View
PerformancePoint Services
Excel Services
Visio Services
SharePoint 2013 Enterprise
SQL Server Database Engine
Single Server
Reporting Services Power View
Analysis Services
SharePoint 2013 Enterprise
SQL Server Database Engine
Shared SQL Server
Separate SQL Server
Reporting Services
Power View
SharePoint 2013
Enterprise
Large Farm
Reporting Services Power View
SharePoint 2013 Enterprise
Reporting Services Power View
SharePoint 2013 Enterprise
Analysis Services
SQL Server Database
Engine
Analysis Services
Analysis Services
SQL Server Database
Reporting Services
Power View
SharePoint 2013
Enterprise
SQL Server Database
Large SharePoint 2013 Farm
Analysis Services
in SharePoint
Mode
1.
Clients
2.
Web Front-End Servers
Application Servers
SQL Server Databases
Config.
Database
Content
Databases
Service App.
Databases
3.
Install SQL Server 2012 SP1
PowerPivot for SharePoint on
an additional server.
Grant SharePoint farm and
service accounts Analysis
Services server admin rights
on the new server.
Register the new server in the
BI Servers configuration of
Excel Services
Front-End
Service Apps
Excel Calculation
Services (ECS)
Excel client
Remote
SP farms
Other
SSPM
PPS Web
Service
PPS Service App
RS add-in
RS Service App
PowerPivot
Web Service
1
MSOLAP
2
1
2
ADOMD.NET
Browser
EWA/EWS
Analysis
Services
ECS API
1
PowerPivot System
Service
2
1
ECS
API
Client
Data Model
2
ECS API
XML/A Client
Timer Job
Only Excel Services loads and unloads PowerPivot data models. All other applications, including PowerPivot,
must use Excel Services to load a data model before establishing a direct connection via TCP/IP. The steps
are transparent to applications using MSOLAP, ADOMD.NET, or AMO.
Only SQL Server Setup and spPowerPivot.msi install the SPClient component.
Individual provider packages available in the SQL Server Feature Pack do not include SPClient.
MSOLAP
ADOMD.NET
AMO
SPClient
ECS API
SPClient is a hidden
feature that will be
installed regardless of
the feature selection.
Excel Calculation
Services
Analysis Services in
SharePoint mode
Load
Data Model
XLSX
SharePoint Content
Database
Large SharePoint 2013 Farm
Install MSOLAP, ADOMD.NET, and AMO on
all SharePoint servers.
Install PowerPivot for SharePoint 2013 on
at least one server (preferably the server
hosting Central Administration)
Web Front-End Servers
Application Servers
SQL Server Databases
Config.
Database
Content
Databases
Service App.
Databases
Analysis Services in
SharePoint Mode
Client
Front-End
Service Apps
Analysis
Services
Client
Internet
Explorer
Business
App
Data Feed
Client
MSOLAP
ADOMD.NET
AMO
Internet
Explorer
Front-End
Service Apps
SharePoint Timer
Service
EWA/EWS
SharePoint Lists
Service
Timer Jobs:
Excel Calculation
Services (ECS)
Management
Dashboard
Usage Data
Import
Usage Data
Processing
BISM Link File
PowerPivot Web
Service
Analysis
Services
SSPM
PowerPivot System
Service
PowerPivot
UI
PowerPivot
Data Refresh
Data Model
PowerPivot Health
Statistics Collector
PowerPivot Mgmt
Dashboard Processing
PowerPivot Setup
Extension
Data Feed Export
PPivot App Database
SQL Server Databases
Run PowerPivot for
SharePoint 2013
Configuration
SP Timer Service
SP Timer Service
SP Timer Service
1 Deploy .wsp’s
to config db
3 Configure local service instances
and SharePoint Dependencies
2 Deploy .wsp’s to SP servers:
• Copy files
• Install features
• Add assemblies to GAC
The PowerPivot Cmdlets are in the
farm solution.
1.
2.
3.
Add-SPSolution –LiteralPath
“C:\Program Files\Microsoft
SQL
Server\110\Tools\PowerPivotToo
ls\SPAddinConfiguration\Resour
ces\PowerPivotFarmSolution.ws
p”
Install-SPSolution –Identity
PowerPivotFarmSolution.wsp –
GACDeployment –Force
Get-help *powerpivot*
PowerShell Scripts for PowerPivot
PowerPivot Config Tool – Script tab
http://msdn.microsoft.com/enus/library/hh213341.aspx
PowerPivot Reference for PowerShell
Activate PowerPivot Features
In the Site Collection, under Site Collection Features,
make sure the PowerPivot Integration Site Collection
Feature is set to Active.
Install PowerPivot Features
•
•
•
PowerPivot (Farm)
PowerPivotAdmin (Central Admin)
PowerPivotSite (Site Collections)
Deploy PowerPivotWebApplicationSolution.wsp
Note that PowerPivot for SharePoint only supports Web applications using Windows authentication.
Forms-based and SAML authentication are not supported.
Deploy PowerPivotFarmSolution.wsp and PowerPivotFarm14Solution.wsp
Deployed once at the farm level and automatically available on all SharePoint servers
SharePoint
Servers
Interactive Data
Refresh
Scheduled Data
Refresh
Analysis Services Server requires
appropriate data providers/client
libraries for the AS engine to
access the data sources.
Microsoft
SQL Azure
Text Files
Teradata
IBM DB2
Oracle
Microsoft
SQL Server
Reporting
Services
Others
(OLE DB/ODBC)
Data
Feeds
Excel
Files
SharePoint Timer Service
PowerPivot Data
Refresh Timer Job
Analysis Services Engine
XLSX
SharePoint
Content
Database
PowerPivot App
Database (Work Queue
and Refresh History)
SharePoint
Configuration
Database
RDBMS
Server
Usage data collection must be enabled for
SharePoint components to log usage data.
Client Libraries
PowerPivot Web Service
PowerPivot
Management
Dashboard
SharePoint
Usage
Database
Usage
Logs
PowerPivot
Service Application
Server Health
and Workbook
Activity
Workbooks
Excel
Calculation Services
PowerPivot
Management
Data Workbook
PowerPivot Health
Statistics Collector
Usage Data
Import
Usage Data
Processing
Mgmt Dashboard
Processing
SharePoint Timer
Service
PowerPivot Application Database
(Customizing the PowerPivot Management Dashboard: http://msdn.microsoft.com/en-us/library/ff718155(v=SQL.105).aspx)
SharePoint-Related
PowerPivot-Related
Resources
http://channel9.msdn.com/Events/TechEd
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn