Cognos URL reporting with dynamic database username and password

[cognosrocks]

Hello All,

Lately I've been exploring URL reporting feature in Cognos and was wondering whether it is possible to override the database credentials which was set in the framework model at runtime.

As per my understanding, whenever a report is executed in Cognos, what it does is it queries the content store and extracts the database credentials for that package and opens a session with the DBMS with the stored credentials and pushes the report query. Thereafter query result gets rendered as per the report specification.

We've a requirement wherein we want to override the database credentials while executing  a report.

I was wondering whether this is possible using SDK.

Request you to please provide some pointers.Thanking you in anticipation.

[xiska]

Hi

In a way it is possible.

The automation interface of the Framework Manager is the bmt script player. This has more to do with writing or exporting xml commands.
The change of a uploaded model is different - this is the SDK.

You need to know that there are different types of commands.
A session command (set current schema = 'me') is set up in cognos connection. This is useful to use the same db with diffeent schemas or other settings. - That is not your point - these are commands after the connection was opend.

In addition you are able to use different connections for one DB. in this case you must make sure that each user can only use one (restricted by permissions) otherwhise the user will be asked which one.

The original question is very simple to answer: Go to the datasources in the framework manager one property points to the name of the database used in Cognos Connection.
You can add a macro function like if sq#(userGivenName)# = 'my name' then DB1 else DB2 end.
You can use it with the goups or roles as well.

Greetings