Adapter type: smtp_out. The SMTP Output adapter sends an e-mail containing stream records.
For each record, the e-mail body contains:
If you use the CCL ATTACH ADAPTER statement to attach an adapter, you must supply the adapter type.
| Property Label | Property ID | Type | Description |
|---|---|---|---|
| SMTP Host | smtpHost | string | (Required) Name or IP address of the e-mail server. No default value. |
| fromAddress | from | string | (Required) E-mail address of the sender. No default value. |
| Importance Column | importanceColumn | string | (Required) Name of the stream column where the e-mail importance is stored. Valid values are: high, normal, and low. The default value is importance. The values are case-sensitive. |
| Address Column | addressColumn | string | (Required) Name of the column where a semicolon-delimited list of recipient e-mail addresses is stored. No default value. |
| Subject Column | subjectColumn | string | (Required) Name of the stream column where the e-mail subject is stored. No default value. |
| SMTP Port | smtpPort | uint | (Optional) Port used by the SMTP server. Default value is 25. |
| SMTP Username | smtpUsername | string | (Optional) Once you configure this property, the SMTP authentication requires the SMTP password to be set also. |
| SMTP Password | smtpPassword | string | (Optional) Set this property if you have set a SMTP username. |
| Use SSL | useSSL | boolean | (Optional) If you want to enable this option, import the security certificate into the Java keystore file (located under install/lib/jre/lib/security/cacerts). Once the security certificate is configured, you can enable this option. Default value is false. Important: Enable the SMTP server for SSL before configuring this option.
|
| Use TLS | useTLS | boolean | (Optional) If you want to enable this option, import the security certificate into the Java keystore file (located under install/lib/jre/lib/security/cacerts). Once the security certificate is configured, you can enable this option. Default value is false. Important: Enable the SMTP server for TLS before configuring this option.
|
| cc Column | ccColumn | string | (Advanced) Name of the column where a semicolon-delimited list of recipient cc addresses is stored. By default, no cc e-mails are sent. |
| bcc Column | bccColumn | string | (Advanced) Name of the column where a semicolon-delimited list of recipient bcc addresses is stored. By default, no bcc e-mails are sent. |
| Column Names | columnNames | string | (Advanced) Colon-delimited names of stream columns whose values are included in the e-mail. By default, the e-mail contains values of all columns in the stream. |
| Show Column Names | showColumnNames | boolean | (Advanced) If true, the adapter includes the column names in the e-mail along with their values. If false, it includes only the values. Default value is true. |
| Number of Resend Attempts | resendAttempts | integer | (Advanced) The number of times to retry sending an e-mail if the initial attempt
to send it fails. Default is 0, no attempt is made to resend e-mails. Choose a moderate value (0 - 10) for this property. Requiring a large number of attempts to resend the e-mail may lead to excessive memory consumption, particularly if aggravated by network problems and a high volume of records waiting to be e-mailed. |
| Log Alert | logAlert | boolean | (Advanced) If true, logs an alert at debug level 1 each time the e-mail sending has been successful or failed. Default value is true. |
| Date Format | dateFormat | string | (Advanced) Date format. Default value is %Y-%m-%dT%H:%M:%S. |
| Timestamp Format | timestampFormat | string | (Advanced) Timestamp format. Default value is %Y-%m-%dT%H:%M:%S. |
PropertySet |
propertyset | string | (Advanced) Specifies the name of the property set from the project configuration file. If you specify the same properties in the project configuration file and the ATTACH ADAPTER statement, the values in the property set override the values defined in the ATTACH ADAPTER statement. No default value. |
Known limitations: