Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 289 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 111 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to send OTBI report to SFTP server
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
Answers
-
Hi @Pritam Das,
Welcome to the Oracle Analytics & AI Community!
OTBI agents cannot directly deliver reports to SFTP, as they are limited to email and dashboard delivery only as of now.
To send output to SFTP, you have to convert the OTBI analysis to a Bi Publisher report.
Hope this help.
Thank you.
0 -
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.
0 -
@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!
0 -
This is not supported yet:
Thanks.
0


