The MicroStrategy Database Instance is a Configuration Object, which logically represents a source database.

The following is a quick reference table for a MicroStrategy Database Instance:

Database Instances are directly associated with MicroStrategy Projects. Each Project should have at least one Database Instance (Primary Database Instance), but it can also be configured with the Multisource option to connect to multiple relational data sources.

It is through this object that MicroStrategy can read tables and columns, and consequently import logical Tables into the MicroStrategy Schema. Database instances also define how and where the generated SQL will be executed.

The Database Instance contains two objects in addition to the database type. These objects are the Database Connection and Database Login.

A MicroStrategy Database Connection is necessary to associate the Database Instance to a Data Source Name (the DSN and a Login)

The following is a quick reference table for a MicroStrategy Database Connection:

The MicroStrategy Database Connection is a Configuration Object that defines the DSN to be used in the connection. To create a Database Connection through MicroStrategy Developer, the DSN should reside in the client machine to become available to the Database Connection editor.

The Database Connection contains one object in addition to the DSN. This object is the Database Login.

The following is a quick reference table for a MicroStrategy Database Login:

The MicroStrategy Database Login is also a Configuration Object that stores the username and password to connect to the data source.