OAS 5.9.0 - Customer wants To Have A facility To Send Agent Delivers To A Destination File System

PinakiB- Oracle-Oracle

Description

As per the current Agent 'Destination' setup, there is no such functionality available to store exports into a location via email. Is it feasible to achieve? Customer is asking to add this feature.

Use Case and Business Need

Customer has tons of reports which gets shared via email and currently situation is like flooding emails to their business on daily basis.
Customer would need help to export or download these files locally into server where OAS is installed so that they can move it NFS or shared folder and business can view the extracted reports from shared folder.
They are looking for some method/way. Is there any scope to configure a FTP location to store the schedule reports? 

Original Idea Number: 4b667cd2be

Michal Zima

Hi Pinaki,

as far as I remember well, part of Virtual Box image for OBIEE 12c (predecessor of OAS) called SampleApps (you should be able to find it and download from Oracle web https://www.oracle.com/business-analytics/business-intelligence/technologies/obiee-samples-downloads.html ) was a custom solution for you requirement - is has been done via custom Java code, leveraging BI Scheduler API and performing saving of agent delivery to file system . This Java code needs to be registered in so called Action Framework and then called as Action (Java method) within definition of agent. Should be applicable to OAS I guess, but you need to try.

Rgds

Michal

Nishith Jain

Hi Pinaki,

We had custom Java code deployed in OBIEE 12C but this is not possible in OAC. So now we are using an API call that directly runs the report and saves the output to a file system. Initially we did this using a Python script that was deployed on a local OCI Linux Bastion host. Now we just place the call from a Dell Boomi process.

We would love the enhancement to agents where FTP output is a delivery option. Can't Oracle port over the FTP functionality from BI Publisher to Agents?

Marcelo Finkielsztein

We use OAC, and we would appreciate a method to save results to an on-premise shared folder.

FTP would be fine; other protocols too.

Alan Lee - Oracle-Oracle

OAC Agents do support the ability to invoke a custom web service. This may be a potential avenue to save results to FTP. On-premise folders will have network challenges.

Nishith Jain

HI Alan Lee can you please provide documentation on how to do this? What web service can be used out of agents for this purpose? Agree with Marcelo... does not have to be FTP, any technology would be fine.