Version 2021
Repository
PostgreSQL can be used as a repository for metadata, Platform Analytics warehouse, Collaboration Server warehouse, and History List warehouse. Enterprise Manager and Narrowcast server are not certified with PostgreSQL.
To help reduce deployment complexity, MicroStrategy includes an embedded repository that can support the following MicroStrategy products:
-
Metadata repository
-
Collaboration server
-
Platform Analytics
-
Remote repository
The MicroStrategy repository is installed if either Platform Analytics or Collaboration server, or both, are installed. 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. This file should be moved to a secure location upon completing the installation. The file's default locations are as follows:
-
On Windows:
C:\Program Files (x86)\Common Files\MicroStrategy\Default_Accounts.txt -
On Linux:
/opt/mstr/MicroStrategy/<MSTR_INSTALL>/Repository/Default_Accounts.txt
The following users are created in the repository by the installer:
|
User name |
Access |
Privileges |
|---|---|---|
|
mstr |
Intermediate Table Index |
Create only secondary index on intermediate table |
|
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 |
The following are databases created in the repository by the installer:
|
Product |
Database |
|---|---|
|
Platform Analytics |
platform_analytics_wh |
|
Collaboration server |
mstr_collab |
The infrastructure is installed and ready for use if it is the right fit for your deployment. This embedded repository is automatically configured, optimized, and managed for you with no manual intervention required for routine usage. See MicroStrategy Repository for more details about the embedded repository.