Question & Answer
Question
When using the datasource User Delegation feature my authentication source supplies Cognos Analytics with a user variable in a specific case (UPPER or lower). My database requires the opposite case so it fails to recognize the user being sent. How can I change the case of the User being supplied within Cognos Analytics so that I don't have to change my authentication source or database target?
Answer
User Delegation uses a macro to pass the appropriate user information to the database therefore you can use additional macros to compliment it.
If you wish to CAST the value returned from your authentication source to lowercase or uppercase you can use the following syntax in your JDBC URL.
hive.server2.proxy.user=#tolower($account.defaultName)#
hive.server2.proxy.user=#toupper($account.defaultName)#
Note:
To see the list of available macros and test their affects on the User Session Parameter, Framework Manager can be employed, if available. Simply create a calculation and create an Expression Definition using the parameters and macros from the Parameters tab.
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg22016688