Use ESS to run a BI Publisher job that transmits reports via SFTP

Juan Miguel Isip-94819

Summary

Is it possible to use ESS execute a BI Publisher job will transmits reports via SFTP?

Content

We have built some Custom Reports in BI Publisher that extract data to a CSV file using a simple SQL script.
This is scheduled running every hour and automatically transmits the file to a vendor's SFTP Server.

However, I'm wondering if its possible to call these jobs from the Enterprise Scheduler (ESS) so that we can maintain it from there?
Is this possible? I don't see any option for ESS jobs to transmit reports to a external SFTP server.

Please advise.

Version

Oracle Business Intelligence Publisher Enterprise

Felix Ribalov-70522

Hi Juan,

We have the same requirement. Did you manage to achieve this? Is there a document about the way to configure ESS jobs to run BIP reports ?

BR,

Felix

User_W8NQH

The solution we followed for this case is:

1. Create a BIP report

2. Used the Schedule Service for the BIP report where you can select the delivery option as 'FTP'

 

Arun Raj

Can you take a look at this link. I believe this is what you are trying to achieve.

Juan Miguel Isip-94819

This is the same approached we've used as mentioned in my post. It's running in BIP, not via ESS.

We would want a solution to use ESS, but still keep the functionality of the sFTP transmission.

Juan Miguel Isip-94819

Not Exactly. I'm aware than we can "link" BI publisher reports to ESS, but Custom ESS Jobs don't have the functionality to send report outputs via sFTP.

Juan Miguel Isip-94819

Unfortunately not, i don't think this is supported at the moment.

Arun Raj

I was able to achieve this.

1. Create Data Model (Make sure to provide bursting details). Refer to this document
2. Create Report (Make sure enable Bursting in Report Properties)
3. Create ESS Job (Make sure to enable Bursting)

If you have provided the details of SFTP Server in the Bursting definition SQL, you should be able to see the files in the SFTP Sever.

I was able to submit a ESS Job and view the files in the SFTP server.

Thanks,

Arun