How to query database, and send results as an email attachment?

One Star

How to query database, and send results as an email attachment?

I would like to query a MySQL database with a select statement, send results to an Excel spreadsheet, and email that file.
I tried tMysqlInput --> tFileOutputExcel --> tSendMail, but that did not work.
How can I do this?
Seventeen Stars

Re: How to query database, and send results as an email attachment?

tMysqlInput --Main flow--> tFileOutputExcel
tMysqlInput --OnSubjobOk --> tSendMail (with the file path from tFileExcelOutput as attachment)

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads