General OBIEE

Get Involved. Join the Conversation.


    Juan Miguel Isip
    Use ESS to run a BI Publisher job that transmits reports via...
    Topic posted September 5, 2018 by Juan Miguel IsipBronze Medal: 1,250+ Points, tagged BI Publisher, Discussion Forums, Fusion, OBI Answers, OBIEE Answers, Report Delivery, Scheduling or Agents, Setup, Setup/Administration 
    88 Views, 1 Comment
    Use ESS to run a BI Publisher job that transmits reports via SFTP
    Is it possible to use ESS execute a BI Publisher job will transmits reports via SFTP?

    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.

    Oracle Business Intelligence Publisher Enterprise



    • Felix Ribalov

      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 ?