This should be a batch process in FAW where it can schedule and pull the data automatically creates a file and drop it in the server.
As per Oracle Support below is the comment.
Currently we can extract data from FTP server using SFTP connection but can't place data on FTP server after extracting using FDI.
https://blogs.oracle.com/analytics/post/configure-secure-file-transfer-protocol-connector-in-fusion-analytics