From the Blog

An icon for a calendar

2017-03-24

Integration with Outlook 365

Integration with Outlook 365

In this use case we will go through the steps needed to integrate CRM events with your Outlook 365. In this scenario, a new event in Siebel is automatically synchronized with your Outlook 365. In other words,when an event is created in your CRM, Adeptia will create a Calendar Event in your Outlook 365 email account.

The first step is to configure an Office 365 “native” application in your Microsoft Azure Active Directory. Refer to the attached document that goes through the steps of configuring a new application in Azure and generating the Client Key and Secret Key that are needed by Adeptia to connect with your Outlook 365.

The Client and the Secret key are provided in the DB Info service in Adeptia as shown below:

Format of the connection:

jdbc:office365:OAuthClientId=<client id>;OAuthClientSecret=<secret key>=;OAuthCallbackURL=http://localhost:33333;InitiateOAuth=GETANDREFRESH;OAuthSettingsLocation=C:\cdata_tokens\OAuthSettings.txt

Clicking on Test Connection in the DB Info screen will open up a login screen that would prompt you to login to your Outlook 365 account. After logging into the account, Adeptia would automatically get the OAuth access to connect to Outlook 365.

After creating the DB Info service, you can now create a Database Schema, select the Event table and map the following fields in the Event table as part of your process flow. Populating the following fields listed below will create a new Calendar Event in Outlook 365.

Required fields to create an Event in Outlook 365:

  1. end_dateTime
  2. end_timeZone
  3. isAllDay
  4. isCancelled
  5. isOrganizer
  6. isReminderOn
  7. reminderMinutesBeforeStart
  8. start_dateTime
  9. start_timeZone
  10. subject

Example of the Event created in Outlook 365 by Adeptia:

Example of the data values mapped to the required fields:

<end_dateTime>2016-11-28T11:30:00.0000000</end_dateTime>

<end_timeZone>UTC</end_timeZone>

<isAllDay>false</isAllDay>

<isCancelled>false</isCancelled>

<isOrganizer>true</isOrganizer>

<isReminderOn>true</isReminderOn>

<reminderMinutesBeforeStart>15</reminderMinutesBeforeStart>

<start_dateTime>2016-11-27T10:30:00.0000000</start_dateTime>

<start_timeZone>UTC</start_timeZone>

<subject>Testing calendar event</subject>

Refer to the sample deployable process flow and the Azure Active Directory configuration instructions.