Installation

Windows
Linux

MicroStrategy Repository is installed if either Platform Analytics, Collaboration Server, or both are installed.

Product Name: Repository
Default Installation Path: C:\Program Files (x86)\Common Files\MicroStrategy\<MSTR_INSTALL>\Repository
<MSTR_INSTALL> is the MicroStrategy install path.
Repository directory structure:
- \pgsql
- \repository-administration

How to log in to MicroStrategy Repository

The installer creates users and database tables for Platform Analytics and Collaboration Server. Default_Accounts.txt is the file containing the user names and passwords to the repository created during the installation. The default location of Default_Accounts.txt is C:\Program Files (x86)\Common Files\MicroStrategy\Default_Accounts.txt. This file should be moved to a secure location upon completing the install.

Users created in the repository by the installer:

User name	Access	Privileges
mstr	MicroStrategy user has access to Platform Analytics and Collaboration Server databases.	Super User
mstr_pa	MicroStrategy user has access to the Platform Analytics database, but does not have access to the Collaboration Server database.	CREATE DATABASE, SELECT DATABASE, SELECT TABLE, CREATE TABLE, DROP TABLE
mstr_collab	MicroStrategy user has access to the Collaboration Server database but does not have access to the Platform Analytics database.	No Create DB, SELECT, INSERT, CREATE TABLE, DROP TABLE

Databases created in the Repository by the installer:

Product	Database
Platform Analytics	platform_analytics_wh
Collaboration Server	mstr_collab

To log in navigate to:

Copy

C:\Program Files (x86)\Common Files\MicroStrategy\<MSTR_INSTALL>\Repository\pgsql\bin

and run:

Copy

pgsql.exe -U <UserName> -d <database> -h <host>

Repository is installed if either Platform Analytics, Collaboration Server, or both are installed.

Product Name: Repository
Default Installation Path: <MSTR_INSTALL>/Repository
<MSTR_INSTALL> is the location of your install path.
Repository directory structure:
- /bin
- /pgdata
- /postgres11
- /repository-administration
- Default_Accounts.txt
Compressed file name: mstr36.tzp

To verify the version of the PostgreSQL run:

Copy

<MSTR_INSTALL>/Repository/bin/mstr_psql --version

How to log in to MicroStrategy Repository

The installer creates users and database tables for Platform Analytics and Collaboration Server. Default_Accounts.txt is the file containing the user names and passwords to the repository created during the installation. The default location of Default_Accounts.txt is <MSTR_INSTALL>/Repository/Default_Accounts.txt. This file should be moved to a secure location upon completing the install.

Users created in the Repository by the installer:

User name	Access	Privileges
mstr	MicroStrategy user has access to Platform Analytics and Collaboration Server databases.	Super User
mstr_pa	MicroStrategy user that has access to the Platform Analytics database, but does not have access to the Collaboration Server database.	CREATE DATABASE, SELECT DATABASE, SELECT TABLE, CREATE TABLE, DROP TABLE
mstr_collab	MicroStrategy user that has access to the Collaboration Server database but does not have access to the Platform Analytics database.	No Create DB, SELECT, INSERT, CREATE TABLE, DROP TABLE

Databases created in the Repository by the installer:

Product	Database
Platform Analytics	platform_analytics_wh
Collaboration Server	mstr_collab

To log in navigate to:

Copy

<MSTR_INSTALL>/Repository/bin

and run:

Copy

./mstr_psql -U <UserName> -d <database> -h <hostIP>