Import 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. You can import each model separately. However, it is much easier to import all models at the same time. There is no performance or security-related reason not to import all models at the same time.

Before performing these procedures, you must copy the models to a location to which the SAP administrator has a minimum of read access. The models are provided in the SAPServiceModels.zip file. This file is installed to the c:\program files\Duet Enterprise\1.0\SAP Service Models folder, by default, when you install Duet Enterprise as described in Install Duet Enterprise (https://go.microsoft.com/fwlink/p/?LinkID=205811).

If you are using the Deployment worksheet (https://go.microsoft.com/fwlink/p/?LinkId=205392), enter the location of the SAPServiceModels.zip file in the “SAPServiceModels.zip location” row of Table 1 of the worksheet.

The SAP administrator must update the models with the appropriate end points and then copy the zip file that contains the updated models to a location to which you have a minimum of read access. By default, the name of the zip file that contains the updated models is BDC.zip.

You will need the following information to import the models.

• Location of the .zip file that contains the BDC models. If you and the SAP administrator are using the Deployment worksheet (https://go.microsoft.com/fwlink/p/?LinkId=205392), the location and name of the .zip file that contains the BDC models is listed in the “BDC models ZIP file location” row of Table 2 of the worksheet.

• 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. If you are using the Deployment worksheet (https://go.microsoft.com/fwlink/p/?LinkId=205392), these user or group account names are listed in the “Users who can access SAP content” row of Table 1 of the worksheet.

• 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”.

Decompress the file that contains the models

The models that the SAP administrator configures will be in the form of a compressed (.zip) file. By default, the name of this file BDC.zip. You must decompress this file before you can import the models.

If you are using the Deployment worksheet (https://go.microsoft.com/fwlink/p/?LinkId=205392), the location at which the SAP administrator stored the .zip file is listed in the “BDC models ZIP file location” row of Table 2 of the worksheet.

After you decompress the files, note the location of the decompressed BDC model files.

If you are using the Deployment worksheet (https://go.microsoft.com/fwlink/p/?LinkId=205392), after decompressing the files, note the location of the decompressed BDC model files in the “Unzipped model file location” row of Table 1 of the worksheet.

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 for Microsoft SharePoint and SAP.

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.

   If you are using the Deployment worksheet (https://go.microsoft.com/fwlink/p/?LinkId=205392), add this name to the “BDC service name” row of Table 1 of the worksheet.

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.

     If you are using the Deployment worksheet (https://go.microsoft.com/fwlink/p/?LinkId=205392), this location will be listed in the “Unzipped model file location” row of Table 1 of the worksheet.

   • <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 that you want to be able 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 this is easier than adding individual users and groups 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.

     If you are using the Deployment worksheet (https://go.microsoft.com/fwlink/p/?LinkId=205392), the users or groups can be found in the “Users who can access SAP content” row of Table 3 of the worksheet.

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

     If you are using the Deployment worksheet (https://go.microsoft.com/fwlink/p/?LinkId=205392), this username is listed in the “User name for WSDL access” row of Table 2 of the worksheet.

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

     If you are using the Deployment worksheet (https://go.microsoft.com/fwlink/p/?LinkId=205392), this password is listed in the “Password for WSDL access” row of Table 2 of the worksheet.

   • <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”.

     If you are using the Deployment worksheet (https://go.microsoft.com/fwlink/p/?LinkId=205392), this name is listed in the “BDC service name” row of Table 1 of the worksheet.

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