Connecting Cassandra using the Simba JDBC driver on MicroStrategy 10

This TN outlines the steps to connect to Cassandra 2.x using the Simba jdbc driver on Strategy 10.7 or earlier. From Strategy 10.8 we ship Strategy Casssandra ODBC Driver.

Prerequisites

1. Download and unzip the Simba Cassandra JDBC driver(SimbaCassandraJDBC42-1.1.2.1002.zip) on the machine with your Strategy install

Connecting via Strategy Developer

1. Navigate AdministrationàConfiguration ManagersàDatabase Instances in developer and create a new database instance
2. In the database creation wizard select Apache Cassandra 2.x as the Database Connection type.

 Create new database connection, go to the Advanced tab and add the following to the Additional connection string parameters field.JDBC;MSTR_JDBC_JAR_FOLDER=<location of unzipped driver folder>;DRIVER=com.simba.cassandra.jdbc42.Driver;URL={jdbc:cassandra://host:port;DefaultKeyspace=};
Note: Refer to the Simba driver documentation for additional parameters to add the URL
 
 

1. Create a DB login and hit OK to save the changes

1. Expand an existing Project or create a new project and navigate to SchemaàWarehouse Catalog. Set the DB instance create above as the current database instance. Hit the execute button. You should be able to view the tables in Cassandra database

Connecting via Data Import

1. Select Add External Data and navigate to Databases à Apache Cassandra. Choose the “Pick tables” option and add a data source
2. Check the edit connection string field and copy the following connection string into the text box
3. =<location of unzipped driver folder>;DRIVER=com.simba.cassandra.jdbc42.Driver;URL={jdbc:cassandra://host:9042}

1. You should now successfully be able to connect and view the keyspaces and tables available