COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Blue on 06 Aug 2017 07:46:54 PM

Title: How to get user credentials from LDAP (AD) for use in URL?
Post by: Blue on 06 Aug 2017 07:46:54 PM
G'day all
I have a report in CA 11.0.4 which has a URL to Maximo. The problem is the requirement is to provide the user name & pw to the Maximo login page so the user goes straight to the WOTRACK page and finds the Work Order details. 
Both softwares use the same LDAP (Active Directory) and if I provide an explicit un and pw the URL works great. E.g.

'http://wlgmaxtest02/maximo/ui/?event=loadapp&value=wotrack&additionalevent=useqbe&additionaleventvalue=wonum=' || [WO Number] || '&login=true&username=<username>&password=<password>'

Obviously I can't pass w pw in plain text but should be able to provide an encrypted one. I can get the username easiliy enough via #sq($account.defaultName)#.

Is there any way to get the password from AD to use in the URL?

Cheers,