MicroStrategy ONE

Upgrading the VLDB Options for a Particular Database Type

The database connection type specifies the type of database that the database instance represents, for example, Oracle 8i or Netezza 4.x. (The database connection type is specified on the General tab of the Database Instances Editor.) This setting ensures that the appropriate default VLDB properties, SQL syntax, and functions are used for your database type.

You must have Administrator privileges to upgrade the metadata. For information on upgrading the metadata and your MicroStrategy environment, see the Upgrade Help. When the metadata updates the database type information:

  • It loads new database types.
  • It loads updated properties for existing database types that are still supported.
  • It keeps properties for existing database types that are no longer supported. If an existing database type does not have any updates, but the properties for it have been removed, the process does not remove them from your metadata.

The steps below show you how to upgrade database types.

  • You have upgraded your MicroStrategy environment, as described in the Upgrade Help.
  • You have an account with administrative privileges.

To Update Database Types

  1. In Developer, log in to a project source using an account with administrative privileges.
  2. From the Folder List, go to Administration > Configuration Managers > Database Instances.
  3. Right-click any database instance and select Edit.
  4. To the right of the Database connection type drop-down list, click Upgrade.
  5. Click Load.
  6. Use the arrows to add any required database types by moving them from the Available database types list to the Existing database types list.
  7. Click OK twice.