DQM in Cognos Analytics

MS SQL Database

As of Cognos 11 sqljdbc4.jar is only needed in <install folder>\drivers

Do not put in <install folder>\v5dataserver\lib nor in <install folder>\webapps\p2pd\WEB-INF\lib
Doing so will generate a BMT-IMP-0002 CAF-WRN-2082 error when adding a Query Item in Framework Manager.

Defining both instance name and port is ok. Make sure you know the port number. If not, use this query to find out the port number:

select distinct local_net_address, local_tcp_port
from sys.dm_exec_connections
where local_net_address is not null

If the user credentials is not authorized to run that query, then for now you are out of luck.

Datasources with jdbc connector can also be used as data servers by checking the "Allow web-based modeling" box on Connection tab in datasource properties section.

In your Framework Manager model, you can set the query mode property to DQM or Compatible mode by selecting the Project and changing the query mode property.