Google Analytics ODBC Connector

Connecting to live Google Analytics data

Connect to live Google Analytics data from reporting tools, databases and custom applications through standard drivers Integrate with BI, Reporting, Analytics, ETL Tools and Custom Solutions. This one Qlik Google Analytics Connector is part of CData ODBC Drivers. These connectors allow users to easily read and edit application, database and web API data. This connector is suitable for both Qlik Sense like QlikView, but can also be used for other tools, such as our data warehouse solution TimeXtender and other BI tools, such as PowerBI In Excel.

Overview

The CData ODBC Driver for Google Analytics is a standard ODBC driver for Windows, Mac OS X and Unix based operating systems.

You can manage it with a driver manager. Both Microsoft and Apple provide GUIs for the driver. Pre-compiled binaries for popular ODBC driver managers are available for most Unix-like operating systems. Follow the steps described in the data source name (DSN) configuration to configure a DSN. Once a DSN is configured, you can use it from various tools on your machine or even other machines in your domain.

The driver provides a relational representation of the Google Analytics profiles in your Google account or in your Google Apps domain. The driver contains tables containing frequently used dimensions and measures as columns; In addition, you can customize the table schemas or customize your own forms to combine a valid set of dimensions and measures. The driver contains the columns available through the Google Analytics Management API and the Google Anlytics Core Reporting API. You must enable these APIs by creating a project in the Google Developers Console. See Connecting to Google for a guide to creating a project and authenticating to the APIs.