README
     Progress(R) DataDirect(R)
     Progress(R) DataDirect(R) for ODBC for Google BigQuery(TM)

     UNIX and Linux Platforms(32- and 64-bit) 

     Release 8.0.0 
     October 10, 2019


***********************************************************************
Copyright (C) 2019 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 BigQuery(TM) Driver. 

This README file contains information not included in the PROGRESS
DATADIRECT(R) FOR ODBC FOR GOOGLE BIGQUERY DRIVER USER'S GUIDE.


CONTENTS

Driver Requirements
Installation Directory 
Release 8.0.0 Features
Required Operating System Patches
Configuring Data Sources
Notes, Known Problems, and Restrictions
Driver WorkAround Options
Documentation 
Installed Files for 32-bit Drivers
Installed Files for 64-bit Drivers


	Driver Requirements

The driver requires a Java Virtual Machine (JVM) that is Java SE 8 or higher,
including Oracle JDK, OpenJDK, and IBM SDK (Java) distributions. Also,
you must set the library path environment variable of your operating system
to the directory containing your JVM's libjvm.so [sl | a] file and that
directory's parent directory. 

	   
    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


   Release 8.0.0 Features  

The Progress DataDirect for ODBC for Google BigQuery driver supports both 
standard and legacy SQL dialects of Google BigQuery. It supports create, read, 
update, and delete operations in internal tables (stored inside Google
BigQuery) and read operations in external tables (stored in data sources 
outside Google BigQuery). In addition, the driver:

* Serves as a complete pass-through driver, leveraging the SQL engine 
  functionality of Google BigQuery to execute SQL queries.
  
* Returns data for complex data types, such as Array and Struct, as JSON 
  strings, which are easy to comprehend for ODBC applications.
  
* Provides proxy support using ProxyHost, ProxyPassword, ProxyPort, and 
  ProxyUser connection properties.

* Supports the handling of large result sets with configurable paging and the 
  FetchSize and WSFetchSize connection properties. 
  
 
    Required Operating System Patches

For HP-UX 11 aCC Users Only
---------------------------
The ODBC drivers for HP-UX 11 aCC are supported on HP-UX 11.0
when running with HP-UX applications built using the HP aCC 
compiler version 3.05 or higher.

The ODBC drivers require certain runtime library patches. HP-UX 
patches are publicly available from the HP Web site (www.hp.com). The 
required patch is:

PHSS_14577

HP updates the patch database regularly; therefore, the patch 
numbers in this file may be superseded by newer versions. If you 
search for any of the specified patches on an HP site and receive 
a message that a patch has been superseded, download and install 
the replacement patch.

 
 Configuring Data Sources

Data sources are stored in the system information file (typically, 
odbc.ini). For details on configuring this file, see the PROGRESS DATADIRECT
FOR ODBC FOR GOOGLE BIGQUERY DRIVER USER'S GUIDE.
 
 
	Notes, Known Problems, and Restrictions 

The following are notes, known problems, and restrictions for the 
8.0 release of the driver:

* For metadata calls, the driver returns catalog as null and schema 
  in catalog.schema format. For example, for the following call: 
  getTables(p1,d1,t1,null), where p1 is project, d1 is dataset, and t1 is table,
  the driver will return catalog as null and schema as p1.d1. Note that  
  catalog and schema are equivalent to project and dataset in 
  Google BigQuery.

* If the file type of the private key file used for service account 
  authentication is .p12, the authentication will fail, unless the 
  skipDDPKIProvider system property is set to true.

* The driver will potentially assemble an unusable CLASSPATH when 
  there are multiple drivers installed and the underlying framework's
  version is different in each of the jars when JVMClassPath argument is
  not pointed to the required jar.
 

    Driver WorkAround Options

Progress DataDirect has included non-standard connection options
(workarounds) for the Google BigQuery driver that enable you to
take full advantage of packaged ODBC-enabled applications 
requiring non-standard or extendedbehavior.
Refer to the chapter "WorkAround Options" in THE PROGRESS DATADIRECT
FOR ODBC GOOGLE BIGQUERY DRIVER USER'S GUIDE for a description of 
these options.

      
     Documentation

THE PROGRESS DATADIRECT FOR ODBC FOR GOOGLE BIGQUERY DRIVER 
USER'S GUIDE
------------------------------------------------------------	 
The User's Guide is provided in PDF and HTML versions. Both versions
are installed in the GoogleBigQueryHelp subdirectory of your product 
installation directory. You can access the HTML help by opening the index.html
file. The PDF version, which you can view using Adobe Reader, can be viewed by 
opening the bigqueryodbcuser.pdf file.

