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
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.
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)
@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:
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!
This is not supported yet:
https://community.oracle.com/customerconnect/discussion/582140/deliver-otbi-report-to-sftp
Thanks.
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?