I was reading an interesting article on Forbes by Dan Woods entitled “Can Hadoop Survive its Weird Beginning?” Dan talks about the Hadoop ecosystem and issues that Hadoop has since it’s three main corporate drivers – Cloudera, HortonWorks, and MapR – are competitors.
One issue that Dan raises is “Hadoop does not support or integrate with the standards that several generations of business intelligence software”. In fact, this has been solved through partnerships Simba has with HortonWorks and MapR. Simba has licensed our “Apache Hive ODBC Driver with SQL Connector” to both HortonWorks and MapR. They both include this ODBC driver in their Hadoop distributions for no extra charge. With the Simba Apache Hive ODBC Driver, you get full ODBC access to Hive. More than that, you get to connect to Hive using HQL and SQL. That means if you have an application like Tableau that talks HQL, it will work and if you have an application like Crystal Reports that talks SQL, it will work. You no longer have to worry about your data being locked in your Hadoop clusters. You can access your data through the Simba Apache Hive ODBC Driver just like you would if your data was in Microsoft SQL Server, Oracle, or Teradata. This is a big step forward for Hadoop!
Note that the Simba Apache Hive ODBC Driver is included by HortonWorks and MapR for no extra costs. You should not have to pay for your ODBC driver. Your Hadoop distribution should include a solid ODBC driver.