About the Easysoft ODBC-Cassandra Driver

The Easysoft ODBC-Cassandra Driver provides real-time access to Cassandra data from any application that supports ODBC.

ODBC API and scalar functions

API functions

Use this table to find out what ODBC API functions the Easysoft ODBC-Cassandra Driver supports:

Function Status

SQLAllocConnect

Supported

SQLAllocEnv

Supported

SQLAllocHandle

Supported

SQLAllocStmt

Supported

SQLBindCol

Supported

SQLBindParameter

Supported

SQLBrowseConnect

Not supported

SQLBulkOperations

Supported

SQLCancel

Supported

SQLCloseCursor

Supported

SQLColAttribute

Supported

SQLColAttributes

Supported

SQLColumnPrivileges

Supported

SQLColumns

Supported

SQLConnect

Supported

SQLCopyDesc

Supported

SQLDataSources

Supported

SQLDescribeCol

Supported

SQLDescribeParam

Supported

SQLDisconnect

Supported

SQLDriverConnect

Supported

SQLDrivers

Supported

SQLEndTran

Supported

SQLError

Supported

SQLExecDirect

Supported

SQLExecute

Supported

SQLExtendedFetch

Supported

SQLFetch

Supported

SQLFetchScroll

Supported

SQLForeignKeys

Supported

SQLFreeConnect

Supported

SQLFreeEnv

Supported

SQLFreeHandle

Supported

SQLFreeStmt

Supported

SQLGetConnectAtt

Supported

SQLGetConnectOption

Supported

SQLGetCursorName

Supported

SQLGetData

Supported

SQLGetDescField

Supported

SQLGetDescRec

Supported

SQLGetDiagField

Supported

SQLGetDiagRec

Supported

SQLGetEnvAttr

Supported

SQLGetFunctions

Supported

SQLGetInfo

Supported

SQLGetStmtAttr

Supported

SQLGetStmtOption

Supported

SQLGetTypeInfo

Supported

SQLMoreResults

Supported

SQLNativeSql

Supported

SQLNumParams

Supported

SQLNumResultCols

Supported

SQLParamData

Supported

SQLParamOptions

Supported

SQLPrepare

Supported

SQLPrimaryKeys

Supported

SQLProcedureColumns

Supported

SQLProcedures

Supported

SQLPutData

Supported

SQLRowCount

Supported

SQLSetConnectAttr

Supported

SQLSetConnectOption

Supported

SQLSetCursorName

Supported

SQLSetDescField

Supported

SQLSetDescRec

Supported

SQLSetEnvAttr

Supported

SQLSetParam

Supported

SQLSetPos

Not supported

SQLSetScrollOptions

Not supported

SQLSetStmtOption

Supported

SQLSetStmtOption

Supported

SQLSetStmtAttr

Supported

SQLStatistics

Supported

SQLTablePrivileges

Supported

SQLTables

Supported

SQLTransact

Supported

Data type mapping

The Easysoft ODBC-Cassandra Driver maps Cassandra data types to ODBC data types in this way:

Cassandra data type ODBC data type

BIGINT

SQL_BIGINT

BLOB

SQL_VARBINARY

BOOLEAN

SQL_BIT

COUNTER

SQL_BIGINT

DATE

SQL_TYPE_DATE

DECIMAL

SQL_NUMERIC

DOUBLE

SQL_DOUBLE

FLOAT

SQL_REAL

INET

SQL_VARCHAR

INT

SQL_INTEGER

SMALLINT

SQL_SMALLINT

TEXT

SQL_VARCHAR

TIME

SQL_TYPE_TIMESTAMP

TIMESTAMP

SQL_TYPE_TIMESTAMP

TIMEUUID

SQL_GUID

TINYINT

SQL_TINYINT

UUID

SQL_GUID

VARCHAR

SQL_VARCHAR

VARINT

SQL_NUMERIC

Finding out more about data types on Windows

If you need more information about a data types, for example, the precision and scale, use Microsoft’s ODBC Test to do this.

  1. Download the version of ODBC Test that matches your application’s architecture from:

    https://www.easysoft.com/ftp/pub/utils/windows/odbc-test/

  2. Copy both files to a folder on the machine where Easysoft ODBC-Cassandra Driver is installed.

  3. Double-click odbcte32.exe.

  4. Select Con > Full Connect.

  5. Choose your Easysoft ODBC-Cassandra Driver data source from the list.

  6. Choose Catalog > SQLGetTypeInfo.

  7. Either choose SQL_ALL_TYPES=0 (1.0) or a specific data type from the DataType list.

  8. Choose Results > Get Data All.