You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

52
Views
7
Comments
edited Sep 5, 2018 9:10AM in General Transactional Reporting (OTBI) 7 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!