README
     Progress(R) DataDirect(R)
     Progress(R) DataDirect(R) for ODBC for Apache Cassandra(TM)

     Windows Platforms(32- and 64-bit) 

     8.0.0 Release
     March 1, 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_80

* The default installation directory for all other installations is:

  C:\Program Files\Progress\DataDirect\ODBC_80	


    Driver Requirements

* The driver requires a Java Virtual Machine (JVM): Java SE 6 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
 
 Certifications
 --------------
* Certified with OpenJDK 11
  Driver version 08.00.0101 (B0377, U0256) 

* Certified with OpenJDK 8
  Driver version 08.00.0101 (B0377, U0256)
 
* Certified with Windows Server 2016 (driver version 08.00.0074 (B0238, U0156))

Data Consistency Level Enhancement
----------------------------------
* The driver has been enhanced to support all the data consistency levels for 
  read and write operations that are supported by Apache Cassandra data stores. 
  Data consistency levels are configured using the Read Consistency and Write 
  Consistency connection options. Refer to the user's guide and reference for
  descriptions of these options. 

   
    Release 8.0.0 Features  

The Progress DataDirect for ODBC for Apache Cassandra driver supports standard
SQL query language to select data from Apache Cassandra databases. In addition,
some insert, update, and delete capabilities are supported. The driver
translates the SQL statements provided by an application into native Cassandra
Query Language(CQL) statements, enabling you to leverage your knowledge 
of SQL.

Features:
	
* Certified against Apache Cassandra versions 2.0, 2.1, 2.2, and 3.7.

* Certified against DataStax Enterprise 4.7, 4.8, 5.0
  
* Supports SQL read-write access to Apache Cassandra data sources.   

* Supports CQL Binary Protocol 

* The driver supports the core SQL-92 grammar.

* Support for all ODBC Core and Level 1 functions and some Level 1 and 
  Level 2 features.  

* Supports user id and password authentication. 

* Generates a relational view of Cassandra data. Tuple and user-defined types 
  are flattened into a relational parent table, while collection types are 
  mapped as relational child tables.
  
* Supports Native and Refresh escape sequences to embed CQL commands in 
  SQL-92 statements. 

* Supports Cassandra's tunable consistency functionality with ReadConsistency
  and WriteConsistency connection options.

* Supports the handling of large result sets through the Fetch Size, Native
  Fetch Size and Result Memory Size connection options.

* Supports applications that do not support unbounded data types through
  the ASCIISize, DecimalPrecision, DecimalScale, VarintPrecision, and 
  VarcharSize connection options. 

* The driver supports the following data types:
  - ASCII	maps to SQL_VARCHAR
  - Bigint	maps to SQL_BIGINT
  - Blob	maps to SQL_LONGVARBINARY
  - Boolean	maps to SQL_BIT
  - Counter     maps to SQL_BIGINT
  - Date        maps to SQL_TYPE_DATE 
  - Decimal     maps to SQL_DECIMAL
  - Double	maps to SQL_DOUBLE
  - Float       maps to SQL_REAL
  - Inet        maps to SQL_VARCHAR
  - Int 	maps to SQL_INTEGER
  - List        maps to SQL_WLONGVARCHAR
  - Map         maps to SQL_WLONGVARCHAR
  - Set         maps to SQL_WLONGVARCHAR
  - Smallint    maps to SQL_SMALLINT
  - Time        maps to SQL_TYPE_TIME
  - Timestamp   maps to SQL_TYPE_TIMESTAMP
  - TimeUUID	maps to SQL_CHAR
  - TINYINT     maps to SQL_TINYINT
  - TUPLE       maps to SQL_WLONGVARCHAR
  - USERTYPE    maps to SQL_WLONGVARCHAR
  - UUID        maps to SQL_CHAR
  - Varchar     maps to SQL_WVARCHAR
  - Varint      maps to SQL_DECIMAL
  
 
	Notes, Known Problems, and Restrictions 

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

