Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BIP Report SFTP Configuration Tables

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
Comments
-
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
0 -
Hi Team,
We got any solution for this? If yes, could you please share with us.
Thanks,
Harish Kumar Kovi
0 -
I need this info too to migrate from Dev to Stage and Prod, rewriting manually is too difficult.
Thanks
0 -
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.
0 -
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.
0 -
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
0