Description

This step checks if an email address is valid or not. The checking process returns one result field (Boolean or String depending on your settings) and one additionnal field (String) containing errors string when email address is not valid.

This step is available in PDI version 3.1 or higher.

This step must receive input stream and add result fields in this input stream.

Image

Options

Option	Description
Step name	Name of the step in the transformation.Note: This name has to be unique in a single transformation.
email fieldname	Specify the name of the field that contains the email addresses to check. This field must be defined in a previous step. Dropdown the combo to select fieldname.
SMTP check?	By default, PDI will only check email address structure (using regular expression). If you want to perform a SMTP check, please select this option and fill Email sender (see after). PDI will extract domain name from the supplied email address (to check) and will try to get all exchangers from the domain name. Each exchanger will be queryed.
Time out	In order to perform a SMTP check, PDI will open a socket on the target SMTP host. Specify here the socket time out (by default 0).
Email sender	If you select "SMTP check?" option, this field is mandatory. PDI will need sender email address to query SMTP host.
Default SMTP server	If you know which SMTP server to query, please specify it here, PDI will then query only this one. *Note*: Specifying SMTP host here will faster the process because PDI will ask only this one and not fetching all the exchangers from the domain name.
dynamic default SMTP?	IF you want to pass default SMTP server in a dynamic way, check this option.
Default SMTP field	If you select the previous option, you must fill this field. This field must be defined in a previous step. Dropdown the combo to select fieldname.
Result fieldname	PDI will store the result of the process in this field. The result will be Boolean (TRUE = the email address is valid, FALSE = the email address is unvalid) if "Result is a string" option is unchecked (see after). *Note*: This field is mandatory and will be added to the input stream.
Result is a string	This option will turn the ouput field into a String and when the email address is valid the output will contains the "Email is valid" field (see after) otherwise it will contains the "Email is not valid" field (see after).
Email is valid	If you selected the previous option, you must fill this field
Email is not valid	If you selected the previous option, you must fill this field
Errors field	When an email is address is unvalid, PDI return the reason. If you want to add it in the input stream, please give the field a name, otherwhise leave this field blank.

How to use this step

This step validate email addresses and it needs to be connected with previous step.

The "email address" step is the source of email addresses. It can be replaced of course by any other steps (Table Input, Text File input, Excel Output,...). The "Mail Validator" step will check email addresses from "mail" field (created in "email address" step).

Field "result" will contains the result of the process (Y or N ie TRUE or FALSE) and PDI will put the errors string in the field "Error message".

The filter rows step "Check eMail" will separate valid email addresses from unvalid ones.