In order to work with Cassandra DB, you will just need to use external Cassandra JDBC driver, since the driver does not come with the Clover. After you get the driver, you may simply create a new DB connection and use it in standard DB componets (DBInputTable, DBOutputTable, DBExecute). However, you should keep in mind that since the CQL language used by Cassandra is slightly different to other SQL dialects, you will not be able to use all functions of mentioned components - this applies to the following features:
- Validation might not work in some cases (especially when "append WHERE 1=0" clause is used).
- Metadata extraction from DB query does not work (validation is required).
- Browsing DB schema in DB components might not work (you will need to write your CQL query manually).
Regarding the BC connection configuration itself, you will not only need to add the JDBC driver jar file itself but also the other Cassandra JDBC dependencies. Configuration information and links to required JAR files (incl. dependencies) are listed here: https://code.google.com/a/apache-extras ... ndra-jdbc/
When loading driver from JAR (green "plus" button), make sure you select all the JAR files (driver and all required dependencies).
On the aforementioned site you can also see format of the URL you need to use in the DB connection wizard (jdbc:cassandra://yourhosts:9160/yourkeyspace).
Hope it helps.