Import BDC models (Duet Enterprise)

Applies to: Duet Enterprise for Microsoft SharePoint and SAP

BDC models are provided for all of the solutions that are provided with Duet Enterprise for Microsoft SharePoint and SAP. Although BDC Models are imported during deployment, you might want to import models at a later time for the following reasons:

• The SAP administrator has updated one or more models.

• Some models that you want to use were not imported during deployment.

• A model has been corrupted or deleted.

You can import each model separately or import them all at once. There is no performance or security related reason not to import all models at once. However, if you need to import only a particular model, it would be faster to import just the one instead of all of them.

In this article:

• Before you begin

• Decompress the file that contains the models

• Verify the service application name of the Business Data Connectivity service

• Import all models

• Import a specific model

Before you begin

You will need the following information to import the models.

• Location of the uncompressed model files.

  If you are importing models again because the models have been updated by an SAP administrator, you will need to complete the Unzip the file that contains the models procedure first. This compressed file is provided by the SAP administrator. Otherwise, if you are importing models for another reason, you can import the models from the location to which the model files were previously uncompressed.

• List of users to whom you want to grant the execute permissions on the models.

  Alternatively, you can grant this permission to all authenticated users.

• User name and password for each user account to which you want to grant all permissions on the models.

• Contact email address that you want SAP administrators to use to report an issue that is related to the SharePoint environment.

• Service application name of the Business Data Connectivity service to which you want to install the models. By default, this name is “Business Data Connectivity Service”. For more information, see Verify the service application name of the Business Data Connectivity service.

Decompress the file that contains the models

The models that are configured by the SAP administrator will be in the form of a compressed (.zip) file. If you are importing models because they were updated by the SAP administrator, you must decompress this file before you can import the models.

Note the location of the decompressed BDC model files. You will need this location when importing one or more models.

Verify the service application name of the Business Data Connectivity service

By default, the name of the Business Data Connectivity service is “Business Data Connectivity Service”. However, an administrator can change this name or an administrator might create a separate Business Data Connectivity service for use with Duet Enterprise.

To verify the service application name of the Business Data Connectivity service

1. In Central Administration, on the Quick Launch, click Application Management.

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

3. In the Type column, click the Business Data Connectivity service application that you want to use.

4. In the Operations group of the Ribbon, click Properties. The name of the Business Data Connectivity service application is listed in the Name section

Import all models

To Import all models

1. Log on to any front-end Web server or application server in the SharePoint Server farm.

   Tip

   Although the models can be installed by using any front-end Web server or application server in the SharePoint Server farm, we recommend that you use the same computer to install all models.

2. Open a Command Prompt window as a farm administrator and at the prompt go to the “<SystemDrive>:\Program Files\Duet Enterprise\1.0” folder.

