Allowed connection properties
Certain Batch pipelines are only compatible with specific properties. Refer to the following table for the full list:
| Source | Allowed Properties |
|---|---|
| Amazon Redshift | HOST, PORT, Profile, options, socketTimeout, sslmode, tcpKeepAlive, user. |
| Dynamics 365 | ApiVersion, AuthScheme, BatchSize, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Timeout, Verbosity. |
| Elastic Search | AWSRegion, AuthScheme, BatchSize, FlattenArrays, FlattenObjects, Location, Logfile, MaxRows, Server, Timeout, Verbosity. |
| Excel | AWSRegion, AuthScheme, BatchSize, Header, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Timeout, Verbosity. |
| Facebook Ad Accounts | AuthenticateAsPage, BatchSize, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Timeout, Verbosity. |
| Facebook Ad Insights | AuthenticateAsPage, BatchSize, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Timeout, VerbositenticateAsPage, BatchSize, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Timeout, Verbosity. |
| Facebook Content Insights | AuthenticateAsPage, BatchSize, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Timeout, Verbosity. |
| Gmail | BatchSize, InitiateOAuth, Location, Logfile, OAuthAccessToken, Timeout, Verbosity. |
| Google Analytics | ApiVersion, AuthScheme, BatchSize, DefaultFilter, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Profile, PropertyId, Schema, Timeout, Verbosity. |
| Google Big Query | AllowLargeResultSets, AuthScheme, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Timeout, Verbosity. |
| Google Custom Search | BatchSize, Location, Logfile, MaxRows, Timeout, Verbosity. |
| Google Sheets | AuthScheme, BatchSize, Header, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Spreadsheet, TeamDriveSupport, Timeout, ValueInputOption, Verbosity. |
| Hubspot | AuthScheme, BatchSize, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Schema, Timeout, UseDisplayNames, Verbosity. |
| IBM DB2 | user. |
| IBM DB2 for i | user. |
| Jira | APIToken, AuthScheme, BatchSize, IncludeCustomFields, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Timeout, UseDisplayNames, Verbosity. |
| Mailchimp | AuthScheme, BatchSize, IncludeCustomFields, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Timeout, Verbosity. |
| MariaDB | HOST, PORT, enabledTLSProtocols, serverTimezone, socketTimeout, tcpKeepAlive, tinyInt1isBit, user, ZeroDateTimeBehavior. |
| Marketo | BatchSize, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Schema, Timeout, UseBulkAPI, Verbosity. |
| Microsoft SQL Server | DATABASENAME, LOGINTIMEOUT, PORTNUMBER, SSL. |
| MongoDB | AuthDatabase, AuthScheme, BatchSize, DNSServer, Database, FlattenArrays, FlattenObjects, Location, Logfile, MaxRows, ReplicaSet, Server, SlaveOK, Timeout, Verbosity. |
| MySQL | HOST, PORT, enabledTLSProtocols, serverTimezone, socketTimeout, tcpKeepAlive, tinyInt1isBit, user, ZeroDateTimeBehavior. |
| Netsuite | AuthScheme, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Schema, Timeout, Verbosity, Version. |
| OData | AuthScheme, BatchSize, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Timeout, Verbosity. |
| Open Exchange Rates | AppId, BatchSize, Location, Logfile, MaxRows, Timeout, Verbosity. |
| Oracle | User. |
| Oracle Eloqua | AuthScheme, BatchSize, BulkQueryTimeout, Company, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Timeout, UseBulkAPI, Verbosity. |
| PostgreSQL | options, socketTimeout, sslmode, tcpKeepAlive, user. |
| Quickbooks | BatchSize, IncludeCustomFields, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Timeout, Verbosity. |
| Sage Intacct | AuthScheme, BatchSize, CompanyID, Location, Logfile, MaxRows, SenderID, SenderPassword, Timeout, Verbosity. |
| Salesforce | AuthScheme, BulkQueryTimeout, InitiateOAuth, Location, Logfile, LoginURL, MaxRows, OAuthAccessToken, Timeout, UseBulkAPI, UseDisplayNames, Verbosity. |
| Shopify | AppId, AuthScheme, BatchSize, IncludeCustomFields, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Schema, Timeout, Verbosity. |
| Snowflake | N/A |
| Stripe | AuthScheme, BatchSize, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Timeout, Verbosity. |
| SugarCRM | BatchSize, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Timeout, UseDisplayNames, Verbosity. |
| Xero | AuthScheme, BatchSize, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Schema, Timeout, Verbosity. |
| Zendesk | AWSRegion, AuthScheme, BackwardsCompatibilityMode, BatchSize, FlattenArrays, FlattenObjects, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Timeout, Verbosity. |
| Zendesk Talk | AWSRegion, AuthScheme, BackwardsCompatibilityMode, BatchSize, FlattenArrays, FlattenObjects, InitiateOAuth, Location, Logfile, MaxRows, OAuthAccessToken, Timeout, Verbosity. |
Requesting additional connection properties
To request additional connection properties, visit our support portal, and raise a support ticket. For more information, read Getting support.