MicroStrategy ONE
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:
C:\Program Files (x86)\Common Files\MicroStrategy\<MSTR_INSTALL>\Repository\pgsql\bin
and run:
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:
<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:
<MSTR_INSTALL>/Repository/bin
and run:
./mstr_psql -U <UserName> -d <database> -h <hostIP>