tSendMail + parameters in a table

One Star

tSendMail + parameters in a table

Hello everybody,
I block on a simply task.
I would like to send an email using parameters (body, subject, from, to ...) stored in a oracle table.
For example: a row with the expeditor, a row with the body...
How can I do?
Using tSendMail is a good Idea?
Thank you for reading
Bonjour à tous,
Mon problème est simple mais c'est le genre de chose que je n'ai jamais fait sous Talend il doit donc me manquer une notion je pense. Je n'ai pas trouvé de cas similaire.
Alors voilà:
Je veux envoyer un mail en utilisant des paramètres (Body, objet etc...) contenus dans une table oracle.
Une ligne de la table peut correspondre à l?expéditeur, l'autre à l'objet du mail etc...
Comment puis-je faire?
Est-ce que passer par le tSendMail est une mauvaise idée?
Merci de m'avoir lu!
Seventeen Stars

Re: tSendMail + parameters in a table

I cannot see the problem. You could read out the Oracle table with tOracleInput and use the flow fields in the tSendMail.
tOracleInput --> tFlowToIterate --> tSendMail
In the tSendMail component you can use the values from the tFlowToIterate to set email subject and body.
Or do I miss something here?
Moderator

Re: tSendMail + parameters in a table

Hi qschneider,
Some screenshots of your job design will be preferred. Here is a related topic .
What's the issue you got for your current job?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now