Option
|
Description
|
API Key
|
Specifies a key that grants access to your Mailchimp account. Filled automatically when you perform web login as described above.
|
Authentication Type
|
Specifies the authentication method to use when connecting to Mailchimp.
|
Client Id
|
Specifies the OAuth 2.0 client ID that you can obtain when you register a custom OAuth app for Mailchimp.
|
Client Secret
|
Specifies the OAuth 2.0 client secret that you can obtain when you register a custom OAuth app for Mailchimp.
|
Connection Lifetime
|
Specifies the time span (in seconds), compared against a connection's creation time when it is returned to the pool; the connection is destroyed if this span is exceeded. The default value is 0 (connection always returns to pool).
|
Connection Timeout
|
Specifies the length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error. The default value is 60.
|
Default Command Timeout
|
Specifies the time in seconds to wait while trying to execute a command before terminating the attempt and generating an error.
|
Failover Retries
|
Specifies the number of retry attempts to automatically re-run a command before displaying an error message in case when the command failed because of an error that may be temporary.
|
Initialization Command
|
Specifies a database-specific command to execute after establishing the connection.
|
Local SQL Engine
|
Determines whether to use local SQL engine for SELECT queries, that are too complex to translate them directly to Mailchimp API calls or to show an error message.
|
Max Pool Size
|
Specifies the maximum number of connections allowed in the pool. Setting the Max Pool Size value in the connection string can affect performance. The default value is 100.
|
Merge Fields Detection Behavior
|
Determines how to present Mailchimp merge tags when working with the ListMembers table. Merge tags are custom fields of the ListMembers table in Mailchimp. It's own set of merge tags can be added for list members of each list; however, Skyvia presents all tables, including Mailchimp ListMembers, so that all its rows have the same columns. Merge Fields Behavior parameter
The following values are available for this setting:
| • | None - all merge tags are not read from Mailchimp and not added as ListMembers table fields. |
| • | JoinCommon - only merge tags that are defined for all the Lists are added as ListMembers table columns. Other tags are ignored. This is the default value. |
| • | JoinAll - all the merge tags are joined to other ListMembers table columns (except for the case described below). If a merge tag is not defined for the list, a list member belongs to, NULL value is returned for the corresponding column of this list member. |
If different lists have merge tags with the same name but different type, default value, required setting, etc., these merge tags are ignored regardless of the Merge Fields Behavior parameter. Merge tags that have the same name for different lists must be the same in order to be available in Skyvia.
|
|
Reading merge tag information takes some time. If you don't to use merge tags, set this parameter to None for best performance.
|
|
Min Pool Size
|
Specifies the minimum number of connections allowed in the pool. The default value is 0.
|
NormalizeDbNames
|
Determines whether database object names are normalized when retrieved from the database.
|
Persist Security Info
|
Indicates if security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state.
|
Pooling
|
Draws the connection from the appropriate pool, or creates and adds it to the appropriate pool, when set to true. This is the default behavior.
|
Proxy Host
|
Specifies the host name or IP address of the proxy server.
|
Proxy Password
|
Specifies the password for the proxy server account.
|
Proxy Port
|
Specifies the port number of the proxy server. The default value is 3128.
|
Proxy User
|
Specifies the proxy server account name.
|
Readonly
|
Indicates whether the connection is read-only (allows only SELECT statements).
|
Run Once Command
|
Specifies a database-specific command to execute after establishing the connection. Unlike Initialization Command, it is not executed for connections obtained from the connection pool.
|
Token Server
|
Is not used for Mailchimp.
|
Use Merge Tag As Field Name
|
Determines whether to use merge tag values as custom field names or use label values instead.
|
UTC Dates
|
Converts dates to UTC format during import when set to True; the date values entered in Excel are then considered UTC dates when saving them to the data source.
|
Connection Dialog