Import models in Duet Enterprise for SharePoint and SAP Server 2.0
Applies to: Duet Enterprise for Microsoft SharePoint and SAP Server 2.0
Summary: Learn how to import BDC models in a deployment of Duet Enterprise 2.0 in a SharePoint Server 2013 environment.
Before importing any Business Data Connectivity (BDC) models, you will need the LsiUrl and MetadataUrl from the SAP administrator for each of the following BDC models to use when DuetConfig.exe is run and the models are imported. You must configure a Duet publishing URL and account. You must grant users permissions on the BDC models that you import before they can access the SAP data that those models represent.
In this article:
Import BDC models and set metadata store permissions
Import the Reporting model
Import the Workflow model
Import and configure the RoleSync model
Configure the publishing URL and account
Set Metadata Store permissions
Import BDC models and set Metadata Store permissions
The following models are provided with Duet Enterprise 2.0 and are installed in this default directory path: C:\Program Files\Duet Enterprise\2.0\BDC Models. This directory contains other models that are installed by default and are not used as part of this deployment.
Workflow
UserSubscription
Reporting
RoleSync
Each of these models must be imported individually because the procedures to import them are not the same. Use the following procedures to import each of the Reporting, Workflow, and RoleSync BDC models.
Import the Reporting model
The Reporting BDC model is imported into Duet Enterprise 2.0 by using the DuetConfig.exe -importbdc command. It requires both an LsiUrl and MetadataUrl to import successfully. Use the following procedure to import the Reporting BDC model.
To import the Reporting model
Verify that you have the following administrative credentials: Windows Administrators group on the front-end web server that is running SharePoint Server 2013 to complete this procedure. You must also be a member of the Farm Administrators group on the SharePoint Server farm on which you are installing Duet Enterprise 2.0.
As administrator, open the Windows command prompt.
At the command prompt, type the default path of the DuetConfig.exe file: cd /d C:\Program Files\Duet Enterprise\2.0.
At the command prompt, type the following command, and then press ENTER:
Duetconfig.exe -importbdc -featurename Reporting -BdcServiceApplication <BDC Service Application> -lsiurl <LsiUrl> -metadataUrl <MetadataUrl>
Where:
<BDC Service Application> equals the BDC Service application name.
<LsiUrl> is the LsiUrl URL that is provided to you by the SAP administrator that matches the BDC model that you want to import.
(optional) <MetadataUrl> is the metadata URL that is provided to you by the SAP administrator that matches the BDC model that you want to import.
When complete, at the command prompt, you receive the following message: The specified BDC model was successfully imported.
Import the Workflow model
The Workflow BDC model is imported into Duet Enterprise 2.0 by using the DuetConfig.exe -importbdc command. It requires both an LsiUrl and MetadataUrl to import successfully. It also requires an additional parameter named UserSubLsiUrl. This UserSubLsiUrl is used for the UserSubscription model, an additional model only imported together with the workflow model. The UserSubscription model allows users to subscribe to workflow tasks on individual Duet Enterprise 2.0 workflow sites. Use the following procedure to import the Workflow and UserSubscription BDC models.
To import the Workflow model
Verify that you have the following administrative credentials: Windows Administrators group on the front-end web server that is running SharePoint Server 2013 to complete this procedure. You must also be a member of the Farm Administrators group on the SharePoint Server farm on which you are installing Duet Enterprise 2.0.
As administrator, open the Windows command prompt.
At the command prompt, type the default path of the DuetConfig.exe file: cd /d C:\Program Files\Duet Enterprise\2.0.
At the command prompt, type the following command, and then press ENTER:
Duetconfig.exe -importbdc -featurename Workflow -BdcServiceApplication <BDC Service Application> -lsiurl <LsiUrl> -usersubLsiurl <UserSubLsiUrl> -metadataUrl <MetadataUrl>
Where:
<BDC Service Application> equals the BDC Service application name.
<LsiUrl> is the LsiUrl URL that is provided to you by the SAP administrator that matches the BDC model that you want to import.
<UserSubLsiUrl> is the UserSubLsiUrl URL that is provided to you by the SAP administrator.
<MetadataUrl> is the metadata URL that is provided to you by the SAP administrator that matches the BDC model that you want to import. The URL is appended to the end of the MetadataUrl provided by the SAP administrator.
When complete, at the command prompt, you receive the following message: The specified BDC model was successfully imported.
Import and configure the RoleSync model
The RoleSync BDC model is imported into Duet Enterprise 2.0 by using the DuetConfig.exe -importbdc command. It requires both an LsiUrl and MetadataUrl to import successfully. Use the following procedure to import the RoleSync BDC model. After the model is imported, it must be configured to start the required timer jobs.
To import the RoleSync model
Verify that you have the following administrative credentials: Windows Administrators group on the front-end web server that is running SharePoint Server 2013 to complete this procedure. You must also be a member of the Farm Administrators group on the SharePoint Server farm on which you are installing Duet Enterprise 2.0.
As administrator, open the Windows command prompt.
At the command prompt, type the default path of the DuetConfig.exe file: cd /d C:\Program Files\Duet Enterprise\2.0.
At the command prompt, type the following command, and then press ENTER:
Duetconfig.exe -importbdc -featurename RoleSync -BdcServiceApplication <BDC Service Application> -lsiurl <LsiUrl> -metadataUrl <MetadataUrl>
Where:
<BDC Service Application> equals the BDC Service application name.
<LsiUrl> is the LsiUrl URL that is provided to you by the SAP administrator that matches the BDC model that you want to import.
<MetadataUrl> is the metadata URL that is provided to you by the SAP administrator that matches the BDC model that you want to import. The URL is appended to the end of the MetadataUrl provided by the SAP administrator.
When complete, at the command prompt, you receive the following message: The specified BDC model was successfully imported.
To configure RoleSync
Verify that you have the following administrative credentials: Windows Administrators group on the front-end web server that is running SharePoint Server 2013 to complete this procedure. You must also be a member of the Farm Administrators group on the SharePoint Server farm on which you are installing Duet Enterprise 2.0.
As administrator, open the Windows command prompt.
At the command prompt, type the default path of the DuetConfig.exe file: cd /d C:\Program Files\Duet Enterprise\2.0.
At the command prompt, type the following command, and then press ENTER:
DuetConfig.exe -ConfigureRoleSync -UserProfileServiceApplicationName <"User Profile Service Application Name">
Where <"User Profile Service Application Name"> equals the name of the User Profile service application.
At the command prompt, you receive the following message: The specified Profile Synchronization Job was successfully configured.
The timer job for RoleSync is now created.
Configure the publishing URL and account
Use this procedure to configure the properties required to enable the SAP system to publish reports and workflows to a specific web application that you want to enable for use with Duet Enterprise 2.0. To complete this procedure, you must know the following:
The URL of the web application that you are configuring.
The port number of the extended port on the web application that you are configuring.
The account that the SAP system will use to publish reports and workflows to the web application that you are configuring.
To configure the publishing URL and account
Verify that you have the following administrative credentials: Windows Administrators group on the front-end web server that is running SharePoint Server 2013 to complete this procedure. You must also be a member of the Farm Administrators group on the SharePoint Server farm on which you are configuring Duet Enterprise 2.0.
As administrator, open the Windows command prompt.
At the command prompt, type the default path of the DuetConfig.exe file: cd /d C:\Program Files\Duet Enterprise\2.0.
At the command prompt, type the following command, and then press ENTER:
duetconfig.exe -configurewebapp <Web Application URL> -PublishingUrl <PublishingUrl> -PublisherAccount <domain\username>
Where:
<Web Application URL> equals the http:// URL of the new web applications that you created.
<PublishingUrl> equals the https://servername:portnumber of the extended web application that the SharePointSSL.cer certificate is bound to.
Tip
Because you extended this web application using a fully qualified domain (FQDN) name, you will need use the FQDN form of the URL here.
<domain\username> equals the domain and user name of the DuetPublisher account.
Important
This account cannot be the same as the SharePoint Farm account or the Managed account assigned to the application pool of the web application using by Duet Enterprise.
At the command prompt, you receive the following message: Successfully configured Duet functionality on the Web Application https://WebApplicaitonURL.
Give the DuetPublisher account to the SAP administrator
You must give the name of the account you are using as the DuetPublisher account to the SAP administrator. We recommend that you use an account in AD DS named DuetPublisher. The SAP administrator will map this user account to one or more SAP roles in SAP NetWeaver Gateway that have access to SAP reports.
Set Metadata Store permissions
Before you can verify the successful configuration and connection between the SharePoint and SAP systems, you must configure Metadata Store permissions.
To set Metadata Store permissions
Verify that you have the following administrative credentials: Windows Administrators group on the front-end web server that is running SharePoint Server 2013 to complete this procedure. You must also be a member of the Farm Administrators group on the SharePoint Server farm on which you are installing Duet Enterprise 2.0.
On the SharePoint Central Administration website, click Application Management.
In the Service Applications section, click Manage service applications.
On the Service applications page, click the link for the Business Data Connectivity Service Application that you are using for Duet Enterprise. By default, the name of the link is BDC Service but this name can be changed by an administrator.
On the BDC models page, in the View section, in the External Content Types drop-down list, select BDC Models. The following four imported models are displayed:
OBA.Server.Reporting
OBA.Server.RoleSync
OBA.Server.UserSubscription
OBA.Server.Workflow
On the BDC Models page, use Set Object Permissions and Set Metadata Store Permissions to set both object and Metadata Store permissions for all models. All users who access these models will need individual permissions to access content from these BDC models.
Set Object Permissions: Execute, Selectable in Client, Edit, and Set Permissions. (For the publisher account only all permissions are required. For all other accounts, you can choose one or more permissions.)
Set Metadata Store Permissions: Execute, Selectable in Client, Edit, and Set Permissions. Make sure to select the Propagate permissions to all BDC models, External Systems and External Content Types in the BDC Metadata Store. Doing so will overwrite existing permissions. (For the publisher account, only all permissions are required. For all other accounts, you can choose one or more permissions).
You might have to run IIS reset to allow these permissions to take effect immediately.
When both the object and Metadata Store permissions are set, you can run Duet Enterprise Configuration Check and validate that all required communication and security checks are working and functional.
See also
Install and configure Duet Enterprise for SharePoint and SAP Server 2.0