Automated Email with Excel or CSV attachment?

Question

Hi everyone,

My team currently uses SAS to pull data from an on-prem database, create an Excel spreadsheet from the SAS dataset, and email the dataset to users specified in the SAS job. The entire query can be automated. We are migrating to Azure and will access to Data Factory, Synapse Analytics, Databricks, Power Automate, Power BI, and Power Apps.

Is there a tool or combination of tools that we can use to achieve this capability? I was under the impression that Data Factory or Synapse Pipelines but that does not appear to be the case.

Answer 1

Hello,

Yes as you have thought, you can make use of ADF/ Synapse analytics to query on Prem database and send email. But with respect to attachment, excel support is not yet there, and you can still use CSV files.

You can use copy activity to pull records from on Prem DB and create a CSV file stored in azure blob storage or data lake storage. And use web activity + logic apps to send email with the CSV file attached to the required persons.

Hope that helps. If you need more details, please let us know.

Thanks.