Connecting to your source – Database Instances, Connections, and Logins
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 canalsobe 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...