Use a Publicly Accessible SMTP Mail Server to Deliver Reports

Connect to your organization’s mail server, so analysts can email their reports and data visualizations directly from Oracle Analytics. The SMTP mail server must be accessible from the public internet.

Oracle Analytics can connect to mail servers with Basic authentication, except for Microsoft Exchange Online (from September 2025). Microsoft plans to fully remove support for Basic authentication by September 2025. If you want Oracle Analytics to use mail services offered by Microsoft Exchange Online (part of Microsoft 365) you must set up and use OAuth2 (Client Credentials Flow) for authentication.

1. In the Oracle Analytics Home page, click the Navigator, and then click Console.
2. Click Mail Settings.
3. Enter the name of the SMTP Server you want to use to deliver emails.

   For example, mymail.example.com.

   The SMTP server must be accessible from the public internet. If your email server has a public IP address, you can enter the public IP address here instead of the server name.

4. Enter the Port number.

   Common SMTP ports include:

   • 25 (Connection Security = None)
   • 465 (Connection Security = SSL/TLS)
   • 587 (Connection Security = STARTTLS)
5. Enter the name and email address that you want to see in the “From” field of emails delivering reports (Display Name of Sender and E-mail Address of Sender).
   For example, Joe Brown and [e-mail].
6. Click Test to verify the connection.

   If you want to test the connection you must do so before you configure any security settings.

   Note:

   You can click Delete at any time to clear all the mail server settings and start again.

7. Optional: If the mail server requires authentication:
   1. In Authentication, select the type of authentication your mail server requires. Either Basic or OAuth2.
   2. For Basic authentication, enter the Username and Password for a user with access to the mail server.

      The password must be between 8 and 255 characters.

   3. For OAuth2 authentication, configure the properties required by your mail server provider.

      Note:

      Currently, Oracle Analytics supports OAuth2 for a single provider: Microsoft - Client Credentials Flow. See Microsoft Exchange Online - Reconfigure Existing SMTP Mail Servers Configured with Basic Authentication to use OAuth2.

      • Username: Username required to authenticate access to the mail server. Any valid user with access to the mail server.
      • Provider: Select Microsoft as the provider for Microsoft Exchange Online (Microsoft 365).
      • Grant Type: Select Client Credentials.
      • Client ID: Enter the client ID required to access the mail server.
      • Client Secret: Enter the client secret required to access the mail server.
      • Directory (Tenant) ID: (Microsoft only) Identifier for the mail server's tenant.
8. Optional: To set up a secure mail server:
   1. Click Connection Security, and select the appropriate security protocol for your mail server.
      • SSL/TLS: Select if your mail server uses SSL or TLS. The port value defaults to 465.
      • STARTTLS: STARTTLS is a way to take an existing insecure connection and upgrade it to a secure connection using SSL or TLS. The port value defaults to 587.

      In TLS Certificate, the Default Certificate is selected for you. The default certificate allows encrypted mail server communication. In most cases, you don’t need to provide a compatible certificate as most mail servers can use the default certificate, including Office 365.

   2. Optional: Upload a custom TLS certificate. In TLS Certificate, select Custom Certificate , and then click Select to navigate to the certificate file (.pem).
      If you haven’t configured a virus scanner, you're prompted to configure one now or proceed without a virus scanner.
9. Click Save.
   Allow some time for your changes to refresh through your system and Email menu options to display.