General OBIEE

Get Involved. Join the Conversation.

Topic

    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
    Title:
    Use ESS to run a BI Publisher job that transmits reports via SFTP
    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

    Comment

     

    • 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 ?

      BR,

      Felix