Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics and AI› Oracle Analytics and AI Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Scheduling a Analysis Subject Area Report to SFTP server

Duplicate
21
Views
5
Comments
narendra kumawat
narendra kumawat Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Idea Lab

Organization Name

Veritas Technologies LLC

Description

We need to send a Report generated through Analytics(OTBI) via New->Analysis straight to a SFTP server. But we can see that this functionality is only available if the report is generated through either New->Reports or New->Data Model. We would want the option to send it to SFTP server available for the Reports generated through New->Analysis.

Use Case and Business Need

Business Users generate most of their reports from New->Analysis as it is convenient and easy for them to generate a report there due to it's simplified UI. But the Users also want that the report to be sent directly to the SFTP server. Since this functionality is not available for Analysis Subject Area Reports, they can't do it. 

More details

In the current scenario, we will have to create a Data Model for every report that had been generated through New->Analysis in the past for it to be sent to the SFTP server. As this is not a feasible solution as every time the user will have to spend time to generate the Data Model and they can't get into much technicalities. We suggest you to add this functionality in other reports generation methods as well. I've attached a file with screenshots describing the situation

Original Idea Number: 43beac9196

3
3 votes

Duplicate · Last Updated

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

Comments

  • John Schmottlach
    John Schmottlach Rank 1 - Community Starter

    We have a similar requirement at multiple customers. We encourage the business and development teams to build their reports as Analyses so that they can leverage the subject area and self service capabilities. However, once the report is built, we are often finding that the output needs to be delivered to a shared location for multiple people to consume the data, or sent off to a different system for processing. We are forced to rewrite these analyses as BI Publisher reports to complete the process.

  • Rachael Puthoff
    Rachael Puthoff Rank 1 - Community Starter

    We have similar requirements. We have multiple vendors that require regular reports and they want it sent to an SFTP site. These reports are analyses in OTBI and we'd love to send them as CSVs to an SFTP site instead of making a data model and report from the analysis and then sending as a CSV to an SFTP site.

  • Hima Bindu Patil -Oracle
    Hima Bindu Patil -Oracle Rank 1 - Community Starter

    A very useful and good idea.

    SFTP should be made available in the 'Destinations' option while scheduling the OTBI report.

  • RVohra
    RVohra Mod
    • 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
  • RVohra
    RVohra Mod

    Please refer Support KM article - An Enhancement Request was raised to enable the FTP feature in OTBI. You may track it using defect id 20990512.

    Hope it helps!