The Progress® DataDirect® for ODBC™ for Apache Cassandra™ driver supports read-write access to Apache Cassandra versions. To support SQL access to Cassandra, the driver creates a relational map of native Cassandra data and translates SQL statements to CQL. Cassandra complex data types Map, List, Set, Tuple, and user-defined types are supported alongside primitive CQL types. The driver optimizes performance when executing joins by leveraging data relationships among Cassandra objects to minimize the amount of data that needs to be fetched over the network. Relationships among objects can be reported with the following metadata methods: SQLColumns, SQLForeignKeys, SQLGetTypeInfo, SQLPrimaryKeys, SQLSpecialColumns, SQLStatistics, and SQLTables. Furthermore, when performing joins, the driver leverages data relationships among Cassandra objects, minimizing the amount of data that needs to be fetched over the network.

The documentation for the driver also includes the Progress DataDirect for ODBC Drivers Reference. The reference provides general reference information for all DataDirect drivers for ODBC, including content on troubleshooting and supported functions. For the complete documentation set, visit the Progress DataDirect Connectors Documentation Hub.