I am needing to zip and push data extension extract files to an external ftp. I recently enabled the 'zip' extract type in the account, which allowed me to zip files stored on the marketing cloud FTP site. However, I am hitting a roadblock when trying to push these files to an external site.
I am needing the ability to either perform the zip extract on files stored in the safehouse. So, they can then be transferred from the safehouse to the external ftp. Or I need the ability to transfer files from the enhanced FTP to an external FTP.
Is there a custom extract or business rule that would allow for either of these asks?
- zip files stored in the safehouse
- transfer file from an enhanced FTP folder to an external FTP
Best Answer
I discovered there is a custom extract that support can enable. It is named 'Custom DE Extract With Zip2'. The extract type will perform a data extract on a data extension and zip the file that it places in the Safehouse. You can then perform a file transfer on this file to move it to the enhanced FTP or an external FTP.
The downside is that each individual extract file is zipped separately. It does not allow you to group multiple files into a single zip.