Deploying MicroStrategy 10

According to the installation and configuration guide, we should deploy all necessary packages. In order to install them, we should execute them under the root:

# su
# yum install compat-libstdc++-33.i686
# yum install libXp.x86_64
# yum install elfutils-devel.x86_64
# yum install libstdc++-4.4.7-3.el6.i686
# yum install krb5-libs.i686
# yum install nss-pam-ldapd.i686
# yum install ksh.x86_64

Moreover, we should change the parameters of the kernel:

# nano/etc/sysctl.conf
kernel.sem=250 32000 32 2048
kernel.shmmni = 4096
vm.max_map_count=5242880

Then, save and reboot.

By default, there are three methods of installation for MicroStrategy Server:

In Red Hat, we have a GUI and can use its benefits. Let's install:

# cd /mstr10/Installations/QueryReportingAnalysis_Linux
# ./setup.sh
user name Microstrategy
name masteringbi

Copy and paste your license key.

Choose the destination locations that we have already created:

All the other parameters we can leave as is.

Let's download and install the PostgreSQL database server:

# yum install postgresql-server
# service postgresql initdb
# chkconfig postgresql on
# service postgresql start
# s
# psql

Let's create a new database in PostgreSQL for MicroStrategy metadata. In order to do this, we should go to the terminal and run the following:

# psql
# CREATE DATABASE mstrmd;
# CREATE USER mstr PASSWORD 'happy2016';
# GRANT ALL ON DATABASE mstrmd TO mstr;

In addition, we should register the plpgsql language in our new database:

# \c mstrmd
# CREATE TRUSTED LANGUAGE plpgsql;

By default, PostgreSQL uses IDENT-based authentication, and this will never allow you to log in with a username and password. We should change the method of authentication by modifying the pg_hba.conf file. Go to this folder:

# cd /var/lib/pgsql/data
# nano pg_hba.conf

Replace IDENT on trust and restart PostgreSQL:

# service postgresql restart

Using the MicroStrategy connectivity wizard, we can create a new DSN. In order to open the wizard, we should run the following commands:

# cd /mstr10/microstrategy_home/bin
# ./mstrconnectwiz

Let's choose PostgreSQL ODBC driver and fill in the form with our credentials:

MicroStrategy has a configuration file that keeps all DSNs. We can create a new DSN directly in this file. We can look at our new DSN like this:

# vi /mstr10/microstrategy_home/odbc.ini

Here is our DSN metadata. In addition, we can configure the parameters of our connection in order to increase performance.

In order to create metadata tables in the brand new database, we should run Configuration Wizard:

# cd /mstr10/microstrategy_home/bin
# ./mstrcfgwiz

During this process, wizard will automatically:

In Configuration Wizard, we should create a new database and choose our DSN:

The next step is the configuration of Intelligence Server using fresh metadata tables. We can use masteringbi as a server definition. After successful configuration we can close wizard and deploy MicroStrategy Web.

Let us install Tomcat on our RHEL server. Open the terminal and give the following commands:

In order to access Tomcat, we should go to http://localhost:8080/.

Now we can deploy MicroStrategy Web and Operations Manager on a brand new Tomcat server. Let's do it:

# cp /mstr10/microstrategy/OperationsManager/MicroStrategyWeb.war 
      /usr/local/tomcat7/webapps
# cp /mstr10/microstrategy/OperationsManager/MicroStrategyOM.war 
      /usr/local/tomcat7/webapps

Then we need restart Tomcat:

# /usr/local/tomcat7/bin/shutdown.sh
# /usr/local/tomcat7/bin/startup.sh

After deploying, we should go to the web admin:

http://localhost:8080/MicroStrategy/servlet/mstrWebAdmin

Then, connect to our server. We can do this just by adding the localhost server. In properties, we should mark that it automatically connects to Intelligence Server.

Later in the book, we will create projects and they will be available here:

http://localhost:8080/MicroStrategy/servlet/mstrWeb

In addition, we can go to Operations Manager in order to configure it:

http://localhost:8080/MicroStrategyOM/servlet/mstrOM

The Operation Manager will be configured in Chapter 9, MicroStrategy System Administration.

We have finished the installation and configuration of Intelligence Server. Now we need to install the MicroStrategy Client tools on the Windows machine.

We should open a port in the firewall for Tomcat on the Linux machine, in order for the Windows machine to access it:

# nano /etc/sysconfig/iptables

Add a new line for port 8080:

-A INPUT -m state --state NEW -m tcp -p tcp --dport 8080 -j ACCEPT

We should also open a port for Intelligence Server:

-A INPUT -m state --state NEW -m tcp -p tcp --dport 34952 -j ACCEPT

Then, restart the service:

# service iptables restart

As a result, we can access MicroStrategy from Windows.

The last step before finishing this chapter is to deploy our sample database, which we will use throughout this book in order to build advanced visualizations, dashboards, and many other things.

There are SQL files in the attachment that comes with this book. We are going to deploy these in our Oracle database:

In order to deploy these files in the Oracle database, we should:

In the next chapter, we will create a schema based on this database.