Google Analytics 4 ODBC 8.0.0 Windows
- Last Updated: May 8, 2026
- 9 minute read
- OpenAccess SDK
- Documentation
README
Progress(R) DataDirect(R)
Progress(R) DataDirect(R) for ODBC for Google Analytics 4(TM)
Windows Platforms (32- and 64-bit)
Release 8.0.0
February 2026
***********************************************************************
Copyright (C) 2026 Progress Software Corporation and/or its
subsidiaries or affiliates. All Rights Reserved.
***********************************************************************
CONTENTS
Post-GA Product Announcements
Installation Directory
Requirements
Data Source and Platform Support
Release 8.0.0 Features
DataDirect ODBC Driver Configuration Manager
Notes, Known Problems, and Restrictions
Driver Workaround Options
Documentation
Installed Files for 32-bit Drivers
Installed Files for 64-bit Drivers
Post-GA Product Announcements
The readme files will no longer be updated with product announcements and new
features after the General Availability (GA) of the product. For the latest
updates and enhancements, please refer to the release notes
(https://www.progress.com/datadirect-connectors/whats-new).
Installation Directory
* The default installation directory for the 32-bit driver on a 64-bit
system is:
C:\Program Files (x86)\Progress\DataDirect\ODBC
* The default installation directory for all other installations is:
C:\Program Files\Progress\DataDirect\ODBC
Requirements
* The installer program requires a JVM that is Java SE 11 or higher, including
Oracle JDK, OpenJDK, and IBM SDK (Java) distributions.
* The driver requires a Java Virtual Machine (JVM): Java SE, version 8 or
higher, including Oracle JDK, OpenJDK, IBM SDK (Java), or higher
LTS versions.
* The driver requires the following runtime library:
Microsoft Visual C/C++ runtime version 14.40.33810 or higher
* IMPORTANT: You must have the Microsoft Data Access Components (MDAC)
installed to use this product.
- For 32-bit Windows systems, version 2.6 or higher is required.
- For 64-bit Windows systems, version 2.8 or higher is required.
Depending on the version of your Windows operating system, these
components may already be installed. You can download a utility that
determines whether MDAC is installed and its version from the following
Microsoft site:
http://msdn.microsoft.com/en-us/data/aa937730.aspx
You can also download MDAC from the same site.
Data Source and Platform Support
For the latest data source and platform support information, refer to the
Product Compatibility Guide:
https://docs.progress.com/bundle/datadirect-product-compatibility/resource/
datadirect-product-compatibility.pdf
Changes Since 8.0.0 GA
Debugging Symbols
-----------------
The product package now includes .pdb files. These files contain debugging
symbols that can be used for diagnosing and debugging issues in the driver.
Windows Runtime Version Upgrade
-------------------------------
The driver is now compiled with a Visual Studio 2022 compiler for Windows
platforms. As a result, you must have Microsoft Visual C/C++ runtime
version 14.40.33810 or higher on your machine to run the driver.
JRE Requirement for the Installer
---------------------------------
The installer program now requires you to install a JRE that is Java SE 11 or
higher before running the installer. In earlier versions, the JRE used by the
installer program was included in the product. However, to avoid potential
security vulnerabilities, the installer program no longer includes a JRE.
Instead, the installer program uses the JRE in your environment to allow for
the most secure version of a JRE to be used.
Notes:
* This change does not affect the JVM requirements for the driver. For the latest
driver requirements, refer to the Product Compatibility Guide:
https://docs.progress.com/bundle/datadirect-product-compatibility/resource/
datadirect-product-compatibility.pdf
* The installer program cannot remove the already installed JRE files from the
install directory automatically. Remove them manually.
* To install the 32-bit drivers on 64-bit Windows platforms and start the SQL
engine service, the installer requires the 32-bit version of Java SE 11 or
higher installed on your machine and defined on your path.
ICU Library Upgrade (74.1)
--------------------------
The ICU library files that are installed with the product have been
upgraded to version 74.1. As a part of this upgrade, the ICU library
file names have changed:
* For the 32-bit driver: From ivicu28.dll to ivicu.dll
* For the 64-bit driver: From ddicu28.dll to ddicu.dll
This upgrade is available starting in build 08.02.1072 of the ICU
library files.
Changes to Installation of Non-Essential Components
----------------------------------------------------
The installer program has been updated to no longer install common components
for drivers that do not use them. As a result, the installer program no longer
installs the following common components for the Google Analytics 4 driver:
* OpenSSL library files, such as ivopenssl30.dll, ddopenssl30.dll, fips.dll,
and openssl.cnf.
* Curl library files, such as ivcurl28.dll and ddcurl28.dll
If the files are not used by any other DataDirect driver on your machine, you
can safely remove them from existing product directories.
Release 8.0.0 Features
The Progress(R) DataDirect(R) for ODBC(TM) for Google Analytics 4(TM) driver
supports SQL read-only access for ODBC applications to Google Analytics using
Google Analytics 4 (GA4) Data and Admin APIs. To support SQL access to Google
Analytics services, the driver creates a relational map of the Google Analytics
data model and translates SQL statements to Google Analytics REST API requests.
In addition, the driver employs a SQL engine component that provides support to
SQL constructs unavailable in Google Analytics. This functionality offers a
number of advantages, including support for reporting data and metadata in a
form that ODBC applications are ready to use.
Features:
* Supports SQL read-only access to Google Analytics
* Supports Google Analytics 4 (GA4) Data and Admin APIs
* Supports all ODBC Core and Level 1 functions and some Level 1 and Level 2
features
* Supports Google Analytics data types
* Supports OAuth 2.0 authentication.
* Supports the handling of large result sets with paging and the Fetch Size
(FetchSize) connection option.
* On Windows platforms, the driver includes an enhanced setup dialog, the
DataDirect ODBC Driver Configuration Manager, for quick configuration and
testing of your driver. This Configuration Manager allows you to:
- Configure data sources
- Generate and edit connection strings
- Test connect data sources and connection strings
- Execute SQL commands for testing
- Add tables to a relational view of Google Analytics data
- Access connection option descriptions and the full product documentation
DataDirect ODBC Driver Configuration Manager
The driver includes a browser-based configuration tool, the DataDirect ODBC
Driver Configuration Manager, that allows you to generate and test connection
URLs that you can use with your application. You can launch the Configuration
Manager by opening the ODBC Administrator from the Progress DataDirect
program group and creating or configuring a data source for the driver.
The Configuration Manager will open in your default web browser. For more
information, refer to the user's guide for your driver.
Notes, Known Problems, and Restrictions
The following are notes, known problems, and restrictions for the
8.1.0 release of the driver:
Specifying values for the same connection option multiple times
---------------------------------------------------------------
The driver does not support specifying values for the same connection
option multiple times in a connection string or DSN. If a value is
specified using the same attribute multiple times or using both
long and short attributes, the connection may fail or the driver may
not behave as intended.
Aggregates for Date/Time Data Types
-----------------------------------
The MIN and MAX aggregates for the Date/Time data types may return incorrect
values.
Case Sensitivity in query parameters for Default Query Options option
---------------------------------------------------------------------
The query parameters in the connection option Default Query Options are case
sensitive. The recommended casing of the parameters is medial capitals
(camel case). For example, DefaultQueryOptions=(startDate=<value>;
endDate=<value>;propertyId=<value>;).
No Configuration Manager support for FILE DSNs
----------------------------------------------
The Configuration Manager does not currently support creating File DSNs. If you
attempt to add a File DSN, the Configuration Manager will create a User DSN
instead.
SQL engine Direct Mode on Windows 32-bit operating system
---------------------------------------------------------
On Windows 32-bit operating system, the SQL engine does not currently support
direct mode (SQLEngineMode=2).
Connection issues when specifying ExtendedOptions
-------------------------------------------------
When specifying a value for the Extended Options (ExtendedOptions) option in
the Configuration Manger, the driver currently adds the option and its value to
the Connection String field. However, the ExtendedOptions attribute is not
supported in Connection Strings; therefore, attempting to connect with the
generated connection string or executing a test connect with the configuration
manager will result in the an “Invalid attribute in the connection string: XO”
error.
To work around this issue, manually edit the connection string to remove
"ExtendedOptions=" from the connection string; then, specify the value of
ExtendOptions as semi-colon separated options in the string.
For example:
Driver=<driver_name>;HostName=<host_name>;ExtendedOptions=WorkArounds2=4096,
WorkArounds2=8192;
Becomes:
Driver=<driver_name>;HostName=<host_name>;WorkArounds2=4096;WorkArounds2=8192;
Driver Workaround Options
Progress DataDirect has included non-standard connection options
(workarounds) for the drivers that enable you to take full advantage of
packaged ODBC-enabled applications requiring non-standard or extended
behavior.
Refer to the chapter "WorkAround Options" in the User's Guide for a description
of these options.
Documentation
PROGRESS DATADIRECT FOR ODBC FOR MONGDB DOCUMENTATION SET
---------------------------------------------------------
The driver documentation set is available from the Progress Information Hub:
https://docs.progress.com/category/datadirectdatadirect-google-analytics
You can access the online help system directly in either of the following ways.
* Via the HTML redirect in the installation Help directory
* By selecting Help from the information menu (? button) in the Configuration
Manager
Installed Files for the 32-bit Driver
This file list assumes a full installation of the driver and
documentation.
The installer copies the following file to the Windows system
directory:
ivtrc28.dll DataDirect trace library
The installer copies the following files and subdirectories to the
product installation directory, by default:
For 32-bit drivers on 64-bit machines:
C:\Program Files (x86)\Progress\DataDirect\ODBC\:
For all other installations:
C:\Program Files\Progress\DataDirect\ODBC\:
\<install_dir>\:
----------------
license.txt Progress DataDirect license agreement
\drivers:
---------
ivgoogleanalytics428.dll DataDirect Google Analytics 4 driver
ivgoogleanalytics428.pdb Debugging symbols for DataDirect Google
Analytics 4 driver
ivgoogleanalytics428r.dll DataDirect Google Analytics 4 driver resource file
ivicu.dll Unicode conversion tables
ivicu.pdb Debugging symbols for ICU library
IVODBC.LIC DataDirect License File
ivtrc28.dll DataDirect trace library
ivtrc28.pdb Debugging symbols for DataDirect trace library
qesqlext.h Header file for DataDirect-specific
ODBC Definitions
\FIXES:
-------
fixes8.0.txt List of fixes since last release
\help\:
-------
*.html HTML redirects to online connector help systems
and documentation resources
\install\:
---------
*.* Files associated with the installer program
\java\lib\:
-----------
googleanalytics4.jar Java components for the driver
\NOTICES\:
---------
ODBC for Google Analytics 4
v8.0 notices.txt Third-party vendor license agreements
\READMES\:
---------
ODBC for Google Analytics 4
v8.0 readme.txt This file
\samples\bulk\:
---------------
bulk.c Bulk example source
bulk.exe Bulk application
bulk.mak Bulk example make file
bulk.sln Bulk example solution file
bulk.vcproj Bulk example project file
ddlogging.properties Log configuration file for
the Google Analytics 4 driver
\samples\bulkstrm\:
------------------
bulk.cpp Bulk streaming example source
bulk.hpp Bulk streaming example header
bulk.rc Bulk streaming example resource file
bulkstreaming.sln Bulk streaming example solution file
bulkstreaming.vcproj Bulk streaming example project file
bulkstrm.exe Bulk streaming example application
bulkstrm.txt Bulk streaming description
ddlogging.properties Log configuration file for the
Google Analytics 4 driver
msgprintf.hpp Bulk streaming example header file
ProgressDataDirect.bmp
ProgressDataDirect.ico
winmain.cpp Bulk streaming example source file
\samples\example\:
------------------
ddlogging.properties Log configuration file for the
Google Analytics 4 driver
example.c Example source
Example.exe Example application
example.h Example header
Example.mak Example make file
Example.sln Example solution file
Example.vcproj Example project file
\samples\translat:
-----------------
LIBMAIN.C
README.TRN Translation Library example description
TRANSLAT.C Translation Library example source file
WINNT.MAK Translation Library example make file
\tools\:
--------
ddextwin.exe License Extender utility
ddprocinfo.exe Processor Information utility
DSNConverterSil.exe Data Source Converter utility
googleanalytics4server32.exe The Google Analytics 4 driver SQL
Server Engine launcher tool
XMLP.exe A GUI demo tool that persists a result set to
an XML data file
\tools\Power BI:
----------------
DataDirectGoogleAnalytics4.pqx Google Analytics 4 Power BI connector file
install.bat Batch file to install Power BI connectors
\tools\Tableau\:
----------------
DataDirect Google Analytics 4.tdc
Tableau data source file
\uninstall\:
------------
*.* Files used to uninstall the product
Installed Files for the 64-bit Driver
This file list assumes a full installation of the driver and
documentation.
The installer copies the following file to the Windows system
directory:
ddtrc28.dll DataDirect trace library
The installer copies the following files and subdirectories to the
product installation directory, by default:
C:\Program Files\Progress\DataDirect\ODBC\:
\<install_dir>\:
----------------
license.txt Progress DataDirect license agreement
\drivers\:
----------
ddgoogleanalytics428.dll DataDirect Google Analytics 4 driver
ddgoogleanalytics428.pdb Debugging symbols for DataDirect Google
Analytics 4 driver
ddgoogleanalytics428r.dll DataDirect Google Analytics 4 driver resource file
ddicu.dll Unicode conversion tables
ddicu.pdb Debugging symbols for ICU library
DDODBC.LIC DataDirect License File
ddtrc28.dll DataDirect trace library
ddtrc28.pdb Debugging symbols for DataDirect trace library
qesqlext.h Header file for DataDirect-specific ODBC
Definitions
\FIXES:
-------
fixes8.0.txt List of fixes since last release
\help\:
-------
*.html HTML redirects to online connector help systems
and documentation resources
\install\:
---------
*.* Files associated with the installer program
\java\lib\:
-----------
googleanalytics4.jar Java components for the driver
\NOTICES\:
----------
ODBC for Google Analytics 4
v8.0 notices.txt Third-party vendor license agreements
\READMES\:
----------
ODBC for Google Analytics 4
v8.0 readme.txt This file
\samples\bulk\:
---------------
bulk.c Bulk example source
bulk.exe Bulk application
bulk.mak Bulk example make file
bulk.sln Bulk example solution file
bulk.vcproj Bulk example project file
ddlogging.properties Log configuration file for
the Google Analytics 4 driver
\samples\bulkstrm\:
------------------
bulk.cpp Bulk streaming example source
bulk.hpp Bulk streaming example header
bulk.rc Bulk streaming example resource file
bulkstreaming.sln Bulk streaming example solution file
bulkstreaming.vcproj Bulk streaming example project file
bulkstrm.exe Bulk streaming example application
bulkstrm.txt Bulk streaming description
ddlogging.properties Log configuration file for the
Google Analytics 4 driver
msgprintf.hpp Bulk streaming example header file
ProgressDataDirect.bmp
ProgressDataDirect.ico
winmain.cpp Bulk streaming example source file
\samples\example\:
------------------
ddlogging.properties Log configuration file for the
Google Analytics 4 driver
example.c Example source
Example.exe Example application
example.h Example header
Example.mak Example make file
Example.sln Example solution file
Example.vcproj Example project file
\samples\translat:
-----------------
LIBMAIN.C
README.TRN Translation Library example description
TRANSLAT.C Translation Library example source file
WINNT.MAK Translation Library example make file
\tools\:
-------
ddextwin.exe License Extender utility
ddprocinfo.exe Processor Information utility
DSNConverterSil.exe Data Source Converter utility
googleanalytics4server64.exe The Google Analytics 4 driver SQL Server
Engine launcher tool
XMLP.exe A GUI demo tool that persists a result set to
an XML data file
\tools\Power BI:
----------------
DataDirectGoogleAnalytics4.pqx Google Analytics 4 Power BI connector file
install.bat Batch file to install Power BI connectors
\tools\Tableau\:
----------------
DataDirect Google Analytics 4.tdc
Tableau data source file
\uninstall\:
------------
*.* Files used to uninstall the product
~~~~~~~~~~~~~~~
February 2026
End of README.TXT