MicroStrategy ONE

Default VLDB Settings for Specific Data Sources

MicroStrategy certifies and supports connection and integration with many third-party databases, MDX cube sources, and other data sources.

These include databases, data sources, and MDX cube sources from third-party vendors such as IBM DB2, Oracle, Informix, SAP, Sybase, Microsoft, Netezza, Teradata, and so on. For certification information on these data sources, refer to the Readme.

Certain VLDB properties use different default settings depending on which data source you are using. This allows MicroStrategy to both properly support and take advantage of certain characteristics of each third-party data source.

You can determine the default options for each VLDB property for a database by performing the steps below. This provides an accurate list of default VLDB properties for your third-party data source for the version of MicroStrategy that you are using.

You have a user account with administrative privileges.

Ensure that you have fully upgraded your MicroStrategy environment and the available database types, as described in Upgrading the VLDB Options for a Particular Database Type.

To Create a List of Default VLDB Settings for a Data Source

  1. In Developer, log in to a project source using an account with administrative privileges.
  2. From the Folder List, expand Administration, then Configuration Managers, and select Database Instances.
  3. From the File menu, point to New, and select Database Instance.
  4. In the Database instance name field, type a descriptive name for the database instance.
  5. From the Database connection type drop-down list, select the appropriate option for the data source to list default VLDB settings for. For example, you can select Oracle 11g to determine the default VLDB settings for an Oracle 11g database.

    To return a list of default VLDB properties for a data source, only an appropriate database connection type needs to be defined for the database instance; a connection to a data source does not need to be made. After you create the list of default VLDB settings for the data source, you can delete the database instance or modify it to connect to your data source.

  6. Click OK to exit the Database Instances Editor and save the database instance.
  7. Right-click the new database instance that you created and select VLDB Properties.
  8. From the Tools menu, ensure that Show Advanced Settings is selected.
  9. From the Tools menu, select Create VLDB Settings Report.

    A VLDB settings report can be created to display current VLDB settings for database instances, attributes, metrics, and other objects in your project. For information on creating a VLDB settings report for other purposes, see Creating a VLDB Settings Report.

  10. Select the Show descriptions of setting values check box. This displays the descriptive information of each default VLDB property setting in the VLDB settings report.
  11. The VLDB settings report now displays all the default settings for the data source. You can copy the content in the report using the Ctrl+C keys on your keyboard, then paste the information into a text editor or word processing program (such as Microsoft Word) using the Ctrl+V keys.
  12. Click Close.
  13. You can then either delete the database instance that you created earlier, or modify it to connect to your data source.