README
     Progress(R) DataDirect(R)
     Progress(R) DataDirect(R) Autonomous REST Connector(R) for ODBC

     Windows Platforms(32- and 64-bit) 

     8.0.0 Release
     October 30, 2019


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


CONTENTS

Installation Directory 
Driver Requirements
Changes Since 8.0.0 GA
Release 8.0.0 Features  
Notes, Known Problems, and Restrictions
Driver Workaround Options
Documentation
Installed Files for 32-bit Drivers
Installed Files for 64-bit Drivers


    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


    Driver Requirements

* The driver requires a Java Virtual Machine (JVM): Java SE 8 or OpenJDK 8 
  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.
  
  
    Changes Since 8.0.0 GA
  
HTTP Response Status Codes
--------------------------  
The driver has been enhanced to allow you to customize how HTTP response 
status codes are processed by the driver. By configuring the input REST file,
you can define error responses for codes that are returned by the service, 
including driver actions and error messages. 
  
Support for Windows Platforms
-----------------------------
The following Windows platforms have reached the end of their product lifecycle
and are no longer supported by the driver:
* Windows 8.0 (versions 8.1 and higher are still supported)
* Windows Vista (all versions)
* Windows XP (all versions)
* Windows Server 2003 (all versions)  
  
OAuth 2.0 Support 
-----------------
The driver has been enhanced to support OAuth 2.0 authentication.  

Custom HTTP-header Support 
--------------------------
The driver has been enhanced to support requests for endpoints that use 
custom HTTP-headers.   


    Release 8.0.0 Features  

The driver supports SQL read-only access to REST API data sources that
express payloads using the JSON format. To support SQL access to REST API data
sources, the driver creates a relational map of the JSON data model and 
translates SQL statements provided by the application to native queries and Web
service calls. In addition, the driver supports multiple simultaneous sessions.

Features:
	
* The driver supports SQL read-only access to REST API endpoints that return 
  JSON payloads. 

* The driver supports all ODBC Core and Level 1 functions and some Level 1 and 
  Level 2 features. 
  
* The driver supports standard JSON data types and additional data types 
  through data type inference.

* The driver supports using internal memory or a configurable REST file to 
  define REST responses and relational mapping. 

* The driver heuristically maps data types, eliminating the need to define 
  native data types in most scenarios.

* The driver supports basic, HTTP-header based, URL-Parameter based and no 
  authentication.  

* The driver supports the handling of large result sets with configurable 
  paging and the Fetch Size and WSFetch Size connection options. 
  
 
	Notes, Known Problems, and Restrictions 

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

Out-of-memory Errors
--------------------
The driver has been designed to handle large result sets; however,
out-of-memory errors can still occur. The following items outline how to reduce
the likelihood of out-of-memory errors for your environment.

* Reduce FetchSize to reduce demands on memory. By lowering the maximum number
  of rows as specified by FetchSize, you lower the number of rows the driver is
  attempts to process before returning data to the application. Thus, you 
  reduce demands on memory and decrease the likelihood of out-of-memory errors.

* Decrease ResultMemorySize until results are successfully returned. Intermediate
  results larger than the value specified will be written to disk as opposed to
  held in memory. When configured correctly, this avoids memory limitations by
  not relying on memory to process larger intermediate results. Be aware that
  while writing to disk reduces the risk of out-of-memory errors, it also
  negatively impacts performance. For optimal performance, decrease this value
  only to a size necessary to avoid errors. By default, ResultMemorySize is set
  to -1, which sets the maximum size of intermediate results held in memory to 
  a percentage of the max Java heap size. If you received errors using the 
  default configuration, use the max Java heap size divided by 4 as a starting
  point when tuning this option.

* Increase the JVM heap size. By increasing the max Java heap size, you increase
  the amount of data the driver can accumulate in memory and avoid 
  out-of-memory errors.

126 Error When Modifying Data Sources on Windows 10
---------------------------------------------------
You may receive a 126 error when adding or configuring a data source stored
on a network location. This might be caused by the settings of the User Account
Control (UAC) security feature on Windows 10. To work around this issue:

Important: Implementing this fix disables security safeguards that are designed
to protect your machine. Before starting, refer to the following Microsoft 
documentation for potential risks associated with disabling the UAC feature:  
http://windows.microsoft.com/en-us/
windows/what-are-user-account-control-settings

1.  From the Start menu, type regedit in the search field; then, select regedit
    from the results list. The Registry Editor window opens. 

2.  Navigate to the following registry subkey: 

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System

3.  Right click on the subkey; then, select New > DWORD Value. 

4.  Rename the new value EnableLinkedConnections. 

5.  Right-click EnableLinkedConnections, and then click Modify. The Edit DWORD 
    Value window opens. 

6.  In the Value data field, type 1. Click OK. 

7.  Close the Registry Editor; then, restart your computer. 


    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 and Reference
for a description of these options.


    Documentation  

