README
     Progress (R) DataDirect (R)

     Progress(R) DataDirect(R) for ODBC for Oracle Service Cloud(TM) Driver

     UNIX and Linux Platforms (32-bit and 64-bit)
     Release 7.1.6
     November 15, 2017


***********************************************************************
Copyright (C) 1990-2016 Progress Software Corporation and/or its 
subsidiaries or affiliates. All Rights Reserved. 
***********************************************************************


CONTENTS

Driver Requirements
Installation Directory 
Changes Since 7.1.6 GA
Changes for 7.1.6 GA
Progress DataDirect for ODBC for Oracle Service Cloud Driver
Required Operating System Patches
Notes, Known Problems, and Restrictions
Driver Work Around Options 
Documentation
Installed Files for the 32-bit Driver
Installed Files for the 64-bit Driver
Documentation Third-Party Acknowledgements 


    Driver Requirements 

The driver requires a Java Virtual Machine (JVM): J2SE 5 or higher. 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_71_32bit

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

  /opt/Progress/DataDirect/ODBC_71_64bit

If you do not have /opt directory permissions, the installer program installs
the driver to your home directory by default. For example, the directory for
32-bit installation would be:

  /<home_directory>/Progress/DataDirect/ODBC_71_32bit

where

  <home_directory>
  
  is the home directory for the user who is installing the product. 
  
 
    Changes Since 7.1.6 GA

Certifications
--------------
* Certified with Red Hat Enterprise 7.3 (driver version 007.15.0115
  (B0214, U0150))
* Certified with Debian Linux 7.11, 8.5 (driver version 07.15.0115 
  (B0214, U0150))
* Certified with Ubuntu Linux 14.04, 16.04 (driver version 07.15.0115 
  (B0214, U0150))
* Certified with Oracle RightNow CX API version 1.2 against sites whose version
  is May 2016.* (driver version 07.15.0132 (B0252, U0174, J000135))	
	
NamedIDBehavior Config Option
-----------------------------
The new NamedIDBehavior config option allows you to determine whether the 
Name attribute of NamedID fields is exposed in the relational map. This 
option can be used to avoid "poor performing query" errors by reducing 
the size of result sets. For details, see "'Poor Performing Query' Error 
Message" and "NamedIDBehavior Config Option" in "Notes, Known Problems, 
and Restictions." 

Refer to the fixes.txt file in the product installation directory for a list of
changes by build number. 


    Changes for 7.1.6 GA
	
Version Certications 
--------------------
* The driver has been certified with Oracle RightNow CX API version 1.2 against
  sites whose version is May 2015.

New Operating System Support
---------------------------- 	
* Certified with Red Hat Enterprise 7.1 
* Certified with CentOS Linux 7.1  
* Certified with Oracle Linux 7.1 
* Certified with SUSE Enterprise Server 12 	

Min Long Varchar
----------------
The new Min Long Varchar Size connection option allows you to fetch
SQL_LONGVARCHAR columns whose size is smaller than the minimum
imposed by some third-party applications.

Varchar Threshold 
-----------------
The new Varchar Threshold connection option allows you to fetch columns
that would otherwise exceed the upper limit of the SQL_VARCHAR type for some
third-party applications. 

For more information about these features, refer to THE PROGRESS DATADIRECT FOR
ODBC FOR ORACLE SERVICE CLOUD DRIVER USER'S GUIDE AND REFERENCE.

 
    Progress DataDirect for ODBC for Oracle Service Cloud Driver

Progress DataDirect for ODBC for Oracle Service Cloud driver supports 
standard SQL query language to provide read-only access to data managed by
the Oracle RightNow CX Cloud Service. The driver maps the Oracle Service Cloud
data model to a set of relational tables and uses a client-side data cache
for improved performance.

In addition:

* The driver supports Oracle RightNow CX API version 1.2 against sites
  whose version is February 2014, May 2014, or August 2014.

* The driver supports all ODBC Core functions. 

* The driver supports the core SQL-92 grammar.

* The driver supports the following data types:
  - BASE_64_BINARY    maps to SQL_LONGVARBINARY
  - BOOLEAN           maps to SQL_BIT
  - DATE              maps to SQL_TYPE_DATE
  - DATETIME          maps to SQL_TYPE_TIMESTAMP
  - DECIMAL           maps to SQL_DOUBLE
  - ID                maps to SQL_BIGINT
  - INTEGER           maps to SQL_INTEGER
  - LONG              maps to SQL_BIGINT
  - LONGTEXT          maps to SQL_LONGVARCHAR
  - STRING            maps to SQL_VARCHAR


    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 ORACLE SERVICE CLOUD DRIVER USER'S GUIDE AND REFERENCE.


    Notes, Known Problems, and Restrictions

	
"Poor Performing Query" Error Message
-------------------------------------
Oracle Service Cloud returns a "Poor performing query" error when executing 
certain queries with the driver. This typically occurs when executing a query 
that requires the Oracle Service Cloud service to perform join operations on 
tables containing a large number of rows. We are currently working on a 
permanent solution to this problem; however, in the interim, you can work 
around this issue by doing the following:

1. Configure the following connection options to the values provided:

   ConfigOptions
   -------------
   Note: In addition to specifying the following recommended value, include any
   other value-pairs that you currently specify for ConfigOptions. These 
   value-pairs should be specified within the curly brackets in a 
   comma-separated list.
   
   Value: {NamedIDBehavior=2}
   
   CreateDB
   --------
   Value: 1 (ForceNew)
   
   EnablePagingWithOrderByID
   -------------------------
   Value: 1 (Enabled)
   Note: This is the default value for this option.
   
   Refer to "Configuring and Connecting to Data Sources" in the User's Guide 
   and Reference for information on configuring connection options for your 
   data source.
   
2. Connect to your Oracle Service Cloud instance. At connection, the driver
   deletes the current local map files and creates new files using the updated
   config option settings.
   
3. Change the value of CreateDB to your preferred setting before your next 
   connection. We recommend specifying a value of 2 (NotExist).

4. Test your settings by executing a query that previously returned the error.
   Based on the results, choose one of the following:
   - If you receive the "Poor Performing Query" error, proceed to the 
     next step.
   - If your query is successfully returned, skip to the "Results" section.  
   
5. Tune the driver's fetching behavior. Using the WSFetchSize option, decrease
   the number of rows the driver attempts to fetch until the 
   "Poor Performing Query" error is no longer returned. For optimal 
   performance, configure WSFetchSize so that the driver returns the maximum
   number of rows possible without returning the error. For example, if you 
   receive the error fetching 500 rows, but not 499 rows, set WSFetchSize=499 
   for maximum throughput.  
   Be aware that decreasing the fetch size can increase the number of web 
   service calls the driver makes to the Oracle Service Cloud service. If your 
   query exceeds the statement call limit, increase the number of rows fetched 
   using WSFetchSize or increase the statement call limit using the 
   StatementCallLimit option to work around this issue.
   
   Notes: 
   * You will need to disconnect and reconnect for changes to connection option
     values to have effect.
   * In the default setting, WSFetchSize=0, the driver uses the maximum page 
     size allowed by the database to determine the number of rows it attempts 
     to fetch for Oracle Service Cloud versions August 2014 or later. For 
     versions earlier than August 2014, the driver attempts to fetch a maximum
     of 10,000 rows.
	 
Results: 
This configuration will allow you to avoid the "Poor performing query" error in
subsequent connections. If you begin receiving the error again, tune the 
WSFetchSize connection option according to the guidelines provided in step 4.

NamedIDBehavior Config Option 
-----------------------------
NamedIDBehavior

Attribute:
NamedIDBehavior

Purpose:
Determines whether the Name attribute of NamedID fields is exposed in the 
relational map. 

Valid Values:
1 | 2 

The value for this option is specified as a key=value pair in the 
ConfigOptions value. 

Behavior:
If set to 1, the driver exposes the Name attribute of the NamedID fields in 
the relational model. Specify this setting if your application needs to 
access the Name strings associated with NamedID columns. 

If set to 2, the driver does not expose the Name attribute of the NamedID 
fields in the relational model. This setting can be used to avoid "poor 
performing query" errors received when executing SELECT * queries against
tables containing a large number of rows.

Default:
1

