MicroStrategy ONE
Configuring MicroStrategy with a Response File
The Configuration Wizard walks you through the process of setting up the environment for the MicroStrategy products installed in your system. You can also configure server definitions, project source names, an Enterprise Manager project, and the metadata, History List, and statistics repositories using a response file with the Configuration Wizard. This enables you to provide a configuration file to users to complete the configuration tasks, rather than requiring users to step through the Configuration Wizard. This can be done to configure a MicroStrategy installation on Windows and Linux.
The Configuration Wizard can also be used to perform MicroStrategy upgrades and create an Enterprise Manager project. These tasks can also be accomplished by using a response file:
- For steps to upgrade MicroStrategy using a response file, see the Upgrade Help.
- For steps to create an Enterprise Manager project with a response file, see the Enterprise Manager Help.
Creating a response file
It is recommended that you always create the response file through the graphical interface of the Configuration Wizard, as described in the procedure To create a response file in this section. This ensures that all applicable options are included in the response file with valid values.
However, you can also create and use a response file with the Configuration Wizard in command line mode on Linux machines. For steps to create and use a response file as well as perform other configurations using command line tools in Linux, see the Configuring MicroStrategy with a response.ini file section in Configuring MicroStrategy Using Command Line Tools.
To create a response file
- Open the MicroStrategy Configuration Wizard. To do this, see To configure MicroStrategy through the Configuration Wizard.
- Any configuration tasks you complete with the Configuration Wizard can be saved to a response file. For steps to complete various configurations tasks with the Configuration Wizard, see the sections listed below:
- Once you reach the Summary page for a configuration, click Save. The Save dialog box opens.
- Specify a name and location to save the response file, and click Save. You are returned to the Summary page.
- To also perform the configuration task, click Finish. The summary information is updated as the configurations are completed, providing a way to track the progress of the configurations.
Steps to use a response file to configure MicroStrategy are covered in Using a response file to configure MicroStrategy installations below.
You can modify a response file with a text editor to make configuration changes such as entering different user login and password information. For information on the parameters and options available in response files, see Response configuration parameters and options.
Using a response file to configure MicroStrategy installations
Rather than stepping through each page of the Configuration Wizard, you can configure MicroStrategy using a response file. You have the following options to use a response file to configure MicroStrategy:
- To use a response file with the Configuration Wizard: This covers the standard procedure of running a response file with the Configuration Wizard interface.
- To use a response file through the Windows command line: This covers the procedure of running a response file from the Windows command line. This enables users to run the file without using any graphical user interfaces.
If you are configuring a MicroStrategy installation on Linux, you can use a command line version of the Configuration Wizard to create and use a response file. For steps to create and use a response file as well as perform other configurations using command line tools in Linux, see the Configuring MicroStrategy with a response.ini file section in Configuring MicroStrategy Using Command Line Tools.
- Configuring MicroStrategy components with System Manager: You can use a Configuration Wizard response file as part of an System Manager workflow. System Manager lets you define multiple configurations for your MicroStrategy environment that can be executed in a single workflow. For information on using MicroStrategy System Manager to configure and deploy your MicroStrategy environments, see the System Administration Help.
To use a response file with the Configuration Wizard
- Open the MicroStrategy Configuration Wizard. To do this, see To configure MicroStrategy through the Configuration Wizard.
- Click Load. The Open dialog box displays.
- Browse to the path where the response file is saved and click Open. The Summary page opens.
- An overview of all of the configuration tasks performed by the response file is displayed. Review the configuration tasks and click Finish to perform the configuration. The summary information is updated as the configurations are completed, providing a way to track the progress of the configurations.
To use a response file through the Windows command line
The steps below are specific to configuring MicroStrategy installed on Windows. For steps to create and use a response file as well as perform other configurations using command line tools in Linux, see Configuring MicroStrategy Using Command Line Tools.
- Type the following command in the Windows command line:
macfgwiz.exe -r "
Path
\response.ini"
Where
Path
\
is the fully qualified path to the response file. For example, the common location of a response file is:C:\Program Files\Common Files\MicroStrategy\RESPONSE.INI
- If an error message is displayed, check the path and name you supplied for the response file and make any required changes. Repeat the previous step to execute the configuration.
Response configuration parameters and options
It is recommended that you always create the response file through the GUI mode of the Configuration Wizard. However, you can also modify a response file with a text editor to make minor changes such as entering different user login and password information.
The file must be saved with ANSI encoding.
The response file for configuring MicroStrategy is divided into three areas of configuration, which are described in the sections below:
- Creating metadata, History List, and statistics repositories
- Setting up MicroStrategy Intelligence Server
- Creating and configuring project sources
- Creating and Configuring the Enterprise Manager Project
- Creating and Configuring the Platform Analytics Project
Creating metadata, History List, and statistics repositories
The response file parameters within the [Repository]
section define how metadata, History List, and statistics and Enterprise Manager repositories are created. The table below lists the available parameters and the functionality of available options for each parameter.
Options |
Description |
[Repository] |
This section configures the metadata repository and statistics tables. You can have more than one |
Repository= |
Defines whether a metadata, History List, and statistics repositories are configured, as determined by the following values:
|
CreateMDTables= |
Defines whether metadata tables are created in a metadata repository, as described below:
|
CreateHistListTables= |
Defines whether a History List repository is created, as determined by the following values:
|
CreateStatTables= |
Defines whether statistics and Enterprise Manager repositories are created, as determined by the following values:
|
MetadataPath= |
Locates the SQL scripts for creating the metadata tables. Example paths to SQL scripts in different environments are listed below: 64-bit Windows environment: Linux: |
HistoryListPath= |
Locates the SQL scripts for creating the History List repository. Example paths to SQL scripts in different environments are listed below: 64-bit Windows environment: Linux: |
StatisticsPath= |
Locates the SQL scripts for creating the statistics and Enterprise Manager repositories. Example paths to SQL scripts in different environments are listed below: 64-bit Windows environment: Linux: |
DSNName= |
Defines the Data Source Name for configuring a metadata repository in the ODBC database. |
UserName= |
Defines the user name to log in to the database containing the metadata repository. |
UserPwd= |
Defines the password to log in to the database containing the metadata repository. |
DSNNameHist= |
Defines the Data Source Name for configuring the History List repository in the ODBC database. |
UserNameHist= |
Defines the user name to log in to the database for configuring the History List repository. |
UserPwdHist= |
Defines the password to log in to the database for configuring the History List repository. |
DSNNameStats= |
Defines the Data Source Name for configuring the statistics and Enterprise Manager repositories in the ODBC database. |
UserNameStats= |
Defines the user name to log in to the database for configuring the statistics and Enterprise Manager repositories. |
UserPwdStats= |
Defines the password to log in to the database for configuring the statistics and Enterprise Manager repositories. |
EncryptPassword= |
Defines whether the password is encrypted in the response file, as determined by the following values:
|
DBName= |
Defines the database name to create tables in DB2 z/OS. This option should only be used when connecting to a DB2 z/OS database. |
TBName= |
Defines the tablespace name to be created in the database.This option should only be used when connecting to a DB2 z/OS database. |
Setting up MicroStrategy Intelligence Server
The response file parameters within the [Server]
section configures an Intelligence Server definition. The table below lists the available parameters and the functionality of available options for each parameter.
Options |
Description |
[Server] |
In this section you can configure the Intelligence Server definition. You can have more than one |
Server= |
Defines whether MicroStrategy Intelligence Server is configured, as determined by the following values:
|
Action= |
Defines whether a server definition is created, used, or deleted, as determined by the following values:
|
InstanceName= |
Defines the name of the Intelligence Server instance. If you select to delete Intelligence Server instances, you can delete multiple instances by listing multiple instance names, separating each name with the \ character. For example, |
ProjectsToRegister= |
Defines projects to be loaded when Intelligence Server is started. You can select to load multiple projects, separating projects by the |
ProjectsToUnRegister= |
Defines projects to not be loaded when Intelligence Server is started. You can select to not load multiple projects, separating projects by the |
DSName= |
Defines the data source name for configuring the MicroStrategy Intelligence Server. This is the data source that stores the metadata. |
DSNUser= |
Defines the user name to log in to the metadata database. |
DSNPwd= |
Defines the password to log in to the metadata database. |
EncryptPassword= |
Defines whether the password is encrypted in the response file, as determined by the following values:
|
DSSUser= |
Defines the MicroStrategy user name to log in to the project. |
DSSPwd= |
Defines the password for the MicroStrategy user name to log in to the project. |
MDPrefix= |
Defines a prefix for metadata repository tables used by the server definition. |
UseAsDefault= |
Defines whether the Intelligence Server definition is set as the default server definition to use for Intelligence Server, as determined by the following values:
|
Port= |
Defines the port used by the Intelligence Server.By default, the port is 34952. |
RestPort= |
Defines the port used by the REST API Server. By default, the port is 34962. |
RegisterAsService= |
This option is only available on Intelligence Servers running on Linux operating systems. Defines whether Intelligence Server is registered as a service. Registering Intelligence Server as a service is determined by the following values:
|
StartServerAfter Config= |
Defines whether Intelligence Server is started after applying the configuration, as determined by the following values:
|
ConfigureSSL= |
Defines whether to enable Intelligence Server and Developer to communicate using the SSL protocol, as determined by the following values:
|
SSLPort= |
Defines the port to use for SSL access. By default, the port is 39321. |
CertificatePath= |
Locates the SSL certificate file you created for Intelligence Server. Type the full path to the SSL certificate file. |
KeyPath= |
Locates private key file you created while requesting the certificate for Intelligence Server. Type the full path to the private key file. |
KeyPassword= |
Defines the password that you used while creating the private key for the SSL certificate. |
DefaultStatisticsRep |
Specifies whether you can create a default statistics database instance for the all of the projects of the local Intelligence Server metadata, as determined by the following values:
|
DefaultDSNNameDefaultStatistics |
Specifies the data source name for your statistics repository. |
UserNameDefaultStatistics |
Specifies the database user name for the user that can connect to the statistics data source. |
UserPwdDefaultStatistics |
Specifies the password for the user that can connect to the statistics data source. |
EncryptUserPwdDefaultStatistics |
Defines whether the statistics user password is encrypted in the response file, as determined by the following values:
|
DefaultStatisticsPrefix |
Defines a prefix for statistics repository tables used by the server definition. |
kafkaHost(s)= |
Provide host name or IP addressee of Telemetry server. Format for this setting should be: server1.acme.com:9092, server2.acme.com:9093,... |
ConfigMessagingService= | Enable or disable Telemetry server for Intelligence Server and configure Telemetry server host and port settings. |
Creating and configuring project sources
The response file parameters within the [Client]
section create and configure project sources. The table below lists the available parameters and the functionality of available options for each parameter.
Options |
Description |
[Client] |
In this section you can configure the project source name. You can have more than one |
Client= |
Defines whether project sources are configured, as determined by the following values:
|
EncryptPassword= |
Defines whether the password is encrypted in the response file, as determined by the following values:
|
DataSource= |
Defines the name of the new project source to create. |
ConnType= |
Defines the database connection type for a project source. The following connection types are supported:
|
DSN= |
If using connection type |
UserName= |
If using connection type |
UserPwd= |
If using connection type |
ServerName= |
If using connection type |
Port= |
If using connection type |
Authentication= |
The following authentication modes are supported:
For information on the available authentication modes, see the Authentication modes. |
MDPrefix= |
If using connection type |
Timeout= |
Defines and enforce a connection time out for inactive users connected to a project source. The following values are supported:
Numerical value greater than 0: A numerical value (in minutes) greater than 0 defines the amount of inactivity that is allowed before a user is automatically disconnected from a project source. |
Creating and Configuring the Enterprise Manager Project
The parameters in the [EMProjectHeader]
portion of the response file create the Enterprise Manager project on this machine and configure the connection to the Statistics and Enterprise Manager repository. The table below lists the available parameters and the functionality of available options for each parameter. For detailed information about each parameter, see the Configuration Wizard Help.
Options |
Description |
[EMProjectHeader] |
Options in this portion refer to creating the Enterprise Manager project on this machine. |
|
Defines whether to create the Enterprise Manager project, as determined by the following values:
|
|
Defines whether the passwords are encrypted in the response file, as determined by the following values:
|
|
The user name to log in to the Enterprise Manager project. |
|
The password for the user name above. This may be encrypted, depending on the |
|
The full path and file name of the MicroStrategy Enterprise Manager project package file used to create the project. On Windows, by default this is |
|
The Data Source Name for the database that contains your Statistics and Enterprise Manager repository. |
|
The user name to connect to the Statistics and Enterprise Manager repository database. |
|
The password for the user name above for the Statistics and Enterprise Manager repository database. This may be encrypted, depending on the |
Creating and Configuring the Platform Analytics Project
The parameters in the [PAProjectHeader]
portion of the response file create the Platform Analytics project on this machine and configure the connection to the Platform Analytics repository. The table below lists the available parameters and the functionality of available options for each parameter. For detailed information about each parameter, see the Configuration Wizard Help.
Options |
Description |
---|---|
[PAProjectHeader] | Options in this portion refer to creating the Platform Analytics project on this machine. |
PAProject= |
Defines whether to create the Platform Analytics project, as determined by the following values:
|
PAProjectEncryptPwd= |
Defines whether the passwords are encrypted in the response file, as determined by the following values:
|
PAProjectDSSUser= | The user name to log in to the Platform Analytics project. |
PAProjectDSSPwd= |
The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting. |
PAProjectPkgFile= |
Beginning with MicroStrategy 2020, this file will be removed and the default project package will be used. The full path and file name of the MicroStrategy Platform Analytics project package file used to create the project. On Windows, by default this is C:\Program Files (x86)\Common Files\MicroStrategy\PlatformAnalyticsProjectObjects.mmp |
PAConfigurePkgFile= |
Beginning with MicroStrategy 2020, this file will be removed and the default project package will be used. The full path and file name of the MicroStrategy Platform Analytics project configuration package file used to create the project. On Windows, by default this is C:\Program Files (x86)\Common Files\MicroStrategy\PlatformAnalyticsConfigurationObjects.mmp. |
PAProjectDSNName= | The Data Source Name for the database that contains your Platform Analytics repository. |
PAProjectDSNUserName= |
The user name to connect to the Platform Analytics repository database. |
PAProjectDSNUserPwd= | The password for the user name above for the Platform Analytics repository database. This may be encrypted, depending on the PAProjectEncryptPwd= setting. |
PAProjectDSNPrefix= |
The prefix for the Platform Analytics repository tables. |