Skip to main content

Does anybody need to ingest data into Ataccama by way of an excel file attached to an email?

One of our business teams receive a “data feed” from an external supplier. It comes as an Excel attachment delivered by email.

We have enquired, they do not have APIs. Excel via email is all we’ve got.

As it stands, my integration will depend on the person receiving the email dropping the file into something like an S3 / ADLS Gen2, and for us to build a .ewf to poll the location regularly to ingest the data (into RDM).

We’re on PaaS, v14.5.1 for now, soon to be v14.5.3.

Don’t think the PaaS stack can automagically read emails and get attachments off. We’re not keen on the dependency on the person to drop the file into ADLS Gen2, but it seems to be my only option at the moment.

Do I have any alternatives?

 

Hi @maykwok_hamilton,

Indeed, Ataccama PaaS doesn't currently offer an option to receive data via SMTP. However, there are a number of solutions that allow you to save emails to object storage.

If your organization utilizes an MFT server, it might offer such functionality. Additionally, AWS allows you to autosave emails to an S3 bucket (using the "Deliver to S3 bucket" action in Amazon Simple Email Service), and Azure allows you to download attachments to blob storage (see the tutorial: "Create workflows that process emails using Azure Logic Apps, Azure Functions, and Azure Storage").

I'd suggest exploring what options are already available within your company. If none, consider your preferred technology stack for a potential solution.

Reply


Community Terms of Use & ConditionsCookie settings