On-Premise SharePoint Server

This section describes how to configure the On-Premise SharePoint Server.

As of Microsoft SharePoint Portal Server 2016, the WebFOCUS App Parts are packaged as a SharePoint Add-in (WfApp.app), which is located in the following directory of your WebFOCUS installation:

drive:\ibi\WebFOCUS82\utilities\ops\sharepoint-addin

where:

drive:

Is the drive letter corresponding to the location where WebFOCUS is installed.

In terms of security, ensure that the same security paradigm is used on both environments (WebFOCUS and SharePoint).

1. Add the domain user ID you intend to use for apps (Add-ins) as a Windows administrator.
2. Use Central Administration to ensure that the Application Management Service and User Profile Service Application are configured, by selecting Manage Service Applications under Application Management.
3. Verify that your domain user ID has a user profile in Central Administration. If it does not, then create a new user profile for it by clicking the User Profile Service link under Manage Service Applications.
4. Under People, select Manage User Profiles, and search for the specific name.
5. Add the domain user ID to SQL Server as a login with the sysadmin role and User Mapping of db_owner, and Sharepoint_shell_access for the SharePoint_config database.
6. Open SharePoint Management Shell using the Run as Administrator option.
7. Load the PowerShell snap-ins for the session/script using the following command:

   Add-PSSnapin Microsoft.Sharepoint.Powershell

8. Add user(s) as spshell administrators using the following command:

   Add-SPShellAdmin -UserName domain\username

9. Set the Add-ins subdomain using the following command:

   Set-SPAppDomain "wfapp.ibi.com"

10. Set the account to run Add-ins using the following command:

    $account = New-SPManagedAccount

11. Set the account, app pool, and database settings using the following commands:

    a.	$account = Get-SPManagedAccount "domain\user"
    
    b.	$appPoolSubSvc = New-SPServiceApplicationPool -Name SettingsServiceAppPool –Account $account
    
    c.	$appPoolAppSvc = New-SPServiceApplicationPool -Name AppServiceAppPool -Account $account
    
    d.	$appSubSvc = New-SPSubscriptionSettingsServiceApplication -ApplicationPool $appPoolSubSvc -Name SettingsServiceApp -DatabaseName SettingsServiceDB 
    (Note: The user ID must be sysadmin or dbcreator for this command.)
    
    e.	$proxySubSvc = New-SPSubscriptionSettingsServiceApplicationProxy –ServiceApplication $appSubSvc
    
    f.	$appAppSvc = New-SPAppManagementServiceApplication -ApplicationPool $appPoolAppSvc -Name AppServiceApp -DatabaseName AppServiceDB
    
    g.	$proxyAppSvc = New-SPAppManagementServiceApplicationProxy -ServiceApplication $appAppSvc

12. Set the Add-in prefix using the following command:

    Set-SPAppSiteSubscriptionName -Name "add-in" -Confirm:$false

    The full app (Add-in) name will appear as shown in the following example:

    http://add-in-61844c031b3e0d.wfapp.ibi.com/sites/WFapp/

    Note: Providing the support for wfapp.ibi.com (or other) domain is the responsibility of the SharePoint administrator.

The SharePoint Server is now configured to support apps (Add-ins).