Alex Popsecu

Today DataStax is delighted to announce the general availability of a new ODBC driver built on top of the Cassandra native protocol (CQL) that can be used free of charge with both open source Cassandra and DataStax Enterprise. The DataStax ODBC driver for Apache Cassandra, developed by ODBC software leader Simba Corporation, is compliant with the latest ODBC 3.52 specification, runs on both 32 and 64-bit versions of Windows and Linux, and can be downloaded from here

The DataStax ODBC Driver for Apache Cassandra enables the integration with a broad array of tools for data processing, migration, analysis and visualization by leveraging the power of both CQL and SQL. It stands as a simple integration point to tap into the online data stored in Apache Cassandra, the massive, scale-out, always-on, distributed database that was built for the cloud, mobile, and internet-of-things.

Let’s take a look at how to get started with the DataStax ODBC Driver for Apache Cassandra. We will walk through using the 64-bit driver on Microsoft Windows, but the process is very similar for the 32-bit driver, and for Linux. In the end we will show how to connect from Tableau to explore a simple data set in Apache Cassandra.

First, ensure that you have a running Apache Cassandra cluster, and note the IP address of one of the nodes, as well as the native protocol port for that node.

Next, let’s install the driver. Download and run the DataStaxCassandraODBC64.msi:
<img alt="welcome wizard" data-align="center" data-entity-type="file" data-entity-uuid="637b30f1-456e-42da-b37d-b98dcaa74bea" src="https://www.datastax.com/sites/default/files/inline-images/Wizard-Welcome-1.png" />
Click “Next”. Now, accept the license terms:
<img alt="click next" data-align="center" data-entity-type="file" data-entity-uuid="90d5a2ff-98d4-4af5-804a-b05a15e72409" src="https://www.datastax.com/sites/default/files/inline-images/EULA-1.png" />
Click “I accept the terms in the License Agreement” and then click “Next”. &nbsp;Now, choose a Destination Folder:
<img alt="destination folder" data-align="center" data-entity-type="file" data-entity-uuid="007d091d-a097-4954-b797-7993e0b148f5" src="https://www.datastax.com/sites/default/files/inline-images/DestinationFolder-1.png" />
Click “Next”.
<img alt="click next" data-align="center" data-entity-type="file" data-entity-uuid="fee97aed-0bf6-43da-a896-0b9adc3aff7d" src="https://www.datastax.com/sites/default/files/inline-images/Installing-1.png" />
Click “Install” to complete the installation. &nbsp;Once it is completed, you will see a success screen:
<img alt="installation complete" data-align="center" data-entity-type="file" data-entity-uuid="41da4448-da0b-4737-a4ab-4b86d3fd8b65" src="https://www.datastax.com/sites/default/files/inline-images/InstallationComplete-1.png" />
Now to set up a Data Source Name (DSN) for use in the ODBC tools. &nbsp;Start by opening the&nbsp;ODBC Administrator. &nbsp;You can find it under the Start menu, under the DataStax ODBC Driver for Apache Cassandra folder:&nbsp;
<img alt="ODBC Administrator" data-align="center" data-entity-type="file" data-entity-uuid="1f1c2748-d5b8-4899-9129-99dcd0305cce" src="https://www.datastax.com/sites/default/files/inline-images/ODBCAdminStart-1.png" />
&nbsp;

When it opens, click on the System DSN tab:
<img alt="click on the System DSN tab" data-align="center" data-entity-type="file" data-entity-uuid="d0032dec-a94a-4cd4-bf04-32a517c2389b" src="https://www.datastax.com/sites/default/files/inline-images/ODBCAdminSystem-1.png" />
You will see the DataStax Cassandra ODBC DSN64 DSN. Select that and click “Configure…”:
<img alt="DSN setup" data-align="center" data-entity-type="file" data-entity-uuid="a15b2b7b-a4ba-4a29-a9bf-a0cf2db404ed" src="https://www.datastax.com/sites/default/files/inline-images/DSNSetup-1.png" />
Here you will enter the host and port for your cluster. You can also optionally change the name of the DSN and the description, as well. Click “Test…”:
<img alt="dsn test" data-align="center" data-entity-type="file" data-entity-uuid="4aab4984-1bd8-47b2-9132-eff76c62d49f" src="https://www.datastax.com/sites/default/files/inline-images/DSNTest-1.png" />
Click “OK”, then click “OK”, and finally click “OK” a third time. &nbsp;Now you have configured a DSN, and you can use this DSN in your ODBC-based tools.

