Connecting Pentaho with Cassandra

[Soundarya]

Hi, 

I am doing an use-case with the Community edition of Pentaho and Cassandra. (Connecting Pentaho with Cassandra DB) 

I installed Pentaho Business Analytics - successfully.. and connected to locahost. localhost:8080/pentaho. In the DataSources (Manage Data Sources) I can see MySQL, Postgres, etc. But my objective is to connect with Cassandra DB with Pentaho.

Pentaho suggested to use Pentaho Spoon - Data Integration. Installed Pentaho Spoon Data Integration successfully and connected Cassandra with that. I can visualize the Cassandra Schema in Pentaho Spoon.,etc.

Now I want to visualize the Cassandra Data in Pentaho BA Server. Can anyone help me to connect with. (I tried adding database using JDBC too. doesnt seem to be working).

And also, from the pentaho documentation, I can view the services and status in Pentaho web : List the services that are running: http://localhost:9080/pentaho-di/kettle/listServices List the status of the service: http://localhost:9080/pentaho-di/kettle/Status

Thanks in advance.

[Alex Popescu]

Hi Soundarya,

Have you tried contacting the folks from Pentaho with this question? A cursory search revealed this blog post http://informationsurvival.blogspot.com/2014/02/cassandra-cql3-integration.html which mentions that Pentaho Data Integration 5 supports CQL3, but I couldn't find other details.

To unsubscribe from this group and stop receiving emails from it, send an email to java-driver-us...@lists.datastax.com.

--

Bests,

Alex Popescu | @al3xandru

Sen. Product Manager @ DataStax