topic Re: How to send Sql query output as mail in Talend Studio

How to send Sql query output as mail

dataleadge — Wed, 28 Aug 2019 11:51:49 GMT

Hello Community,

I'm new to talend and wanted to execute an job which would send my Sql query output as mail to the recipients .The query needs to be run on daily basis and the output should be attached to mail.It'd be great if anyone can help me with components and connection.

Thanks in advance!

Re: How to send Sql query output as mail

Anonymous — Thu, 29 Aug 2019 08:26:44 GMT

Hello,

Please have a look at this related topic:https://community.talend.com/t5/Design-and-Development/resolved-Sending-query-result-by-mail/m-p/100984#M59354

Let us know if it helps.

Best regards

Sabrina

Re: How to send Sql query output as mail

dataleadge — Fri, 06 Sep 2019 10:44:41 GMT

Hi Sabrina,

Thanks for your reply-that was of great help.I would appreciate if you'll help me to get the output which is sent in mail in tabular form.Following is the example that would give you brief idea about my query.

The output I want in mail:

schema1 schema2 schema3

data data data

The output I'm getting:

schema1

data

schema2

data

schema3

data

Thanks in advance!

Best Regards.

Re: How to send Sql query output as mail

Anonymous — Thu, 12 Sep 2019 04:33:37 GMT

Hello,

What's your output component? Could you please post your current job design screenshot here?

Best regards

Sabrina