Table of Contents

Search

  1. Preface
  2. Using Metadata Manager
  3. Configuring Metadata Manager
  4. Application Resources
  5. Business Glossary Resources
  6. Business Intelligence Resources
  7. Custom Resources
  8. Data Integration Resources
  9. Data Modeling Resources
  10. Database Management Resources
  11. Universal Resources
  12. Managing Resources
  13. Loading and Monitoring Resources
  14. Managing Permissions
  15. Resource Migration
  16. Repository Migration
  17. Appendix A: Metadata Manager Login
  18. Appendix B: Metadata Manager Properties Files
  19. Appendix C: Resource Configuration Files
  20. Appendix D: Glossary

Metadata Manager Administrator Guide

Metadata Manager Administrator Guide

Microstrategy Configuration Properties

Microstrategy Configuration Properties

Update the configuration properties when you create or edit a Microstrategy resource.
The following table describes the Microstrategy configuration properties:
Property
Description
Agent URL
Host name and port number of the Metadata Manager Agent. You can use the Metadata Manager Agent installed on any machine.
Source system version
Version of the data source to which you want to connect.
Some Microstrategy source versions are deprecated and will become obsolete. Use the supported versions to load metadata from Microstrategy. You can still create, edit, and load resources from the deprecated versions. However, Informatica cannot help you resolve an issue encountered on a deprecated version.
Version
Version of Microstrategy. Select a version or configure the Metadata Manager Agent to detect the version.
Default is auto-detect.
Project source
Name of the project source to which you want to connect.
A project source is a connection to a repository that is located on a local or remote Intelligence Server. The Intelligence Server connects to a data warehouse and contains a number of metadata projects that operate on the data warehouse.
Login user
The user name to connect to the project source.
Login password
The password used to connect to the project source.
Default language
The language that you want to use. Microstrategy 9.x supports multiple languages. Select one of the following values:
  • Chinese (Simplified)
  • Chinese (Traditional)
  • English (United States)
  • French (France)
  • German (Germany)
  • Italian (Italy)
  • Japanese
  • Korean
  • Portuguese (Brazil)
  • Spanish (Spain)
  • Swedish (Sweden)
Default is English (United States).
Import schema only
Imports the schemas for the selected projects without the reports and documents. Specify one of the following values:
  • True. Import the schemas only.
  • False. Import the schemas, reports, and documents.
Default is false.
Data model tables design level
The design level of the imported tables. Specify one of the following values:
  • Physical. A table appears in the physical view of the model.
  • Logical and Physical. A table appears in the logical view and in the physical view of the model.
Incremental import
Load changes since the previous resource load or load complete metadata. Specify one of the following values:
  • True. Load recent changes only.
  • False. Perform a complete load of the metadata.
Import hierarchies
Specifies whether to extract hierarchies from Microstrategy.
Default is true.
Multiple threads
Number of worker threads that the Metadata Manager Agent uses to extract metadata asynchronously. Leave blank or enter a positive integer value.
If blank, the Metadata Manager Agent calculates the number of worker threads. The Metadata Manager Agent allocates between one and six threads based on the JVM architecture and the number of available CPU cores on the machine that runs the Metadata Manager Agent. If you specify a value that is not valid, the Metadata Manager Agent allocates one worker thread.
Reduce the number of worker threads if the Metadata Manger Agent generates out of memory errors when it extracts metadata. You can increase the number of worker threads if the machine that runs the Metadata Manager Agent has a large amount of available memory, for example, 10 GB or more. However, if you specify too many worker threads, performance can decrease.
Default is blank.
Miscellaneous
Specify one or more miscellaneous options separated by commas. You can specify a miscellaneous option with a -
<character>
and an optional value.
You can enter the following options based on your requirements:
  • -m
    . Specify the maximum Java memory size in whole number. For example,
    -m 4G
    or
    -m 2500M
    .
  • -j
    . Java command line options. For example,
    -j -Dname=value -Xms1G
    .
  • -r
    . Specify to remove the report pages and their graphical structure in Metadata Manager.
  • -sf
    . Specify to skip importing filters.
  • -sp
    . Specify to skip importing prompts.
  • -spv
    . Specify to skip importing creation data, modification date, and author for schema objects.
Auto assign connections
Metadata Manager configures connection assignments to relational database resource types during the resource load. If you disable this option, you must configure connection assignments in the resource properties after you create the resource.
Projects
The name of the projects to which you want connect in the selected project source. Separate multiple project names with a semicolon (;).
If you change any Microstrategy resource configuration property, delete the
MicroStrategy
cache folder in the
<MITI_Agent_HOME>data\MIMB\cache
location before you load the resource.

0 COMMENTS

We’d like to hear from you!