NOTE: To download Adobe Reader, visit the Adobe Web site at 
http://www.adobe.com.

  
    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:


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
fixes.txt                         List of fixes since last release
license.txt                       End User License Agreement

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


/help/GoogleBigQueryHelp:
index.html                        HTML help system entry file
bigqueryodbcuser.pdf              PDF copy of the User's Guide
*.*                               Support folders for the HTML help system

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

/java/lib:
googlebigquery.jar                Java components of the driver

/lib:
The following library files all have the extension .so, except when 
installed on HP-UX PA-RISC, in which case the extension is .sl.

ivgbq28.so                        DataDirect Driver for Google BigQuery 
ivtrc28.so                        Progress DataDirect trace library
libddcurl28.so                    Library used for HTTP connections  [.a on AIX]
libivicu28.so                     Unicode conversion tables  [.a on AIX]
libivmbackw.so                    SQLDriverConnect Motif library 
libodbc.so                        ODBC Driver Manager [.a on AIX]
libodbcinst.so                    ODBC Installer [.a on AIX]
odbc.so                           ODBC Driver Manager (dynamically loadable) 
                                  [AIX only]
odbccurs.so                       ODBC Cursor library 
odbcinst.so                       ODBC Installer (dynamically loadable) 
                                  [AIX only]
vscnctdlg.so                      ODBC library for Motif operations

/locale/en_US/LC_MESSAGES:
ivmbackw.mo                       Motif library message file
ivmbackw.po                       Motif library message source
ivgbq28.mo                        Google BigQuery driver message file
ivgbq28.po                        Google BigQuery driver message file source
odbc.m                            ODBC Driver Manager message file
odbc.po                           ODBC Driver Manager message source

/NOTICES:
ODBC for Google BigQuery 
v8.0 notices.txt                  Third-party vendor license agreements	

/READMES:
ODBC for Google BigQuery 
v8.0 readme.txt                   This file

/samples:
/example/example                  Example application
/example/example.c                Example source
/example/example.h                Example header
/example/example.mak              Example make file

/tools:
ddextu                            License Extender utility
ddprocinfo                        Processor Information utility

/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:

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
fixes.txt                         List of fixes since last release
license.txt                       End User License Agreement

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

/help/GoogleBigQueryHelp:
index.html                        HTML help system entry file
bigqueryodbcuser.pdf              PDF copy of the User's Guide
*.*                               Support folders for the HTML help system

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

/java/lib:
googlebigquery.jar                Java components of the driver



/lib:
The following library files all have the extension .so, except when 
installed on HP-UX PA-RISC, in which case the extension is .sl.

ddgbq28.so                        DataDirect Driver for Google BigQuery 
ddtrc28.so                        Progress DataDirect trace library
libddcurl28.so                    Library used for HTTP connections  [.a on AIX]
libddicu28.so                     Unicode conversion tables  [.a on AIX]
libddmbackw.so                    SQLDriverConnect Motif library 
libodbc.so                        ODBC Driver Manager [.a on AIX]
libodbcinst.so                    ODBC Installer [.a on AIX]
odbc.so                           ODBC Driver Manager (dynamically loadable) 
                                  [AIX only]
odbccurs.so                       ODBC Cursor library 
odbcinst.so                       ODBC Installer (dynamically loadable) 
                                  [AIX only]
vscnctdlg.so                      ODBC library for Motif operations

/locale/en_US/LC_MESSAGES:
ddmbackw.mo                       Motif library message file
ddmbackw.po                       Motif library message source
ddgbq28.mo                        Google BigQuery driver message file
ddgbq28.po                        Google BigQuery driver message file source
odbc.m                            ODBC Driver Manager message file
odbc.po                           ODBC Driver Manager message source

/NOTICES:
ODBC for Google BigQuery 
v8.0 notices.txt                  Third-party vendor license agreements	

/READMES:
ODBC for Google BigQuery 
v8.0 readme.txt                   This file

/samples:
/example/example                  Example application
/example/example.c                Example source
/example/example.h                Example header
/example/example.mak              Example make file

/tools:
ddextu                            License Extender utility
ddprocinfo                        Processor Information utility

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



~~~~~~~~~~~~~~
October 10, 2019
End of README.TXT