Please enable JavaScript to view this site.

Navigation: Invantive SQL > Providers

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