Notes:
- If you are receiving "poor performing query" errors, you can work around 
  this issue by setting NamedIDBehavior=2. This reduces the size of the 
  result set, allowing the Oracle Service Cloud service to successfully 
  return the query. For this change to have effect, you will need recreate 
  the local mapping files by setting CreateDB=1; then, connecting to your 
  Oracle Service Cloud instance. After creating your new local mapping files, 
  you should reconfigure CreateDB to your preferred setting. We recommend a 
  setting of CreateDB=2. For more information, see "Poor Performing 
  Query errors."
	
Querying the CreatedTime and Updated Time fields on Custom Objects
------------------------------------------------------------------
Although the CreatedTime and UpdatedTime fields on custom objects map to the 
relational view, you cannot query against them unless you enable the 
fields within the Object Designer in the Oracle Service Cloud admin tool. 

Querying File Attachments for Sub-Objects
------------------------------------------
Queries against file attachments for sub-objects fail to retrieve the 
attachment data.

Creating Views With Two-Part Names
----------------------------------
The driver returns an invalid schema error when creating a view using a 
two-part name in the view definition.

Drop Cache Statement
--------------------
In some situations, the driver reports that executing a DROP CACHE statement
completed successfully without dropping the cache.
 
ODBC Development on UNIX and Linux Platforms
--------------------------------------------
All of the Release 7.1 Core Components (header files, etc.) needed for 
development of ODBC applications on UNIX and 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 UNIX and Linux Platforms
----------------------------------------------------
A default installation of the product on UNIX and 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.

SQLColAttribute(s)
------------------
The column attributes 1001 and 1002, which were assigned as 
DataDirect-specific attributes, were inadvertently used as system 
attributes by the Microsoft 3.0 ODBC implementation. Applications 
using those attributes must now use 1901 and 1902, respectively.

SQLDriverConnect
----------------
SQLDriverConnect using options other than SQL_DRIVER_NOPROMPT is 
supported only on systems that include the Motif libraries 
libivmback.so or libddmback.so and vscnctdlg.so.

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.

For AIX Users
------------------------------
Some IBM AIX C compilers, such as xlc 3.1.4, do not support the use 
of C++ build binaries. C developers on AIX should consult their 
compiler documentation and verify that their AIX C compiler supports 
the use of C++ shared libraries or the application could be unstable.

Unexpected behavior may occur randomly if the LIBPATH variable 
exceeds 178 characters AND the ORACLE_HOME variable is relatively 
long. To resolve this, create a shorter symbolic link for 
ORACLE_HOME.


    Driver WorkAround Options

Progress DataDirect has included non-standard connection options
(workarounds) for the Oracle Service Cloud 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 ORACLE SERVICE CLOUD DRIVER USER'S GUIDE AND REFERENCE for a 
description of these options.


    Documentation	 	 

THE PROGRESS DATADIRECT FOR ODBC FOR 
ORACLE SERVICE CLOUD DRIVER USER'S GUIDE AND REFERENCE
------------------------------------------------------
THE PROGRESS DATADIRECT FOR ODBC FOR ORACLE SERVICE CLOUD DRIVER USER'S 
GUIDE AND REFERENCE is provided in PDF and HTML versions. The PDF version is 
available on the Progress DataDirect Web site.

You can view this version using Adobe Reader. 

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

The HTML versions of the book is installed in the OSCHelp subdirectory of 
your product installation directory. You can access the help by opening the 
index.html file.


    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_71_32bit	

If you do not have /opt directory permissions, the installer program installs
the driver to your home directory by default. For example, the directory for
32-bit installation would be:

  /<home_directory>/Progress/DataDirect/ODBC_71_32bit

where

  <home_directory>
  
  is the home directory for the user who is installing the product. 


fixes.txt             List of fixes since last release 
license.txt           Progress DataDirect license agreement            
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	          

/adminhelp:           [Linux only]

help.html            Administrator HTML help system entry file 
wwhsec.htm           HTML help system support file
unixadmin*.*         Content files for the HTML help system 

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

