Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Mastering Business Intelligence with MicroStrategy

You're reading from   Mastering Business Intelligence with MicroStrategy Master Business Intelligence with Microstrategy 10

Arrow left icon
Product type Paperback
Published in Jul 2016
Publisher Packt
ISBN-13 9781785884405
Length 396 pages
Edition 1st Edition
Arrow right icon
Authors (4):
Arrow left icon
Neil Mehta Neil Mehta
Author Profile Icon Neil Mehta
Neil Mehta
Himani Rana Himani Rana
Author Profile Icon Himani Rana
Himani Rana
Ning Ma Ning Ma
Author Profile Icon Ning Ma
Ning Ma
Dmitry Anoshin Dmitry Anoshin
Author Profile Icon Dmitry Anoshin
Dmitry Anoshin
Arrow right icon
View More author details
Toc

Table of Contents (13) Chapters Close

Preface 1. Getting Started with MicroStrategy FREE CHAPTER 2. Setting Up an Analytics Semantic Layer and Public Objects 3. Building Advanced Reports and Documents 4. Advanced Visualization Techniques 5. Customization of MicroStrategy 6. Predictive Analysis with MicroStrategy 7. Accelerating Your Business with Mobile Analytics 8. Data Discovery with MicroStrategy Desktop 9. MicroStrategy System Administration 10. Design and Implementation of the Security Model 11. Big Data Analytics with MicroStrategy 12. MicroStrategy Troubleshooting

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:

Connecting Hortonworks with MicroStrategy

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

  1. 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

  2. Install the driver by double-clicking the download file.
  3. Once...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime