Send Flow notifications by email
In the Etlworks Integrator, it is possible to send an email notification when the Flow has been automatically executed by the scheduler.
Step 1. Create an Outbound Email Connection.
Step 2. Continue by opening the
Flows window, clicking
+ , and typing
send email into the
Select Flow Type box. Select the
Send Email Flow type.
Step 3. Select the
Outbound Email Connection created in Step 1.
Step 4. Select the
Parameters tab and enter the email parameters. Most of them are optional overrides corresponding to
Outbound Email Connection parameters:
From: the from email address.
To: the to email addresses.
Cc: the cc email addresses.
Bcc: the bcc email addresses.
Subject: the email's subject.
Message: the message body. You can use HTML formatting tags.
Header: an optional header that will be added before the message body.
Footer: an optional footer that will be added after the message body.
Folder: the name of the folder on the email server to copy the message to.
File: the full name (including path) of the file to attach.
Use a wildcard file name (for example,
*.csv) to attach multiple files.
On Exception: by default, any error causes a halt of execution. When
Ignoreis selected, the errors will be ignored and execution will continue. Read how to configure the Flow to ignore all or specific exceptions.
Exception Mask: you can specify what errors should be ignored while still halting execution for all other errors. Enter part or all of the exception string. This field only works when the
Ignore On Exceptionoption is selected.
Execute if Error: if this option is selected, the Etlworks Integrator will send the email if there is an error. It could be useful if you want to notify someone that there is a problem with running the Flow and you would like to attach a report.
Extract and transform data, then send to the outbound email Connection
Emails and email attachments can be used as destinations in a source-to-destination transformation, similar to the use of databases, files, web services, and social websites.
Step 1. Create an Outbound Email Connection, which will be used as the destination.
Step 2. Create any database, file, web service, or social web site Connection, which will be used as the source.
Step 3. Start creating a Flow in the
Flows window by clicking
+ and selecting any Flow type where the source is a database, file, web service, or social website and the destination is a file.
Step 4. Modify the Flow by selecting the Connection created in Step 2 as the source (
FROM), and the Connection created in Step 1 as the destination (
Step 5. Add
Mapping and modify
Parameters, if needed.