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?
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.