Prerequisite

1. Before subscribing to notifications, make sure that you have first created a live feed.
2. Configure the mail service:

   For the live feed tool to send notifications, you need to configure the Simple Mail Transfer Protocol (SMTP) Settings in the Data Studio Settings.

   Refer to the Send Email on Autonomous Database chapter for more details.

   Note
   
   The Live Feed tool uses the UTL_SMTP package in the back end to provide an interface. While UTL_SMTP itself does not inherently support encryption like OAuth2, which is required by some providers (e.g., Microsoft 365), using a secure connection (SSL/TLS) can encrypt the communication between your application and the SMTP server. However, UTL_SMTP does not natively support OAuth2, which is becoming increasingly common for authentication with large email providers.

   The following rules apply while configuration:

   • The SMTP server port must be 25 or higher. The only ports likely to be used here are 587 (most common for modern setups, typically with StartTLS), 465 (Secure Sockets Layer) or 25 (no encryption).
   • The SMTP server host name must not be blank.
   • The E-mail address field must not be blank.
   • Typically, clients will need to provide authentication credentials to access their SMTP server. Additionally, most setups will likely use StartTLS for encryption. However, the specific requirements can vary depending on how the company or provider has configured their system.

You can configure the email notifications in the following locations:

Livefeed page

Data Load Dashboard

Catalog page

Configure Email Notifications on the Live Feed tool

After you have created a Live Table Feed using the Live Feed tool, navigate to the Live Feed tool .

You will view the Live Table Feed card on the Live Feed tool page.

1. Click the Actions icon on the card and select Manage Email Notification.
   
   
   
   Description of the illustration live-feed-email.png
   
   
2. On the Email Notification dialog, select +Add to add your email address where you will receive the notification.
   
   
   
   Description of the illustration send-email.png
   
   
3. Enter the email address.
4. Select any of the available options to receive email notifications based on the following conditions:
   • On Loaded Rows: Select this option if you want to be notified in case the Live Feed successfully imports new data into your table.
   • On Failure: Select this option if you want to be notified in case the Live Feed fails to run due to an error. For example, if the storage location for your files is missing, or your access credentials are no longer valid.
   • On Rejected Rows: Select this option if you want to be notified in case the Live Feed encounters and rejects incorrect data. For instance, when there is a data type mismatch, such as attempting to import the word Blue into a column that must consist of only numbers.
5. Click OK.

Configure Email Notifications on the Data Load Dashboard

Once you have created a Live Feed, you will view the status of the feed on the Data Load Dashboard.

1. Click the Actions menu on the table header, click Live Feed and select Email.
   
   
   
   Description of the illustration dataload-email.png
   
   
2. On the Email Notification dialog, select +Add to add your email address where you will receive the notification.
3. Enter the email address.
4. Click OK.

Configure Email Notifications on the Catalog Tool

After you have configured the email notifications, the subscriber with the email address specified in the Email Management notification dialog will now receive notifications according to the settings you configure during the live feed creation process.