Limitations and Requirements

• OAuth 2.0 authentication is required. 

  • An OAuth 2.0 web client must be available for use in the

    D s webapp
    type Portal

    . 

  • You cannot create OAuth 2.0 connections via API.

• The following schema is supported: UniversalAnalytics.

  Tip
  Tip: This schema was previously called GoogleAnalytics by the driver vendor.

  
  

• D s conntype
  type google_analytics

   allows up to 10 metrics and seven dimensions in a single query.

  • When issuing a query that selects all columns, only the default Metric columns are selected for tables with more than 10 Metrics.

  • The default Dimensions are used unless you explicitly select other dimension columns.

• All reports in

  D s conntype
  type google_analytics

   must cover a specific date range.

  • The default behavior is to pull the last month of data if the StartDate and EndDate inputs are left unset.

  • To override this behavior, the values can be set directly in the query.

Create Connection

via

D s webapp
type Portal

When you create the connection, please review the following properties and specify them accordingly:

Timeout=0;SupportEnhancedSQL=true;

For more information, see the driver documentation http://cdn.cdata.com/help/DAG/jdbc/default.htm.

Connect String Options

Enhanced SQL

By default, the following connect string options is included. This option enables an enhanced form of SQL support for the connection.

SupportEnhancedSQL=true;

When this feature is enabled:

• In-memory processing that is handled by default in the querying application (

  D s webapp
  type Portal

  ) is passed to Google Analytics for processing. 
• This feature enables the use of advanced SQL expressions, such as the use of more predicates, joins, and aggregations.

For more information on enhanced SQL for Google Analytics, see https://cdn.cdata.com/help/DAG/jdbc/RSBGoogleAnalytics_p_SupportEnhancedSQL.htm.

Data Type Conversions

For more information, see the driver documentation http://cdn.cdata.com/help/DAG/jdbc/.

Example queries:

To import data from Google Analytics, you typically create a custom SQL SELECT statement. Example:

SELECT distinct Date, Sessions, NewUsers, BounceRate, PageviewsPerSession, AvgSessionDuration, Browser, FROM GoogleAnalytics.Traffic where StartDate = '90DaysAgo' and EndDate ='Today'

• Do not apply quotes, double-quotes, or brackets around field or table values.
• Literal values should be in single quotes.
• StartDate and EndDate parameters can be used to specify a date range.
  
  • You can also use date literal functions to specify date ranges. For more information, see http://cdn.cdata.com/help/DAG/jdbc/pg_dateliteralfunctions.htm.

For more information:

• SQL syntax: http://cdn.cdata.com/help/DAG/jdbc/pg_overview.htm
• SQL examples: http://cdn.cdata.com/help/DAG/jdbc/pg_retrievingdata.htm