Connecting Hortonworks with MicroStrategy
There are two ways to connect Hortonworks to MicroStrategy:
Using an ODBC connector, which is an application programming interface for accessing a Hadoop system.
Using a Native connector, also known as a MicroStrategy Hadoop gateway, which is a data processing engine included in MicroStrategy 10. It natively taps into HDFS and generates the schema on read, allowing faster parallel data transfer from Hadoop:
For this book we will be using an ODBC connector. To read more about setting up via a Native connector, the user can refer to the following URL:
https://community.microstrategy.com/t5/Server/TN248914-Overview-and-installation-of-the-MicroStrategy-10/ta-p/248914
Setting up an ODBC connector
Open the MicroStrategy machine and download the 64-bit Hortonworks ODBC driver - Hortonworks ODBC Driver for Apache Hive (v2.1.2) - from the following link:
http://hortonworks.com/downloads/#addons
Install the driver by double-clicking the download file.
Once...