Planning & Consolidation > COGNOS Controller

Cognos Controller Licensing - reading from SQL Server

(1/1)

pontushaglund:
Hello.

I have a customer that is using Cognos Controller that uses a Microsoft SQL Server as the backend database. We're trying to figure out if a license is needed to read data from the Cognos data straight from SQL Server (without using any Cognos license). Anybody that has an answer to this question?

Thanks,

Pontus

smiley:
You can use the datamart option from Controller.
That will create a star schema in the Controller database, ready to report on.
https://www.ibm.com/support/knowledgecenter/en/SS9S6B_10.3.1/com.ibm.swg.ba.cognos.ctrl_inst.10.3.1.doc/t_ctrl_usedatamart.html

As for Controller tables themselves, they are not encrypted, so you can extract whatever you want from it.

I donĀ“t see why you should have anything to do with licensing. You own the data that Controller generates.

Navigation

[0] Message Index

Go to full version