KB483459: How to configure passthrough database authentication for SAP HANA

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.
There are three authentication modes that have been tested for passthrough for SAP HANA:

• Standard authentication
• LDAP authentication
• Windows authentication

For information on Passthrough authentication, see Linking Database Users and MicroStrategy Users: Passthrough Execution.
You can configure linked warehouse logins with the Project Configuration Editor in Developer.

How to Enable Linked Warehouse Logins 

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 steps to enable, see To enable linked warehouse login on Linking database users and MicroStrategy users: Passthrough execution.

How to Link a User to a Database User

To allow database authentication, you must link the users in the Strategy environment to warehouse database users. Linking allows Intelligence Server to map a warehouse database user to a Strategy user.
For steps to link, see How to Link a User to a Database User.

How to Verify if the Passthrough User was Used to Execute the Report

1. Run a report.
2. Right-click on the executed report.
3. Switch to SQL view and verify the user used for executing the report.

For more information on implementing database warehouse authentication, see the System Administration Guide.