The CData ODBC Driver for Google Analytics is a standards-based ODBC driver with editions for Windows and Unix-based operating systems, like macOS and Linux. The following sections show how to create an ODBC data source and query data.

Creating a DSN on Your Platform

The following guides show how to use the standard tools to configure data source names (DSN).

• Windows

  Windows DSN Configuration shows how to configure a DSN with the Microsoft ODBC Administrator tool.

• macOS

  macOS DSN Configuration shows how to configure a DSN with the iODBC driver manager.

• Linux

  Linux DSN Configuration shows how to configure DSNs with several major driver managers on Linux.

Google Analytics Version Support

The driver supports both Universal Analytics and Google Analytics 4 APIs. The driver provides a relational view of the Google Analytics profiles in your Google account or across your Google Apps domain. The driver includes tables that contain often-used dimensions and metrics as columns; additionally, you can customize the table schemas or write your own to combine any valid set of dimensions and metrics. The driver exposes the columns available through the Google Analytics Management API (Universal Analytics), the Google Anlytics Core Reporting API (Universal Analytics), the Data API (Google Analytics 4) and the Admin API (Google Analytics 4). You must enable these APIs by creating a project in the Google Developers Console. See "Connecting to Google Analytics" for a guide to creating a project and authenticating to the APIs.

See Also

See the following sections to connect to the DSN from tools and from code:

• Using from Tools: Connect to the DSN from various tools on different platforms.
• Using ODBC: Connect to the DSN using the native ODBC API.
• Create a Linked Server: Connect to the DSN as a remote SQL Server database.
• MySQL Remoting: Connect to the DSN over the MySQL protocol.