Install Java 8

Install Java8 with HotSpot JVM:

https://adoptium.net/?variant=openjdk8

When installing, make sure to select “set java_home”

Install 7Zip

https://www.7-zip.org/download.html

Install Python 2.7

(note, this is necessary for cqlsh to work)

https://www.python.org/download/releases/2.7/

Download the windows x86 x64 installer.

Make sure to select “install for all users” when installing.

Note that the python installer does NOT add python to the path. If you would like to add it to the path, you will need to Right-Click on “My Compter” or “This PC”, select “Advanced system settings” Select “Environment Variables” select PATH under “System variables” select “edit” select “new” and then add in the path for python (typically C:\Python27)

Install Visual C++ 2010 Runtime:

https://www.microsoft.com/en-gb/download/details.aspx?id=26999

Download and install the x64 version.

Install Cassandra 3.* (Not 4)

Note, we currently do not run Cassandra 4. This will change in the near future, please make sure to check your release notes in case this changes.

Download the latest version of Cassandra from Apache’s website:

https://cassandra.apache.org/_/download.html

Extract the tar.gz into your download folder using 7zip (simple right-click and extract – you will need to do this twice).

Create a c:\cassandra folder

Copy the contents that you extracted into that folder (drill into the extracted folders until you get a bin\conf\doc, etc. list of files and folders)

Right-click on “c:\cassandra\bin\cassandra.bat” and select “run as administrator” This will launch Cassandra for you. Leave this command window open so you can access cassandra.

if it throws an access violation exception and mentions “sigar-amd64…” in the error, navigate to

C:\cassandra\lib\sigar-bin

rename sigar-amd64-winnt.dll to “_sigar-amd64-winnt.dll“ (this is so it doesn’t bother trying to load it)

Download latest Spoon with Plugins

This downloads our pre-packaged version of spoon with all the Alterian plugins pre-installed

https://ddepdi.s3.eu-west-2.amazonaws.com/pdi.zip

Extract that to your download folder, create a folder to hold it where you want. I usually have C:\

Program Files\Kettle but it doesn’t matter where it is.

Run spoon.bat to launch Kettle.

Download a client to query Cassandra

The following instructions detail how to install Datastax DevCenter. However, there are a number of clients available to view tables and run queries against Cassandra.

1. Download Devcenter from the following location: https://downloads.datastax.com/#devcenter

2. Uncompress the file to the root of C

   1. e.g. DevCenter-1.6.0-win-x86_64.zip → C:\DevCenter-1.6.0-win-x86_64

3. Run "C:\DevCenter-1.6.0-win-x86_64\DevCenter\DevCenter.exe"

4. Ensure Cassandra is running and create a connection to it:
   

   Image Removed

5. Click Finish

6. In the query window, select the connection

   Image Removed

   1. The schema window will now show all the available keyspaces and tables

...