This should be a batch process where it can schedule and pull the data automatically creates a file and drop it in the server.
As per the Oracle SR 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
Very helpful information.
Thanks for sharing @User_VTIXP!