MicroStrategy, Apache Hive and the Hortonworks Sandbox


MicroStrategy uses Apache Hive (via ODBC connection) as the defacto standard for SQL access in Hadoop.

Establishing a connection from MicroStrategy to Hadoop and the Hortonworks Sandbox is fairly straight forward. While the MicroStrategy Analytics Platform provides a comprehensive set of analytics and business intelligence capabilities, the Analytics Desktop is one component of the platform that gives business users an easy and convenient option to get started with MicroStrategy.

The process described here is for MicroStrategy Analytics Desktop installed on Windows, but the approach is similar when using the MicroStrategy Analytics Platform with Hortonworks on non-Windows platforms (Linux, Solaris, HP-UX, AIX).

Before you get started:

  1. Download the Hortonworks Sandbox 2.0.
  2. Download the 100% Free MicroStrategy Analytics Desktop product


Additional Information:

This on-demand Webinar, in conjunction with our partner MicroStrategy, you’ll learn more about how to use MicroStrategy for Advanced Business Intelligence with Hortonworks Data Platform.


June 13, 2014 at 5:43 am


I’ve tried to configrue the odbc driver, but it didn’t do. I have tried this with another distribution and i had to configure some Network issues.

Following your documentation that should not be the case when running the sandbox in a local VM and installing odbc on the host of the VM.

Any hints on this?

best regards, jan

Leave a Reply

Your email address will not be published. Required fields are marked *

If you have specific technical questions, please post them in the Forums

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>