Extracting Email Attachments

jerome_rajan · Post by **jerome_rajan** » Thu Apr 23, 2015 10:18 pm

Is there a way by which we can have DataStage extract Excel attachments from email messages? This process is being done manually today. The Excel files are then read using the Unstructured Data stage.

Thank you

ShaneMuir · Post by **ShaneMuir** » Fri Apr 24, 2015 9:09 am

Generally speaking I would say no... but nothing is impossible.

To do so though I would expect you would need some sort of routine to be run on your Email Server to extract all attachments to a given directory that you could then read with DataStage.

ray.wurlod · Post by **ray.wurlod** » Fri Apr 24, 2015 4:58 pm

One of my colleagues is preparing a paper for Insight 2015 on extracting information from emails into DataStage. Not sure if it addresses attachments, and it's in a very early phase.

kduke · Post by **kduke** » Sun Apr 26, 2015 8:42 am

I would script it. Put all your attachments in a specific folder. Then process files in folder. You can easily run script in a sequence before job.