Data FROM Email attached files on Exchange server TO PostgreSQL DB

Anonymous — Sat, 16 Nov 2024 06:09:53 GMT

Hi All,

I need to read data FROM:

csv files attached to email on Microsoft Exchange server
excel files attached to email on Microsoft Exchange server
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

Re: Data FROM Email attached files on Exchange server TO PostgreSQL DB

fdenis — Wed, 03 Apr 2019 17:15:30 GMT

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

topic Data FROM Email attached files on Exchange server TO PostgreSQL DB in Talend Studio

Data FROM Email attached files on Exchange server TO PostgreSQL DB

Re: Data FROM Email attached files on Exchange server TO PostgreSQL DB