Linking Database Users and MicroStrategy Users: Passthrough Execution

You can link a MicroStrategy user to an RDBMS login ID using the User Editor (on the Authentication tab, specify the Warehouse Login and Password) or using Command Manager. This link is required for database warehouse authentication (see Implement Database Warehouse Authentication) but works for other authentication modes as well.

You can configure each project to use either connection mappings and/or the linked warehouse login ID when users execute reports, documents, or browse attribute elements. If passthrough execution is enabled, the project uses the linked warehouse login ID and password as defined in the User Editor (Authentication tab). If no warehouse login ID is linked to a user, Intelligence Server uses the default connection and login ID for the project's database instance.

By default, warehouse passthrough execution is turned off, and the system uses connection mappings. If no connection mapping is defined for the user, Intelligence Server uses the default connection and login ID for the project's database instance.

Why use Passthrough Execution?

You may want to use passthrough execution for these reasons:

RDBMS auditing: If you want to be able to track which users are accessing the RDBMS system down to the individual database query. Mapping multiple users to the same RDBMS account blurs the ability to track which users have issued which RDBMS queries.
Teradata spool space: If you use the Teradata RDBMS, note that it has a limit for spool space set per account. If multiple users share the same RDBMS account, they are collectively limited by this setting.
RDBMS security views: If you use security views, each user needs to log in to the RDBMS with a unique database login ID so that a database security view is enforced.

Enabling Linked Warehouse Logins

You can configure linked warehouse logins with the Project Configuration Editor in Developer. To create a connection mapping, you assign a user or group either a database connection or database login that is different from the default. For information on this, see Connecting to the Data Warehouse.

To Enable Linked Warehouse Logins

In Developer, log into your project. You must log in as a user with administrative privileges.
From the Administration menu, point to Projects, and select Project Configuration.
Expand the Database Instances category, expand Authentication, and then select Warehouse.
Select the Use warehouse pass-through credentials check box.
To use warehouse credentials for all database instances, select the For all database instances option.
To use warehouse credentials for specific database instances, select the For selected database instances option. Then select those database instances from the list below.
Click OK.