I have a need to create a flat file of some data from EpiServer database and send it to a third party AWS S3 bucket for reporting purpose. Now the steps I am thinking is to create a scheduled job which will fetch data which I am familiar with.
Question is where should I output the file in the DXC environment so once the file is ready I can send the file either through SFTP or AWS S3 API something. Is there any preferred way of doing this?
I suggest you to avoid storing the file to physical location instead of this you can go with Azure blobs storage and then serve the file from there.