Export a FDI csv output file in a outside server

Question

Hi,

Just a quick question : we are creating a report that is supposed to be used in another app. We would like to know whether there is a way to export the csv output file automatically when the flow is executed into an external server ? Or the only way is to save the csv in a table in the database connection and then export it from ADW directly ?

Thank you,

Regards,

Lauriane

Sumanth V -Oracle · Accepted Answer

@Lauriane Massin Whitaker -

As of today, Oracle Analytics Cloud (OAC) does not have a feature to directly place extracted CSV files onto an SFTP server. However, you may explore options available in BI Publisher, where CSV extracts can be configured to be placed on an SFTP server. Additionally, your external server can then be set up to pick up the CSV output from the configured SFTP location.

https://docs.oracle.com/middleware/bi12214/bip/BIPAD/GUID-11DB0A6D-5847-46A1-97BA-6216D2257A6F.htm#BIPAD299