OTBI: OTBI Agent with SFTP Destination

Fongang

Summary

How to Setup OTBI Agent to export report results to SFTP Server

Content

Hello All,

I have a request to export the result output of an OTBI report to an SFTP server on a daily basis. Unfortunately the delivery Agent for scheduling OTBI reports does not have the FTP as a Destination option. Has anyone some Ideas on how I can go about this? your contributions are highly appreciated.

 

Regards

 

Kingsley

Christian Berg

Short answer: You can't

Longer answer: In order to deliver to FTP you will need to use BI Publisher with its bursting options: https://docs.oracle.com/middleware/12213/bip/BIPDM/GUID-A926D588-426F-47C7-8A9A-B0A7959C5814.htm

Fongang

Thanks Christian

User_5NGE4

I installed BIP 12c on linux server in its own domain. I can see in admin console that bi_server1 is running but when try to access the http://localhost:9704/xmlpserver
it gave me 404 error.

any help will be appreciated.
thanks,
akhtar