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:
- 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 it's installed, go to Start | All program | Administrative tools | Data Sources (ODBC) to open the ODBC data source administrator.
- Click on System DSN and click on the Add button.
- Select the Hortonworks Hive ODBC driver and enter DSN setup:
- Fill the form with the following information:
- Data Source Name: sample Hortonworks Hive DSN
- Host:
192.168.81.129 - Port:
10000 - Database:
default - Mechanism:
User Name - User Name:
maria_dev
- Open the MicroStrategy Desktop application.
- Click on File | Add data.
- Select Hadoop | Hortonworks Hive from the following screen:
- Select Build a query and then Next.
- Click Add on the import from tables screen.
- Select the data source. The user can either choose DSN-less data source or a DSN data source.
- In our case we will select a DSN data source. Select the appropriate information and click OK.
- Now, clicking on Hadoop under DATA SOURCES will populate all the tables available in Hive under AVAILABLE TABLES:
- We can confirm this by checking the tables available in the Hive interface:
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.