ODBC provides a method for specifying connection information via a connection string and the SQLDriverConnect API. This section provides examples of connection strings configured to use common features and functionality. You can modify and/or combine these examples to create a connection string for your environment.

In addition to the connection strings for DSN-less connections demonstrated in this section, the driver supports DSN and File DSN connection strings. See "Using a connection string" for syntax and detailed information for supported connection string types.

Note: Although you can still connect to Google Analytics, you cannot query your data without defining the tables in your schema using the Add Tables (AddTables) option. You can generate a value for this option using the Configure Logical Schema button in the Configuration Manager and copy it into your string. See Configuring data sources with the Configuration Manager for details.
Note: The options and values described in this section apply to all configuration methods.

OAuth 2.0 authentication

This following strings demonstrate the basic options used to connect using OAuth 2.0 authentication.

Refresh token flow

DRIVER=DataDirect 8.0 Google Analytics 4;AddTables='{myTableDefinitionString}';
       ClientID=ab123c45-def6-7g89-gh1i-m2345no67891.apps.googleusercontent.com;
       ClientSecret=12a3=bCD/EfGh4Ijk+Lm5P67qR8s=//TuV+WXy1Zabcd;
       RefreshToken=1//12a3=bCD/EfGh4Ijk+Lgd8g-44tk3c527831;[attribute=value[;...]]

For more information on these options and values, see OAuth 2.0 Authentication.

Proxy server

This string includes the properties used to connect to a Proxy Server with OAuth 2.0 authentication. 
DRIVER=DataDirect 8.0 Google Analytics 4;AddTables='{myTableDefinitionString}';
       ProxyHost=pserver;ProxyPassword=secret;ProxyPort=808;ProxyUser=proxy_user;
       ClientID=ab123c45-def6-7g89-gh1i-m2345no67891.apps.googleusercontent.com;
       ClientSecret=12a3=bCD/EfGh4Ijk+Lm5P67qR8s=//TuV+WXy1Zabcd;
       RefreshToken=1//12a3=bCD/EfGh4Ijk+Lgd8g-44tk3c527831;[attribute=value[;...]]
For more information on these options and values, see Proxy server options.