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.
...
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. |
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). |
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 straing string in the field "Error message".
The filter rows step "Check eMail" will separate valid email addresses from unvalid ones. 
