You are not logged in.
I'm new to forums, not sure this is the proper place. We have a project we need help on. We are seeking people who can create Talend Jobs as explained below.
By doing this we intend to automate the process of moving attachments from the Gmail account to the correct directory on the FTP server. File attachments are sent by email each day. The format for the data in the attachments is different for each sender. We use the sender to identify what data format to expect. Additionally, we hard code some data values based upon the sender. The data will be inserted into Salesforce accounts. This Job will be used about twenty times with different email and Salesforce accounts. Hard-coding the login credentials is fine.
When the work is complete we will have received a ETL Job that we can import. The Job will retrieve the emails from a Gmail account and capture the attachments.
The “Sender” will be used to determine the Schema. We need to use different Schemas depending on the “Sender” email address. We can create the Schemas. The Schemas are to be used for the data in the attachments.
So the Job should use different Schemas depending on the Sender. The attachment must be used with the correct Sender.
If errors are detected, an email should be sent to firstname.lastname@example.org describing the file which errored or where the error occurred. The process should be able to be re-run upon error. So, if there are emails that won’t be read again, we need to know which emails.
The data in the attachments will be inserted using a common Schema. We can give that Schema when you’re ready. Again, if this fails for any reason, we want an email sent to email@example.com and we need to be able to get the file out of the email inbox. If it makes more sense to move the email that is causing a problem to another folder, do that.
Welcome to Talend Community!
All your requirement about this ETL can be done in Talend Data Integration.
Fetch mails from Gmail: tPOP
Retrieve attachment: tFileInputMail
Because of limited details, we can't create an accurate job for you.
You might read these tutorials for a quick start.
Then use the components above to create this job with your job logic.
Please feel free to ask any questions.