Oracle BI report export to FTP location

AbhishekC-Oracle

Hi,

Please note, we need to export BI reports into some secure location via SFTP connection.

Q1. Does OBIEE 12c support this functionality ?

Q2. If not supported then what is the best way to implement this functionality?

Q3. Does next OBIEE version (release) include this feature as it seems like very common need for every organization.

I would really appreciate if anyone can put some light on this topic.

Regards,

Abhishek

Joel

Have you considered BI Publisher reports for this as it provides this functionality out of the box. You could attempt this in OBIEE but it would be something that you’d have to put together yourself.
https://docs.oracle.com/middleware/12211/bip/BIPAD/GUID-52398FBA-CB92-4A8D-9187-770A98C657E4.htm#BIPAD306

AbhishekC-Oracle

Thanks for the update.

Yes, BI Publisher has this functionality but unfortunately BI-publisher is not in our scope.

It would be grate to know if next version of BI includes this feature as OOTB then we can by pass security approvals to open multiple ports for multiple Clients.

Joel

There's an outstanding Enhancement Request for this feature OOTB. This might give you some guidance in getting it done in OBIEE - https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=379332587024192&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id…

AbhishekC-Oracle

Thanks for the update.

In the Bug, its saying it is an outstanding enhancement request for OBIEE 12c, but in current OBIEE 12c doesn't include this feature as OOTB.

Joel

In the bug, you'll notice that it was created on 16-Sep-2015 (almost 4 years ago) which would indicate that the request has been around for a while..