Prepare calendar data sources for the Aggregated Business Calendar Web Part in Duet Enterprise 2.0

Applies to: Duet Enterprise for Microsoft SharePoint and SAP Server 2.0

Summary: Learn how to prepare Exchange and SAP calendar data sources for the Duet Enterprise Aggregated Business Calendar Web Part.

The Aggregated Business Calendar Web Part enables you to work with multiple calendars at the same time. Site owners can aggregate up to four of any of the following types of calendars into the Aggregated Business Calendar Web Part: SAP calendars, SharePoint calendars, Exchange calendars, and custom calendars. For example, a site owner can add two SharePoint calendars, one Exchange calendar, and one SAP Business calendar, or four SAP Business calendars. Any combination of these calendar types is supported. To have these calendars aggregated into one place helps you avoid switching between different calendars, and you can easily compare schedules and avoid schedule conflicts.

A SharePoint farm administrator must create a trust relationship between the SharePoint Server farm and Exchange Server and import the BDC model that is used with the SAP time management data before a site owner can use the Exchange and SAP calendar data sources in the Aggregated Business Calendar Web Part.

SharePoint calendars do not have to be prepared by a SharePoint farm administrator before they can be used in the Aggregated Business Calendar Web Part. Instead, a site owner can create a SharePoint calendar and use it in the Aggregated Business Calendar Web Part immediately. For more information, see Add and use an Aggregated Business Calendar Web Part in Duet Enterprise 2.0 on Office.com.

In this article:

• Before you begin

• Prepare an Exchange calendar data source

• Prepare an SAP calendar data source

Before you begin

Before you begin this operation, review the following information about prerequisites:

• You must know the name of the root certificate that the Exchange Server is using for secure email (SSL), client authentication, server authentication, and so on to prepare the Exchange calendar data source.

• Verify with the SAP administrator that the services used for time management are running on the SAP system.

• Verify that the SAP administer has saved the TimeEntry BDC model (TimeEntry.bdcm) to a location where a SharePoint farm administrator has a minimum of read access.

• You must be a member of the Windows Administrators group and a member of the SharePoint Farm Administrator group to complete these procedures.

Prepare an Exchange calendar data source

To prepare an Exchange calendar data source, an Administrator or member of the Administrators group must create a trust relationship between the SharePoint Server farm and Exchange Server. This requires the root authority certificate for the server that is running Exchange Server.

To get the root authority certificate for the server that is running Exchange Server

1. Log on as administrator or member of the Administrators group to a computer on which Outlook 2013 has been installed and connected to the Exchange calendar that you want to use.

2. Click Start, and then click Run.

3. In the Open box, type certmgr.msc, and then click OK.

4. In the left pane, expand Trusted Root Certification Authorities, and then click Certificates.

5. In the right pane, in the Issued To column, right-click the certificate that is used by the Exchange server for secure Email, Client Authentication, and Server Authentication. For example, GTE CyberTrust Global Root. Point to All Tasks, and then click Export.

   Note

   Typically, the Intended Purposes column for this certificate includes the words: secure email, client authentication, server authentication, and code signing.

6. On the Welcome to the Certificate Export Wizard page, click Next.

7. On the Export File Format page, ensure that DER encoded binary X.509 (CER) is selected, and then click Next.

8. On the File to Export page, type a full path of where to save the file, and then click Next.

9. On the Completing the Certificate Export Wizard page, click Finish.

10. Click OK to close The export was successful dialog box.

To create a trust relationship with the server that is running Exchange Server

1. In the SharePoint Central Administration website, on the Quick Launch, click Security.

2. In the General Security section, click Manage trust.

3. On the ribbon, tn the Manage group, click New.

4. In the Establish Trust Relationship dialog box, in the Name box, type a name for the trust relationship.

5. In the Root Certificate for the trust relationship section, click Browse. Click the root authority certificate that you exported in the previous procedure, and then click Open.

6. In the Establish Trust Relationship dialog box, click OK.

   The trust relationship that you created appears on the Trust Relationships page.

Prepare an SAP calendar data source

Before a member of the site Owners group can add an SAP calendar as a data source to the Aggregated Business Calendar Web Part, a farm administrator must do the following:

• Verify with the SAP administrator that the services used for time management are running on the SAP system.

• Import the TimeEntry BDC model.

• Set permissions on the Time external content type.

Import the TimeEntry BDC model

You must import the TimeEntry (TimeEntry.bdcm) BDC model that an SAP administrator provides before a member of the site Owners group can configure an SAP business calendar. An SAP administrator must create this BDC model and provide it in a location for which a SharePoint farm administrator has a minimum of read access.

To import the TimeEntry BDC model

1. Verify that the user account that is performing this procedure is a member of the Farm Administrators group.

2. In Central Administration, click Application Management.

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

4. Click the Business Data Connectivity Service application that is being used by Duet Enterprise.

5. On the ribbon, in the BDC Models group, click Import.

6. On the Import BDC Model page, in the BDC Model section, type the full path of the TimeEntry.xml file.

7. In the File Type section, ensure that Model is selected.

8. Click Import.

9. When the BDC Model was successfully imported page appears, click OK.

10. The model appears in the BDC Model Name column as Time.

Set permissions on the Time external content type

Use this procedure to set permissions on the external content type that is defined in the TimeEntry BDC model.

To set permissions on the Time external content type

1. In Central Administration, click Application Management.

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

3. Click the Business Data Connectivity Service application that is being used by Duet Enterprise.

4. On the ribbon, in the View group, click External Content Types.

5. Select the check box on the Time row, and on the ribbon, in the Permissions group, click Set Object Permissions.

6. On the Set Object Permissions page, in the top box, enter a user or group to which you want to grant permissions to this model, and then click Add.

7. In the Permissions section, select the check boxes for the permissions to which you want to assign this user or group.

   Select the Execute check box, to enable a user or group to execute operations (create, read, update, delete, or query) that are supported by the external content type. Users need this permission to view the SAP calendar.

   Select the Selectable In Clients check box, to enable a user or group to create external lists of the external content type. Site owners need this permission to create a SAP calendar.

8. To propagate permissions to all methods nested in the external content type, select Propagate permissions to all methods of this external content type. Doing so will overwrite existing permissions.

9. Repeat steps 6 through 8 for each additional user or group to which you want to grant permissions to the Time external content type.

For information about how to add the business calendar to the Aggregated Business Calendar Web Part, see Add and use an Aggregated Business Calendar Web Part in Duet Enterprise 2.0 on Office.com.

See also

Operate and maintain Duet Enterprise for SharePoint and SAP Server 2.0