Version 2021

Warehouse Passthrough

MicroStrategy allows you to link a MicroStrategy user to RDBMS login ID using the User editor (on the Authentication tab, specify the Warehouse Login and Password) or Command Manager.

You can configure each project to use either connection mappings 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. If no warehouse login ID is linked to a user, the 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, the 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 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.

How to Link a MicroStrategy User to an RDBMS User

  1. Log into MicroStrategy Developer as a user with administrator privilege.

  2. Go to Administration > User Manager.

  3. Edit the user and specify the Warehouse Login and Password for a MicroStrategy user from the User editor.

How to Enable Warehouse Passthrough Authentication?

  1. In Developer, log into your project. You must log in as a user with administrative privileges.

  1. From the Administration menu, go to Projects > Project Configuration.

  2. Expand the Database Instances category > Authentication > Warehouse.

  3. Select the Use warehouse pass-through credentials checkbox.

  4. To use warehouse credentials for all database instances, select For all database instances.

  5. To use warehouse credentials for specific database instances, select For selected database instances. Then select those database instances from the list below.

  6. Click OK.