Deliver Reports Using OAuth Authorized SMTP Server

You can use an OAuth 2.0 authorized Microsoft Exchange Online SMTP server to deliver pixel-perfect reports.

In the Publisher Email delivery configuration page, you can configure to use any of these OAuth authorized Microsoft Exchange Online SMTP servers to deliver pixel-perfect reports:

• OAuth authorized Microsoft Exchange Online SMTP server configured using the Console. You can use mail servers configured through the Console to deliver data visualizations, analyses, dashboards, and Publisher reports.

  See Use a Publicly Accessible SMTP Mail Server to Deliver Reports and Microsoft Exchange Online - Reconfigure Existing SMTP Mail Servers Configured with Basic Authentication to use OAuth2.

  Note:

  If you change mail settings using Console after you configure the Microsoft Exchange Online SMTP server for Publisher report delivery, your changes aren't automatically available to Publisher.

  In this case, you must remove the Microsoft Exchange Online SMTP server configuration from the Publisher Email delivery configuration page, and refresh the Publisher Email delivery configuration page.

• OAuth authorized Microsoft Exchange Online SMTP server configured to exclusively deliver Publisher reports.

1. Configure delivery.
   1. From the Administration page, under Delivery, select Delivery Configuration.
   2. Enter value for Email From Address.

      The sender email address must be correct to test connection to the Microsoft Exchange Online SMTP server.

   3. Enter value for Delivery Notification Email From Address.
   4. Optional: Enter values for Success Notification Subject, Warning Notification Subject, Failure Notification Subject, and Skipped Notification Subject.
      The completed jobs use the appropriate notification subject depending on the status of the job.
   5. Deselect Use System Proxy Settings.
   6. Click Apply.
2. From the Administration page, under Delivery, select Email.
3. If you want to use the OAuth authorized SMTP server that's configured in Oracle Analytics for visualizations, click the SMTP server name link listed in the Email tab, and make sure the authentication type is OAuth2.

   If required, you can edit and change the server name, host name, port number, secure connection type, user name, client ID, client secret, and tenant ID of the Microsoft Exchange Online SMTP server.

4. If you want to add an OAuth authorized SMTP server exclusively for Publisher report delivery, click Add Server, and provide the server configuration details.
   1. Enter the server name and the host name of the Microsoft Exchange Online SMTP server.
   2. Enter the Port number recommended by the SMTP service provider.
   3. Select STARTTLS from the Secure Connection list.
   4. For Authentication Type, select OAuth2.
   5. Specify values for Username, Client ID, Client Secret, and Tenant ID.
5. If you want to restrict access to the delivery channel, in the Access Control section, perform these steps:
   1. Deselect Public.
   2. From the Available Roles list, select one or more roles you want to provide access to the delivery channel, and click Move to add them to the Allowed Roles list.
6. Click Test Connection.
7. Click Apply.
8. Make the OAuth authorized Microsoft Exchange Online SMTP server as the default for email delivery.
9. Optional: Configure the bursting jobs to deliver reports using the SMTP email server.
   Update bursting queries to specify SMTP Email server as the delivery channel in DEL_CHANNEL and provide the "From" address in PARAMETER3.
10. Test report delivery.
    1. Schedule a job to email a report using the SMTP email server.
    2. In the Job History Details page, check the status of the job.