Concepts: Information Architecture, Knowledge Management, Portals, Enterprise Search, Collaboration, Extranets, Intranets, Business Intelligence, Business Process Automation, ECM, Records Management, CRM, ERP, Mobile, Web
Approach: Project Management, Business Analysis, Strategy, Design, Development, Implementation
Technologies: Microsoft SharePoint, Office 365, Azure, SQL Server, Windows, HTML5, CSS, JavaScript, ASP.NET
Thursday, January 23, 2014
SharePoint 2013: How to Configure the PerformancePoint Service Application using PowerShell
Description
This post describes how to configure the SharePoint Server 2013 PerformancePoint Service Application using PowerShell.
Solution
1) Document the Naming Convention
Determine a naming convention for each of the Service Application components. Document the naming convention.
Application Pool: SvcApp_SPServiceApplicationPool_01
Application Pool Service Account: Domain\SvcAccount
Application: SvcApp_SPPerformancePointServiceApplication_01
2) Prepare the Application Pool / Service Account
Example: Subscription Settings Application Pool: SvcApp_SPServiceApplicationPool_01 Application Pool Service Account: Domain\SvcAccount
A) If you are using an existing application pool:
You do not need to create a Service Account nor an Application Pool. Note the names of each.
Verify Application Pool.
Get-SPServiceApplicationPool | Select Name
Get the existing Application Pool.
$SvcAppPool = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_01"
B) If you are creating a new application pool:
Determine which service account you will use to run the application pool that will be assigned to the. If you need to, create and register a service account to run the Subscription Settings Service Application.
Create the Service Application Pool and register it to the Service Account.
$SvcAppPool = New-SPServiceApplicationPool -Name "SvcApp_SPServiceApplicationPool_01"$AppPool = New-SPServiceApplicationPool -Account (Get-SPManagedAccount Domain\SvcAccount)
Verify Application Pool.
Get-SPServiceApplicationPool | Select Name
Get the existing Application Pool.
$SvcAppPool = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_01"
3) Open the SharePoint 2013 Management Shell as Administrator.
4) Create the Service Application and assign it to the Application Pool.
$SvcApp = New-SPPerformancePointServiceApplication –ApplicationPool $SvcAppPool -Name "SvcApp_SPPerformancePointServiceApplication_01" -DatabaseName "SvcApp_SPPerformancePointServiceApplication_01_DB_01" -DatabaseServer "SQL Alias Name"
Verify Service Application.
Get-SPServiceApplication | Select Name
5) Create the Service Application Proxy and assign it to the Service Application.
$SvcAppProxy = New-SPPerformancePointServiceApplicationProxy -Name "SvcApp_SPPerformancePointServiceApplication_01_Proxy_01" -ServiceApplication $SvcApp
Verify Service Application Proxy
Get-SPServiceApplicationProxy | Select Name
Notes
This Service Application does have a database associated with it.
References
Microsoft TechNet (2012). New-SPPerformancePointServiceApplication. Retrieved January 23, 2014 from http://technet.microsoft.com/en-us/library/ff608122.aspx.
Microsoft TechNet (2012). New-SPPerformancePointServiceApplicationProxy. Retrieved January 23, 2014 from http://technet.microsoft.com/en-us/library/ff608135.aspx.
Microsoft TechNet (2012). Service application cmdlets in SharePoint 2013. Retrieved January 22, 2014 from http://technet.microsoft.com/en-us/library/ee906561.aspx.
Microsoft TechNet (2012). SharePoint 2013 - Service Applications. Retrieved January 22, 2014 from http://social.technet.microsoft.com/wiki/contents/articles/12512.sharepoint-2013-service-applications.aspx.
Nice blog and very much informative
ReplyDeletesharepoint developer training