Send several OAC reports by Email to 2000+ Email Users — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Send several OAC reports by Email to 2000+ Email Users

Received Response
62
Views
3
Comments

Summary:

Our customer wants to send several OAC reports by Email to 2000+ Email Users. The customer wants to store the report name (path in catalog), EmailID in a ADW table and want to use to deliver the contents of Reports (in PDF) to the Email ID present in the ADW table. Please suggest high level steps to achieve this.

Content (required):

OAC IBOTS

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Answers

  • Indranil Basak-Oracle
    Indranil Basak-Oracle Rank 4 - Community Specialist

    Hi Sunil,


    Looks what I understand, looking Recipients list from ADW table. Recipients list would be dynamically fetch based on reports.

    Looks one possible way long back I tried for OBIEE12c version. Below steps might help . Need POC for OAS/OAC.

    1. Create agent every reports with "Get Recipients from the Analysis Used in the Agent Condition" and choose email column.
    2. Condition analysis will provide Recipients List of user on specific report.


  • Sunil Gunturu-Oracle
    Sunil Gunturu-Oracle Rank 4 - Community Specialist

    okay thanks for this Indranil, Customer wants to drive it via configuration table only with email ID's stored in the configuration table.

    Is there a way to have the report outputs send via ODI?

  • Joshua C. Stewart
    Joshua C. Stewart Rank 5 - Community Champion

    To my knowledge, there aren't OAC API's that allow you to source reports directly from your catalog and attach them to an ODI process.

    The process Indranil laid out is the best practice standard we follow for sharing OAC reports. Everything would still be driven via the configuration table, however, in this case you are replacing an ODI Agent with an OAC Agent. It's actually very straightforward, as you can build your Conditional Analysis via a Direct SQL Query to your configuration table.