SQLColAttributes for Columns in Prepared Statements
---------------------------------------------------
SQLColAttributes currently returns the incorrect data types and searchability
for columns in prepared statements.

Row Counts for Semicolon Delimited Statement Batches
----------------------------------------------------
Contrary to the driver metadata returned, row counts for semicolon delimited 
statement batches are rolled up into a single value rather than being returned
for each explicit statement.

CURRENT OF Syntax Error 
-----------------------
Attempting to update data using a named cursor with the CURRENT OF cursor 
syntax currently returns an error.

Updates on Counter Columns
--------------------------
Update is supported for Counter columns only when all the other columns in the
row comprise that row's primary key. When updating a Counter column on an
existing row, the Counter column is updated according to the increment (or
decrement) specified in the SQL statement. When updating a Counter column for
which there is no existing row, the values of the columns that comprise the 
row's primary key are inserted into the table alongside the value of the 
Counter column. Note that Update is only supported using the native syntax. 

Out-of-memory Errors
--------------------
The driver has been designed to handle large result sets that result. However,
out-of-memory errors can 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
  required 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.

system.indexes collection
-------------------------
The driver hides the system.indexes collection, and tables containing the "$"
character are hidden to prevent naming conflicts.

oplog.rs system table
---------------------
The driver hides the oplog.rs system table.

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 is 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 FOR ODBC FOR APACHE CASSANDRA DRIVER 
USER'S GUIDE AND REFERENCE
------------------------------------------------------------	 
The User's Guide and Reference is provided in PDF and HTML versions. Both 
versions are installed in the CassandraHelp 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 
cassandraodbcuser.pdf file.

NOTE: To download Adobe Reader, visit the Adobe Web site at 
http://www.adobe.com.
  
  
   Installed Files 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_80\:

For all other installations:
  C:\Program Files\Progress\DataDirect\ODBC_80\:

license.txt         Progress DataDirect license agreement

\drivers:
ivcsndr28.dll	    DataDirect Driver for Apache Cassandra 
ivcsndr28r.dll	    DataDirect Driver for Apache Cassandra
		    resource file
ivcsndr28s.dll	    DataDirect Driver for Apache Cassandra
		    setup library 
ivcurl28.dll        Library used for HTTP connection
ivicu28.dll	    Unicode conversion tables
IVODBC.LIC	    DataDirect License File
ivtrc28.dll         DataDirect trace library
qesqlext.h	    Header file for DataDirect-specific ODBC 
                    Definitions

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

\jre
*.*		    Files associated with the installer program

\NOTICES:
ODBC for Apache Cassandra 
v8.0 notices.txt               Third-party vendor license agreements

\READMES:
ODBC for Apache Cassandra 
v8.0 readme.txt 	          This file

\samples:
\bulk\bulk.c        		  Bulk example source
\bulk\bulk.exe      		  Bulk application
\bulk\bulk.mak      		  Bulk example make file
\bulk\bulk.sln      		  Bulk example solution file
\bulk\bulk.vcproj   		  Bulk example project file
\bulk\ddlogging.properties        Log configuration file for the 
                                  Cassandra driver
                       
\bulkstrm\bulk.cpp                Bulk streaming example source
\bulkstrm\bulk.hpp                Bulk streaming example header
\bulkstrm\bulk.rc                 Bulk streaming example resource file
\bulkstrm\bulkstreaming.sln       Bulk streaming example solution file
\bulkstrm\bulkstreaming.vcproj    Bulk streaming example project file
\bulkstrm\bulkstrm.exe            Bulk streaming example application
\bulkstrm\bulkstrm.txt 		  Bulk streaming description
\bulkstrm\ddlogging.properties    Log configuration file for the 
                                  Cassandra driver
\bulkstrm\msgprintf.hpp           Bulk streaming example header file
\bulkstrm\ProgressDataDirect.bmp
\bulkstrm\ProgressDataDirect.ico
\bulkstrm\winmain.cpp             Bulk streaming example source file

\example\ddlogging.properties     Log configuration file for the 
                                  Cassandra driver
