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

  1. 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.

  2. As administrator, open the Windows command prompt.

  3. At the command prompt, type the default path of the DuetConfig.exe file: cd /d C:\Program Files\Duet Enterprise\2.0.

  4. 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.

  5. 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

  1. 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.

  2. As administrator, open the Windows command prompt.

  3. At the command prompt, type the default path of the DuetConfig.exe file: cd /d C:\Program Files\Duet Enterprise\2.0.

  4. 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.

  5. 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

  1. 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.

  2. As administrator, open the Windows command prompt.

  3. At the command prompt, type the default path of the DuetConfig.exe file: cd /d C:\Program Files\Duet Enterprise\2.0.

  4. 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.

  5. When complete, at the command prompt, you receive the following message: The specified BDC model was successfully imported.

To configure RoleSync

  1. 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.

  2. As administrator, open the Windows command prompt.

  3. At the command prompt, type the default path of the DuetConfig.exe file: cd /d C:\Program Files\Duet Enterprise\2.0.

  4. 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.

  5. At the command prompt, you receive the following message: The specified Profile Synchronization Job was successfully configured.

  6. 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

  1. 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.

  2. As administrator, open the Windows command prompt.

  3. At the command prompt, type the default path of the DuetConfig.exe file: cd /d C:\Program Files\Duet Enterprise\2.0.

  4. 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.

  5. 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

  1. 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.

  2. On the SharePoint Central Administration website, click Application Management.

  3. In the Service Applications section, click Manage service applications.

  4. 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.

  5. 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

  6. 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).

  7. You might have to run IIS reset to allow these permissions to take effect immediately.

  8. 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