Set Up an Email 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.

  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 joseph.brown@example.com.
  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. Select Authenticated.
    2. Enter the Username and Password for a user with access to the mail server.
  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.