Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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

Published: November 20, 2012

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

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

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.

note Note:

This article does not provide guidance about how to prepare a custom calendar data source.

In this article:

Before you begin

note Note:

Because SharePoint 2013 runs as websites in Internet Information Services (IIS), administrators and users depend on the accessibility features that browsers provide. SharePoint 2013 supports the accessibility features of supported browsers. For more information, see the following resources:

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.

Tip Tip:

To complete this procedure, 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.

note Note:

You must use an on-premise Exchange Server. Office 365 is not supported.

note Note:

Using the aggregated business calendar web part with an Exchange calendar is supported on Web applications that are configured for NTLM only. Web applications that are configured for Kerberos authentication are not supported.

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

note Note:

The TimeEntry BDC model is included with Duet Enterprise 2.0 and is designed to be used with SAP time data. However, the Aggregated Business Calendar Web Part can be used with other data sources such as leave requests and so on. To use the Aggregated Business Calendar Web Part with other data sources, a developer must first create a BDC model to be used for the SAP data source. Then, you can import the BDC model and set permissions on the external content type just as you would with the TimeEntry BDC model.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.