/help/OSCHelp:
index.html           HTML help system entry file [Linux only]
wwwhsec.htm          HTML help system support file
/*.*                 Support folders for the HTML help system 
rightnow_connect.txt Help text for the Oracle Service Cloud driver 
                     SQLDriverConnect dialog 	
          
/include:
odbcinst.h            Include files
qesqlext.h
sql.h
sqlext.h
sqltypes.h
sqlucode.h
sqlunx.h

/java/lib:
rightnow.jar         Java components for the Oracle Service Cloud driver

/lib:
The following library files have the extension, .so, except for files 
installed on HP-UX PA-RISC, which have the extension .sl.

Resource library file names end in r; setup library file names end in s. 
The resource and setup libraries are for use by the LINUX ODBC 
Administrator and appear in the file list ONLY on Linux platforms

ivrnow27.so           Oracle Service Cloud driver
ivtrc27.so	  Progress DataDirect trace library
ivtrn27.so            Progress DataDirect sample translation library
libivicu27.so         Unicode conversion tables [.a on AIX]
libivssl27.so         SSL support file (OpenSSL library 
                      version 1.0.2f) [.a on AIX]
libivmback.so         SQLDriverConnect Motif library [.a on AIX] 
libivmbackw.so        SQLDriverConnect Motif library [.a on AIX] 
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

/OpenSSL/1.0.0r/libivssl27.so  SSL support file (OpenSSL library 
                               version 1.0.0r) [.a on AIX] 

/OpenSSL/1.0.2d/libivssl27.so  SSL support file (OpenSSL library 
                               version 1.0.2d) [.a on AIX] 

/OpenSSL/1.0.2f/libivssl27.so  SSL support file (OpenSSL library 
                               version 1.0.2f) [.a on AIX] 

/locale/en_US/LC_MESSAGES:
ivmback.mo            Motif library message file
ivmback.po            Motif library message source
ivmbackw.mo	      Motif library message file
ivmbackw.po	      Motif library message source
ivrnow.mo	      Oracle Service Cloud library message file
ivrnow.po	      Oracle Service Cloud library message source
odbc.m                ODBC Driver Manager message file
odbc.po		      ODBC Driver Manager message source

/NOTICES:
ODBC for 
Oracle Service Cloud
v7.1.6 notices.txt    Third-party vendor license agreements

/READMES:
ODBC for 
Oracle Service Cloud
v7.1.6 readme.txt     This file

/samples:
/bulk/bulk                  Bulk application
/bulk/bulk.c                Bulk example source
/bulk/bulk.mak              Bulk example make file
/bulk/bulk.txt              Bulk example description
/bulk/ddlogging.properties  Log configuration file for the 
	                    Oracle Service Cloud driver

/bulkstrm/bulk.cpp          Bulk streaming example source
/bulkstrm/bulk.hpp          Bulk streaming example header
/bulkstrm/bulkstrm          Bulk streaming example application
/bulkstrm/bulkstrm.txt      Bulk streaming example description
/bulkstrm/main.cpp          Bulk streaming example source
/bulkstrm/msgprintf.hpp     Bulk streaming example header
/bulkstrm/streambulk.mak    Bulk streaming example make file
/bulkstrm/ddlogging.properties    Log configuration file for the 
                                  Oracle Service Cloud driver

/example/example            Example application
/example/example.c          Example source
/example/example.h          Example header
/example/example.mak        Example make file
/example/example.txt        Example description
/example/ddlogging.properties     Log configuration file for the 
                                  Oracle Service Cloud driver

/trn/makefile               Translation Library example make file
/trn/readme.trn             Translation Library example description
/trn/translat.c             Translation Library example source file
/trn/ivtrn27.exp            Translation shared library export file 
                            [AIX only]

/tools:
ddextu                    License Extender utility
ddprocinfo                Processor Information utility
odbcadmin                 ODBC Data Source Administrator [Linux only]
/oracle/genclntsh816      Oracle 8.1.6 shared library creation script 
                          [HP-UX 11 PA-RISC only]

/uninstall/*.*            Files used to uninstall the product
						  
/wizards:
index.html
odbcperf.jar              Performance wizard
/images/*.*						  


	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_71_64bit

If you do not have /opt directory permissions, the installer program installs
the driver to your home directory by default. For example, the directory for
64-bit installation would be:

  /<home_directory>/Progress/DataDirect/ODBC_71_64bit

where

 <home_directory>
  
  is the home directory for the user who is installing the product. 


fixes.txt            List of fixes since last release 
license.txt          Progress DataDirect license agreement  
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

/adminhelp:           [Linux only]
help.html            Administrator HTML help system entry file 
wwhsec.htm           HTML help system support file
unixadmin*.*         Content files for the HTML help system 

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

/help/OSChelp:
index.html           HTML help system entry file 
/*.*                 Support folders for the HTML help system 
rightnow_connect.txt Help text for the Oracle Service Cloud driver 
                     SQLDriverConnect dialog					 
					 
/include:
odbcinst.h            Include files
qesqlext.h
sql.h
sqlext.h
sqltypes.h
sqlucode.h
sqlunx.h
					 
/java/lib:
rightnow.jar         Java components for the Oracle Service Cloud driver

/lib:
Resource library file names end in r; setup library file names end in s. 
The resource and setup libraries are for use by the LINUX ODBC 
Administrator and appear in the file list ONLY on Linux platforms.
					 
ddrnow27.so           Oracle Service Cloud driver
ddtrc27.so	  Progress DataDirect trace library
ddtrn27.so            Progress DataDirect sample translation library
libddicu27.so         Unicode conversion tables [.a on AIX]
libddssl27.so         SSL support file (OpenSSL library 
                      version 1.0.2f) [.a on AIX]
libddmback.so         SQLDriverConnect Motif library [.a on AIX] 
libddmbackw.so        SQLDriverConnect Motif library [.a on AIX] 
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	

/OpenSSL/1.0.0r/libddssl27.so  SSL support file (OpenSSL library 
                               version 1.0.0r) [.a on AIX] 

/OpenSSL/1.0.2d/libddssl27.so  SSL support file (OpenSSL library 
                               version 1.0.2d) [.a on AIX]  
	
/OpenSSL/1.0.2f/libddssl27.so  SSL support file (OpenSSL library 
                               version 1.0.2f) [.a on AIX]			 
					 
/locale/en_US/LC_MESSAGES:
ddmback.mo            Motif library message file
ddmback.po            Motif library message source
ddmbackw.mo           Motif library message file
ddmbackw.po           Motif library message source
ddrnow27.mo           Oracle Service Cloud driver message file
ddrnow27.po           Oracle Service Cloud driver message file source
odbc.m                ODBC Driver Manager message file
odbc.po		      ODBC Driver Manager message source					 

/NOTICES:
ODBC for
Oracle Service Cloud
v7.1.6 notices.text   Third-party vendor license agreements	

/READMES:
ODBC for
Oracle Service Cloud
v7.1.6 readme.txt     This file

/samples:
/bulk/bulk                      Bulk application
/bulk/bulk.c                    Bulk example source
/bulk/bulk.mak                  Bulk example make file
/bulk/bulk.txt                  Bulk example description
/bulk/ddlogging.properties      Log configuration file for the 
			  Oracle Service Cloud driver

/bulkstrm/bulk.cpp        	Bulk streaming example source
/bulkstrm/bulk.hpp        	Bulk streaming example header
/bulkstrm/bulkstrm        	Bulk streaming example application
/bulkstrm/bulkstrm.txt    	Bulk streaming example description
/bulkstrm/main.cpp        	Bulk streaming example source
/bulkstrm/msgprintf.hpp   	Bulk streaming example header
/bulkstrm/streambulk.mak  	Bulk streaming example make file
/bulkstrm/ddlogging.properties  Log configuration file for the 
                                Oracle Service Cloud driver

/example/ddlogging.properties	Log configuration file for 
                              the Oracle Service Cloud driver
/example/example          	Example application
/example/example.c        	Example source
/example/example.h        	Example header
/example/example.mak      	Example make file
/example/example.txt	Example description 
/example/example64.txt    	Example description

/trn/makefile             	Translation Library example make file
/trn/readme.trn           	Translation Library example description
/trn/translat.c           	Translation Library example source file								
		
/tools:
ddextu                    License Extender utility
ddprocinfo                Processor Information utility
odbcadmin                 ODBC Data Source Administrator [Linux only]

uninstall/*.*             Files used to uninstall the product

/wizards:
index.html
odbcperf.jar              Performance wizard
/images/*.*	


	Documentation Third Party Acknowledgements

One or more products in the Progress DataDirect for ODBC for Oracle Service
Cloud v7.1 release includes third party components covered by licenses that
require that the following documentation notices be provided.  If changes in
third party components occurred for the current release of the Product, the 
following Third Party Acknowledgements may contain notice updates to any 
earlier versions provided in documentation or README file. 						

Progress DataDirect for ODBC for Oracle Service Cloud v7.1 incorporates 
HyperSQL database v1.8.0.10 from The HSQL Development Group.  Such technology
is subject to the following terms and conditions: Copyright (c) 2001-2005, The
HSQL Development Group All rights reserved. Redistribution and use in source 
and binary forms, with or without modification, are permitted provided that 
the following conditions are met: Redistributions of source code must retain
the above copyright notice, this list of conditions and the following 
disclaimer.  Redistributions in binary form must reproduce the above copyright
notice, this list of conditions and the following disclaimer in the 
documentation and/or other materials provided with the distribution. Neither 
the name of the HSQL Development Group nor the names of its contributors may 
be used to endorse or promote products derived from this software without 
specific prior written permission. THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT
HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, 
INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND
FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL HSQL 
DEVELOPMENT GROUP, HSQLDB.ORG, OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, 
INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE
OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF 
ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
Progress DataDirect for ODBC for Oracle Service Cloud v7.1 incorporates Stax2 
API v3.1.1.  Such technology is subject to the following terms and conditions:
Copyright (c) 2004-2010, Woodstox Project (http://woodstox.codehaus.org/) All
rights reserved.
Redistribution and use in source and binary forms, with or without 
modification, are permitted provided that the following conditions are met:
1. Redistributions of source code must retain the above copyright notice, this
   list of conditions and the following disclaimer.
2. Redistributions in binary form must reproduce the above copyright notice, 
   this list of conditions and the following disclaimer in the documentation 
   and/or other materials provided with the distribution.
3. Neither the name of the Woodstox XML Processor nor the names of its 
   contributors may be used to endorse or promote products derived from this 
   software without specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED 
WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE 
DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR
ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES 
(INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; 
LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON
ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT 
(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS 
SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

Progress DataDirect for ODBC for Oracle Service Cloud v7.1 incorporates ICU 
Library v4.2.1.  Such technology is subject to the following terms and 
conditions: ICU License - ICU 1.8.1 and later ICU License - ICU 1.8.1 and later
COPYRIGHT AND PERMISSION NOTICE. Copyright (c) 1995-2010 International Business
Machines Corporation and others. All rights reserved. Permission is hereby 
granted, free of charge, to any person obtaining a copy of this software and 
associated documentation files (the "Software"), to deal in the Software 
without restriction, including without limitation the rights to use, copy, 
modify, merge, publish, distribute, and/or sell copies of the Software, and
to permit persons to whom the Software is furnished to do so, provided that 
the above copyright notice(s) and this permission notice appear in all copies
of the Software and that both the above copyright notice(s) and this permission
notice appear in supporting documentation. THE SOFTWARE IS PROVIDED "AS IS", 
WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO 
THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND 
NONINFRINGEMENT OF THIRD PARTY RIGHTS. IN NO EVENT SHALL THE COPYRIGHT HOLDER 
OR HOLDERS INCLUDED IN THIS NOTICE BE LIABLE FOR ANY CLAIM, OR ANY SPECIAL 
INDIRECT OR CONSEQUENTIAL DAMAGES, OR ANY DAMAGES WHATSOEVER RESULTING FROM 
LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR
OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR 
PERFORMANCE OF THIS SOFTWARE. Except as contained in this notice, the name of 
a copyright holder shall not be used in advertising or otherwise to promote the
sale, use or other dealings in this Software without prior written 
authorization of the copyright holder.  All trademarks and registered 
trademarks mentioned herein are the property of their respective owners.

Progress DataDirect for ODBC for Oracle Service Cloud v7.1 incorporates OpenSSL
toolkit v1.0.0_x and OpenSSL toolkit v1.0.2_x.  Such technology is subject to 
the following terms and conditions:  License - LICENSE ISSUES==============The
OpenSSL toolkit stays under a dual license, i.e. both the conditions of the 
OpenSSL License and the original SSLeay license apply to the toolkit.

See below for the actual license texts. Actually both licenses are BSD-style 
Open Source licenses. In case of any license issues related to OpenSSL please 
contact openssl-core@openssl.org.
OpenSSL License --------------- Copyright (c) 1998-2011 The OpenSSL Project.  
All rights reserved. 

Redistribution and use in source and binary forms, with or without 
modification, are permitted provided that the following conditions are met:
1. Redistributions of source code must retain the above copyright notice, this
   list of conditions and the following disclaimer.
2. Redistributions in binary form must reproduce the above copyright notice, 
   this list of conditions and the following disclaimer in the documentation 
   and/or other materials provided with the distribution.
3. All advertising materials mentioning features or use of this software must
   display the following acknowledgment:
   "This product includes software developed by the OpenSSL Project for use in
   the OpenSSL Toolkit. (http://www.openssl.org/)"
4. The names "OpenSSL Toolkit" and "OpenSSL Project" must not be used to 
   endorse or promote products derived from this software without prior written
   permission. For written permission, please contact openssl-core@openssl.org.
5. Products derived from this software may not be called "OpenSSL" nor may 
   "OpenSSL" appear in their names without prior written permission of the 
   OpenSSL Project.
6. Redistributions of any form whatsoever must retain the following 
   acknowledgment:
   "This product includes software developed by the OpenSSL Project for use in
   the OpenSSL Toolkit (http://www.openssl.org/)"
THIS SOFTWARE IS PROVIDED BY THE OpenSSL PROJECT ``AS IS'' AND ANY EXPRESSED 
OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES 
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.  IN NO
EVENT SHALL THE OpenSSL PROJECT OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, 
INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, 
DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY 
OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING 
NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, 
EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
====================================================================
This product includes cryptographic software written by Eric Young 
(eay@cryptsoft.com).  This product includes software written by Tim Hudson 
(tjh@cryptsoft.com).
Original SSLeay License -----------------------Copyright (C) 1995-1998 Eric 
Young (eay@cryptsoft.com) All rights reserved.
This package is an SSL implementation written by Eric Young 
(eay@cryptsoft.com).
The implementation was written so as to conform with Netscapes SSL.
This library is free for commercial and non-commercial use as long as the 
following conditions are aheared to.  The following conditions apply to all 
code found in this distribution, be it the RC4, RSA, lhash, DES, etc., code; 
not just the SSL code.  The SSL documentation included with this distribution
is covered by the same copyright terms except that the holder is Tim Hudson 
(tjh@cryptsoft.com).
Copyright remains Eric Young's, and as such any Copyright notices in the code 
are not to be removed.
If this package is used in a product, Eric Young should be given attribution 
as the author of the parts of the library used.
This can be in the form of a textual message at program startup or in 
documentation (online or textual) provided with the package.
Redistribution and use in source and binary forms, with or without 
modification, are permitted provided that the following conditions are met:
1. Redistributions of source code must retain the copyright notice, this list 
   of conditions and the following disclaimer.
2. Redistributions in binary form must reproduce the above copyright notice, 
   this list of conditions and the following disclaimer in the documentation 
   and/or other materials provided with the distribution.
3. All advertising materials mentioning features or use of this software must
   display the following acknowledgement:
   "This product includes cryptographic software written by Eric Young 
   (eay@cryptsoft.com)"
   The word 'cryptographic' can be left out if the routines from the library 
   being used are not cryptographic related :-).
4. If you include any Windows specific code (or a derivative thereof) from the
   apps directory (application code) you must include an acknowledgement:
"This product includes software written by Tim Hudson (tjh@cryptsoft.com)"
THIS SOFTWARE IS PROVIDED BY ERIC YOUNG ``AS IS'' AND ANY EXPRESS OR IMPLIED 
WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF 
MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.  IN NO 
EVENT SHALL THE AUTHOR OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, 
INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT 
LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, 
OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF 
LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING 
NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, 
EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
The licence and distribution terms for any publically available version or 
derivative of this code cannot be changed.  i.e. this code cannot simply be 
copied and put under another distribution licence [including the GNU Public 
Licence.]


~~~~~~~~~~~~~~
November 15, 2017
End of README.TXT