We need to integrate with another system the customer's last open date and their opt out information. I am open to the best way to do it but I thought perhaps:
1. Schedule a query or export nightly.
2. Have results go to SFTP site.
3. External system consumes the file.
Can you suggest the best way to accomplish this business requirement. I read somewhere that you can't schedule a recurring export but you can be creative to work around this. Not sure how.
Please sign in to leave a comment.