How to send OTBI report to SFTP server

Question

Hello Expert,

We have a requirement where we need to push an OTBI report to an SFTP server, and we would like to know how we can achieve this.

Regards,

Pritam

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/28346/how-to-send-otbi-report-to-sftp-server

This is not supported yet:

https://community.oracle.com/customerconnect/discussion/582140/deliver-otbi-report-to-sftp

Thanks.

RVohra · Answer

@Pritam Das , Welcome to the Oracle Analytics Community!

One option is to use Data Set for the OTBI Analysis as Data Set while creating the Data Model.

Here are the high-level steps:

* Go to Tools → Reports and Analytics.
* Click Browse Catalog.
* Navigate to create a new Data Model
* Select Data Set → Analysis.
* Provide: Analysis Path , Example:  /Shared Folders/Custom/Integration/OTBI_Report_For_SFTP
* Save the Data Model. This tells BI Publisher to pull data directly from OTBI.
* Create the BI Publisher Report From the Data Model 
* Choose layout type:

* Excel template
* RTF template
* CSV output

9. Configure SFTP Delivery

Feel free to reach out if you have any questions in terms of how to configure SFTP Delivery.

Hope it helps!

Bhaskar Konar · Answer

Hi @Pritam Das,

In addition to the above, please check the following note from Oracle:

(KB662873) Need the FTP delivery option when using OTBI Agent (iBot)

An Enhancement Request was raised to enable the FTP feature in OTBI. You may track it using defect id 20990512.

You may use this document for tracking instructions: How to Monitor / Track ER a Bug from My Oracle Support (Doc ID 1298390.1)

Hope this help.

Thank you.