Data FROM Email attached files on Exchange server TO PostgreSQL DB

[Anonymous]

Hi All, 

I need to read data FROM:

1. csv files attached to email on Microsoft Exchange server
2. excel files attached to email on Microsoft Exchange server
3. csv files on sftp server

This should be schedules daily, and

All this much be written TO various tables on a postgresql server.

Any thoughts on how talend might help on this tasks, 

Any help will be much appreciated!

Krgds. Christian

[fdenis · Accepted solution]

Talend is an etl it use to run with multiple types of data .
you can use tpop to read end extract attacment from any mail server.
and user tfileinput to read data tdb output to load data into dbs.
have a look at https://www.solypse.com/talend-gmail-pieces-jointes/
good luck