Book Image

MicroStrategy Quick Start Guide

By : Fernando Carlos Rivero Esqueda
Book Image

MicroStrategy Quick Start Guide

By: Fernando Carlos Rivero Esqueda

Overview of this book

MicroStrategy is an enterprise business intelligence application. It turns data into reports for making and executing key organization decisions. This book shows you how to implement Business Intelligence (BI) with MicroStrategy. It takes you from setting up and configuring MicroStrategy to security and administration. The book starts by detailing the different components of the MicroStrategy platform, and the key concepts of Metadata and Project Source. You will then install and configure MicroStrategy and lay down the foundations for building MicroStrategy BI solutions. By learning about objects and different object types, you will develop a strong understanding of the MicroStrategy Schema and Public Objects. With these MicroStrategy objects, you will enhance and scale your BI and Analytics solutions. Finally, you will learn about the administration, security, and monitoring of your BI solution.
Table of Contents (17 chapters)
Title Page
Copyright and Credits
Dedication
Packt Upsell
Foreword
Contributors
Preface
Index

Database connectivity in MicroStrategy


In Chapter 1, Architecture - Installing and Configuring MicroStrategy, we learned that MicroStrategy connects to its Metadata database either by configuring a 2-Tier (Direct) or a 3-Tier (Server) Project Source. However, we have not discussed yet how it connects to the source of the data. Each MicroStrategy Project can connect to one or multiple sources to which the generated SQL, resulting from Reports and Intelligent Cubes, gets executed. The following diagram depicts an example of how one Project connects to a database (for instance, a Data warehouse):

In the following sections, we will learn which MicroStrategy Objects are necessary to establish such connectivity.