Powered by Zoomin Software. For more details please contactZoomin

DataDirect ODBC ReadMe

Google Analytics 4 ODBC 8.0.0 Linux

  • Last Updated: May 8, 2026
  • 8 minute read
    • OpenAccess SDK
    • Documentation

     README
     Progress(R) DataDirect(R)
     Progress(R) DataDirect(R) for ODBC for Google Analytics 4(TM) 

     Linux 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.

***********************************************************************

This README file contains information for Progress(R) DataDirect(R)  
for ODBC for Google Analytics 4(TM). 

This README file contains information not included in the PROGRESS
DATADIRECT(R) FOR ODBC FOR Google Analytics 4(TM) DRIVER USER'S GUIDE.


CONTENTS

Post-GA Product Announcements
Requirements
Installation Directory
Data Source and Platform Support 
Release 8.0.0 Features   
Configuring Data Sources
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).


    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. 
  Also, you must set the library path environment variable of your operating 
  system to the directory containing your JVM's libjvm.so file and that 
  directory's parent directory. 
  
* The driver requires the following runtime libraries for Linux: 
  C/C++ runtime libraries version GCC 2.12 or higher 

	   
    Installation Directory 
	   
* The default installation directory for the 32-bit driver is:

  /opt/Progress/DataDirect/ODBC

* The default installation directory for the 64-bit driver is:

  /opt/Progress/DataDirect/ODBC_64Bit


    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 Release
	
Debugging Symbols
-----------------
The driver binaries now include debugging symbols that can be used 
for diagnosing and debugging issues in 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.


ICU Library Upgrade (74.1)
--------------------------
The ICU library files that are installed with the product have been upgraded to
version 74.1. In addition, the ICU library file names have changed. For the
32-bit driver, the ICU file name has changed from libivicu28.so to libivicu.so.
For the 64-bit driver, the ICU file name has changed from libddicu28.so to
libddicu.so.

This upgrade is available starting in build 08.02.0965 of the ICU library
files.

ODBC Cursor Library
-------------------
The product package no longer includes the ODBC Cursor library file 
(odbccurs.so) because it has some known security vulnerabilities that 
could potentially expose you to security risks.

Note: The installer program cannot remove the ODBC Cursor library file 
automatically while installing a new version of the driver. Remove it 
manually.

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.so, ddopenssl30.so, fips.so, 
  and openssl.cnf.
* Curl library files, such as libivcurl28.so and libddcurl28.so.  

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. 

* A Password Encryption Tool, called ddencpwd, is now included with the product
  package. It encrypts passwords for secure handling in connection strings and
  odbc.ini files. At connection, the driver decrypts these passwords and passes
  them to the data source as required.  
  
	
    Configuring Data Sources

Data sources are stored in the system information file (typically, 
odbc.ini). This file can be edited using a text editor. For details on 
configuring this file, see earlier versions of the PROGRESS DATADIRECT FOR ODBC
FOR GOOGLE ANALYTICS 4 USER'S GUIDE.
 
 
    Notes, Known Problems, and Restrictions 

The following are notes, known problems, and restrictions for the 
8.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>;).

ODBC development on Linux platforms
-----------------------------------
All of the Release 8.0 Core Components (header files, etc.) needed for 
development of ODBC applications on Linux are installed into the /include
directory created by the product installer.

Please read the notices.txt file in the installation directory for 
licensing information regarding the ODBC Core Components. Contact your 
Progress DataDirect representative if you have any questions.

Developers using programming languages other than C++:
The DataDirect ODBC Driver Manager is a C++ shared library. The ODBC 
Driver Manager can be used with any language that supports loading a 
C++ shared library; however, if you are using a programming language 
other than C++, you must take additional steps to ensure that the C++ 
libraries are initialized properly when loaded. If you are not using 
C++, consult your compiler documentation for instructions on using C++ 
shared libraries with your application.
  
LANG environment setting on Linux platforms
-------------------------------------------
A default installation of the product on Linux assumes that 
the value of the LANG environment setting is en_US. If your locale is
not set to en_US, the drivers may not return error messages properly. 
In this case, you must create a symbolic link in the 
<Install_Dir>/locale directory that has the same value as the LANG 
environment setting. This link must point to the 
<Install_Dir>/locale/en_US directory.
 
SQLDriverConnect
----------------
On UNIX, SQLDriverConnect should not use options other than SQL_DRIVER_NOPROMPT
unless your application implements its own login dialog. 
 
SQL_C_NUMERIC
-------------
Because of inconsistencies in the ODBC specification, users attempting 
to use SQL_C_NUMERIC parameters must set the precision and scale values 
of the corresponding structure and the descriptor fields in the 
Application Parameter Descriptor.
 

    Driver WorkAround Options

Progress DataDirect has included non-standard connection options
(workarounds) for the driver 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 PROGRESS DATADIRECT FOR ODBC
DRIVERS REFERENCE for a description of these options.

      
     Documentation 
	 
The driver documentation set is available from the Progress Information Hub:

https://docs.progress.com/category/datadirect-google-analytics

You can access the online help system directly via the HTML redirect in the 
installation Help directory.

  
    Installed Files for the 32-bit Driver
	 
This file list assumes a full installation of the 32-bit driver and 
documentation. 

The installer copies the following files and subdirectories to the 
product installation directory, by default:

/opt/Progress/DataDirect/ODBC:

/<install_dir>/:
----------------
odbc.csh                         Setup script for C shell
odbc.ini                         Sample odbc.ini file
odbcinst.ini                     Sample odbcinst.ini file
odbc.sh                          Setup script for Bourne shell
IVODBC.LIC                       DataDirect license file
license.txt                      End User License Agreement


/bin/:
------
ivtestlib                        Test application to check that required 
                                 libraries are present and loadable


/FIXES/:
--------
fixes8.0.txt                     List of fixes since last release


/help/:
------- 
*.html                           HTML redirects to driver help systems


/include/:
----------
odbcinst.h                       Include files
qesqlext.h
sql.h
sqlext.h
sqltypes.h
sqlucode.h
sqlunx.h


/install/:
---------
*.*                              Files associated with the installer program

/java/lib/:
----------
googleanalytics4.jar             Java components of the driver


/lib/:
------
ivgoogleanalytics428.so          DataDirect Google Analytics 4 driver  
ivtrc28.so                       DataDirect trace library
libivicu.so                      Unicode conversion tables 
libodbc.so                       ODBC Driver Manager 
libodbcinst.so                   ODBC Installer
								
								
/locale/en_US/LC_MESSAGES/:
--------------------------
ivgooogleanalytics428.mo         Google Analytics 4 driver message file
ivgoogleanalytics428.po          Google Analytics 4 driver message file source
odbc.m                           ODBC Driver Manager message file
odbc.po                          ODBC Driver Manager message source


/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                             Bulk application
bulk.c                           Bulk example source
bulk.mak                         Bulk example make file
bulk.txt                         Bulk load example readme 
ddlogging.properties             Log configuration file for the 
                                 Google Analytics 4 driver


/samples/bulkstrm/:
------------------
bulkstrm                         Bulk streaming example application
bulk.cpp                         Bulk streaming example source
bulk.hpp                         Bulk streaming example header
bulkstrm.txt                     Bulk streaming description
ddlogging.properties             Log configuration file for the
                                 Google Analytics 4 driver
main.cpp                         Bulk streaming example source file
msgprintf.hpp                    Bulk streaming example header file
streambulk.mak                   Bulk streaming example make file


/samples/example/:								  
------------------						  
example                          Example application
example.c                        Example source
example.h                        Example header
example.mak                      Example make file
ddlogging.properties             Log configuration file for the 
                                 Google Analytics 4 driver 


/samples/trn/:
--------------
makefile                         Translation Library example make file
readme.trn                       Translation Library example description
translat.c                       Translation Library example source file
								 
								 
/tools/:
--------
ddencpwd                         Password Encryption Tool
ddextu                           License Extender utility
ddprocinfo                       Processor Information utility
launch_server.sh                 Script that launches the SQL Engine in 
                                 server mode


/uninstall/:
------------
*.*                              Files used to uninstall the product
							

    Installed Files for the 64-bit Driver
	 
This file list assumes a full installation of the 64-bit driver and 
documentation. 

The installer copies the following files and subdirectories to the 
product installation directory, by default:

/opt/Progress/DataDirect/ODBC_64Bit:


/<install_dir>/:
-------------
odbc.csh                         Setup script for C shell
odbc.ini                         Sample odbc.ini file
odbcinst.ini                     Sample odbcinst.ini file
odbc.sh                          Setup script for Bourne shell
DDODBC.LIC                       DataDirect license file
license.txt                      End User License Agreement


/bin/:
------
ddtestlib                        Test application to check that required 
                                 libraries are present and loadable


/FIXES/:
--------
fixes8.0.txt                     List of fixes since last release


/help/:
------- 
*.html                           HTML redirects to driver help systems


/include/:
----------
odbcinst.h                       Include files
qesqlext.h
sql.h
sqlext.h
sqltypes.h
sqlucode.h
sqlunx.h


/install/:
---------
*.*                              Files associated with the installer program


/java/lib/:
----------
googleanalytics4.jar             Java components of the driver


/lib/:
------
ddgoogleanalytics428.so          DataDirect Google Analytics 4 driver
ddtrc28.so                       DataDirect trace library 
libddicu.so                      Unicode conversion tables
libodbc.so                       ODBC Driver Manager [.a on AIX]
libodbcinst.so                   ODBC Installer [.a on AIX]


/locale/en_US/LC_MESSAGES/:
---------------------------
ddgoogleanalytics428.mo          Google Analytics 4 driver message file
ddgoogleanalytics428.po          Google Analytics 4 driver message file source
odbc.m                           ODBC Driver Manager message file
odbc.po                          ODBC Driver Manager message source


/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                             Bulk application
bulk.c                           Bulk example source
bulk.mak                         Bulk example make file
bulk.txt                         Bulk load example readme 
ddlogging.properties             Log configuration file for the 
                                 Google Analytics 4 driver


/samples/bulkstrm/:
------------------
bulkstrm                         Bulk streaming example application
bulk.cpp                         Bulk streaming example source
bulk.hpp                         Bulk streaming example header
bulkstrm.txt                     Bulk streaming description
ddlogging.properties             Log configuration file for the
                                 Google Analytics 4 driver
main.cpp                         Bulk streaming example source file
msgprintf.hpp                    Bulk streaming example header file
streambulk.mak                   Bulk streaming example make file


/samples/example/:								  
------------------						  
example                          Example application
example.c                        Example source
example.h                        Example header
example.mak                      Example make file
ddlogging.properties             Log configuration file for the 
                                 Google Analytics 4 driver 


/samples/trn/:
--------------
makefile                         Translation Library example make file
readme.trn                       Translation Library example description
translat.c                       Translation Library example source file


/tools/:
--------
ddencpwd                         Password Encryption Tool
ddextu                           License Extender utility
ddprocinfo                       Processor Information utility
launch_server.sh                 Script that launches the SQL Engine in 
                                 server mode


/uninstall/:
------------
*.*                              Files used to uninstall the product

  
  
~~~~~~~~~~~~~~~~~
February 2026
End of README.TXT


TitleResults for “How to create a CRG?”Also Available inAlert