Oracle Analytics and AI

OTBI Scheduled Report to FTP Folder

Description

Currently we get the reports from OTBI via email. But it will be good to have the agent send the output directly to our FTP/SFTP server.

Use Case and Business Need

Hi, We would like to have the report data out directly to our FTP/SFTP so that it will be easy for us automate the data to load in our target database and use it for data analytics purposes. With the current feature of report delivery by email, we need manual activity in placing the file in the folder. We want to override this manual activity.

Thanks,

Ila

Original Idea Number: 56de82cd36

Find more posts tagged with

Submitted

Agents

BI Publisher

Actions

BI Publisher Data Models

Status: Submitted

Comments

sami123

Agree.

Taleo Learn BI reporting tool provides this capability.

For Taleo Recruiting OBI report, we forward report output to role account email box and then we have a VB script which downloads attachment and save the file to network location.

thanks

Sami

Ilavarasu Radjunilamegame

Hi Sami,

Thanks for your response. Can we get the sample VB script that can be used for downloading attachments from email box and place it on our network drive.

Thanks,

Ila

Reena Trangri

Hi IIa,

Similar ideas have already being posted and also reviewed by Oracle. Oracle should soon consider this and make it available.

Thanks and Regards,

Reena Trangri

Koby Kimchy-Oracle

Hi,

try this

create ticket to open the fusion SFTP for the customer
request to increase the BI report size limit if required (default is 0.5GB)
update SFTP credentials in BIP
set the output of the report to SFTP
run the scheduled report

Regards,

koby

User_ZNGHL

As of 01-DEC-2017 Oracle will Deprecate Oracle SFTP server. This is going to be an issue since the files to be stored in UCM

Ramesh Nakka

We had BO that option and we were able to schedule report in BO older. which also had the capacity to generate data more than 7MB ( 30 MB to 40 MB -.excel 2003)

Can we have the same option available here in OBI Folder scheduling option. So that users can browse to that folder download the data by themselves.

Regards,

Ramesh

Thousif Syed

Done voting. This is much needed for us.

Mike Quinn

Only being able to send via email is really limiting on our use case

Glen Ryen

Hi Mike,

As a workaround, have you looked into defining a BI Publisher data model and report? You could base the BIP data model off an OTBI analysis and schedule the report with SFTP delivery. It changes where you look for the running BIP job vs. an OTBI agent, but that should deliver the file you want to the destination server.

Hope that helps,

Glen

RVohra

OTBI Agent delivery channels are limited to Email, Dashboard and Alert-based delivery and there is NO standard or supported capability to deliver OTBI analyses directly to an SFTP location via Agents.

In contrast, BI Publisher does support SFTP / FTP delivery

This difference is by design in the Fusion BI architecture:

OTBI is intended for interactive analytics and light scheduling
BI Publisher is intended for enterprise reporting and file-based integrations