Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Send several OAC reports by Email to 2000+ Email Users

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):
Answers
-
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.
- Create agent every reports with "Get Recipients from the Analysis Used in the Agent Condition" and choose email column.
- Condition analysis will provide Recipients List of user on specific report.
0 -
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?
0 -
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.
0