Integrating Pega Sales Automation 7.31 and 7.4 with Microsoft Outlook by using the Pega for Outlook Office add-in
Pega Sales Automation™ provides a Pega for Outlook Office add-in that you can use to integrate your application with multiple client types depending on Exchange server versions.
With the Pega for Outlook Office add-in, you can perform the following actions:
- Search, open, and display Pega Sales Automation leads, contacts, opportunities, organizations, and accounts.
- Synchronize emails and appointments.
- Associate emails or appointments with contacts, leads, opportunities, organizations, and accounts.
- Create contacts, leads, opportunities, activities, and tasks.
The Pega for Outlook Office add-in supports the following features:
- Single sign-on (SSO) – after you log in to the add-in for the first time, you can access it from any device, without reentering your login credentials.
- Pinnable task pane – leave the add-in task pane open in your mailbox when you switch between messages.
If you customize your URL pattern by replacing prweb in your URL with a custom value, you must override the OutlookLogin.js and OutlookAddIn.js script files in your implementation layer. Pinnable task pane is supported in an email or appointment reply as well.
Prerequisites
- Verify that your server is SSL enabled (HTTPS).
- Verify that third-party cookies are enabled for your browser. To learn how to enable them, see your browser's online documentation.
- If you are using Microsoft Edge to access a private server, add https://outlook.office.com to your list of trusted websites.
- To configure Outlook add-in on iPhone in Safari, allow cross-site tracking in Safari.
To install the Pega for Outlook Office add-in, complete the following steps:
- Configuring the Web server
- Configuring the manifest file
- Configuring settings for the Pega for Outlook Office add-in
- Authenticating the Pega for Outlook Office add-in using a custom single-sign-on (SSO)
- Publishing the add-in as an organizer
- Publishing the add-in as an individual mailbox user
- (Optional): Updating calendar items from Sales Automation portal
Configuring the Web server
Configure your Sales Automation server for the Pega for Outlook Office add-in user by adding the AddIn folder and entering your authentication credentials.The AddIn folder contains the required images for your Pega for Outlook Office add-in integration.
- Download the following AddIn folder: AddIn folder.
- Open the WinSCP Login dialog and log in to your server.
- Add the AddIn folder to the /opt/tomcat/webapps directory.
- If you are using Tomcat 7 or later, to designate the pipe symbol '|' as a valid character in your query parameters, in the /opt/tomcat/conf directory, add
tomcat.util.http.parser.HttpParser.requestTargetAllow=|{}
to catalina.properties. - In the /opt/tomcat/webapps/prweb/WEB-INF folder, to authenticate the Pega for Office Outlook add-in user, open the web.xml file and add the following servlet and servlet mappings:
<servlet> <servlet-name>OutlookAddIn</servlet-name> <display-name>OutlookAddIn</display-name> <description>Internet Application Composer, using custom authentication techniques</description> <servlet-class>com.pega.pegarules.internal.web.servlet.WebStandardBoot</servlet-class> <init-param> <param-name>PegaEtierClass</param-name> <!-- COMPONENTS: This was previously com.pega.pegarules.services.HttpAPI --> <param-value>com.pega.pegarules.session.internal.engineinterface.service.HttpAPI</param-value> </init-param> <init-param> <param-name>AuthenticationType</param-name> <param-value>PRCustom</param-value> </init-param> <init-param> <param-name>RuntimeServletName</param-name> <param-value>OutlookAddIn</param-value> </init-param> <init-param> <param-name>AuthService</param-name> <param-value>OutlookAddinService</param-value> </init-param> </servlet> <servlet-mapping> <servlet-name>OutlookAddIn</servlet-name> <url-pattern>/OutlookAddIn</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>OutlookAddIn</servlet-name> <url-pattern>/OutlookAddIn/*</url-pattern> </servlet-mapping>
Configuring the manifest file
To provide your URLs for the Pega for Outlook Office add-in, configure the manifest file.
- In the Dev Studio header search text field, search for and download the OAddinManifest.xml file.
- Open the OAddinManifest.xml file.
- Configure the manifest file elements as shown in the following table:
Manifest file element Manifest file
element required dataSample input <Id>String</Id>
Enter the unique ID of your Office Addin-in as a GUID. <Id>6ac7a924-6039-42e5-8d0c-63a0b9c31417</Id>
<IconUrl DefaultVAlue=" " />
Enter the URL of the image that is used to represent your Pega for Outlook Office add-in. <IconUrl DefaultValue="https://10.60.215.243:8443/AddIn/Images/Icon64.png"/>
<SourceLocation DefaltValue=" "/>
Enter the source file locations for your Pega for Outlook Office add-in as a URL between 1 and 2,018 characters long.
The source location must be an HTTPS address, not a file path.
<SourceLocation DefaultValue="https://10.60.215.243:8443/prweb/[email protected]&pzAuth=guest"/>
<bt:Images> <bt:Image id="icon16" DefaultValue=""/> <bt:Image id="icon32" DefaultValue=""/> <bt:Image id="icon80" DefaultValue=""/> </bt:Images>
Enter the URL of the images that are used to represent your Pega for Outlook Office add-in. Microsoft recommends using three images: 16px, 32px, and 80px. <bt:Images> <bt:Image id="icon16" DefaultValue="https://10.60.215.243:8443/AddIn/Images/Icon16.png"/> <bt:Image id="icon32" DefaultValue="https://10.60.215.243:8443/AddIn/Images/Icon64.png"/> <bt:Image id="icon80" DefaultValue="https://10.60.215.243:8443/AddIn/Images/Icon80.png"/> </bt:Images>
<bt:Urls> <bt:Url id="messageReadTaskPanelUrl" DefaultValue=""/> </bt:Urls>
<bt:Urls>
<bt:Url id="messageReadTaskPanelUrl" DefaultValue="https://10.60.215.243:8443/prweb/[email protected]&pzAuth=guest"/>
</bt:Urls>
Configuring settings for the Pega for Outlook Office add-in
To determine how the Pega for Outlook Office add-in handles attachments and to specify the internal domains to filter out from the Add a Person list for emails and appointments, configure settings in Pega Sales Automation. Configuration is divided into the following parts: App Studio settings and Developer settings.
- In the explorer panel of App Studio, click .
- Click the Microsoft Exchange tab.
- In the Outlook add-in settings section, complete the following steps:
- If you want to process attachments when synchronizing emails and appointments, select the Process attachments check box. For more information, see Configuring Pega Sales Automation to Microsoft Exchange calendar integration.
- Enter the Internal domains that you want to filter out when populating the Add a Person list for emails and appointments. For example, if you enter, in.pega.com, any email or appointment recipients that have the domain @in.pega.com do not display in the Add a Person list. If you enter multiple domains, enter the domain names as comma separated values. For example, pega.com, in.pega.com.
- Click .
- Enter the certificate location to validate the JWT token which is used to establish SSO across devices.
- In Dev Studio, click .
- If you are using Office 365, no action is needed.
- If you are using an on-premises Exchange 2013 or 2016 server, change the KeyStore URL to reflect that. For example, if you are using an Exchange 2013 server with the URL, mail.in.company.com, then your KeyStore URL is: https://mail.in.company.com /autodiscover/metadata/json/1/.
- In Dev Studio, click .
Authenticating the Pega for Outlook Office add-in by using a custom single-sign-on (SSO)
The Pega for Outlook Office add-in includes an authentication service called OutllookAddInService (servlet name:OutlookAddIn) that enables you to use a single-sign-on (SSO) functionality. The authentication service uses Pega Sales Automation operator credentials and a Microsoft Exchange Server JWT token to validate users.
If you want to use your organization's SSO service to allow authentication by using network credentials, rather than the Microsoft Exchange Server JWT token, complete the following steps:
- Open the OAddinManifest.xml file.
- Search for the OutlookAddIn servlet and replace it with your SSO servlet.
- Search for
[email protected]&pzAuth=guest
and replace it withpyActivity=Data-Portal.OutlookLogin
.The URL should now appear as: https://pegadevap.murex.com/prweb/sso?pyActivity=Data-Portal.OutlookLogin.
- Log in to Dev Studio.
- In the explorer, click .
- Select your SSO and copy your identity provider (idP) domain name. Make sure the domain is https.
- In the manifest file, add your idP domain under the
<AppDomains>
element. - Import the manifest file for your mailbox user account and verify the add-in
- In the Dev Studio header search text field, search for and select the Outlookaddin.js file.
- Find the following two lines in the Outlookaddin.js file:
var snapstartURL = prpcURL.concat("/prweb").concat("?pyActivity=").concat("Data-Portal.OutlookViewInBrowser"); var clientURL = prpcURL.concat("/prweb").concat("?pyActivity=").concat("Data-Portal.OutlookViewInBrowser&outlookWO=" +insHandle);
- Add your SSO servlet after
prweb
in each line ("/prweb/SSO").
For example:
var snapstartURL = prpcURL.concat("/prweb/SSO").concat("?pyActivity=").concat("Data-Portal.OutlookViewInBrowser"); var clientURL = prpcURL.concat("/prweb/SSO").concat("?pyActivity=").concat("Data-Portal.OutlookViewInBrowser&outlookWO=" +insHandle
Publishing the Pega for Outlook Office add-in as an organizer to all mailbox users
If you need to publish the Pega for Outlook Office add-in to all mailbox users, complete the following steps:
- Log in to Microsoft Office 365 as an admin user and open the Microsoft Exchange Admin center.
- Click .
- Click Add from File. >
- Upload and install the OAddinManifest.xml file that you configured for your Pega for Outlook Office add-in.
- Log in to Pega Sales Automation as an administrator.
- In the Dev Studio header search text field, search for and select the OAddinManifest.xml file.
- Click Download file.
- Open the file and change the Pega-provided URLs to match the URLs for your implementation.
- Double-click the application to open the Edit Add-in settings window and review the default settings. If you select the Optional, disabled by default option, your users must manually enable the add-in.
Publishing the Pega for Outlook Office add-in to an individual mailbox user
If you need to publish the Pega for Outlook Office add-in to only one mailbox user, complete the following steps:
- From your Microsoft Office 365 inbox, in the top-right corner of the screen, click the icon.
- In the Settings pane, click .
- Click .
- Click OAddinManifest.xml file that you configured for your Pega for Outlook Office add-in. and upload the
Optional: Updating calendar items from Sales Automation portal
If you configure the Pega Sales Automation to Microsoft Exchange calendar integration after enabling the Pega for Outlook Office add-in you will not be able to update the calendar items from the Sales Automation portal. Meetings synchronized using the Outlook add-in can not be updated in the portal until running the MigrateOfficeAddinAppointment activity.
Previous topic Integrating Pega Sales Automation with Microsoft Outlook by using the Pega for Outlook Office add-in Next topic Integrating Pega Sales Automation with Gmail by using the Chrome extension