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:
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:
- Install the driver by double-clicking the download file.
- Once...