Google Analytics ODBC Driver

Table of Contents:

Overview

Progress DataDirect’s ODBC Driver for Google Analytics offers a high-performing, secure and reliable connectivity solution for ODBC applications to access Google Analytics data. Our ODBC driver can be easily used with SQL across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX. Enjoy real-time analytics, reporting and business intelligence (BI) capabilities with your favorite tools such as Tableau, Power BI, Qlik, Excel, Cognos, Informatica, SAS, Board, MicroStrategy, SSIS, Oracle OBIEE and more.

Supports Google Analytics Management API version 3
Creates a relational map of the Google Analytics data model and translates SQL statements to Google Analytics REST API requests
Uses ODBC industry standards for fast, real-time access

Features

Fast

Superfast data loading and extraction that reduces the time and cost of running enterprise infrastructures

Built-in Caching

The Salesforce driver can implement a client-side data cache for improved performance. For maximum flexibility, driver caches data on a per-table basis, as opposed to results from specific queries. Caching data on a table level allows the caches to be queried, filtered, and sorted in other queries. Once a cache is created, its use is transparent to the application.

Enterprise Features

Extensive support of data types to enable the full use of Greenplum functionality

Secure

Supports the latest TLS protocols for data encryption, secure authentication methods for connections and HTTP Proxy for client security while connecting to cloud deployments

Robust

Ensure high availability via application failover and workload balancing without changing application code

Easy to Use

True standards compliance with ODBC and JDBC

Versatile

Supported on every major platform and certified to work with leading applications such as Power BI, Tableau, Informatica, Cognos, SAS, Business Objects and more

Technical Specifications

Progress DataDirect for ODBC for Google Analytics
Version 8.0.0
(32- and 64-bit drivers are available for all supported databases and platforms unless otherwise noted.)