There is a database extension in salesforce marketing cloud that I need to export from the automation. I didn't create the DE and am unsure how to export it for use outside of salesforce marketing cloud. It is from a SQL query. Any help is much appreciated. Thank you.
You'll need one of two type of Data Extract Activity provisioned to your account by Support:
- Data Extension Extract
- Data Extension Extract with File Encoding and gzip
I'd recommend the latter of the two extract types as many (most) external applications misinterpret the archaic UCS-2 file encoding of the standard Data Extension Extract.
The steps to then include in your Automation to extract data from your Data Extension are as follows:
Step 1. SQL Query Activity that populates your Data Extension
Step 2. Data Extract Activity using one of the two extract types (take care that both require the External Key of your DE and not the name of the DE)
Step 3. File Transfer Activity. Move the file created by Step 2 from the Safehouse to your Enhanced FTP or other File Location