3. At the prompt, type DuetConfig /importbdc <UnzippedModelFileLocation>\models.xml” /AddUsers “<EndUsers>” /UserName <WSDLaccount> /Password <WSDLaccountPassword> /Email <EmailAcct> /BDCServiceApplication <BDC Service Application Name> and then press Enter.

   Where:

   • <UnzippedModelFileLocation> is the location on which the decompressed models are stored. For example, d:\UnzippedModelFiles or \\contoso\UnzippedModelFiles.

   • <EndUsers> is a comma-separated list of Windows Active Directory Domain Services (AD DS) users or Windows AD DS domain groups in the format domain\username to which you want to grant execute permissions on the BDC models. This enables end users that you add to make Business Data Connectivity calls to SAP NetWeaver. When you add multiple users, you must enclose the comma separated list in quotes. For example “contoso\user1,contoso\user2”.

     All users or groups of users who you want to enable to view or interact with SAP information in SharePoint sites must be granted this permission. We recommend that you specify nt authority\authenticated users for this parameter; this grants this permission to all authenticated users. This is easier than adding users and groups individually and does not involve a security risk. If you choose to specify individual AD DS users and group instead of using nt authority\authenticated users for this parameter, you must also do the following:

     • Specify the AD DS account of the administrator who later will run DuetConfig /checkconfiguration on this list in order to be granted permissions on the SAPRoles and SAPUsers external content types.

     • Specify the AD DS account of the SharePoint 2010 Timer service. Note that this account must also be mapped to an SAP user in the SAP system.

     Note

     Only AD DS users and AD DS groups are supported. SharePoint groups are not supported by this parameter.

   • <WSDLaccount> is a user account that has permissions to download SAP WSDLs. The user that you specify by using this parameter must be mapped to an SAP user in the SAP system and an SAP administrator must grant this user access to the WSDLs in the SAP system.

     Note

     Only AD DS users are supported. SharePoint groups are not supported by this parameter.

   • <WSDLaccountPassword> is the password of the user who is specified by using the /UserName parameter.

   • <EmailAcct> is the contact email address of the SharePoint administrator who you want the SAP administrator to use when an issue is discovered.

   • <BDC Service Application Name> is the service application name of the Business Data Connectivity service to which you want to install the models. By default, this name is “Business Data Connectivity Service”.

     Import is complete when you see success messages (displayed in the Command Prompt) for each of the models and the message [Success] Duet Enterprise configuration utility has successfully imported all the BDC models.

     Note

     The models are listed in List of models (https://go.microsoft.com/fwlink/p/?LinkId=205308).

Import specific models

Importing specific models is similar to importing all models except that when you import a specific model you use the /models parameter to specify one or more specific models that you want to install. For a list of BDC models provided with Duet Enterprise, see List of models (https://go.microsoft.com/fwlink/p/?LinkId=205308).

To Import specific models

1. Log on to any front-end Web server or application server in the SharePoint Server farm.

   Tip

   The models can be installed by using any front-end Web server or application server in the SharePoint Server farm. We recommend that you use the same server to install all models.

2. Open a Command Prompt window as a Farm Administrator and at the prompt go to the “<SystemDrive>:\Program Files\Duet Enterprise\1.0” folder.

3. At the prompt type DuetConfig /importbdc “<UnzippedModelFileLocation>\models.xml” /models <Comma separated list of models> /AddUsers “<EndUsers>” /UserName <WSDLaccount> /Password <WSDLaccountPassword> /Email <EmailAcct> /BDCServiceApplication <BDC Service ApplicationName> and press Enter.

   Where:

   • <UnzippedModelFileLocation> is the location on which the decompressed models are stored. For example, d:\UnzippedModelFiles or \\contoso\UnzippedModelFiles.

   • <Comma separated list of models> is a comma separated list of the names of files of the models that you want to import.

   • <EndUsers> is a comma separated list of Windows Active Directory Domain Services (AD DS) users or Windows AD DS domain groups in the format domain\username to which you want to grant execute permissions on the BDC models. This enables the end users that you add to make Business Data Connectivity service calls to SAP NetWeaver. When you add multiple users, you must enclose the comma-separated list in quotes. For example “contoso\user1,contoso\user2”.

     All users or groups of users who you want to enable to view or interact with SAP information in SharePoint sites must be granted this permission. We recommend that you specify nt authority\authenticated users for this parameter so that all authenticated users are granted this permission because it is easier than adding users and groups individually and does not involve a security risk. If you choose to specify individual AD DS users and group instead of using nt authority\authenticated users for this parameter and you are importing the Role or UserRole BDC models, you must also do the following:

     • Specify the AD DS account of the administrator who later will run DuetConfig /checkconfiguration on this list in order to be granted permissions on the SAPRoles and SAPUsers external content types.

     • Specify the AD DS account of the SharePoint 2010 Timer service. Note that this account must also be mapped to an SAP user in the SAP system.

     Note

     Only AD DS users and AD DS groups are supported. SharePoint groups are not supported by this parameter.

   • <WSDLaccount> is a user account that has permissions to download SAP WSDLs. The users that you specify by using this parameter must be mapped to an SAP user in the SAP system and an SAP administrator must grant this user access to the WSDLs in the SAP system.

     Note

     Only AD DS users are supported. SharePoint groups are not supported by this parameter.

   • <AdminPassword> is the password of the user who is specified by using the /UserName parameter.

   • <EmailAcct> is the contact email address of the SharePoint administrator that you want the SAP administrator to use in the event that an issue is discovered.

   • <BDC Service Application Name> is the service application name of the Business Data Connectivity service application to which you want to install the models. By default, this name is “Business Data Connectivity Service”.

   Import is complete when you see success messages (displayed in the Command Prompt) for each of the models that you imported. For more information, see List of models (https://go.microsoft.com/fwlink/p/?LinkId=205308).