\example\example.c         	  Example source
\example\Example.exe       	  Example application
\example\example.h         	  Example header
\example\Example.mak       	  Example make file
\example\Example.sln       	  Example solution file
\example\example.txt       	  Example description
\example\Example.vcproj    	  Example project file

\translat\LIBMAIN.C				  
\translat\README.TRN    	  Translation Library example description
\translat\TRANSLAT.C    	  Translation Library example source file
\translat\WINNT.MAK     	  Translation Library example make file

\Tableau:
DataDirect Apache Cassandra.tdc   Tableau data source file 

\tools:
ddextwin.exe		License Extender utility
ddprocinfo.exe		Processor Information utility
DSNConverterSil.exe	Data Source Converter utility
cassandraserver32.exe   The Cassandra 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 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:

ivtrc28.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_80\:

license.txt         Progress DataDirect license agreement

\drivers:
ddcsndr28.dll	    DataDirect Driver for Apache Cassandra 
ddcsndr28r.dll	    DataDirect Driver for Apache Cassandra
		    resource file
ddcsndr28s.dll	    DataDirect Driver for Apache Cassandra
		    setup library 
ddcurl28.dll        Library used for HTTP connection
ddicu28.dll	    Unicode conversion tables
DDODBC.LIC	    DataDirect License File
ddtrc28.dll         DataDirect trace library
qesqlext.h	    Header file for DataDirect-specific ODBC 
                    Definitions

\help\CassandraHelp 					
INDEX.HTML          HTML help system entry file
\*.*                Support folders for the HTML help system
					
\java\lib:
cassandra.jar	    Java components for the driver

\jre
*.*		    Files associated with the installer program

\NOTICES:
ODBC for Apache Cassandra 
v8.0 notices.txt               Third-party vendor license agreements

\READMES:
ODBC for Apache Cassandra 
v8.0 readme.txt 	          This file

\samples:
\bulk\bulk.c        		  Bulk example source
\bulk\bulk.exe      		  Bulk application
\bulk\bulk.mak      		  Bulk example make file
\bulk\bulk.sln      		  Bulk example solution file
\bulk\bulk.vcproj   		  Bulk example project file
\bulk\ddlogging.properties        Log configuration file for the 
                                  Cassandra driver
                       
\bulkstrm\bulk.cpp                Bulk streaming example source
\bulkstrm\bulk.hpp                Bulk streaming example header
\bulkstrm\bulk.rc                 Bulk streaming example resource file
\bulkstrm\bulkstreaming.sln       Bulk streaming example solution file
\bulkstrm\bulkstreaming.vcproj    Bulk streaming example project file
\bulkstrm\bulkstrm.exe            Bulk streaming example application
\bulkstrm\bulkstrm.txt 		  Bulk streaming description
\bulkstrm\ddlogging.properties    Log configuration file for the 
                                  Cassandra driver
\bulkstrm\msgprintf.hpp           Bulk streaming example header file
\bulkstrm\ProgressDataDirect.bmp
\bulkstrm\ProgressDataDirect.ico
\bulkstrm\winmain.cpp             Bulk streaming example source file

\example\ddlogging.properties     Log configuration file for the 
                                  Cassandra driver
\example\example.c         	  Example source
\example\Example.exe       	  Example application
\example\example.h         	  Example header
\example\Example.mak       	  Example make file
\example\Example.sln       	  Example solution file
\example\example.txt       	  Example description
\example\Example.vcproj    	  Example project file

\translat\LIBMAIN.C				  
\translat\README.TRN    	  Translation Library example description
\translat\TRANSLAT.C    	  Translation Library example source file
\translat\WINNT.MAK     	  Translation Library example make file

\Tableau:
DataDirect Apache Cassandra.tdc   Tableau data source file 

\tools:
ddextwin.exe		License Extender utility
ddprocinfo.exe		Processor Information utility
DSNConverterSil.exe	Data Source Converter utility
cassandraserver64.exe   The Cassandra 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		



~~~~~~~~~~~~~~
March 1, 2019
End of README.TXT