COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS Connection => Topic started by: mwgainesjr on 03 Feb 2010 08:59:39 AM

Title: Oracle Sign On
Post by: mwgainesjr on 03 Feb 2010 08:59:39 AM
Our Cognos authentication is through AD.  Currently our users have to log in to the Oracle data source with their username/password every time they run a report or query.  Is there any way possible to configure Cognos to use their AD credentials that they logged into Cognos with to log in to the data source?
Title: Re: Oracle Sign On
Post by: Allen Krause on 09 Apr 2010 11:51:16 AM
My Cognos instance has a similar setup to yours.  We use AD to authenticate and Oracle for the datasources.


You will want to either talk to your lead dba or dba member at least do discuss instead of logging into Oracle every single time, through cognos setup the datasource with the schema name and login.  DBA will/might have to reconfigure security for the change. 

In this practice for production users are allowed to run reports within cognos and only be prompted to log into the application


Hope this helps.