Invantive Data Hub
Connector Mail: SMTP mail. |
SMTP mail.
Code for use in settings.xml: Mail
Alias: mail
Abbreviation: ml
Status: Production
Available in Editions: Paid
String-comparison is Case-sensitive: true
Use Catalog in Full Name: true
Use Schema in Full Name: true
Connector Attributes
The Mail connector can be configured using the following attributes:
Code |
Description |
Default Value |
Set from Connection String |
Set from Set SQL-Statement |
Set from Connectors File |
Set from Log On |
|---|---|---|---|---|---|---|
bulk-delete-page-size-rows |
Number of rows to delete per batch when bulk deleting |
10000 |
✓ |
✓ |
✓ |
|
bulk-insert-page-size-bytes |
Approximate maximum size in bytes of batch when bulk inserting |
10000000 |
✓ |
✓ |
✓ |
|
bulk-insert-page-size-rows |
Number of rows to insert per batch when bulk inserting |
10000 |
✓ |
✓ |
✓ |
|
force-case-sensitive-identifiers |
Consider identifiers as case-sensitive independent of the platform capabilities. |
False |
✓ |
✓ |
✓ |
|
forced-casing-identifiers |
Forced casing of identifiers. Choose from Unset, Lower, Upper and Mixed. |
|
✓ |
✓ |
✓ |
|
invantive-sql-correct-invalid-date |
Whether to correct invalid dates. |
False |
✓ |
✓ |
✓ |
|
invantive-sql-forward-filters-to-data-containers |
Whether to forward filters to data containers. |
True |
✓ |
✓ |
✓ |
|
invantive-sql-shuffle-fetch-results-data-containers |
Whether to shuffle results fetched from data containers. |
False |
✓ |
✓ |
✓ |
|
invantive-use-cache |
Whether to cache the results of a query. |
True |
✓ |
✓ |
✓ |
|
log-native-calls-to-disk |
Registers native calls to data container backend as disk files. |
False |
✓ |
✓ |
✓ |
|
log-native-calls-to-trace |
Log native calls to data container backend on the trace. |
False |
✓ |
✓ |
✓ |
|
mail-body-html |
Set whether the mail body is HTML. |
|
✓ |
✓ |
✓ |
|
mail-from-email |
The default FROM email address. |
|
✓ |
✓ |
✓ |
|
mail-from-name |
The default FROM name. |
|
✓ |
✓ |
✓ |
|
mail-priority |
Priority of the mail; negative is bulk, 0 is neutral, positive is urgent. |
|
✓ |
✓ |
✓ |
|
mail-reply-to-email |
The default REPLY TO email address. |
|
✓ |
✓ |
✓ |
|
mail-reply-to-name |
The default REPLY TO name. |
|
✓ |
✓ |
✓ |
|
maximum-length-identifiers |
Non-default maximum length in characters of identifier names. |
|
✓ |
✓ |
✓ |
|
max-url-length-accepted |
The maximum accepted URL length before raising an error. |
8000 |
✓ |
✓ |
✓ |
|
max-url-length-desired |
The maximum desired URL length. |
8000 |
✓ |
✓ |
✓ |
|
partition-slot-based-rate-limit-length-ms |
Total length in ms across all slots of a partition-based rate limit. |
60000 |
✓ |
|
✓ |
|
partition-slot-based-rate-limit-slots |
Number of slots per partition-based rate limit. Null means no slot-based rate limit |
|
✓ |
|
✓ |
|
pre-request-delay-ms |
Pre-request delay in milliseconds per request. |
0 |
✓ |
✓ |
✓ |
|
requested-page-size |
Preferred number of rows to exchange per round trip; only effective on limited platforms such as AFAS Online |
|
✓ |
✓ |
✓ |
|
requests-parallel-max |
Maximum number of parallel data requests from individual partitions on the data container. |
32 |
✓ |
✓ |
✓ |
|
slot-based-rate-limit-length-ms |
Total length in ms across all slots of a slot-based rate limit. |
60000 |
✓ |
|
✓ |
|
slot-based-rate-limit-slots |
Number of slots of a slot-based rate limit. Null means no slot-based rate limit |
|
✓ |
|
✓ |
|
smtp-enable-ssl |
Set whether SSL is enabled for SMTP connections. |
False |
✓ |
✓ |
✓ |
|
smtp-host-address |
The default SMTP host address to use. |
|
✓ |
✓ |
✓ |
|
smtp-host-port-number |
The default SMTP host post number to use. |
|
✓ |
✓ |
✓ |
|
smtp-minimum-deliver-duration-ms |
Minimum deliver duration in milliseconds for the SMTP send plus inserted sleep when SMTP send finished earlier than the minimum. |
|
✓ |
✓ |
✓ |
|
smtp-password |
The default SMTP password to authenticate with. |
|
✓ |
✓ |
✓ |
|
smtp-send-timeout-ms |
Timeout in milliseconds after which the SMTP send times out. |
|
✓ |
✓ |
✓ |
|
smtp-user-name |
The default SMTP user name to authenticate with. |
|
✓ |
✓ |
✓ |
|
standardize-identifiers |
Rewrite all identifiers to the preferred standards as configured by standardize-identifiers-casing and maximum-length-identifiers. |
True |
✓ |
✓ |
✓ |
|
standardize-identifiers-casing |
Rewrite all identifiers to the recommended standard platform-specific casing when changing a data model on a case-dependent platform. |
True |
✓ |
✓ |
✓ |
|
10-09-2020 00:0820.1.206-BETA+2915
