Data Feed would require you to do some what I like to call "post processing" on your side; yes. You can do a few things. You can leverage Adobe.io to get anything out of Analytics. But you will need to code up your own application to get the data out. Of course Engineering Services would be able to get something out for you. Live Stream API is also an option for an additional price. But anything that is out of the box can be possible if you need Data Warehouse data to go to Azure. You should reach out to your CSM in that case.
FTP/SFTP is not an option for us. My understanding is that Data Feed requires high level of transformation at our end where as DW will give the processed data. We would prefer the processed data from the DW but not FTP route. What other options do we have? How does the API route works ?