You can use connection properties to customize the driver for your environment. This section organizes connection properties according to functionality. You can use connection properties with either the JDBC DriverManager or a JDBC data source. For a DriverManager connection, a property is expressed as a key value pair and takes the form property=value. For a data source connection, a property is expressed as a JDBC method and takes the form setproperty(value).

Note:
  • In a JDBC data source, string values must be enclosed in double quotation marks, for example, setProxyPassword("secret").
  • The data type listed for each connection property is the Java data type used for the property value in a JDBC data source.
  • Connection property names are case-insensitive. For example, AuthenticationMethod is the same as authenticationmethod.
  • For connection properties that support string values, use the following escape sequence to specify values containing leading or trailing spaces and curly brackets: {value}. For example: ProxyPassword={hello } or ProxyPassword={{hello}}.

The following tables describe the connection properties by functionality.

OAuth 2.0 properties

The following table summarizes properties used for OAuth 2.0 authentication method.

Property Data Source Method Default
AccessToken getAccessToken()

setAccessToken(String)

 No default value
AuthenticationMethod getAuthenticationMethod()

setAuthenticationMethod(String)

 OAuth2
ClientID getClientId()

setClientId(String)

 No default value
ClientSecret getClientSecret()

setClientSecret(String)

 No default value
RefreshToken getRefreshToken()

setRefreshToken(String)

 No default value
Scope getOauthScope()

setOauthScope(String)

 For default, see the connection property description.

Proxy server properties

The following table summarizes proxy server connection properties.

Property Data Source Method Default
ProxyHost getProxyHost()

setProxyHost(String)

 No default value
ProxyPassword getProxyPassword()

setProxyPassword(String)

 No default value
ProxyPort getProxyPort()

setProxyPort(Integer)

 0 which means the default is determined by the ProxyHost property.

For HTTP URLs: 80

For HTTPS URLs: 443
ProxyUser getProxyUser()

setProxyUser(String)

 No default value

Timeout properties

The following table summarizes timeout connection properties.

Property Data Source Method Default
LoginTimeout getLoginTimeout()

setLoginTimeout(Integer)

 0 (seconds)
QueryTimeout getQueryTimeout()

setQueryTimeout(Integer)

 0 (seconds)

Web service properties

The following table summarizes Web service connection properties, including those related to timeouts.

Property Data Source Method Default
LoginTimeout getLoginTimeout()

setLoginTimeout(Integer)

 0 (no timeout)
QueryTimeout getQueryTimeout()

setQueryTimeout(Integer)

 0 (no timeout)
StmtCallLimit getStmtCallLimit()

setStmtCallLimit(Integer)

 0 (no limit)
StmtCallLimitBehavior getStmtCallLimitBehavior()

setStmtCallLimitBehavior(String)

 ErrorAlways

Mapping properties

The following table summarizes connection properties involved in mapping the Google Analytics data model to a SQL model.

Property Data Source Method Default
AddTables getAddTables()

setAddTables(String)

 No default value
CustomPrefix getCustomPrefix()

setCustomPrefix(String)

 Include
CustomPrefixName getCustomPrefixName()

setCustomPrefixName(String)

 No default value
KeywordConflictSuffix getKeywordConflictSuffix()

setKeywordConflictSuffix(String)

 No default value
SchemaMap getSchemaMap()

setSchemaMap(String)

 Default value depends on environment
ShowDeprecatedObjects getShowDeprecatedObjects()

setShowDeprecatedObjects(Boolean)

 false
ShowInternalTables getShowInternalTables()

setShowInternalTables(Boolean)

 false
SubtractTables getSubtractTables()

setSubtractTables(String)

 No default value

Statement pooling properties

The following table summarizes statement pooling connection properties.

Property Data Source Method Default
ImportStatementPool getImportStatementPool()

setImportStatementPool(String)

 No default value
MaxPooledStatements getMaxPooledStatements()

setMaxPooledStatements(Integer)

 0
RegisterStatementPoolMonitorMBean getRegisterStatementPoolMonitorMbean()

setRegisterStatementPoolMonitorMbean(Boolean)

 false

Additional properties

The following table summarizes additional connection properties.

Property Data Source Method Default
AddTables getAddTables()

setAddTables(String)

 No default value
ConnectionRetryCount getConnectionRetryCount()

setConnectionRetryCount(Integer)

 5
ConnectionRetryDelay getConnectionRetryDelay()

setConnectionRetryDelay(Integer)

 1 (second)
DefaultQueryOptions getDefaultQueryOptions()

setDefaultQueryOptions(String)

 If no value is specified (the default), the driver uses 
startDate=30daysAgo;
endDate=yesterday
DefaultView getDefaultView()

setDefaultView(String)

 No default value
FetchSize getFetchSize()

setFetchSize(Integer)

 100 (rows)
InitializationString getInitializationString()

setInitializationString(String)

 No default value
InsensitiveResultSetBufferSize getInsensitiveResultsetBufferSize()

setInsensitiveResultsetBufferSize(Integer)

 2048 (KB of memory)
TransactionMode getTransactionMode()

setTransactionMode(String)

 NoTransactions