Oracle Analytics Publisher Idea Lab

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

BIP Report SFTP Configuration Tables

Needs Votes
372
Views
6
Comments
Rahul Kasambe
Rahul Kasambe Rank 1 - Community Starter

Description

BIP Report SFTP Configuration Tables. Most of the BIP admin task of creating SFTP configuration at

Oracle Transactional Business Intelligence

Manage BI Publisher --> Delivery --> FTP

Username , Password , Private Key File is setup.

How to query these FTP data by using a BIP query builder and selecting data from any of the fusion backend tables.

Use Case and Business Need

This will allow IT support to check impact of any SFTP configuration changes and how it will impact the different BIP reports using it.

More details

As per the SR SR 3-26021563351 : BIP Report SFTP Configuration Tables

Brought this up with BIP BDE/GTL.

The Admin configuration information, SFTP, email, etc, etc... are stored in files not the database.
So there is no query.

If access to this information is functionality you would like to see had, I would suggest submitted ER/Idea to the Idea lab.

Original Idea Number: ae91667fe9

6
6 votes

Needs Votes · Last Updated

Thanks for your Idea Rahul. We are moving this idea to it's next stage of Needs Votes. Here you can promote the idea to generate interest, based on the interest it will go to the next stages

Comments

  • Karthikeyan Sukumar
    Karthikeyan Sukumar Rank 3 - Community Apprentice

    Yes, it is very much needed information through the backend. Other information we can read from the application but the password couldn't able to see.

    Thanks!

    Karthik

  • Kovi Harish Kumar
    Kovi Harish Kumar Rank 1 - Community Starter

    Hi Team,

    We got any solution for this? If yes, could you please share with us.

    Thanks,

    Harish Kumar Kovi

  • makarandamondikar
    makarandamondikar Rank 1 - Community Starter

    I need this info too to migrate from Dev to Stage and Prod, rewriting manually is too difficult.

    Thanks

  • Natarajasuthan K
    Natarajasuthan K Rank 1 - Community Starter

    Information retrieval as a webservice/any form of data retrieval, will greatly help to understand more details, when/who made the change/create, for troubleshooting/analysis.

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics Strategist

    This is a long pending enhancement. We should be able to report the data created from UI. I understand this might be a major revamp as this data is stored as metadata. So, any solution - webservices rather than direct table access will also be helpful.

    Thanks.

  • uocam
    uocam Rank 1 - Community Starter

    Require this information in tables to be able to use the details in SQL reports to avoid having to manually update the code for each environment