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 authentication properties

The following table summarizes the connection properties required to connect to a service when using OAuth 2.0 authentication.

Table 1. Required properties
Property Data Source Method Default
AccessToken

getAccessToken()

setAccessToken(String)

 No default value
AuthenticationMethod getAuthenticationMethod()

setAuthenticationMethod(String)

 OAuth2
AuthURI

getAuthUri()

AuthUri(String)

 https://accounts.google.com/o/oauth2/auth
ClientID

getClientId()

setClientId(String)

 No default value
ClientSecret

getClientSecret()

setClientSecret(String)

No default value
RedirectURI

getRedirUri()

setRedirUri(String)

No default value
RefreshToken

getRefreshToken()

setRefreshToken(String)

 No default value
Scope

getScope()

setScope(String)

No default value
ServerName getServerName()

setServerName(String)

 analyticsdata.googleapis.com
TokenURI

getTokenUri()

setTokenUri(String)

 https://accounts.google.com/o/oauth2/token

Mapping properties

The following table summarizes the 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
KeywordConflictSuffix

getKeywordConflictSuffix()

setKeywordConflictSuffix(String)

No default value

Proxy server properties

The following table summarizes the proxy server connection properties.

Table 2. Proxy Server 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

Web service properties

The following table summarizes the web service connection properties.

Table 3. Web Service Properties
Property Data Source Method Default
StmtCallLimit getStmtCallLimit()

setStmtCallLimit(Integer)

 0 (no limit)
StmtCallLimitBehavior getStmtCallLimitBehavior()

setStmtCallLimitBehavior(String)

 errorAlways
WSRetryCount

getWSRetryCount()

setWSRetryCount(Integer)

 5
WSTimeout

getWSTimeout()

setWSTimeout(Integer)

 120

Additional properties

The following table summarizes additional connection properties.

Table 4. Additional Properties
Property Data Source Method Default
DebugRecord

getDebugRecord()

setDebugRecord(String)

No default value
DefaultQueryOptions

getDefaultQueryOptions()

setDefaultQueryOptions(String)

 No default value
FetchSize getFetchSize()

setFetchSize(Integer)

 100 (rows)
InitializationString getInitializationString()

setInitializationString(String)

 No default value
LogConfigFile getLogConfigFile()

setLogConfigFile(String)

 ddlogging.properties
SpyAttributes getSpyAttributes()

setSpyAttributes(String)

 No default value
TransactionMode getTransactionMode()

setTransactionMode(String)

 NoTransactions