For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
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.
Comment
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
Be the first to rate this
|
Sign in to rate this
Unfortunately not, i don't think this is supported at the moment.
Be the first to rate this
|
Sign in to rate this
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'
Average Rating:



2 ratings
|
Sign in to rate this
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.
Average Rating:



1 rating
|
Sign in to rate this
Can you take a look at this link. I believe this is what you are trying to achieve.
Be the first to rate this
|
Sign in to rate this
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.
Average Rating:



1 rating
|
Sign in to rate this
I was able to achieve this.
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
Be the first to rate this
|
Sign in to rate this