Page 1 of 1
Extracting Email Attachments
Posted: Thu Apr 23, 2015 10:18 pm
by jerome_rajan
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
Posted: Fri Apr 24, 2015 9:09 am
by ShaneMuir
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.
Posted: Fri Apr 24, 2015 4:58 pm
by ray.wurlod
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.
Posted: Sun Apr 26, 2015 8:42 am
by kduke
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.