THE PROGRESS DATADIRECT AUTONOMOUS REST CONNECTOR FOR ODBC
USER'S GUIDE AND REFERENCE
---------------------------------------------------------- 
The User's Guide and Reference is provided in PDF and HTML versions. Both 
versions are installed in the AutoRESTHelp subdirectory of your product 
installation directory. You can access the HTML help by opening the index.html
file or by clicking the Help button on the driver setup dialog. The PDF 
version, which you can view using Adobe Reader, can be viewed by opening the 
autorestodbcuser.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 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\:

\\:
----------------
license.txt                     Progress DataDirect license agreement

\drivers:
---------
ivautorest28.dll                 DataDirect Autonomous REST Connector 
ivautorest28r.dll                DataDirect Autonomous REST Connector 
                                 resource file	
ivautorest28s.dll                DataDirect Autonomous REST Connector 
                                 setup library 	
ivcurl28.dll                     Library used for HTTP connection
ivicu28.dll                      Unicode conversion tables
IVODBC.LIC                       DataDirect License File
ivtrc28.dll                      DataDirect trace library
ivssl28.dll                      SSL support file (1.0.2n)
qesqlext.h                       Header file for DataDirect-specific 
                                 ODBC Definitions

\OpenSSL\latest\:
-----------------
ivssl28.dll                      SSL support file 
                                 (OpenSSL library file, version 1.0.2n)
			
\help\AutoRESTHelp\:
--------------------					
index.html                       HTML help system entry file
autorestodbcuser.pdf             PDF copy of the User's Guide and Reference
\*.*                             Support folders for the HTML help system
		
\java\lib\:
-----------
autorest.jar                     Java components for the driver

\jre\:
------
*.*                              Files associated with the installer program

\NOTICES\:
---------
ODBC for Autonomous REST Connector  
v8.0 notices.txt                 Third-party vendor license agreements

\READMES\:
---------
ODBC for Autonomous REST Connector  
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 
                                 Autonomous REST Connector

\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 
                                 Autonomous REST Connector 
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 
                                 Autonomous REST Connector 
example.c                        Example source
Example.exe                      Example application
example.h                        Example header
Example.mak                      Example make file
Example.sln                      Example solution file
example.txt                      Example description
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

\Tableau\:
----------
DataDirect AutoREST.tdc          Tableau data source file 

\tools\:
-------
ddextwin.exe                     License Extender utility
ddprocinfo.exe                   Processor Information utility
DSNConverterSil.exe              Data Source Converter utility
autorestserver32.exe             The Autonomous REST Connector SQL 
                                 Server Engine
XMLP.exe                         A GUI demo tool that persists a result set to
                                 an XML data 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\:

\\:
----------------
license.txt                      Progress DataDirect license agreement

\drivers\:
----------
ddautorest28.dll                 DataDirect Autonomous REST Connector  
ddautorest28r.dll                DataDirect Autonomous REST Connector 
                                 resource file
ddautorest28s.dll                DataDirect Autonomous REST Connector 
                                 setup library 
ddcurl28.dll                     Library used for HTTP connection
ddicu28.dll	                 Unicode conversion tables
DDODBC.LIC	                 DataDirect License File
ddssl28.dll                      SSL support file (1.0.2n)
ddtrc28.dll                      DataDirect trace library
qesqlext.h	                 Header file for DataDirect-specific ODBC 
                                 Definitions

\OpenSSL\latest\:
----------
ddssl28.dll                      SSL support file 
                                 (OpenSSL library file, version 1.0.2n)

\help\AutoRESTHelp\:
-------------------- 					
INDEX.HTML                       HTML help system entry file
autorestodbcuser.pdf             PDF copy of the User's Guide and Reference
\*.*                             Support folders for the HTML help system
					
\java\lib\:
-----------
autorest.jar	                 Java components for the driver

\jre\:
------
*.*		                 Files associated with the installer program

\NOTICES\:
----------
ODBC for Autonomous REST Connector 
v8.0 notices.txt                 Third-party vendor license agreements

\READMES\:
----------
ODBC for Autonomous REST Connector
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 
                                  Autonomous REST Connector 
                       
\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 
                                  Autonomous REST Connector 
msgprintf.hpp                     Bulk streaming example header file
ProgressDataDirect.bmp
ProgressDataDirect.ico
winmain.cpp                       Bulk streaming example source file

\samples\example\:
------------------
\example\ddlogging.properties     Log configuration file for the 
                                  Autonomous REST Connector
example.c                    	  Example source
Example.exe                 	  Example application
example.h                   	  Example header
Example.mak                       Example make file
Example.sln                 	  Example solution file
example.txt                 	  Example description
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

\Tableau\:
----------
DataDirect AutoREST.tdc           Tableau data source file 

\tools\:
-------
ddextwin.exe                     License Extender utility
ddprocinfo.exe                   Processor Information utility
DSNConverterSil.exe              Data Source Converter utility
autorestserver64.exe             The Autonomous REST Connector SQL 
                                 Server Engine 
XMLP.exe                         A GUI demo tool that persists a result set to
                                 an XML data file					
								
\uninstall\:
------------
*.*                              Files used to uninstall the product		

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