One Star

email through Talend

i am new to talend can anyone of you suggest me books other then User Guide for talend
I need to ask is it possible to send email to the mail id's with the help of talen open studio
21 REPLIES
Community Manager

Re: email through Talend

Hello
Does the tSendMail component fit your need?
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: email through Talend

The User Guide and the Components Guide are essential reading and generally of a good quality. Read these and then browse these forums and check out the tutorials on the Talend site - they are in a rather weird format but they do cover relevant and realistic scenarios.
Yes there is an email component but as in most cases when someone asls "can I do X with Talend?" the answer is almost always yes, because you can easily drop into java or perl to do it if there either isn't a component to do it or you want to do it your way...
T
One Star

Re: email through Talend

i have seen about this component but i am not able to do with it can u just help me to have a tutorial based on it if anyone i will be highly obilised
One Star

Re: email through Talend

There's a usage scenario included in the components user guide on page 999 - have you read that?
T
One Star

Re: email through Talend

Starting job sendemail at 17:47 01/10/2010.
connecting to socket on port 3870
connected
connecting to socket on port 5040
connected
Exception in component tSendMail_1
javax.mail.MessagingException: Unknown SMTP host: smtp.provider.com;


nested exception is:
java.net.UnknownHostException: smtp.provider.com
at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1280)
at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:370)
at javax.mail.Service.connect(Service.java:297)
at javax.mail.Service.connect(Service.java:156)
at javax.mail.Service.connect(Service.java:105)
at javax.mail.Transport.send0(Transport.java:168)
at javax.mail.Transport.send(Transport.java:98)
at honey.sendemail_0_1.sendemail.tFileInputDelimited_1Process(sendemail.java:1132)
at honey.sendemail_0_1.sendemail.runJobInTOS(sendemail.java:1387)
at honey.sendemail_0_1.sendemail.main(sendemail.java:1252)
Caused by: java.net.UnknownHostException: smtp.provider.com
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:158)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:381)
at java.net.Socket.connect(Socket.java:537)
disconnected
disconnected
at java.net.Socket.connect(Socket.java:487)
at com.sun.mail.util.SocketFetcher.createSocket(SocketFetcher.java:232)
at com.sun.mail.util.SocketFetcher.getSocket(SocketFetcher.java:189)
at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1250)
... 9 more
Job sendemail ended at 17:47 01/10/2010.
This is the error when i am trying to send it FYI i am giving u my screenshot of the job also
Employee

Re: email through Talend

Your configuration is wrong, check the parameters (smtp host, port,...)
One Star

Re: email through Talend

ya i have set it to smtp serber name of gmail
smtp host:smtp.gmail.com
smptp port:995
One Star Mo
One Star

Re: email through Talend

try adding the ip/host in the list of hosts under windows/system32/driver/etc/hosts
One Star

Re: email through Talend

i am working in linux
One Star Mo
One Star

Re: email through Talend

On linux it is under this:
etc/hosts
One Star

Re: email through Talend

its still the same
One Star

Re: email through Talend

somebody help me i have this code please helpe
Exception in component tSendMail_1
javax.mail.MessagingException: Unknown SMTP host: smtp.gmail.com;
nested exception is:
java.net.UnknownHostException: smtp.gmail.com
at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1932)
at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:638)
at javax.mail.Service.connect(Service.java:317)
at javax.mail.Service.connect(Service.java:176)
at javax.mail.Service.connect(Service.java:125)
at javax.mail.Transport.send0(Transport.java:194)
at javax.mail.Transport.send(Transport.java:124)
at test.testmailling_0_1.testmailling.tSendMail_1Process(testmailling.java:413)
at test.testmailling_0_1.testmailling.runJobInTOS(testmailling.java:623)
at test.testmailling_0_1.testmailling.main(testmailling.java:491)
Caused by: java.net.UnknownHostException: smtp.gmail.com
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.connect(Unknown Source)
at com.sun.net.ssl.internal.ssl.BaseSSLSocketImpl.connect(Unknown Source)
at com.sun.mail.util.SocketFetcher.createSocket(SocketFetcher.java:288)
at com.sun.mail.util.SocketFetcher.getSocket(SocketFetcher.java:205)
at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1900)
... 9 more
disconnected
Job testmailling terminé à 13:06 21/04/2013.
Moderator

Re: email through Talend

Hi ninio,
The error message imply that something wrong with your SMTP host. Could you mind checking your STMP host? Please see the component reference tSendMail
Please see my screenshot, I used OUTLOOK and the SMTP is "mail10.Myoutlookonline.com". The job works well for me.
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.
One Star

Re: email through Talend

hello
i set the server smtp.gmail.com and port 995
it s the same problem
their is something you must know that we are using proxy and authentication for network that means every user to connect to the network have login and password
One Star

Re: email through Talend

hi XDSHI
thanks for the help but sorry still the same problem, i heard someone said that we must add ip host
if that is what should do i opened the etc file but i don't know the ip address of smtp provider
Moderator

Re: email through Talend

Hi,
I have made a testing that sending an e-mail from my gmail to my 163mail. The job works well.
See my screenshot for details
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.
One Star

Re: email through Talend

Hi,
I want to send a mail
1. Incase of failure I have to send the report
2. If succeeded I have to send the number of rows in of each table.
I was struct with with the mail component. I dont know how to configure it.
I've to send the mail using office365
subject: Load succeeded <current_date> 
Moderator

Re: email through Talend

Hi Ramkumar,
Please try these parameters in your tSendmail:
SMTP setting
Server name: smtp.office365.com
Port: 587
Encryption method: TLS
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.
One Star

Re: email through Talend

i am just trying to use tsend email can some one tell me the process and what we can do with it 
i tired and got this error 
Starting job sendemail at 19:07 05/07/2016.
connecting to socket on port 3548
connected
javax.mail.MessagingException: Unknown SMTP host: smtp.gmail.com ;
  nested exception is:
java.net.UnknownHostException: smtp.gmail.com 
disconnected
Job sendemail ended at 19:07 05/07/2016.
One Star

Re: email through Talend

https://support.google.com/a/answer/176600?hl=en
your port seems to not be the one to use.
Moderator

Re: email through Talend

Hi jasansed,
Can you test to ping to smtp:gmail.com in a command prompt and see if you are able to connect to smtp:gmail.com? For example:
DSmiley Embarassedping smtp:gmail.com

Are you under proxy in your network? Could you please show us tSendmail component setting screenshot?
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.