As an example, let’s use Tableau and connect to a simple data set in Apache Cassandra to explore. &nbsp;First, make sure you have downloaded and installed Tableau version 8.3, and go ahead and start it:
<img alt="tableau welcome" data-align="center" data-entity-type="file" data-entity-uuid="79de3b3a-c701-4191-a925-54a9992a88ea" src="https://www.datastax.com/sites/default/files/inline-images/TableauWelcome-700x548-1.png" />
From here, click “Connect to data”:
<img alt="connect to data" data-align="center" data-entity-type="file" data-entity-uuid="2e1c2b63-0349-407f-8b63-c3322d0bec16" src="https://www.datastax.com/sites/default/files/inline-images/TableauODBC-700x547-1.png" />
Select “Other Databases (ODBC)” and choose the DSN we created above. Here, we used the default name “DataStax Cassandra ODBC DSN64”. Next, click “Connect”, and fill out the Server, Port, and Database fields. For this example, we will use the&nbsp;<code>WEATHERCQL</code>&nbsp;keyspace and the&nbsp;<code>DAILY</code>&nbsp;table therein, which is included as a demo in DataStax Enterprise 4.6:
<img alt="tableau connection" data-align="center" data-entity-type="file" data-entity-uuid="bc0a19de-117b-4650-8281-550ac29ca7b0" src="https://www.datastax.com/sites/default/files/inline-images/TableauConnection-700x577-1.png" />
Choose the “Cassandra” Database, and search for - and select - the&nbsp;<code>weathercql</code>&nbsp;Schema. &nbsp;Lastly, search for the&nbsp;<code>daily</code>&nbsp;table. Drag the “daily (weathercql.daily)” table to the “Drag tables here” box in the upper right:
<img alt="choose cassandra database" data-align="center" data-entity-type="file" data-entity-uuid="ab92f81f-5a9e-434a-bacf-9c7429feb39b" src="https://www.datastax.com/sites/default/files/inline-images/TableauChooseTable-700x580-1.png" />
Click “Go to Worksheet”. &nbsp;You may get this popup warning, but you can click “OK”. There are some limitations in the driver, but Tableau will be able to compensate for them. &nbsp;If you are interested, you can click “Show Details” for more information.

We can now create a simple Worksheet:
<img alt="create worksheet" data-align="center" data-entity-type="file" data-entity-uuid="076902de-e60b-41a5-a61f-eeda12badc27" src="https://www.datastax.com/sites/default/files/inline-images/TableauWorksheetBlank-700x578.png" />
This Worksheet is a “Live” Worksheet, meaning that Tableau will make live queries to the data in Cassandra as the operations happen. You may see status popups indicating that it has issued a query. Let’s look at the maximum temperature for each month in the data for each of the station locations. &nbsp;First, create a filter on the Metric Dimension by dragging the Metric Dimension into the Filters box. &nbsp;This will bring up a popup box to choose temperature:
<img alt="live worksheet" data-align="center" data-entity-type="file" data-entity-uuid="5ef5a6d6-4a29-4348-b1c7-21a6a4be9d2f" src="https://www.datastax.com/sites/default/files/inline-images/TableauWorksheetFilter-700x577.png" />
Click “OK”. Now, drag the Date Dimension to the Columns box. &nbsp;We want to change the function on the Date value to Month and Year, but it defaults to just Year. &nbsp;If you hover over the blue bubble for YEAR(Date), there is a down arrow you can use to bring up another menu. &nbsp;When you do this, choose the second Month option, the one that has “May 2011” (or something similar) next to it. &nbsp;Next, drag the Max Measure to the Rows box. &nbsp;We want the maximum of the maximums, so hover over the SUM(Max) bubble to find the down arrow that will allow you to choose the Measure submenu, where you can choose Maximum. Then, drag the Stationid Dimension to the Marks box, specifically on the Color box:
<img alt="tableau worksheet" data-align="center" data-entity-type="file" data-entity-uuid="d2e49c83-1312-4f06-aba9-a8a42d24ca8d" src="https://www.datastax.com/sites/default/files/inline-images/TableauWorksheetArrows-700x580.png" />
The finished chart should look like this:
<img alt="finished chart" data-align="center" data-entity-type="file" data-entity-uuid="b57f305b-6237-4c48-9ecb-792f5b30224e" src="https://www.datastax.com/sites/default/files/inline-images/TableauWorksheetOneLine-700x577.png" />
We can click on one of the lines to see just that line time series:
<img alt="line time series" data-align="center" data-entity-type="file" data-entity-uuid="869ad3b9-1ad7-4be0-a364-1fbbc89e73da" src="https://www.datastax.com/sites/default/files/inline-images/TableauWorksheetOneLine-700x577-1.png" />
You can continue refining this Worksheet and then save it (by clicking File-&gt;Save).

This completes our short guide. The online documentation for the driver is available here and a manual, in PDF format, is included with the installers. Now you can download the Download DataStax ODBC driver for Apache Cassandra and DataStax Enterprise with CQL connector and put it to real work!

The DataStax ODBC driver with CQL connector for Apache Cassandra and DataStax Enterprise Available Now

Alex Popsecu

Discover more

Share

More Technology

Why DataStax Loves LangChain

Getting Started with DataStax Astra DB and Amazon Bedrock

Why You Can't Miss Cassandra Summit

Mitigate the OpenAI Debacle with Open Source and Cloud

NoSQL and Vector DB
for Generative AI,
Instantly, At Scale

Alex Popsecu

Discover more

Share

More Technology

Why DataStax Loves LangChain

Getting Started with DataStax Astra DB and Amazon Bedrock

Why You Can't Miss Cassandra Summit

Mitigate the OpenAI Debacle with Open Source and Cloud

NoSQL and Vector DBfor Generative AI,Instantly, At Scale

NoSQL and Vector DB
for Generative AI,
Instantly, At Scale