DS to Cassandra

Curious George · Post by **Curious George** » Mon Nov 04, 2013 12:22 pm

Hi All,

Please let me know if it is possible to connect to Cassandra server using DataStage Java Client/Java Transformer Stage.

There is no driver for Cassandra available in the DataStage server.
I would like to know if there is a way to connect to Cassandra directly using pure Java code without any drivers.
If that is possible then I would compile such a Java code and use that class within my Java Client stage in DataStage.

lstsaur · Post by **lstsaur** » Mon Nov 04, 2013 3:30 pm

No, even using pure java code you still need to have a driver. There are lots of examples out there to show you how to use JDBC or ODBC to connect to Cassandra server.

vmcburney · Post by **vmcburney** » Wed Nov 06, 2013 7:55 pm

I think there is an Apache license JDBC driver for Cassandra but the ODBC drivers cost money. You would need to move to DataStage 9.1.2 to be able to use JDBC from DataStage. There is a version of DataStage coming out early next year with even better NoSQL support.