Now Supporting DataStax Enterprise and Cassandra – Your Favorite BI Tools
The strong growth in enterprise usage of NoSQL and big data technologies has resulted in most third party software suppliers of database tools offering support for DataStax Enterprise and Apache Cassandra. The good news for you is that it’s now easier than ever to use both DataStax Enterprise and Cassandra for analytics work in your favorite BI tools in the same way you’ve done with various RDBMS’s for years.
Let me highlight just a few of the solutions available to you…
Jaspersoft is a well-known open source BI and ETL solutions provider. They support DataStax Enterprise and Cassandra in both their BI platform and ETL offering, and provide native connectors for both Cassandra and Hadoop that you can use. You can also utilize Cassandra and Hadoop/Hive ODBC drivers with their software.
To see Jaspersoft in action with Cassandra and DataStax Enterprise, check out this webinar done earlier this year.
Yes, believe it or not, the #1 most used tool for BI work is Microsoft Excel. Using ODBC connectivity, a user can use Excel’s data connection wizards and data import utilities to drag data from many different databases into spreadsheets where the information can be sliced and diced at will.
There are ODBC drivers for Cassandra and DataStax Enterprise that can be installed on client workstations and configured to pull data back both from Cassandra and Hadoop/Hive. To see how easy this can be, check out this short, visual tutorial.
Pentaho is another very well known supplier of open source BI and ETL solutions. Their business analytics and integration platforms support both DataStax Enterprise and Cassandra. If you’d like a quick tutorial on how to move data from a particular datasource to Cassandra, see their short online tutorial that demonstrates how easy they make it.
For a nice tutorial of using Pentaho with DataStax Enterprise and Cassandra, take a look at this webinar done a short time back.
Tableau is a leading provider of BI solutions. They offer desktop, server, and web/public editions of their BI platform. Tableau supplies built-in connectivity to both DataStax Enterprise and Cassandra from within their toolset.
All of Tableau’s BI editions can be easily downloaded and trialed.
Talend is more of an open source leader is data integration/ETL than typical BI, however their Talend Open Studio product is used by many. They support both DataStax Enterprise and Cassandra by providing pre-built connectors for Cassandra and Hadoop.
By no means are the vendors listed above the only ones supporting DataStax Enterprise and Cassandra in their toolsets. By using either the Simba ODBC driver for Cassandra or the DataStax ODBC driver for Hive mentioned in the Microsoft Excel section above, many other BI solutions can easily connect to and work with DataStax Enterprise and Cassandra. Tools like Microstrategy, Informatica, and others can operate in this manner.
Download a copy of DataStax Enterprise Edition today if you haven’t already, and be sure to contact us if you’re using a BI or ETL tool that doesn’t have a way to connect to DataStax Enterprise or Cassandra, and we’ll see what we can do to change that.